P_ProcOrdMgmtOp

DDL: P_PROCORDMGMTOP SQL: PPORMGMTOP Type: view COMPOSITE
26 Fields 2 Data Sources

P_ProcOrdMgmtOp 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 (12)

NameValueLevelField
AbapCatalog.sqlViewName PPORMGMTOP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT 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 OrderOperationInternalID Plan No.f.Oper.
ProcessOrder I_LogisticsOrder OrderID Order ID
ManufacturingOrderCategory I_LogisticsOrder OrderCategory Order Category
ProductionPlant I_LogisticsOrder Plant Valuation Area
ProductionSupervisor I_LogisticsOrder ProductionSupervisor Prodn Supervisor
Sequence Sequence Visit Sequence
Operation Operation Transaction
StandardTextInternalID StandardTextInternalID Std Text Key
OperationText OperationText Description
Language Language Report Text Language
BillOfOperationsSequence BillOfOperationsSequence Sequence
BillOfOperationsType I_OrderOperationBasic BillOfOperationsType Task List Type
BillOfOperationsGroup I_OrderOperationBasic BillOfOperationsGroup Group
BillOfOperationsVariant I_OrderOperationBasic BillOfOperationsVariant Group Counter
BOOOperationInternalID BOOOperationInternalID Task list node
BillOfOperationsVersion I_OrderOperationBasic BillOfOperationsVersion Routing Version
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
OperationControlProfile OperationControlProfile Control Key
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
Plant I_OrderOperationBasic Plant Valuation Area
ObjectInternalID I_OrderOperationBasic ObjectInternalID Object number
MfgOrderOperationIsPhase MfgOrderOperationIsPhase Ind.: Phase
_OrderInternalID _OrderInternalID
OrderIntBillOfOpItemOfPhase 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_ProcOrdMgmtOp.
-- 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: PPORMGMTOP

CREATE VIEW P_ProcOrdMgmtOp AS
SELECT
  afvc.OrderInternalID AS OrderInternalID,
  OrderOperationInternalID,
  aufv.OrderID AS ProcessOrder,
  aufv.OrderCategory AS ManufacturingOrderCategory,
  aufv.Plant AS ProductionPlant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  Sequence,
  Operation,
  StandardTextInternalID,
  OperationText,
  Language,
  BillOfOperationsSequence,
  afvc.BillOfOperationsType AS BillOfOperationsType,
  afvc.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvc.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOOOperationInternalID,
  afvc.BillOfOperationsVersion AS BillOfOperationsVersion,
  SuperiorOperationInternalID,
  OperationControlProfile,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  afvc.Plant AS Plant,
  afvc.ObjectInternalID AS ObjectInternalID,
  MfgOrderOperationIsPhase,
  OrderIntBillOfOpItemOfPhase
FROM I_OrderOperationBasic AS afvc
INNER JOIN I_LogisticsOrder AS aufv ON /* join condition not captured in parsed metadata */
;

Learn More