I_MaintOrdCompPurOrderC

DDL: I_MAINTORDCOMPPURORDERC SQL: IMTORDCOMPPURORD Type: view COMPOSITE
60 Fields 1 Data Sources 2 Associations

Purchase Orders for Maintenance Orders

I_MaintOrdCompPurOrderC is a Composite CDS View that provides data about "Purchase Orders for Maintenance Orders" in SAP S/4HANA. It reads from 1 data source (P_MaintOrdDirectProcmtViaPO) and exposes 60 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MaintOrdDirectProcmtViaPO P_MaintOrdDirectProcmtViaPO from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaintOrderOperPlanningValues _MaintOrderOperPlanningValues _MaintOrderOperPlanningValues.MaintOrderRoutingNumber = P_MaintOrdDirectProcmtViaPO.MaintOrderRoutingNumber and _MaintOrderOperPlanningValues.MaintOrderOperationCounter = P_MaintOrdDirectProcmtViaPO.MaintOrderOperationCounter
[0..1] I_MaintenanceOrderComponent_2 _MaintenanceOrderComponent _MaintenanceOrderComponent.Reservation = P_MaintOrdDirectProcmtViaPO.Reservation and _MaintenanceOrderComponent.ReservationItem = P_MaintOrdDirectProcmtViaPO.ReservationItem

Annotations (9)

NameValueLevelField
EndUserText.label Purchase Orders for Maintenance Orders view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IMTORDCOMPPURORD view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
MaintenanceOrder MaintenanceOrder Order
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
MaintOrderOperationCounter MaintOrderOperationCounter Counter
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
ReferenceDate ReferenceDate Reference Date
MaintOrdBasicStartDate MaintOrdBasicStartDate Bas. Start Date
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Earl.start date
RequirementDate RequirementDate Requirement Date
Supplier Supplier Supplier
Material Material Vehicle Model
PurchasingProcessingStatus PurchasingProcessingStatus Proc. State
MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
MaintenanceOrderDesc MaintenanceOrderDesc Description
MaintOrdComponentIsMissing MaintOrdComponentIsMissing
OrderQuantity OrderQuantity Quantity
ReceivedQuantity ReceivedQuantity Quantity Received
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
ProductType ProductType Product Type Group
MaterialGroup MaterialGroup Product Group
PurchaseOrderItemText PurchaseOrderItemText Short Text
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
NetAmount NetAmount Stated Amount
DocumentCurrency DocumentCurrency Document Currency
PurchasingGroup PurchasingGroup Purchasing Group
ReleaseIsNotCompleted ReleaseIsNotCompleted Subj.to Release
MaintenanceOrderType MaintenanceOrderType Order Type
MaintPriorityType MaintPriorityType PriorityType
MaintPriority MaintPriority Priority
MaintPriorityDesc MaintPriorityDesc Priority
MaintPriorityColorCode MaintPriorityColorCode
MaintenanceRevision MaintenanceRevision Revision
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicStartTime ScheduledBasicStartTime
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledBasicEndTime ScheduledBasicEndTime
PlantSection PlantSection Plant Section
WorkCenterInternalID WorkCenterInternalID Work Center
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
OperationDescription OperationDescription Op. Short Text
OperationText OperationText Description
MaintProcurementMilestone _ProcurementMilestone MaintProcurementMilestone Milestone
MaintOrdProcmtMilestoneDate _ProcurementMilestone MaintOrdProcmtMilestoneDate Milestone Date
MaintOrdProcmtMlstnDateTime _ProcurementMilestone MaintOrdProcmtMlstnDateTime Milestone Date&Time
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderComponent _MaintenanceOrderComponent
_MaintOrderOperPlanningValues _MaintOrderOperPlanningValues
_PurchaseOrderItem _PurchaseOrderItem
_Supplier _Supplier
_FuncnlLocationLabel _FuncnlLocationLabel

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 I_MaintOrdCompPurOrderC.
-- 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: IMTORDCOMPPURORD

CREATE VIEW I_MaintOrdCompPurOrderC AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  MaintenanceOrder,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Reservation,
  ReservationItem,
  ReferenceDate,
  MaintOrdBasicStartDate,
  OpErlstSchedldExecStrtDte,
  RequirementDate,
  Supplier,
  Material,
  PurchasingProcessingStatus,
  MaintenanceOrderOperation,
  MaintenanceOrderDesc,
  MaintOrdComponentIsMissing,
  OrderQuantity,
  ReceivedQuantity,
  PurchaseOrderQuantityUnit,
  ProductType,
  MaterialGroup,
  PurchaseOrderItemText,
  Plant,
  StorageLocation,
  NetAmount,
  DocumentCurrency,
  PurchasingGroup,
  ReleaseIsNotCompleted,
  MaintenanceOrderType,
  MaintPriorityType,
  MaintPriority,
  MaintPriorityDesc,
  MaintPriorityColorCode,
  MaintenanceRevision,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  MainWorkCenter,
  MainWorkCenterPlant,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  PlantSection,
  WorkCenterInternalID,
  Equipment,
  FunctionalLocation,
  MaintObjectLocAcctAssgmtNmbr,
  OperationDescription,
  OperationText,
  _ProcurementMilestone.MaintProcurementMilestone AS MaintProcurementMilestone,
  _ProcurementMilestone.MaintOrdProcmtMilestoneDate AS MaintOrdProcmtMilestoneDate,
  _ProcurementMilestone.MaintOrdProcmtMlstnDateTime AS MaintOrdProcmtMlstnDateTime
FROM P_MaintOrdDirectProcmtViaPO
LEFT OUTER JOIN I_MaintOrderOperPlanningValues AS _MaintOrderOperPlanningValues ON _MaintOrderOperPlanningValues.MaintOrderRoutingNumber = P_MaintOrdDirectProcmtViaPO.MaintOrderRoutingNumber AND _MaintOrderOperPlanningValues.MaintOrderOperationCounter = P_MaintOrdDirectProcmtViaPO.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent ON _MaintenanceOrderComponent.Reservation = P_MaintOrdDirectProcmtViaPO.Reservation AND _MaintenanceOrderComponent.ReservationItem = P_MaintOrdDirectProcmtViaPO.ReservationItem  -- association [0..1]
;

Learn More