P_ProcOrdOpSuccssrPhaseCalc

DDL: P_PROCORDOPSUCCSSRPHASECALC SQL: PPOROPSUCPHSCLC Type: view COMPOSITE
8 Fields 1 Data Sources 1 Associations

P_ProcOrdOpSuccssrPhaseCalc is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ProcOrdCurOpPhseAggrgn) and exposes 8 fields with key field OrderInternalBillOfOperations. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdCurOpPhseAggrgn _MaxOpPhase from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BillOfOperationsRelationship _SuccssrPhase _SuccssrPhase.BillOfOperationsType = _MaxOpPhase.BillOfOperationsType and _SuccssrPhase.PrdcssrBOOGroup = _MaxOpPhase.BillOfOperationsGroup and _SuccssrPhase.PrdcssrBOOVariant = _MaxOpPhase.BillOfOperationsVariant and _SuccssrPhase.PrdcssrBOOOpInternalID = _MaxOpPhase.OrderOperationInternalID and _SuccssrPhase.BOORelationshipType = '1' and _SuccssrPhase.IsDeleted = ''

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPOROPSUCPHSCLC 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 (8)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations P_ProcOrdCurOpPhseAggrgn OrderInternalBillOfOperations Order Internal Bill of Operations
ProcessOrder P_ProcOrdCurOpPhseAggrgn ProcessOrder Order
OrderIntBillOfOperationsItem P_ProcOrdCurOpPhseAggrgn OrderOperationInternalID
CurOperation P_ProcOrdCurOpPhseAggrgn CurOperation
BillOfOperationsType P_ProcOrdCurOpPhseAggrgn BillOfOperationsType Task List Type
BillOfOperationsGroup P_ProcOrdCurOpPhseAggrgn BillOfOperationsGroup Group
BillOfOperationsVariant P_ProcOrdCurOpPhseAggrgn BillOfOperationsVariant Group Counter
SuccssrBOOOpInternalID _SuccssrPhase SuccssrBOOOpInternalID

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_ProcOrdOpSuccssrPhaseCalc.
-- 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: PPOROPSUCPHSCLC

CREATE VIEW P_ProcOrdOpSuccssrPhaseCalc AS
SELECT
  _MaxOpPhase.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _MaxOpPhase.ProcessOrder AS ProcessOrder,
  _MaxOpPhase.OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  _MaxOpPhase.CurOperation AS CurOperation,
  _MaxOpPhase.BillOfOperationsType AS BillOfOperationsType,
  _MaxOpPhase.BillOfOperationsGroup AS BillOfOperationsGroup,
  _MaxOpPhase.BillOfOperationsVariant AS BillOfOperationsVariant,
  _SuccssrPhase.SuccssrBOOOpInternalID AS SuccssrBOOOpInternalID
FROM P_ProcOrdCurOpPhseAggrgn AS _MaxOpPhase
LEFT OUTER JOIN I_BillOfOperationsRelationship AS _SuccssrPhase ON _SuccssrPhase.BillOfOperationsType = _MaxOpPhase.BillOfOperationsType AND _SuccssrPhase.PrdcssrBOOGroup = _MaxOpPhase.BillOfOperationsGroup AND _SuccssrPhase.PrdcssrBOOVariant = _MaxOpPhase.BillOfOperationsVariant AND _SuccssrPhase.PrdcssrBOOOpInternalID = _MaxOpPhase.OrderOperationInternalID AND _SuccssrPhase.BOORelationshipType = '1' AND _SuccssrPhase.IsDeleted = ''  -- association [0..1]
;

Learn More