P_ProcOrdCurOp

DDL: P_PROCORDCUROP SQL: PPROCORDCUROP Type: view COMPOSITE
12 Fields 1 Data Sources 2 Associations

P_ProcOrdCurOp is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_LogisticsOrder) and exposes 12 fields with key field ProcessOrder. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LogisticsOrder _ProcOrd from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_ProcOrdLatestOpAggr _ProcOrdLatestOp $projection.OrderInternalBillOfOperations = _ProcOrdLatestOp.MfgOrderInternalID and $projection.ProcessOrder = _ProcOrdLatestOp.ProcessOrder and $projection.ProductionPlant = _ProcOrdLatestOp.ProductionPlant and $projection.ProductionSupervisor = _ProcOrdLatestOp.ProductionSupervisor
[0..1] P_ProcOrdFirstOpAggr _ProcOrdFirstOp $projection.OrderInternalBillOfOperations = _ProcOrdFirstOp.MfgOrderInternalID and $projection.ProcessOrder = _ProcOrdFirstOp.ProcessOrder and $projection.ProductionPlant = _ProcOrdFirstOp.ProductionPlant and $projection.ProductionSupervisor = _ProcOrdFirstOp.ProductionSupervisor

Annotations (10)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder OrderID Order ID
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
ManufacturingOrderCategory I_LogisticsOrder OrderCategory Order Category
ProductionPlant I_LogisticsOrder Plant Valuation Area
ProductionSupervisor I_LogisticsOrder ProductionSupervisor Prodn Supervisor
BillOfOperationsGroup I_LogisticsOrder BillOfOperations
BillOfOperationsType I_LogisticsOrder BillOfOperationsType Task List Type
BillOfOperationsVariant I_LogisticsOrder BillOfOperationsVariant Group Counter
LatestOperationendasCurOperation
_OrderCategory _OrderCategory
_Plant _Plant
_ProductionSupervisor _ProductionSupervisor

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_ProcOrdCurOp.
-- 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: PPROCORDCUROP

CREATE VIEW P_ProcOrdCurOp AS
SELECT
  OrderID AS ProcessOrder,
  OrderInternalBillOfOperations,
  _ProcOrd.OrderCategory AS ManufacturingOrderCategory,
  _ProcOrd.Plant AS ProductionPlant,
  _ProcOrd.ProductionSupervisor AS ProductionSupervisor,
  _ProcOrd.BillOfOperations AS BillOfOperationsGroup,
  _ProcOrd.BillOfOperationsType AS BillOfOperationsType,
  _ProcOrd.BillOfOperationsVariant AS BillOfOperationsVariant,
  case when _ProcOrdLatestOp.LatestOperation is null then _ProcOrdFirstOp.FirstOperation else _ProcOrdLatestOp.LatestOperation end as CurOperation AS LatestOperationendasCurOperation
FROM I_LogisticsOrder AS _ProcOrd
LEFT OUTER JOIN P_ProcOrdLatestOpAggr AS _ProcOrdLatestOp ON OrderInternalBillOfOperations = _ProcOrdLatestOp.MfgOrderInternalID AND ProcessOrder = _ProcOrdLatestOp.ProcessOrder AND ProductionPlant = _ProcOrdLatestOp.ProductionPlant AND ProductionSupervisor = _ProcOrdLatestOp.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdFirstOpAggr AS _ProcOrdFirstOp ON OrderInternalBillOfOperations = _ProcOrdFirstOp.MfgOrderInternalID AND ProcessOrder = _ProcOrdFirstOp.ProcessOrder AND ProductionPlant = _ProcOrdFirstOp.ProductionPlant AND ProductionSupervisor = _ProcOrdFirstOp.ProductionSupervisor  -- association [0..1]
;

Learn More