I_SerialNumberMaterialDocument

DDL: I_SERIALNUMBERMATERIALDOCUMENT Type: view_entity COMPOSITE Package: LO_SN_DEPRECATED

Serial Number Material Documents

I_SerialNumberMaterialDocument is a Composite CDS View that provides data about "Serial Number Material Documents" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceItemObject, I_MaintItmObjListMaterialDoc) and exposes 9 fields with key fields Material, SerialNumber, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 3 associations to related views. Part of development package LO_SN_DEPRECATED.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceItemObject _MaintenanceItemObject inner
I_MaintItmObjListMaterialDoc _SerialMaterialDoc from

Associations (3)

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

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_SerialNumberMaterialDoc_2 view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Serial Number Material Documents view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material I_MaintenanceItemObject Material
KEY SerialNumber I_MaintenanceItemObject SerialNumber
KEY MaterialDocument I_MaintItmObjListMaterialDoc MaterialDocument
KEY MaterialDocumentItem I_MaintItmObjListMaterialDoc MaterialDocumentItem
KEY MaterialDocumentYear I_MaintItmObjListMaterialDoc MaterialDocumentYear
Equipment I_MaintenanceItemObject Equipment
_Product _Product
_Equipment _Equipment
_MaterialDocumentItem _MaterialDocumentItem 
@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