I_ExistenceCheckOnMatlDocItem

//-- 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_MatDocOvwItmSerialNumber as _SerialNo on  $projection.MaterialDocument     = _SerialNo.MaterialDocument
                                                                and $projection.MaterialDocumentItem = _SerialNo.MaterialDocumentItem
                                                                and $projection.MaterialDocumentYear = _SerialNo.MaterialDocumentYear
{
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
//      cast(

//            min(case when _SerialNo.SerialNumber is null

//                        then 'X'

//                     else '' end

//           ) as boolean preserving type) as MatlDocHasNoSerializedMaterial,

//      @Semantics.booleanIndicator: true           

//      case min(_SerialNo.PhysicalInventoryDocumentItem)

//           when '000'

//                then 'X'

//           else ''

//            end                          as MatDocHasNoSrlNmbrForPInv


cast(

            // This field is 'X' when either the material in the material document is NOT serialized or

            // the Material is Serialized but it is related to a Physical inventory document, in which case

            // the field below (MatDocHasNoSrlNmbrForPInv) is blank. These fields toggle de visibility 

            // of the two different facets for SNs in the Material Documents Overview App. Therefore, ONLY ONE OF THESE 

            // CAN BE BLANK AT A GIVEN TIME

            min(case when (     ( _SerialNo.SerialNumber is not null and _SerialNo.PhysicalInventoryDocumentItem <> '000' )
                            or  ( _SerialNo.SerialNumber is null )                              
                          )
                        then 'X'
                     else '' end
           ) as boolean preserving type) as MatlDocHasNoSerializedMaterial, 
      
      @Semantics.booleanIndicator: true
      min( case when ( _SerialNo.PhysicalInventoryDocumentItem is null or _SerialNo.PhysicalInventoryDocumentItem = '000' )   
                  then 'X'
                else ''
           end 
         ) as MatDocHasNoSrlNmbrForPInv
}
group by
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  _SerialNo.PhysicalInventoryDocumentItem
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATDOCOVWITMSERIALNUMBER",
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/