C_SAFTDeliverySerialNumber

DDL: C_SAFTDELIVERYSERIALNUMBER SQL: CSAFTDELSERN Type: view CONSUMPTION

PT SAFT MOG Serial Number

C_SAFTDeliverySerialNumber is a Consumption CDS View that provides data about "PT SAFT MOG Serial Number" in SAP S/4HANA. It reads from 3 data sources (I_SAFTDeliveryItem, I_MaintItmObjListDeliveryDoc, I_MaintenanceItemObject) and exposes 3 fields with key fields DeliveryDocument, DeliveryDocumentItem, SerialNumber.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
I_SAFTDeliveryItem a from
I_MaintItmObjListDeliveryDoc b inner
I_MaintenanceItemObject c inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSAFTDELSERN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label PT SAFT MOG Serial Number view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_SAFTDeliveryItem DeliveryDocument
KEY DeliveryDocumentItem I_SAFTDeliveryItem DeliveryDocumentItem
KEY SerialNumber I_MaintenanceItemObject SerialNumber 
@AbapCatalog.sqlViewName: 'CSAFTDELSERN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'PT SAFT MOG Serial Number'
define view C_SAFTDeliverySerialNumber
  as select from I_SAFTDeliveryItem           as a
    inner join   I_MaintItmObjListDeliveryDoc as b on  a.ReferenceSDDocument         = b.DeliveryDocument
                                                   and a.ReferenceSDDocumentItem     = b.DeliveryDocumentItem
                                                   and a.ReferenceSDDocumentCategory = b.SDDocumentCategory
    inner join   I_MaintenanceItemObject      as c on b.MaintenanceItemObjectList = c.MaintenanceItemObjectList

{

      //key

      // @ObjectModel.foreignKey.association: '_DeliveryDocument'

  key a.DeliveryDocument     as DeliveryDocument,
  key a.DeliveryDocumentItem as DeliveryDocumentItem,
  key c.SerialNumber         as SerialNumber
}
where
  c.SerialNumber <> ''

Learn More