A_ProcessOrderOperation

DDL: A_PROCESSORDEROPERATION Type: view_entity COMPOSITE
30 Fields 1 Data Sources 1 Associations

API for Process Order Operations

A_ProcessOrderOperation is a Composite CDS View that provides data about "API for Process Order Operations" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationDurn) and exposes 30 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationDurn I_MfgOrderOperationDurn from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MfgOrderSequence _OrderSequence $projection.ManufacturingOrder = _OrderSequence.ManufacturingOrder and $projection.ManufacturingOrderSequence = _OrderSequence.ManufacturingOrderSequence and $projection.OrderInternalBillOfOperations = _OrderSequence.OrderInternalID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label API for Process Order Operations view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderOperation ManufacturingOrderOperation Activity
MfgOrderOperationIsPhase MfgOrderOperationIsPhase
ManufacturingOrderSequence ManufacturingOrderSequence
MfgOrderSequenceText
MfgOrderOperationText MfgOrderOperationText
ManufacturingOrderType ManufacturingOrderType
BusinessProcessEntryUnit BusinessProcessEntryUnit
ManufacturingOrderCategory ManufacturingOrderCategory
WorkCenterTypeCode WorkCenterTypeCode Work Center Type Code
WorkCenter WorkCenter Work Center
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Earliest Execution Start Date
OpErlstSchedldExecStrtTme OpErlstSchedldExecStrtTme Earliest Execution Start Time
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte Earliest Execution End Date
OpErlstSchedldExecEndTme OpErlstSchedldExecEndTme Earliest Execution End Time
OpActualExecutionStartDate OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime OpActualExecutionStartTime Actual Execution Start Time
OpActualExecutionEndDate OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime OpActualExecutionEndTime Actual Execution End Time
OperationUnit OperationUnit Act/op UoM
OpPlannedTotalQuantity OpPlannedTotalQuantity
ErlstSchedldExecDurnInWorkdays ErlstSchedldExecDurnInWorkdays Scheduled Execution Duration
OpActualExecutionDays OpActualExecutionDays Actual Execution Duration
OpTotalConfirmedYieldQty OpTotalConfirmedYieldQty
WorkCenterInternalID WorkCenterInternalID Work Center
LastChangeTimeendasLastChangeDateTime
ManufacturingOrderSubOperation ManufacturingOrderSubOperation
OperationControlProfile OperationControlProfile Control Key

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_ProcessOrderOperation.
-- 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_ProcessOrderOperation AS
SELECT
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  ManufacturingOrder,
  ManufacturingOrderOperation,
  MfgOrderOperationIsPhase,
  ManufacturingOrderSequence,
  cast(_OrderSequence.MfgOrderSequenceText as mfgordersequencetext preserving type) AS MfgOrderSequenceText,
  MfgOrderOperationText,
  ManufacturingOrderType,
  BusinessProcessEntryUnit,
  ManufacturingOrderCategory,
  WorkCenterTypeCode,
  WorkCenter,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  OperationUnit,
  OpPlannedTotalQuantity,
  ErlstSchedldExecDurnInWorkdays,
  OpActualExecutionDays,
  OpTotalConfirmedYieldQty,
  WorkCenterInternalID,
  case I_MfgOrderOperationDurn._MfgOrder.LastChangeDate when '00000000' then concat(I_MfgOrderOperationDurn._MfgOrder.MfgOrderCreationDate , I_MfgOrderOperationDurn._MfgOrder.MfgOrderCreationTime) else concat(I_MfgOrderOperationDurn._MfgOrder.LastChangeDate,I_MfgOrderOperationDurn._MfgOrder.LastChangeTime) end as LastChangeDateTime AS LastChangeTimeendasLastChangeDateTime,
  ManufacturingOrderSubOperation,
  OperationControlProfile
FROM I_MfgOrderOperationDurn
LEFT OUTER JOIN I_MfgOrderSequence AS _OrderSequence ON ManufacturingOrder = _OrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _OrderSequence.ManufacturingOrderSequence AND OrderInternalBillOfOperations = _OrderSequence.OrderInternalID  -- association [1..1]
;

Learn More