A_SerialNumberMaterialDocument

DDL: A_SERIALNUMBERMATERIALDOCUMENT SQL: ASERNOITEM Type: view COMPOSITE Package: ODATA_MM_IM_API_MATERIAL_DOC

Serial Numbers

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

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_Equipment I_Equipment inner
I_SerialNumberMaterialDocument I_SerialNumberMaterialDocument from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_MaterialDocumentItem _MaterialDocumentItem $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentItem.MaterialDocument and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
[0..*] A_Equipment _Equipment $projection.Material = _Equipment.Material and $projection.SerialNumber = _Equipment.SerialNumber

Annotations (13)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASERNOITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Serial Numbers view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material I_SerialNumberMaterialDocument Material
KEY SerialNumber I_SerialNumberMaterialDocument SerialNumber
KEY MaterialDocument I_SerialNumberMaterialDocument MaterialDocument
KEY MaterialDocumentItem I_SerialNumberMaterialDocument MaterialDocumentItem
KEY MaterialDocumentYear I_SerialNumberMaterialDocument MaterialDocumentYear
ManufacturerSerialNumber I_Equipment ManufacturerSerialNumber
SerialNumberIsRecursive
_Equipment _Equipment
_MaterialDocumentItem _MaterialDocumentItem 
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.sqlViewName: 'ASERNOITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Serial Numbers'
@VDM.viewType : #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.createEnabled: false
@ObjectModel.updateEnabled: false
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@Metadata.ignorePropagatedAnnotations:true
define view A_SerialNumberMaterialDocument
  as select from I_SerialNumberMaterialDocument
    inner join   I_Equipment on I_SerialNumberMaterialDocument.Equipment = I_Equipment.Equipment

  association [1..1] to A_MaterialDocumentItem as _MaterialDocumentItem on  $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear
                                                                        and $projection.MaterialDocument     = _MaterialDocumentItem.MaterialDocument
                                                                        and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
  association [0..*] to A_Equipment            as _Equipment            on  $projection.Material     = _Equipment.Material
                                                                        and $projection.SerialNumber = _Equipment.SerialNumber
{

  key I_SerialNumberMaterialDocument.Material,
  key I_SerialNumberMaterialDocument.SerialNumber,
  key I_SerialNumberMaterialDocument.MaterialDocument,
  key I_SerialNumberMaterialDocument.MaterialDocumentItem,
  key I_SerialNumberMaterialDocument.MaterialDocumentYear,
      I_Equipment.ManufacturerSerialNumber,
      cast( '' as subrk preserving type ) as SerialNumberIsRecursive,

      _Equipment,
      _MaterialDocumentItem

}

Learn More