C_ProjectScheduleNetworkDetail

DDL: C_PROJECTSCHEDULENETWORKDETAIL Type: view_entity CONSUMPTION
55 Fields 1 Data Sources 2 Associations

Project Schedule Network Details

C_ProjectScheduleNetworkDetail is a Consumption CDS View that provides data about "Project Schedule Network Details" in SAP S/4HANA. It reads from 1 data source (R_ProjNetworkGraphOverviewTP) and exposes 55 fields with key fields ProjectNetwork, Version, ProjectObjectRootNode. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjNetworkGraphOverviewTP R_ProjNetworkGraphOverviewTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ProjScheduleProjectForDetail _Project $projection.ProjectInternalID = _Project.ProjectInternalID
[0..1] C_ProjSchedWBSElementForDetail _WBSElement _WBSElement.WBSElementInternalID = $projection.WBSElementInternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Project Schedule Network Details view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork ProjectNetwork Network
KEY Version Version XML Vers.
KEY ProjectObjectRootNode ProjectObjectRootNode Object number
ProjectNetworkDescription ProjectNetworkDescription Network Description
ProjectNetworkType ProjectNetworkType Network Type
OrderTypeName OrderTypeName
ProjectNetworkObject ProjectNetworkObject
ProjectInternalID ProjectInternalID Project Def.
WBSElementInternalID WBSElementInternalID WBS Internal ID
Plant Plant Valuation Area
MRPController MRPController MRP Controller
OrderCategory OrderCategory Order Category
PlantName PlantName Plant Name
PriorityCodeName PriorityCodeName Priority
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ControllingAreaName ControllingAreaName Long Text
CompanyCodeName CompanyCodeName Company Name
BusinessAreaName BusinessAreaName Business Area Name
ProfitCenterName ProfitCenterName Profit Center Name
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
BasicSchedulingType BasicSchedulingType Scheduling type
FcstSchedulingReductionLevel FcstSchedulingReductionLevel
OrdIsNotSchedldAutomatically OrdIsNotSchedldAutomatically No auto. cost.
CapacityRqmtHasNotToBeCreated CapacityRqmtHasNotToBeCreated
SchedulingIsAllowingForBreaks SchedulingIsAllowingForBreaks
SuperiorProjectNetwork SuperiorProjectNetwork Subnetwork of
SuperiorProjectNetworkIntID SuperiorProjectNetworkIntID
SuperiorNtwkActivityInternalID SuperiorNtwkActivityInternalID
SuperiorNtwkActivityExternalID SuperiorNtwkActivityExternalID Operation/Activity
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
ScheduledReleaseDate ScheduledReleaseDate
StatusProfile StatusProfile Status Profile
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSDescription WBSDescription WBS Element Name
ProjectExternalID ProjectExternalID Project def.
ProjectObject ProjectObject Object number
ProjectDescription ProjectDescription Project Name
ResponsiblePersonName ResponsiblePersonName User
PriorityCode PriorityCode Priority
CompanyCode CompanyCode Receiver Company Code
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
FactoryCalendar FactoryCalendar Factory Calendar
ObjBasedAuthorizationIsActive ObjBasedAuthorizationIsActive
_NetworkActivityByInternalKey _NetworkActivityByInternalKey
_Project _Project
_WBSElement _WBSElement

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 C_ProjectScheduleNetworkDetail.
-- 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 C_ProjectScheduleNetworkDetail AS
SELECT
  ProjectNetwork,
  Version,
  ProjectObjectRootNode,
  ProjectNetworkDescription,
  ProjectNetworkType,
  OrderTypeName,
  ProjectNetworkObject,
  ProjectInternalID,
  WBSElementInternalID,
  Plant,
  MRPController,
  OrderCategory,
  PlantName,
  PriorityCodeName,
  SalesOrder,
  SalesOrderItem,
  ControllingAreaName,
  CompanyCodeName,
  BusinessAreaName,
  ProfitCenterName,
  PlannedStartDate,
  PlannedEndDate,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate,
  ActualStartDate,
  ActualEndDate,
  BasicSchedulingType,
  FcstSchedulingReductionLevel,
  OrdIsNotSchedldAutomatically,
  CapacityRqmtHasNotToBeCreated,
  SchedulingIsAllowingForBreaks,
  SuperiorProjectNetwork,
  SuperiorProjectNetworkIntID,
  SuperiorNtwkActivityInternalID,
  SuperiorNtwkActivityExternalID,
  IsMarkedForDeletion,
  ScheduledReleaseDate,
  StatusProfile,
  WBSElementExternalID,
  WBSDescription,
  ProjectExternalID,
  ProjectObject,
  ProjectDescription,
  ResponsiblePersonName,
  PriorityCode,
  CompanyCode,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  ResponsibleCostCenter,
  FactoryCalendar,
  ObjBasedAuthorizationIsActive
FROM R_ProjNetworkGraphOverviewTP
LEFT OUTER JOIN C_ProjScheduleProjectForDetail AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN C_ProjSchedWBSElementForDetail AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;

Learn More