P_PhysInvtryNotPostedBatch_L1

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Not posted batch master'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #D,
    sizeCategory: #XL,
    dataClass: #MASTER
}
@VDM:{
       private: true,
       viewType: #COMPOSITE
     }
define view entity P_PhysInvtryNotPostedBatch_L1
as select from I_PhysInvtryIndBatchStorLoc as batch
{
  key batch.Material,
  key batch.Plant,
  key batch.StorageLocation,
  key batch.Batch,
      cast( '01' as nsdm_lbbsa ) as InventoryStockType
}

union select from I_PhysInvtryIndBatchStorLoc as batch
{
  key batch.Material,
  key batch.Plant,
  key batch.StorageLocation,
  key batch.Batch,
      cast( '02' as nsdm_lbbsa ) as InventoryStockType
}      

union select from I_PhysInvtryIndBatchStorLoc as batch
{
  key batch.Material,
  key batch.Plant,
  key batch.StorageLocation,
  key batch.Batch,
      cast( '07' as nsdm_lbbsa ) as InventoryStockType
}

union select from I_PhysInvtryIndBatchStorLoc as batch
{
  key batch.Material,
  key batch.Plant,
  key batch.StorageLocation,
  key batch.Batch,
      cast( '08' as nsdm_lbbsa ) as InventoryStockType
}