P_ProdOrdMgmtOp

DDL: P_PRODORDMGMTOP Type: view_entity COMPOSITE
26 Fields 2 Data Sources

P_ProdOrdMgmtOp is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OrderOperationBasic, I_LogisticsOrder) and exposes 26 fields with key fields OrderInternalID, OrderOperationInternalID.

Data Sources (2)

SourceAliasJoin Type
I_OrderOperationBasic afvc from
I_LogisticsOrder aufv inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderOperationBasic OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
ManufacturingOrder I_LogisticsOrder OrderID Order ID
ManufacturingOrderCategory I_LogisticsOrder OrderCategory Order Category
ProductionPlant I_LogisticsOrder Plant Valuation Area
ProductionSupervisor I_LogisticsOrder ProductionSupervisor Prodn Supervisor
Sequence I_OrderOperationBasic Sequence Visit Sequence
Operation I_OrderOperationBasic Operation Transaction
StandardTextInternalID I_OrderOperationBasic StandardTextInternalID Std Text Key
OperationText I_OrderOperationBasic OperationText Description
Language I_OrderOperationBasic Language Report Text Language
BillOfOperationsSequence I_OrderOperationBasic BillOfOperationsSequence Sequence
BillOfOperationsType I_OrderOperationBasic BillOfOperationsType Task List Type
BillOfOperationsGroup I_OrderOperationBasic BillOfOperationsGroup Group
BillOfOperationsVariant I_OrderOperationBasic BillOfOperationsVariant Group Counter
BOOOperationInternalID I_OrderOperationBasic BOOOperationInternalID Task list node
BillOfOperationsVersion I_OrderOperationBasic BillOfOperationsVersion Routing Version
SuperiorOperationInternalID I_OrderOperationBasic SuperiorOperationInternalID Sup. Op. Node
OperationControlProfile I_OrderOperationBasic OperationControlProfile Control Key
WorkCenterInternalID I_OrderOperationBasic WorkCenterInternalID Work Center
WorkCenterTypeCode I_OrderOperationBasic WorkCenterTypeCode Object Type
Plant I_OrderOperationBasic Plant Valuation Area
ObjectInternalID I_OrderOperationBasic ObjectInternalID Object number
MfgOrderOperationIsPhase I_OrderOperationBasic MfgOrderOperationIsPhase Ind.: Phase
_OrderInternalID I_OrderOperationBasic _OrderInternalID
OrderIntBillOfOpItemOfPhase I_OrderOperationBasic OrderIntBillOfOpItemOfPhase Node

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_ProdOrdMgmtOp.
-- 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 P_ProdOrdMgmtOp AS
SELECT
  afvc.OrderInternalID AS OrderInternalID,
  afvc.OrderOperationInternalID AS OrderOperationInternalID,
  aufv.OrderID AS ManufacturingOrder,
  aufv.OrderCategory AS ManufacturingOrderCategory,
  aufv.Plant AS ProductionPlant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  afvc.Sequence AS Sequence,
  afvc.Operation AS Operation,
  afvc.StandardTextInternalID AS StandardTextInternalID,
  afvc.OperationText AS OperationText,
  afvc.Language AS Language,
  afvc.BillOfOperationsSequence AS BillOfOperationsSequence,
  afvc.BillOfOperationsType AS BillOfOperationsType,
  afvc.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvc.BillOfOperationsVariant AS BillOfOperationsVariant,
  afvc.BOOOperationInternalID AS BOOOperationInternalID,
  afvc.BillOfOperationsVersion AS BillOfOperationsVersion,
  afvc.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  afvc.OperationControlProfile AS OperationControlProfile,
  afvc.WorkCenterInternalID AS WorkCenterInternalID,
  afvc.WorkCenterTypeCode AS WorkCenterTypeCode,
  afvc.Plant AS Plant,
  afvc.ObjectInternalID AS ObjectInternalID,
  afvc.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afvc._OrderInternalID AS _OrderInternalID,
  afvc.OrderIntBillOfOpItemOfPhase AS OrderIntBillOfOpItemOfPhase
FROM I_OrderOperationBasic AS afvc
INNER JOIN I_LogisticsOrder AS aufv ON /* join condition not captured in parsed metadata */
;

Learn More