P_ProcOrdMisgCompAggrgn

DDL: P_PROCORDMISGCOMPAGGRGN Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG

Process Order Missing Components Aggregation

P_ProcOrdMisgCompAggrgn is a Composite CDS View that provides data about "Process Order Missing Components Aggregation" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 2 fields with key field ManufacturingOrder. Part of development package VDM_PP_PROC_ORD_MNG.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent I_MfgOrderOperationComponent from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder
NumberOfMissingComponents 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType:  #COMPOSITE
@VDM.private: true
define view entity P_ProcOrdMisgCompAggrgn
  as select from I_MfgOrderOperationComponent
{
  key ManufacturingOrder,
      count(*) as NumberOfMissingComponents
}
where
      MaterialComponentIsMissing = 'X'
  and ReservationIsFinallyIssued = ''
  and ManufacturingOrderCategory = '40'
group by
  ManufacturingOrder

Learn More