I_SERIALNUMBERDELIVERYDOCUMENT

CDS View

Serial Number in Delivery Document

I_SERIALNUMBERDELIVERYDOCUMENT is a CDS View in S/4HANA. Serial Number in Delivery Document. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FldLogsSerialNmbrDeliveryDoc view from COMPOSITE Serial number for Delivery
R_CustRetDelivItemSerialNmbrTP view_entity from TRANSACTIONAL Customer Returns Deliv Item SrlNmbr - TP
R_InbDelivItemSerialNumberTP view_entity from TRANSACTIONAL Inbound Delivery Item Serial Number - TP
R_OutbDelivItemSerialNumberTP view_entity from TRANSACTIONAL Outbound Dlv Item Serial Number - TP 
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }
                  
@AbapCatalog.sqlViewName: 'ISERNODELDOCS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #A,
        sizeCategory:   #XL }
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET
]

@EndUserText.label: 'Serial Number in Delivery Document'
@Metadata.ignorePropagatedAnnotations:true
define view I_SerialNumberDeliveryDocument
  as select from I_MaintObjListDeliveryDocument as _MaintObjListDeliveryDocument
  -- data source association to list item cannot be used due to current CDS restrictions
  -- (could be done implicitly in field list by _A._B[inner].C, but non-maskable warnings ensue)
  -- ... join needs foreign key relationship to be defined again
    inner join I_MaintenanceObjectListItem as _MaintenanceObjectListItem
      on _MaintObjListDeliveryDocument.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
{
  @ObjectModel.foreignKey.association: '_Equipment'
  key _MaintenanceObjectListItem.Equipment,

  @ObjectModel.foreignKey.association: '_DeliveryDocument'
  key _MaintObjListDeliveryDocument.DeliveryDocument,
  @ObjectModel.foreignKey.association: '_DeliveryDocumentItem'
  key _MaintObjListDeliveryDocument.DeliveryDocumentItem,

  @ObjectModel.foreignKey.association: '_Product'
  _MaintenanceObjectListItem.Material,
  _MaintenanceObjectListItem.SerialNumber,

  _MaintenanceObjectListItem._Equipment,
  _MaintObjListDeliveryDocument._DeliveryDocument,
  _MaintObjListDeliveryDocument._DeliveryDocumentItem,
  _MaintenanceObjectListItem._Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEOBJECTLISTITEM",
"I_MAINTOBJLISTDELIVERYDOCUMENT"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM",
"I_EQUIPMENT",
"I_PRODUCT"
],
"BASE":
[
"I_MAINTENANCEOBJECTLISTITEM",
"I_MAINTOBJLISTDELIVERYDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More