I_ExistenceCheckOnMatlDocItem

DDL: I_EXISTENCECHECKONMATLDOCITEM Type: view_entity COMPOSITE Package: MBND_CLOUD_BL

Existence Check on Material Doc Item

I_ExistenceCheckOnMatlDocItem is a Composite CDS View that provides data about "Existence Check on Material Doc Item" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 5 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 2 associations to related views. Part of development package MBND_CLOUD_BL.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MaintObjListMaterialDocument _SerialNo $projection.MaterialDocument = _SerialNo.MaterialDocument and $projection.MaterialDocumentYear = _SerialNo.MaterialDocumentYear and $projection.MaterialDocumentItem = _SerialNo.MaterialDocumentItem
[0..1] I_SrlzdMatlDocItmsFromPInv _SerialNoPI $projection.MaterialDocument = _SerialNoPI.MaterialDocument and $projection.MaterialDocumentYear = _SerialNoPI.MaterialDocumentYear and $projection.MaterialDocumentItem = _SerialNoPI.MaterialDocumentItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Existence Check on Material Doc Item view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
MatlDocItmHasMatlDocSrlNmbr
MatlDocItmHasPhysInvtrySrlNmbr 
//-- This CDS View is intended to check if Material Document Item consists specific fields              --

//-- At the moment based on Material Document Number, Material Document Item and Material Document Year --

//-- existence of Serial Number is being check, this is open for any further improvements/additions     --


@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData.blocking: #NOT_REQUIRED }
@EndUserText.label: 'Existence Check on Material Doc Item'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
}
define view entity I_ExistenceCheckOnMatlDocItem
  as select from I_MaterialDocumentRecord
  association [0..*] to I_MaintObjListMaterialDocument as _SerialNo   on  $projection.MaterialDocument     = _SerialNo.MaterialDocument
                                                                      and $projection.MaterialDocumentYear = _SerialNo.MaterialDocumentYear
                                                                      and $projection.MaterialDocumentItem = _SerialNo.MaterialDocumentItem
  association [0..1] to I_SrlzdMatlDocItmsFromPInv     as _SerialNoPI on  $projection.MaterialDocument     = _SerialNoPI.MaterialDocument
                                                                      and $projection.MaterialDocumentYear = _SerialNoPI.MaterialDocumentYear
                                                                      and $projection.MaterialDocumentItem = _SerialNoPI.MaterialDocumentItem
{
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
      @Semantics.booleanIndicator: true
      case when _SerialNo.MaterialDocument is null then '' else 'X' end    as MatlDocItmHasMatlDocSrlNmbr,
      @Semantics.booleanIndicator: true
      case when _SerialNoPI.MaterialDocument is null  then '' else 'X' end as MatlDocItmHasPhysInvtrySrlNmbr
}
group by
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  _SerialNo.MaterialDocument,
  _SerialNoPI.MaterialDocument

Learn More