I_InspLotSerialNumber_2

DDL: I_INSPLOTSERIALNUMBER_2 Type: view_entity COMPOSITE Package: VDM_QM_INSPECTION

Serial Number of Inspection Lot

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

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceItemObject I_MaintenanceItemObject inner
I_MaintObjListInspectionLot I_MaintObjListInspectionLot from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Serial Number 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 (5)

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

{
  key    I_MaintObjListInspectionLot.InspectionLot,
  key    I_MaintenanceItemObject.MaintenanceItemObjectList,
  key    I_MaintenanceItemObject.MaintenanceItemObject,
         
         I_MaintenanceItemObject.SerialNumber,
         
//         Associations

         I_MaintObjListInspectionLot._InspectionLot
}

Learn More