P_PRODNMODELLATESTBOMVERSION

CDS View

Retrive the latest BOM versions

P_PRODNMODELLATESTBOMVERSION is a CDS View in S/4HANA. Retrive the latest BOM versions. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductionModel view_entity inner COMPOSITE Production Model Header 
@EndUserText.label: 'Retrive the latest BOM versions'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #MASTER
}
define view entity P_ProdnModelLatestBOMVersion
  as select from I_BOMHeaderDetermine 
{
  key BillOfMaterialVariantUsage,
  key BillOfMaterialCategory,
  key cast( BillOfMaterial as cs_stlnr ) as BillOfMaterial,
  key BillOfMaterialVariant,
      cast( max(BillOfMaterialVersion) as bom_version ) as BillOfMaterialVersion

}
where
      IsVersionBillOfMaterial = 'X'
  and IsMarkedForDeletion       = ''
group by
  BillOfMaterialVariantUsage,
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant

Learn More