P_ProcOrdInspLotUsgeDcsnCodeR

DDL: P_PROCORDINSPLOTUSGEDCSNCODER Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG

Process Order Inspection Lots with Usage Decision Code R

P_ProcOrdInspLotUsgeDcsnCodeR is a Composite CDS View that provides data about "Process Order Inspection Lots with Usage Decision Code R" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, P_ProcOrdAORList_2) and exposes 4 fields with key field ProcessOrder. Part of development package VDM_PP_PROC_ORD_MNG.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionLot _InspLot inner
P_ProcOrdAORList_2 _ProcessOrder from

Annotations (6)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder P_ProcOrdAORList_2 OrderID
InspLotUsageDecisionValuation
ScheduledBasicStartDate P_ProcOrdAORList_2 ScheduledBasicStartDate
ScheduledBasicEndDate P_ProcOrdAORList_2 ScheduledBasicEndDate 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@VDM.viewType:  #COMPOSITE
@VDM.private: true
define view entity P_ProcOrdInspLotUsgeDcsnCodeR
  //Change selection for P_ProcOrdAORList_2 that is more optimized

  as select from P_ProcOrdAORList_2 as _ProcessOrder 
  inner join I_InspectionLot as _InspLot on _InspLot.ManufacturingOrder              = _ProcessOrder.OrderID
{
  key _ProcessOrder.OrderID as ProcessOrder,
//      _ProcessOrder.ProductionPlant,

//      _ProcessOrder.ProductionSupervisor,

      'R'                              as InspLotUsageDecisionValuation,
      //Expose Start and End dates to push-down filters to associations

      _ProcessOrder.ScheduledBasicStartDate,
      _ProcessOrder.ScheduledBasicEndDate
}
where
       _InspLot._InspLotUsageDecision.InspLotUsageDecisionValuation = 'R'
  and(
       _InspLot.InspectionLotOrigin                                 = '04'
    or _InspLot.InspectionLotOrigin                                 = '03'
  )
group by
  _ProcessOrder.OrderID,
  _ProcessOrder.ScheduledBasicStartDate,
  _ProcessOrder.ScheduledBasicEndDate
//  _ProcessOrder.ProductionPlant,

//  _ProcessOrder.ProductionSupervisor

Learn More