I_InspLotSerialNumber

DDL: I_INSPLOTSERIALNUMBER Type: view_entity COMPOSITE Package: VDM_QM_INSPECTION

Serial Numbers of Inspection Lot

I_InspLotSerialNumber is a Composite CDS View that provides data about "Serial Numbers of Inspection Lot" in SAP S/4HANA. It reads from 2 data sources (I_MaintObjListInspectionLot, I_MaintenanceItemObject) and exposes 6 fields with key fields InspectionLot, MaintenanceItemObjectList, SerialNumber. Part of development package VDM_QM_INSPECTION.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintObjListInspectionLot _sernum from
I_MaintenanceItemObject I_MaintenanceItemObject inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Serial Numbers of Inspection Lot view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_MaintObjListInspectionLot InspectionLot
KEY MaintenanceItemObjectList I_MaintenanceItemObject MaintenanceItemObjectList
KEY SerialNumber I_MaintenanceItemObject SerialNumber
InspectionLotType
Plant
_InspectionLot I_MaintObjListInspectionLot _InspectionLot 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Serial Numbers of Inspection Lot'
@ObjectModel: {
    usageType: {
        dataClass: #MASTER,
        serviceQuality: #C,
        sizeCategory: #M
    }
}
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
define view entity I_InspLotSerialNumber
  as select from I_MaintObjListInspectionLot as _sernum
inner  join  I_MaintenanceItemObject   on  _sernum.MaintenanceObjectList = I_MaintenanceItemObject.MaintenanceItemObjectList

{

  key    _sernum.InspectionLot,
  key    I_MaintenanceItemObject.MaintenanceItemObjectList,
  key    I_MaintenanceItemObject.SerialNumber,
         _sernum._InspectionLot.InspectionLotType,
         _sernum._InspectionLot.Plant,

//         Associations

         _sernum._InspectionLot

}

Learn More