A_ProductionOrderOperation

DDL: A_PRODUCTIONORDEROPERATION Type: view_entity COMPOSITE
28 Fields 1 Data Sources 1 Associations

API Production Order Operations

A_ProductionOrderOperation is a Composite CDS View that provides data about "API Production Order Operations" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationDurn) and exposes 28 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 Production 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 (28)

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

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_ProductionOrderOperation.
-- 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_ProductionOrderOperation 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
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