I_PROJECTNETWORK

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);