P_ProcOrdOpsMgmtStatus

DDL: P_PROCORDOPSMGMTSTATUS SQL: PPRCORDOPSSTS Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG
15 Fields 1 Data Sources

Process order operations status

P_ProcOrdOpsMgmtStatus is a Composite CDS View that provides data about "Process order operations status" in SAP S/4HANA. It reads from 1 data source (P_ProcOrdMgmtOperationCalc) and exposes 15 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdMgmtOperationCalc P_ProcOrdMgmtOperationCalc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRCORDOPSSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ProcessOrder ProcessOrder Order
WorkCenter WorkCenter Work Center
ManufacturingOrderSequence ManufacturingOrderSequence
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ProductionPlant ProductionPlant Prod plnt
ProductionSupervisor ProductionSupervisor Prodn Supervisor
WorkCenterInternalID WorkCenterInternalID Work Center
ProcOrdOpStatusCode ProcOrdOpStatusCode
OpLtstSchedldExecStrtDte OpLtstSchedldExecStrtDte Latest start
Material Material Vehicle Model
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte Lat.finish date
_OrderInternalID _OrderInternalID

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_ProcOrdOpsMgmtStatus.
-- 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: PPRCORDOPSSTS

CREATE VIEW P_ProcOrdOpsMgmtStatus AS
SELECT
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  ProcessOrder,
  WorkCenter,
  ManufacturingOrderSequence,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  ProductionSupervisor,
  WorkCenterInternalID,
  ProcOrdOpStatusCode,
  OpLtstSchedldExecStrtDte,
  Material,
  OpLtstSchedldExecEndDte
FROM P_ProcOrdMgmtOperationCalc
;

Learn More