A_ProjectNetwork

DDL: A_PROJECTNETWORK Type: view_entity COMPOSITE
73 Fields 1 Data Sources 2 Associations

Project Network

A_ProjectNetwork is a Composite CDS View that provides data about "Project Network" in SAP S/4HANA. It reads from 1 data source (R_ProjectNetworkTP) and exposes 73 fields with key field ProjectNetwork. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjectNetworkTP R_ProjectNetworkTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_ProjectNetworkStatus _ProjectNetworkStatus $projection.ProjectNetwork = _ProjectNetworkStatus.ProjectNetwork
[1..1] E_LogisticsOrder _Extension $projection.ProjectNetwork = _Extension.OrderID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Network view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entitySet.name ProjectNetwork view
OData.entityType.name ProjectNetwork_Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork ProjectNetwork Order
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
ProjectNetworkDescription ProjectNetworkDescription Network Name
ProjNtwkLangBsdDescription ProjNtwkLangBsdDescription
ProjectNetworkType ProjectNetworkType
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ScheduledReleaseDate ScheduledReleaseDate
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledFcstdReleaseDate ScheduledFcstdReleaseDate
ActualReleasedDate ActualReleasedDate
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
BasicSchedulingType BasicSchedulingType Scheduling type
BasicSchedulingReductionLevel BasicSchedulingReductionLevel
OrdIsNotSchedldAutomatically OrdIsNotSchedldAutomatically No auto. cost.
CapacityRqmtHasNotToBeCreated CapacityRqmtHasNotToBeCreated
SchedulingIsAllowingForBreaks SchedulingIsAllowingForBreaks
FcstSchedulingReductionLevel FcstSchedulingReductionLevel
ProjectExternalID ProjectExternalID Project def.
ProjectInternalID ProjectInternalID Project Def.
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SuperiorProjectNetwork SuperiorProjectNetwork Subnetwork of
SuperiorProjectNetworkIntID SuperiorProjectNetworkIntID
SuperiorNtwkActivityExternalID SuperiorNtwkActivityExternalID Operation/Activity
SuperiorNtwkActivityInternalID SuperiorNtwkActivityInternalID
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
ControllingObjectClass ControllingObjectClass Object Class
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
Currency Currency Valuation Crcy
ResponsiblePlannerGroup ResponsiblePlannerGroup
ChangeNumber ChangeNumber Change Number
NetworkProfile NetworkProfile
Plant Plant Valuation Area
MRPController MRPController MRP Controller
PriorityCode PriorityCode Priority
BaseUnit BaseUnit Unit of Measure
PlannedTotalQty PlannedTotalQty
CostingSheet CostingSheet Costing Sheet
PlannedCostsCostingVariant PlannedCostsCostingVariant Plnd Costing Variant
ActualCostsCostingVariant ActualCostsCostingVariant Act. Costing Variant
OverheadCode OverheadCode Overhead Key
PlannedCostCalculation PlannedCostCalculation
PurReqnOrResvnGeneration PurReqnOrResvnGeneration Purchase Reqn. / Resvn. Generation
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
JointVenture JointVenture Joint venture
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureObjectType JointVentureObjectType JV Object Type
JointVentureClass JointVentureClass JIB/JIBE Class
JointVentureSubClass JointVentureSubClass JIB/JIBE SbClsA
JointVentureOriginalCostObject JointVentureOriginalCostObject Or. Cost Obj.
NetworkIsAccountAssigned NetworkIsAccountAssigned
ProcurementMode ProcurementMode
ProjectNetworkExecutionRate ProjectNetworkExecutionRate
StatusCombinationCode StatusCombinationCode
ProjectNetworkObject ProjectNetworkObject
ControllingObject ControllingObject Object number
ObjBasedAuthorizationIsActive ObjBasedAuthorizationIsActive
_ProjectNetworkStatus _ProjectNetworkStatus

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ProjectNetwork.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_ProjectNetwork AS
SELECT
  ProjectNetwork,
  ProjectNetworkInternalID,
  ProjectNetworkDescription,
  ProjNtwkLangBsdDescription,
  ProjectNetworkType,
  PlannedStartDate,
  PlannedEndDate,
  ScheduledReleaseDate,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate,
  ScheduledFcstdReleaseDate,
  ActualReleasedDate,
  ActualStartDate,
  ActualEndDate,
  BasicSchedulingType,
  BasicSchedulingReductionLevel,
  OrdIsNotSchedldAutomatically,
  CapacityRqmtHasNotToBeCreated,
  SchedulingIsAllowingForBreaks,
  FcstSchedulingReductionLevel,
  ProjectExternalID,
  ProjectInternalID,
  WBSElementExternalID,
  WBSElementInternalID,
  SalesOrder,
  SalesOrderItem,
  SuperiorProjectNetwork,
  SuperiorProjectNetworkIntID,
  SuperiorNtwkActivityExternalID,
  SuperiorNtwkActivityInternalID,
  ControllingArea,
  CompanyCode,
  BusinessArea,
  ProfitCenter,
  FunctionalArea,
  ControllingObjectClass,
  TaxJurisdiction,
  ResponsibleCostCenter,
  Currency,
  ResponsiblePlannerGroup,
  ChangeNumber,
  NetworkProfile,
  Plant,
  MRPController,
  PriorityCode,
  BaseUnit,
  PlannedTotalQty,
  CostingSheet,
  PlannedCostsCostingVariant,
  ActualCostsCostingVariant,
  OverheadCode,
  PlannedCostCalculation,
  PurReqnOrResvnGeneration,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  IsMarkedForDeletion,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass,
  JointVentureOriginalCostObject,
  NetworkIsAccountAssigned,
  ProcurementMode,
  ProjectNetworkExecutionRate,
  StatusCombinationCode,
  ProjectNetworkObject,
  ControllingObject,
  ObjBasedAuthorizationIsActive
FROM R_ProjectNetworkTP
LEFT OUTER JOIN A_ProjectNetworkStatus AS _ProjectNetworkStatus ON ProjectNetwork = _ProjectNetworkStatus.ProjectNetwork  -- association [1..*]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ProjectNetwork = _Extension.OrderID  -- association [1..1]
;

Learn More