P_NmbrOfProcOrdOpsWithQltyIss

DDL: P_NMBROFPROCORDOPSWITHQLTYISS SQL: PPORNMBRQLTYISS Type: view COMPOSITE

P_NmbrOfProcOrdOpsWithQltyIss is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ProcOrdMgmtOperation) and exposes 5 fields with key field OrderInternalBillOfOperations.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdMgmtOperation Op from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPORNMBRQLTYISS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalID
ProcessOrder ProcessOrder
ProductionPlant ProductionPlant
ProductionSupervisor ProductionSupervisor
NmbrOfProcOrdOpsWithQltyIss 
@AbapCatalog.sqlViewName: 'PPORNMBRQLTYISS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType:  #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Nmbr of Proc Ord Ops phases with quality issues'

define view P_NmbrOfProcOrdOpsWithQltyIss
  as select from P_ProcOrdMgmtOperation as Op
{
  key    OrderInternalID                                  as OrderInternalBillOfOperations,
         ProcessOrder,
         ProductionPlant,
         ProductionSupervisor,
         count( distinct MfgOrderPhaseSuperiorOperation ) as NmbrOfProcOrdOpsWithQltyIss
}
where
      ManufacturingOrderCategory  = '40'
  and MfgOrderOperationIsPhase    = 'X' 
  and SuperiorOperationInternalID is initial
  and Sequence                    = '000000'
  and ProcOrdOpHasQualityIssue    = 'X'
  and OpActualExecutionStartDate != '00000000'
group by
  OrderInternalID,
  ProcessOrder,
  ProductionPlant,
  ProductionSupervisor

Learn More