I_MATERIALBOMHEADERCURRENTDATE

CDS View

Material BOM header valid today

I_MATERIALBOMHEADERCURRENTDATE is a CDS View in S/4HANA. Material BOM header valid today. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaterialBOMHeaderSearch view inner BASIC BOM header view for CDS based search model.

Fields (3)

KeyField CDS FieldsUsed in Views
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialVersion BillOfMaterialVersion 1
EngineeringChangeDocument EngineeringChangeDocument 1 
@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