P_ProjSchedMaintOrderAttrib

DDL: P_PROJSCHEDMAINTORDERATTRIB SQL: PMAINTORDATTR Type: view COMPOSITE Package: ODATA_PROJECT_SCHEDULE
26 Fields 1 Data Sources 2 Associations

Work Order Attributes

P_ProjSchedMaintOrderAttrib is a Composite CDS View that provides data about "Work Order Attributes" in SAP S/4HANA. It reads from 1 data source (I_ProjSchedMaintOrderData) and exposes 26 fields with key field ProjectNetwork. It has 2 associations to related views. Part of development package ODATA_PROJECT_SCHEDULE.

Data Sources (1)

SourceAliasJoin Type
I_ProjSchedMaintOrderData MaintanenceOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_Notification _Notification $projection.ProjectNetwork = _Notification.OrderID
[0..1] I_ProjSchedMaintOrderBasicData _MaintenanceOrderBasicData $projection.ProjectNetwork = _MaintenanceOrderBasicData.MaintenanceOrder

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTORDATTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork I_ProjSchedMaintOrderData MaintenanceOrder Order
ProjectNetworkInternalID I_ProjSchedMaintOrderData OrderInternalBillOfOperations Order Internal Bill of Operations
ProjectNetworkObject I_ProjSchedMaintOrderData ObjectInternalID Object number
ProjectObject
ProjectObjectNodeType
ProjectNetworkDescription I_ProjSchedMaintOrderData OrderDescription
PlannedStartDate I_ProjSchedMaintOrderData PlannedStartDate Latest Planned Start
PlannedEndDate I_ProjSchedMaintOrderData PlannedEndDate Ltst Planned Finish
ScheduledBasicStartDate I_ProjSchedMaintOrderData ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate I_ProjSchedMaintOrderData ScheduledBasicEndDate Sched. finish
ActualStartDate I_ProjSchedMaintOrderData ActualStartDate Actual Start
ActualEndDate I_ProjSchedMaintOrderData ActualEndDate Actual Finish
PriorityCode I_ProjSchedMaintOrderData PriorityCode Priority
Plant I_ProjSchedMaintOrderData Plant Valuation Area
CompanyCode I_ProjSchedMaintOrderData CompanyCode Receiver Company Code
CreationDate I_ProjSchedMaintOrderData CreationDate Time Stamp
CreatedByUser I_ProjSchedMaintOrderData CreatedByUser User Name
LastChangeDate I_ProjSchedMaintOrderData LastChangeDate Time Stamp
MRPController I_ProjSchedMaintOrderData MRPController MRP Controller
CostCenter I_ProjSchedMaintOrderData CostCenter Cost Center
FactoryCalendar
BasicSchedulingType BasicSchedulingType Scheduling type
ResponsiblePerson _MaintenanceOrderBasicData MaintOrdPersonResponsible Person Resp. ID
ResponsiblePersonName
_MaintenanceOrderBasicData _MaintenanceOrderBasicData
_Notification _Notification

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 P_ProjSchedMaintOrderAttrib.
-- 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.
-- SQL view name: PMAINTORDATTR

CREATE VIEW P_ProjSchedMaintOrderAttrib AS
SELECT
  MaintanenceOrder.MaintenanceOrder AS ProjectNetwork,
  MaintanenceOrder.OrderInternalBillOfOperations AS ProjectNetworkInternalID,
  MaintanenceOrder.ObjectInternalID AS ProjectNetworkObject,
  MaintanenceOrder._Project.ProjectObject AS ProjectObject,
  'OR' AS ProjectObjectNodeType,
  MaintanenceOrder.OrderDescription AS ProjectNetworkDescription,
  MaintanenceOrder.PlannedStartDate AS PlannedStartDate,
  MaintanenceOrder.PlannedEndDate AS PlannedEndDate,
  MaintanenceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  MaintanenceOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  MaintanenceOrder.ActualStartDate AS ActualStartDate,
  MaintanenceOrder.ActualEndDate AS ActualEndDate,
  MaintanenceOrder.PriorityCode AS PriorityCode,
  MaintanenceOrder.Plant AS Plant,
  MaintanenceOrder.CompanyCode AS CompanyCode,
  MaintanenceOrder.CreationDate AS CreationDate,
  MaintanenceOrder.CreatedByUser AS CreatedByUser,
  MaintanenceOrder.LastChangeDate AS LastChangeDate,
  MaintanenceOrder.MRPController AS MRPController,
  MaintanenceOrder.CostCenter AS CostCenter,
  MaintanenceOrder._Plant.FactoryCalendar AS FactoryCalendar,
  BasicSchedulingType,
  _MaintenanceOrderBasicData.MaintOrdPersonResponsible AS ResponsiblePerson,
  _MaintenanceOrderBasicData._ProjSchedMaintOrdRespPerson.MaintOrdPersonResponsibleName AS ResponsiblePersonName
FROM I_ProjSchedMaintOrderData AS MaintanenceOrder
LEFT OUTER JOIN I_Notification AS _Notification ON ProjectNetwork = _Notification.OrderID  -- association [0..*]
LEFT OUTER JOIN I_ProjSchedMaintOrderBasicData AS _MaintenanceOrderBasicData ON ProjectNetwork = _MaintenanceOrderBasicData.MaintenanceOrder  -- association [0..1]
;

Learn More