P_MPEInspectionSubset

DDL: P_MPEINSPECTIONSUBSET Type: view_entity COMPOSITE

Inspection Point of Inspection Operation

P_MPEInspectionSubset is a Composite CDS View that provides data about "Inspection Point of Inspection Operation" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 8 fields with key fields InspectionLot, InspectionSubsetInternalID, InspPlanOperationInternalID.

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubset inspSubset from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inspection Point of Inspection Operation view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey InspectionSubsetInternalID view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionSubset InspectionLot
KEY InspectionSubsetInternalID I_InspectionSubset InspectionSubsetInternalID
KEY InspPlanOperationInternalID I_InspectionSubset InspPlanOperationInternalID
InspSubsetUsageDcsnValuation I_InspectionSubset InspSubsetUsageDcsnValuation
OrderInternalBillOfOperations inspOp OrderInternalBillOfOperations
OrderOperationInternalID inspOp OrderOperationInternalID
_InspectionLot I_InspectionSubset _InspectionLot
_InspectionOperation I_InspectionSubset _InspectionOperation
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Point of Inspection Operation'
@VDM: {
    viewType: #COMPOSITE,
    private: true
}
@ObjectModel: {
    usageType: { serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL },
    representativeKey: 'InspectionSubsetInternalID'
}   

define view entity P_MPEInspectionSubset
  as select from I_InspectionSubset as inspSubset
  left outer to one join I_InspectionOperation as inspOp on inspSubset.InspectionLot = inspOp.InspectionLot 
                                                        and inspSubset.InspPlanOperationInternalID = inspOp.InspPlanOperationInternalID
{
      @ObjectModel.foreignKey.association: '_InspectionLot'
  key inspSubset.InspectionLot,
  key inspSubset.InspectionSubsetInternalID,
      @ObjectModel.foreignKey.association: '_InspectionOperation'
  key inspSubset.InspPlanOperationInternalID,
      inspSubset.InspSubsetUsageDcsnValuation,
      inspOp.OrderInternalBillOfOperations,
      inspOp.OrderOperationInternalID,
      // Associations

      inspSubset._InspectionLot,
      inspSubset._InspectionOperation
}