I_MaterialBOMHeaderCurrentDate

DDL: I_MATERIALBOMHEADERCURRENTDATE SQL: IMBOMHDRCURR Type: view BASIC

Material BOM header valid today

I_MaterialBOMHeaderCurrentDate is a Basic CDS View that provides data about "Material BOM header valid today" in SAP S/4HANA. It reads from 4 data sources (mpe_featuractiv, stko, stzu, P_VersionBOMIsActive) and exposes 9 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BOMHeaderInternalChangeCount.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
mpe_featuractiv manf_feature left_outer
stko stko from
stzu stzu inner
P_VersionBOMIsActive vers_active left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMBOMHDRCURR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Material BOM header valid today view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stko stlty
KEY BillOfMaterial stko stlnr
KEY BillOfMaterialVariant stko stlal
KEY BOMHeaderInternalChangeCount stko stkoz
BOMPredecessorVersion stko bom_prev_versn
BillOfMaterialVersion stko bom_versn
EngineeringChangeDocument stko aennr
ValidityStartDate stko datuv
ValidityEndDate stko valid_to 
@AbapCatalog.sqlViewName: 'IMBOMHDRCURR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Material BOM header valid today'
define view I_MaterialBOMHeaderCurrentDate
  as select from stko
  inner join stzu as stzu on stko.stlnr = stzu.stlnr
                         and stko.stlty = stzu.stlty
  left outer join P_VersionBOMIsActive  as vers_active on vers_active.agb29 = '29' 
  left outer join mpe_featuractiv as manf_feature on manf_feature.feature = 'EME'
  {
  key stko.stlty          as BillOfMaterialCategory,
  key stko.stlnr          as BillOfMaterial,
  key stko.stlal          as BillOfMaterialVariant,
  key stko.stkoz          as BOMHeaderInternalChangeCount,
      stko.bom_prev_versn as BOMPredecessorVersion,
      stko.bom_versn      as BillOfMaterialVersion,
      stko.aennr          as EngineeringChangeDocument,
      stko.datuv          as ValidityStartDate,
      stko.valid_to       as ValidityEndDate
}
where     stko.lkenz          = ''
  and     stko.stlty          =  'M'
  and     stko.datuv          <= $session.system_date
  and     stko.valid_to       > $session.system_date
  and
    ( ( ( vers_active.VersionBOMIsActive = 'X'
      and stko.bom_prev_versn =  '0000'
      and stko.bom_versn      <> ''
      and stko.versnlastind   =  ''
      and stko.versnst = '01'
      )
     or 
        ( manf_feature.feature = 'EME'
     and stko.bom_prev_versn =  '0000'
     and stko.bom_versn      <> ''
     and stko.versnlastind   =  ''
     and stko.versnst = '01'
      ) )
    
     or( ( vers_active.VersionBOMIsActive = 'X' 
      and  stko.bom_versn  <> ''
      and stko.versnlastind   =  'X'
      )
       or 
      ( manf_feature.feature = 'EME' 
     and stko.bom_versn  <> ''
     and stko.versnlastind   =  'X'
      )
    )
    or(  stko.bom_versn      =  ''  
    )
  )

Learn More