C_ProjectShedMaintOrderGraph

DDL: C_PROJECTSHEDMAINTORDERGRAPH Type: view_entity CONSUMPTION
79 Fields 1 Data Sources 4 Associations

Maintanence Order Graph Overview

C_ProjectShedMaintOrderGraph is a Consumption CDS View that provides data about "Maintanence Order Graph Overview" in SAP S/4HANA. It reads from 1 data source (R_ProjSchedMaintOrderGraphTP) and exposes 79 fields with key fields MaintenanceOrder, ProjectObjectRootNode. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProjSchedMaintOrderGraphTP R_ProjSchedMaintOrderGraphTP projection

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_ProjScheduleProjectForDetail _Project _Project.ProjectInternalID = $projection.ProjectInternalID
[0..1] C_ProjSchedWBSElementForDetail _WBSElement _WBSElement.WBSElementInternalID = $projection.WBSElementInternalID
[0..1] C_ProjScheduleNetworkForDetail _ProjectNetwork _ProjectNetwork.ProjectNetwork = $projection.SuperiorProjectNetwork
[0..1] C_ProjSchedNtwkActyForDetail _NetworkActivity _NetworkActivity.ProjectNetworkInternalID = $projection.SuperiorProjectNetworkIntID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintanence Order Graph Overview 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 (79)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY ProjectObjectRootNode ProjectObjectRootNode Object number
MaintenanceOrderDesc MaintenanceOrderDesc Description
OrderTypeName OrderTypeName Order Type Name
ProjectNetworkObject ProjectNetworkObject Object number
ProjectInternalID ProjectInternalID Project Def.
WBSElementInternalID WBSElementInternalID WBS Internal ID
MaintenanceActivityType MaintenanceActivityType Maintenance Activity Type
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlannerGroupName MaintenancePlannerGroupName Planner Group Name
WorkCenter WorkCenter Main Work Center
WorkCenterText WorkCenterText Main Work Center Name
ResponsiblePerson ResponsiblePerson Responsible Person
MaintOrdPersonResponsibleName MaintOrdPersonResponsibleName Responsible Person Name
MaintPriority MaintPriority Priority
MaintPriorityDesc MaintPriorityDesc Priority
MaintenanceNotification MaintenanceNotification Notification Number
MaintenanceNotificationText MaintenanceNotificationText Notification
IsMarkedForDeletion IsMarkedForDeletion Flagged for Deletion
OperationSystemCondition OperationSystemCondition System Condition
CompanyCode CompanyCode Company Code
CompanyCodeName CompanyCodeName Company Name
ControllingArea ControllingArea Controlling Area
ControllingAreaName ControllingAreaName Long Text
BusinessArea BusinessArea Business Area
BusinessAreaName BusinessAreaName Business Area Name
ResponsibleCostCenter ResponsibleCostCenter Resp. Cost Center
ResponsibleCostCenterName ResponsibleCostCenterName
ProfitCenter ProfitCenter Profit Center
ProfitCenterName ProfitCenterName Profit Center Name
MainWorkCenterPlant MainWorkCenterPlant Work Center Plant
MaintenancePlanningPlantName MaintenancePlanningPlantName Planning Plant 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 Schedule Type
SchedulingTypeName SchedulingTypeName Schedule Type Name
LatestAcceptableCompletionDate LatestAcceptableCompletionDate Final Due Date
NotificationReportingDate NotificationReportingDate Notification Date
NotificationRequiredStartDate NotificationRequiredStartDate Requirement Start Date
NotificationRequiredEndDate NotificationRequiredEndDate Requirement End Date
Version Version XML Vers.
ProjectExternalID ProjectExternalID Project Definition
ProjectDescription ProjectDescription Project Definition Name
WBSElementExternalID WBSElementExternalID WBS Element
WBSDescription WBSDescription WBS Element Name
ProjectNetwork ProjectNetwork Network
ProjectNetworkDescription ProjectNetworkDescription Project Network Name
NetworkActivity NetworkActivity Network Activity ID
NetworkActivityDescription NetworkActivityDescription Network Activity Name
MaintOrdProcessPhaseCode MaintOrdProcessPhaseCode Process Phase
EAMProcessPhaseCodeDesc EAMProcessPhaseCodeDesc Process Phase Description
MaintOrdProcessSubPhaseCode MaintOrdProcessSubPhaseCode Process Subphase
EAMProcessSubPhaseCodeDesc EAMProcessSubPhaseCodeDesc Process Subphase Description
SuperiorProjectNetwork SuperiorProjectNetwork Subnetwork of
SuperiorProjectNetworkIntID SuperiorProjectNetworkIntID
SuperiorNtwkActivityInternalID SuperiorNtwkActivityInternalID
Plant Plant Valuation Area
MRPController MRPController MRP Controller
OrderType OrderType Order Type
OrderCategory OrderCategory Order Category
CostCenter CostCenter Cost Center
LatestSchedldFcstdStartDate LatestSchedldFcstdStartDate
LatestSchedldFcstdEndDate LatestSchedldFcstdEndDate
PriorityCode PriorityCode Priority
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
FactoryCalendar FactoryCalendar Factory Calendar
_WBSElement _WBSElement
_Project _Project
_Notification _Notification
_ProjectNetwork _ProjectNetwork
_NetworkActivity _NetworkActivity
_WBSElementData _WBSElementData
_Plant _Plant

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_ProjectShedMaintOrderGraph.
-- 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_ProjectShedMaintOrderGraph AS
SELECT
  MaintenanceOrder,
  ProjectObjectRootNode,
  MaintenanceOrderDesc,
  OrderTypeName,
  ProjectNetworkObject,
  ProjectInternalID,
  WBSElementInternalID,
  MaintenanceActivityType,
  MaintenancePlannerGroup,
  MaintenancePlannerGroupName,
  WorkCenter,
  WorkCenterText,
  ResponsiblePerson,
  MaintOrdPersonResponsibleName,
  MaintPriority,
  MaintPriorityDesc,
  MaintenanceNotification,
  MaintenanceNotificationText,
  IsMarkedForDeletion,
  OperationSystemCondition,
  CompanyCode,
  CompanyCodeName,
  ControllingArea,
  ControllingAreaName,
  BusinessArea,
  BusinessAreaName,
  ResponsibleCostCenter,
  ResponsibleCostCenterName,
  ProfitCenter,
  ProfitCenterName,
  MainWorkCenterPlant,
  MaintenancePlanningPlantName,
  PlannedStartDate,
  PlannedEndDate,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate,
  ActualStartDate,
  ActualEndDate,
  BasicSchedulingType,
  SchedulingTypeName,
  LatestAcceptableCompletionDate,
  NotificationReportingDate,
  NotificationRequiredStartDate,
  NotificationRequiredEndDate,
  Version,
  ProjectExternalID,
  ProjectDescription,
  WBSElementExternalID,
  WBSDescription,
  ProjectNetwork,
  ProjectNetworkDescription,
  NetworkActivity,
  NetworkActivityDescription,
  MaintOrdProcessPhaseCode,
  EAMProcessPhaseCodeDesc,
  MaintOrdProcessSubPhaseCode,
  EAMProcessSubPhaseCodeDesc,
  SuperiorProjectNetwork,
  SuperiorProjectNetworkIntID,
  SuperiorNtwkActivityInternalID,
  Plant,
  MRPController,
  OrderType,
  OrderCategory,
  CostCenter,
  LatestSchedldFcstdStartDate,
  LatestSchedldFcstdEndDate,
  PriorityCode,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  FactoryCalendar
FROM R_ProjSchedMaintOrderGraphTP
LEFT OUTER JOIN C_ProjScheduleProjectForDetail AS _Project ON _Project.ProjectInternalID = ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN C_ProjSchedWBSElementForDetail AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN C_ProjScheduleNetworkForDetail AS _ProjectNetwork ON _ProjectNetwork.ProjectNetwork = SuperiorProjectNetwork  -- association [0..1]
LEFT OUTER JOIN C_ProjSchedNtwkActyForDetail AS _NetworkActivity ON _NetworkActivity.ProjectNetworkInternalID = SuperiorProjectNetworkIntID  -- association [0..1]
;

Learn More