P_ProcOrdOpScrapIssAggrgn

DDL: P_PROCORDOPSCRAPISSAGGRGN Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG
6 Fields 2 Data Sources

Process Order Operation Scrap Issues Aggregation

P_ProcOrdOpScrapIssAggrgn is a Composite CDS View that provides data about "Process Order Operation Scrap Issues Aggregation" in SAP S/4HANA. It reads from 2 data sources (I_OrderOperation, P_ProcessOrderHeader) and exposes 6 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOpItemOfPhase. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (2)

SourceAliasJoin Type
I_OrderOperation afvg from
P_ProcessOrderHeader aufv inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (6)

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

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_ProcOrdOpScrapIssAggrgn.
-- 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_ProcOrdOpScrapIssAggrgn AS
SELECT
  afvg.OrderInternalID AS OrderInternalBillOfOperations,
  afvg.OrderIntBillOfOpItemOfPhase AS OrderIntBillOfOpItemOfPhase,
  aufv.OrderID AS ProcessOrder,
  aufv.Plant AS ProductionPlant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  'X' AS ProcOrdOpHasQualityIssue
FROM I_OrderOperation AS afvg
INNER JOIN P_ProcessOrderHeader AS aufv ON /* join condition not captured in parsed metadata */
;

Learn More