I_SlsDocItemSerialNumber

DDL: I_SLSDOCITEMSERIALNUMBER Type: view_entity COMPOSITE Package: VDM_SD_SLS

Serial Number in Sales Document Item

I_SlsDocItemSerialNumber is a Composite CDS View that provides data about "Serial Number in Sales Document Item" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceObjectListItem, I_MaintObjListSlsDocumentItem) and exposes 14 fields with key fields SalesDocument, SalesDocumentItem, SerialNumber. Part of development package VDM_SD_SLS.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceObjectListItem MaintenanceObjectListItem inner
I_MaintObjListSlsDocumentItem MaintObjListSalesDocumentItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Serial Number in Sales Document Item view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_MaintObjListSlsDocumentItem SalesDocument
KEY SalesDocumentItem I_MaintObjListSlsDocumentItem SalesDocumentItem
KEY SerialNumber I_MaintenanceObjectListItem SerialNumber
Product I_MaintenanceObjectListItem Material
Equipment I_MaintenanceObjectListItem Equipment
SDDocumentCategory I_MaintObjListSlsDocumentItem SDDocumentCategory
SalesDocumentType I_MaintObjListSlsDocumentItem SalesDocumentType
SalesDocumentItemCategory I_MaintObjListSlsDocumentItem SalesDocumentItemCategory
SerialNumberAssignmentDate I_MaintObjListSlsDocumentItem SerialNumberAssignmentDate
SerialNumberAssignmentTime I_MaintObjListSlsDocumentItem SerialNumberAssignmentTime
_Equipment I_MaintenanceObjectListItem _Equipment
_SalesDocument I_MaintObjListSlsDocumentItem _SalesDocument
_SalesDocumentItem I_MaintObjListSlsDocumentItem _SalesDocumentItem
_Product I_MaintenanceObjectListItem _Product 
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #COMPOSITE

@ObjectModel: {
                usageType: {
                            serviceQuality: #A,
                            sizeCategory:   #L,
                            dataClass:      #TRANSACTIONAL
                           },
                 supportedCapabilities: [
                            #SQL_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET
                                        ]
              }
@EndUserText.label: 'Serial Number in Sales Document Item'
@Metadata.ignorePropagatedAnnotations:true
define view entity I_SlsDocItemSerialNumber
  as select from I_MaintObjListSlsDocumentItem as MaintObjListSalesDocumentItem
  -- 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 MaintObjListSalesDocumentItem.MaintenanceObjectList = MaintenanceObjectListItem.MaintenanceObjectList
{
      @ObjectModel.foreignKey.association: '_SalesDocument'
  key MaintObjListSalesDocumentItem.SalesDocument,
      @ObjectModel.foreignKey.association: '_SalesDocumentItem'
  key MaintObjListSalesDocumentItem.SalesDocumentItem,

  key MaintenanceObjectListItem.SerialNumber,

      @ObjectModel.foreignKey.association: '_Product'
      MaintenanceObjectListItem.Material as Product,
      @ObjectModel.foreignKey.association: '_Equipment'
      MaintenanceObjectListItem.Equipment,
      MaintObjListSalesDocumentItem.SDDocumentCategory,
      MaintObjListSalesDocumentItem.SalesDocumentType,
      MaintObjListSalesDocumentItem.SalesDocumentItemCategory,
      MaintObjListSalesDocumentItem.SerialNumberAssignmentDate,
      MaintObjListSalesDocumentItem.SerialNumberAssignmentTime,

      MaintenanceObjectListItem._Equipment,
      MaintObjListSalesDocumentItem._SalesDocument,
      MaintObjListSalesDocumentItem._SalesDocumentItem,
      MaintenanceObjectListItem._Product
}

Learn More