I_SERIALNUMBERMATERIALDOCUMENT

CDS View

Serial Number Material Documents

I_SERIALNUMBERMATERIALDOCUMENT is a CDS View in S/4HANA. Serial Number Material Documents. It contains 5 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 5 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_SerialNumberMaterialDocument view from COMPOSITE Serial Numbers
I_MaterialDocumentSerialNumber view_entity from COMPOSITE Seial Numbers for Material Document
R_MaterialDocItemSerialNoTP view_entity from TRANSACTIONAL RAP Matdoc Serialnumbers

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY MaterialDocumentYear MaterialDocumentYear 1
KEY SerialNumber SerialNumber 1 
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  lifecycle.status: #DEPRECATED,
  lifecycle.successor: 'I_SerialNumberMaterialDoc_2'
}

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

@EndUserText.label: 'Serial Number Material Documents'
@Metadata.ignorePropagatedAnnotations:true
define view entity I_SerialNumberMaterialDocument
  as select from I_MaintItmObjListMaterialDoc as _SerialMaterialDoc

    inner join   I_MaintenanceItemObject      as _MaintenanceItemObject on _SerialMaterialDoc.MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList

  association [0..1] to I_Product              as _Product              on  $projection.Material = _Product.Product  
  association [0..1] to I_Equipment            as _Equipment            on  $projection.Material     = _Equipment.Material
                                                                        and $projection.SerialNumber = _Equipment.SerialNumber                                                                      
  association [0..1] to I_MaterialDocumentItem as _MaterialDocumentItem on  $projection.MaterialDocument     = _MaterialDocumentItem.MaterialDocument
                                                                        and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
                                                                        and $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear

{
      @ObjectModel.foreignKey.association: '_Product'
  key _MaintenanceItemObject.Material,
  key _MaintenanceItemObject.SerialNumber,
  key _SerialMaterialDoc.MaterialDocument,
  key _SerialMaterialDoc.MaterialDocumentItem,
  key _SerialMaterialDoc.MaterialDocumentYear,

      _MaintenanceItemObject.Equipment,

      _Product,
      _Equipment,
      _MaterialDocumentItem
}

Learn More