P_ProcOrdMgmtInspSubsetResult

DDL: P_PROCORDMGMTINSPSUBSETRESULT SQL: PPORINSPSSETRES Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG

Inspection Lot Subset Result

P_ProcOrdMgmtInspSubsetResult is a Composite CDS View that provides data about "Inspection Lot Subset Result" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, I_LogisticsOrder) and exposes 6 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. Part of development package VDM_PP_PROC_ORD_MNG.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionLot _InspLot inner
I_LogisticsOrder _ProcessOrder inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPORINSPSSETRES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot _InspSubsetResult InspectionLot
KEY InspPlanOperationInternalID _InspSubsetResult InspPlanOperationInternalID
KEY InspectionCharacteristic _InspSubsetResult InspectionCharacteristic
ProcessOrder I_LogisticsOrder OrderID
ProductionPlant I_LogisticsOrder Plant
ProductionSupervisor I_LogisticsOrder ProductionSupervisor 
@AbapCatalog.sqlViewName: 'PPORINSPSSETRES'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Inspection Lot Subset Result'

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@VDM.viewType:  #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ProcOrdMgmtInspSubsetResult
  as select distinct from I_InspSubsetResult as _InspSubsetResult
    inner join            I_InspectionLot    as _InspLot      on _InspLot.InspectionLot = _InspSubsetResult.InspectionLot
                                                              and(
                                                                InspectionLotType       = '04'
                                                                or InspectionLotType    = '03'
                                                              )
    inner join            I_LogisticsOrder   as _ProcessOrder on  _ProcessOrder.OrderID       = _InspLot.ManufacturingOrder
                                                              and _ProcessOrder.OrderCategory = '40'
{
  key _InspSubsetResult.InspectionLot               as InspectionLot,
  key _InspSubsetResult.InspPlanOperationInternalID as InspPlanOperationInternalID,
  key _InspSubsetResult.InspectionCharacteristic    as InspectionCharacteristic,
      _ProcessOrder.OrderID                         as ProcessOrder,
      _ProcessOrder.Plant                           as ProductionPlant,
      _ProcessOrder.ProductionSupervisor
}
where
  _InspSubsetResult.InspectionValuationResult = 'R'
group by
  _InspSubsetResult.InspectionLot,
  _InspSubsetResult.InspPlanOperationInternalID,
  _InspSubsetResult.InspectionCharacteristic,
  _ProcessOrder.OrderID,
  _ProcessOrder.Plant,
  _ProcessOrder.ProductionSupervisor

Learn More