I_MATERIALDOCUMENTSERIALNUMBER

CDS View

Seial Numbers for Material Document

I_MATERIALDOCUMENTSERIALNUMBER is a CDS View in S/4HANA. Seial Numbers for Material Document. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MatDocOvwItmSerialNumber view_entity from COMPOSITE Serial Number for Material Document Item
I_MaterialDocumentOvwSerialNo view_entity from COMPOSITE Serial Number For Material Document Overview 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Seial Numbers for Material Document'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@Search.searchable: true
@VDM.viewType: #COMPOSITE

define view entity I_MaterialDocumentSerialNumber
  as select from I_SerialNumberMaterialDocument
{
      @Search.defaultSearchElement: true
  key Material,
      @Search.defaultSearchElement: true
  key SerialNumber,
      @Search.defaultSearchElement: true
  key MaterialDocument,
  key cast ( case _MaterialDocumentItem.HasMultipleAccountAssignment
        when ''
           then MaterialDocumentItem
        else
            _MaterialDocumentItem.MultiAcctAssgmtOriglMatlDocItm
        end as mblpo preserving type )                                 as MaterialDocumentItem,
  key MaterialDocumentYear,
      Equipment,
      _Product._Text[1: Language=$session.system_language].ProductName as MaterialName,
      /* Associations */
      _Product
}
where
  _MaterialDocumentItem.IsAutomaticallyCreated = ''

Learn More