P_NmbrOfProcOrdOpValidPhases

DDL: P_NMBROFPROCORDOPVALIDPHASES Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG
6 Fields 2 Data Sources 1 Associations

Number of process order op confirmable phases

P_NmbrOfProcOrdOpValidPhases is a Composite CDS View that provides data about "Number of process order op confirmable phases" in SAP S/4HANA. It reads from 2 data sources (I_OrderOperation, P_ProcessOrderHeader) and exposes 6 fields with key fields ProcessOrder, MfgOrderInternalID, OrderIntBillOfOperationsItem. It has 1 association to related views. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (2)

SourceAliasJoin Type
I_OrderOperation afvg from
P_ProcessOrderHeader aufv inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OperationControlProfile _OperationControlProfile afvg.OperationControlProfile = _OperationControlProfile.OperationControlProfile

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder P_ProcessOrderHeader OrderID Order ID
KEY MfgOrderInternalID I_OrderOperation OrderInternalID Plan No.f.Oper.
KEY OrderIntBillOfOperationsItem I_OrderOperation OrderIntBillOfOpItemOfPhase Node
ProductionPlant P_ProcessOrderHeader Plant Valuation Area
ProductionSupervisor P_ProcessOrderHeader ProductionSupervisor Prodn Supervisor
NumberOfPhasesDisplayed

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_NmbrOfProcOrdOpValidPhases.
-- 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_NmbrOfProcOrdOpValidPhases AS
SELECT
  aufv.OrderID AS ProcessOrder,
  afvg.OrderInternalID AS MfgOrderInternalID,
  afvg.OrderIntBillOfOpItemOfPhase AS OrderIntBillOfOperationsItem,
  aufv.Plant AS ProductionPlant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  count(*) AS NumberOfPhasesDisplayed
FROM I_OrderOperation AS afvg
INNER JOIN P_ProcessOrderHeader AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON afvg.OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
;

Learn More