A_SerialNumberMaterialDocument

DDL: A_SERIALNUMBERMATERIALDOCUMENT SQL: ASERNOITEM Type: view COMPOSITE

Serial Numbers

A_SerialNumberMaterialDocument is a Composite CDS View that provides data about "Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberMaterialDocument) and exposes 8 fields with key fields Material, SerialNumber, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
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..1] A_Equipment _Equipment $projection.Material = _Equipment.Material and $projection.SerialNumber = _Equipment.SerialNumber

Annotations (14)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.preserveKey true 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 (8)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY SerialNumber SerialNumber
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
ManufacturerSerialNumber _Equipment ManufacturerSerialNumber
_Equipment _Equipment
_MaterialDocumentItem _MaterialDocumentItem 
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@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
  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..1] to A_Equipment            as _Equipment            on  $projection.Material     = _Equipment.Material
                                                                        and $projection.SerialNumber = _Equipment.SerialNumber



{


  key Material,
  key SerialNumber,
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
      _Equipment.ManufacturerSerialNumber,

      _Equipment,
      _MaterialDocumentItem

}

Learn More