I_SerialNumberMaterialDocument

DDL: I_SERIALNUMBERMATERIALDOCUMENT SQL: ISERNOMATDOCS Type: view COMPOSITE

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.

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 (15)

NameValueLevelField
AbapCatalog.sqlViewName ISERNOMATDOCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 Material
KEY SerialNumber SerialNumber
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
Equipment Equipment
_Product _Product
_Equipment _Equipment
_MaterialDocumentItem _MaterialDocumentItem 
@AbapCatalog.sqlViewName: 'ISERNOMATDOCS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@ClientHandling.algorithm: #SESSION_VARIABLE
@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 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 Material,
  key SerialNumber,
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,

      Equipment,

      _Product,
      _Equipment,
      _MaterialDocumentItem
}

Learn More