I_ExistenceCheckOnMaterialDoc

DDL: I_EXISTENCECHECKONMATERIALDOC Type: view_entity COMPOSITE Package: MBND_CLOUD_BL

Existence Check on Material Document

I_ExistenceCheckOnMaterialDoc is a Composite CDS View that provides data about "Existence Check on Material Document" in SAP S/4HANA. It reads from 1 data source (I_ExistenceCheckOnMatlDocItem) and exposes 4 fields with key fields MaterialDocument, MaterialDocumentYear. Part of development package MBND_CLOUD_BL.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ExistenceCheckOnMatlDocItem I_ExistenceCheckOnMatlDocItem from

Annotations (8)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentYear MaterialDocumentYear
MatlDocHasMatlDocSrlNmbrs
MatlDocHasPhysInvtrySrlNmbrs 
//-- This CDS View is intended to check if Material Document consists specific fields --

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

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

//-- improvements/additions

@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Existence Check on Material Document'

@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData.blocking: #NOT_REQUIRED }
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE

@ObjectModel: {
                usageType: {
                            dataClass:      #TRANSACTIONAL,
                            serviceQuality: #C,
                            sizeCategory:   #XL
                           }
               }

define view entity I_ExistenceCheckOnMaterialDoc
  as select from I_ExistenceCheckOnMatlDocItem
{
  key MaterialDocument,
  key MaterialDocumentYear,
      @Semantics.booleanIndicator: true
      max( MatlDocItmHasMatlDocSrlNmbr )    as MatlDocHasMatlDocSrlNmbrs,
      @Semantics.booleanIndicator: true
      max( MatlDocItmHasPhysInvtrySrlNmbr ) as MatlDocHasPhysInvtrySrlNmbrs

}
group by
  MaterialDocument,
  MaterialDocumentYear

Learn More