I_PROJECTNETWORK
Project Network Details
I_PROJECTNETWORK is a CDS View in S/4HANA. Project Network Details. It contains 91 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChgImpactNtwkDets | view | from | CONSUMPTION | Network Order Details |
| C_HCMTimeShtProjNtwkVH | view_entity | from | CONSUMPTION | Project Network |
| FAC_PROJECTNETWORKVH | view | from | Data Source for Project NetWork | |
| I_FldLogsMaintenanceOrderVH | view | union | COMPOSITE | List of Maintenance Order for Field Logistics |
| I_FldLogsWorkOrderVH | view | union | COMPOSITE | Work Order Value Help Non Teco Orders |
| I_MPNetwork | view | inner | COMPOSITE | Get Master Project Network |
| I_MstrProjItmProjStrucNode | view | inner | COMPOSITE | Project Structure Node Master Project |
| I_ProjectNetworkStdVH | view | from | COMPOSITE | Project Network Details |
| I_ProjectNtwkValueHelp | view | from | COMPOSITE | Project Network Value Help |
| I_ProjectObjectUnion | view_entity | union_all | COMPOSITE | Hierarchy data of the Project |
| I_TravelNetworkValueHelp | view | from | COMPOSITE | Travel Request Network |
| P_ProjectObject_2 | view | union_all | COMPOSITE | Project Object |
| P_ProjNetworkWithVersion | view | union_all | COMPOSITE | |
| SHSM_CN_LDST_SH_NP | view | from | View for collective search help AUKO and search help CN_LDST | |
| SHSM_M_AUKOA | view | from | View for matchcode ID AUKO-A | |
| SHSM_M_AUKOB | view | from | View for matchcode ID AUKO-B | |
| SHSM_M_AUKOC | view | from | View for matchcode ID AUKO-C | |
| SHSM_M_AUKOD | view | from | View for matchcode ID AUKO-D | |
| SHSM_M_AUKOE | view | from | Networks by MRP controller | |
| SHSM_M_AUKOF | view | from | View for matchcode ID AUKO-F |
Fields (91)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjectNetwork | aufnr,ControllingObjectExternalID,ProjectNetwork | 5 |
| _BusinessArea | _BusinessArea | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingObjectClass | _ControllingObjectClass | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _Currency | _Currency | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _MRPController | _MRPController | 1 | |
| _NetworkProfile | _NetworkProfile | 1 | |
| _NetworkShortText | _NetworkShortText | 1 | |
| _OrderCategory | _OrderCategory | 1 | |
| _OrderType | _OrderType | 1 | |
| _Plant | _Plant | 1 | |
| _Prioritycode | _Prioritycode | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ResponsiblePlannerGroup | _ResponsiblePlannerGroup | 1 | |
| _SalesOrder | _SalesOrder | 1 | |
| _SalesOrderItem | _SalesOrderItem | 1 | |
| _TaxJurisdiction | _TaxJurisdiction | 1 | |
| _WBSElement | _WBSElement | 2 | |
| ActualCostsCostingVariant | ActualCostsCostingVariant | 1 | |
| ActualEndDate | ActualEndDate | 2 | |
| ActualReleasedDate | ActualReleasedDate | 1 | |
| ActualStartDate | ActualStartDate | 2 | |
| BaseUnit | BaseUnit | 1 | |
| BasicSchedulingType | BasicSchedulingType | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConfirmedEndDate | ConfirmedEndDate | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingObjectClass | ControllingObjectClass | 1 | |
| CostCenter | CostCenter | 1 | |
| CostElement | CostElement | 1 | |
| CostingSheet | CostingSheet | 1 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationDate | CreationDate | 2 | |
| CreationTime | CreationTime | 1 | |
| Currency | Currency | 1 | |
| ForecastedEndDate | ForecastedEndDate | 1 | |
| ForecastedStartDate | ForecastedStartDate | 1 | |
| ForecastSchedulingType | ForecastSchedulingType | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| JointVenture | JointVenture | 1 | |
| JointVentureClass | JointVentureClass | 1 | |
| JointVentureObjectType | JointVentureObjectType | 1 | |
| JointVentureOriginalCostObject | JointVentureOriginalCostObject | 1 | |
| JointVentureSubClass | JointVentureSubClass | 1 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangeTime | LastChangeTime | 1 | |
| LastScheduledDate | LastScheduledDate | 1 | |
| MRPController | MRPController | 3 | |
| NetworkActivityConfirmation | NetworkActivityConfirmation | 1 | |
| NetworkIsAccountAssigned | NetworkIsAccountAssigned | 1 | |
| NetworkProfile | NetworkProfile | 1 | |
| ObjBasedAuthorizationIsActive | ObjBasedAuthorizationIsActive | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrderIsNotCostedAutomatically | OrderIsNotCostedAutomatically | 1 | |
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | 1 | |
| OverheadCode | OverheadCode | 1 | |
| PlannedCostsCostingVariant | PlannedCostsCostingVariant | 1 | |
| PlannedEndDate | PlannedEndDate | 1 | |
| PlannedStartDate | PlannedStartDate | 1 | |
| Plant | Plant | 3 | |
| PriorityCode | PriorityCode | 1 | |
| ProductConfiguration | ProductConfiguration | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectInternalID | ProjectInternalID | 2 | |
| ProjectNetworkDescription | ProjectNetworkDescription | 4 | |
| ProjectNetworkInternalID | ProjectNetworkInternalID | 3 | |
| ProjectNetworkObject | objnr,ProjectNetworkObject | 3 | |
| ProjectNetworkType | ProjectNetworkType | 3 | |
| ProjNtwkInterestCalcProfile | ProjNtwkInterestCalcProfile | 1 | |
| Reservation | Reservation | 1 | |
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| ScheduledBasicEndDate | ScheduledBasicEndDate | 2 | |
| ScheduledBasicStartDate | ScheduledBasicStartDate | 2 | |
| ScheduledFcstdReleaseDate | ScheduledFcstdReleaseDate | 1 | |
| ScheduledForecastedEndDate | ScheduledForecastedEndDate | 1 | |
| ScheduledForecastedStartDate | ScheduledForecastedStartDate | 1 | |
| ScheduledReleaseDate | ScheduledReleaseDate | 1 | |
| SuperiorProjectNetwork | SuperiorProjectNetwork | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| WBSElementInternalID | WBSElementInternalID | 3 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Project Network Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTNETWORK (
PROJECTNETWORK,
_BUSINESSAREA,
_COMPANYCODE,
_CONTROLLINGAREA,
_CONTROLLINGOBJECTCLASS,
_COSTCENTER,
_CURRENCY,
_FUNCTIONALAREA,
_MRPCONTROLLER,
_NETWORKPROFILE,
_NETWORKSHORTTEXT,
_ORDERCATEGORY,
_ORDERTYPE,
_PLANT,
_PRIORITYCODE,
_PROFITCENTER,
_RESPONSIBLEPLANNERGROUP,
_SALESORDER,
_SALESORDERITEM,
_TAXJURISDICTION,
_WBSELEMENT,
ACTUALCOSTSCOSTINGVARIANT,
ACTUALENDDATE,
ACTUALRELEASEDDATE,
ACTUALSTARTDATE,
BASEUNIT,
BASICSCHEDULINGTYPE,
BUSINESSAREA,
CAPACITYREQUIREMENT,
CHANGENUMBER,
COMPANYCODE,
CONFIRMEDENDDATE,
CONTROLLINGAREA,
CONTROLLINGOBJECTCLASS,
COSTCENTER,
COSTELEMENT,
COSTINGSHEET,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CURRENCY,
FORECASTEDENDDATE,
FORECASTEDSTARTDATE,
FORECASTSCHEDULINGTYPE,
FUNCTIONALAREA,
ISMARKEDFORDELETION,
JOINTVENTURE,
JOINTVENTURECLASS,
JOINTVENTUREOBJECTTYPE,
JOINTVENTUREORIGINALCOSTOBJECT,
JOINTVENTURESUBCLASS,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
LASTCHANGETIME,
LASTSCHEDULEDDATE,
MRPCONTROLLER,
NETWORKACTIVITYCONFIRMATION,
NETWORKISACCOUNTASSIGNED,
NETWORKPROFILE,
OBJBASEDAUTHORIZATIONISACTIVE,
ORDERCATEGORY,
ORDERID,
ORDERISNOTCOSTEDAUTOMATICALLY,
ORDISNOTSCHEDLDAUTOMATICALLY,
OVERHEADCODE,
PLANNEDCOSTSCOSTINGVARIANT,
PLANNEDENDDATE,
PLANNEDSTARTDATE,
PLANT,
PRIORITYCODE,
PRODUCTCONFIGURATION,
PROFITCENTER,
PROJECTINTERNALID,
PROJECTNETWORKDESCRIPTION,
PROJECTNETWORKINTERNALID,
PROJECTNETWORKOBJECT,
PROJECTNETWORKTYPE,
PROJNTWKINTERESTCALCPROFILE,
RESERVATION,
RESPONSIBLEPLANNERGROUP,
SALESORDER,
SALESORDERITEM,
SCHEDULEDBASICENDDATE,
SCHEDULEDBASICSTARTDATE,
SCHEDULEDFCSTDRELEASEDATE,
SCHEDULEDFORECASTEDENDDATE,
SCHEDULEDFORECASTEDSTARTDATE,
SCHEDULEDRELEASEDATE,
SUPERIORPROJECTNETWORK,
TAXJURISDICTION,
WBSELEMENTINTERNALID,
PRIMARY KEY (PROJECTNETWORK)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA