I_MaterialDocumentSerialNumber

DDL: I_MATERIALDOCUMENTSERIALNUMBER Type: view_entity COMPOSITE Package: MBND_CLOUD_BL

Seial Numbers for Material Document

I_MaterialDocumentSerialNumber is a Composite CDS View that provides data about "Seial Numbers for Material Document" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberMaterialDocument) and exposes 7 fields with key fields Material, SerialNumber, MaterialDocument, MaterialDocumentYear. Part of development package MBND_CLOUD_BL.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberMaterialDocument I_SerialNumberMaterialDocument from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Seial Numbers for Material Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY SerialNumber SerialNumber
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentYear MaterialDocumentYear
Equipment Equipment
MaterialName
_Product _Product 
@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