P_MATBILLOFMATERIALHEADERDEX

DDL: P_MATBILLOFMATERIALHEADERDEX Type: view_entity BASIC Package: CS_MODEL

Private view for Material BOM header

P_MATBILLOFMATERIALHEADERDEX is a Basic CDS View that provides data about "Private view for Material BOM header" in SAP S/4HANA. It reads from 2 data sources (stko, stzu) and exposes 39 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BOMHeaderInternalChangeCount. Part of development package CS_MODEL.

2 data source(s) 39 fields

Data Sources (2)

SourceAliasJoin Type
stko stko from
stzu stzu inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stko stlty
KEY BillOfMaterial
KEY BillOfMaterialVariant stko stlal
KEY BOMHeaderInternalChangeCount stko stkoz
BillOfMaterialVariantUsage stzu stlan
BillOfMaterialVersion stko bom_versn
BillOfMaterialAuthsnGrp stzu stlbe
BOMIsConfigurable stzu kbaus
IsConfiguredMaterial stzu kbaus
IsVersionBillOfMaterial stzu versnind
BOMHeaderText stzu ztext
BOMGroup stzu exstl
IndicatorIsBOMWithDateHistory stzu hisdt
IndicatorIsBOMChangedWithHist stzu histk
HeaderValidityStartDate stko datuv
HeaderEngineeringChgNmbrDoc stko aennr
DeletionIndicator stko lkenz
BOMIsArchivedForDeletion stko loekz
RecordCreationDate stko andat
CreatedByUser stko annam
LastChangeDate stko aedat
LastChangedByUser stko aenam
BOMHeaderBaseUnit stko bmein
BOMHeaderQuantityInBaseUnit stko bmeng
DocumentIsCreatedByCAD stko cadkz
LaboratoryOrDesignOffice stko labor
LongTextLanguage stko ltxsp
BOMAlternativeText stko stktx
BillOfMaterialStatus stko stlst
BOMOrBOMAltvCrtedInPlnt stko wrkan
IsALE stko alekz
BillOfMaterialHeaderUUID stko guidx
HeaderValidityEndDate stko valid_to
ChgToEngineeringChgDocument stko ecn_to
BOMVersionStatus stko versnst
IsLatestBOMVersion stko versnlastind
LastChangeDateTime stko lastchangedatetime
BOMAssetNtwkHndovrIsRelevant stko bom_ain_ind
BOMPredecessorVersion stko bom_prev_versn 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}

define view entity P_MATBILLOFMATERIALHEADERDEX as select from stko
    inner join   stzu as stzu on  stko.stlty = stzu.stlty
                              and stko.stlnr = stzu.stlnr
{
  key stko.stlty                                 as BillOfMaterialCategory,
  key cast(stko.stlnr as cs_stlnr preserving type ) as BillOfMaterial,
  key stko.stlal                                 as BillOfMaterialVariant,
  key stko.stkoz                                 as BOMHeaderInternalChangeCount,
      stzu.stlan                                 as BillOfMaterialVariantUsage,
      stko.bom_versn                             as BillOfMaterialVersion,
      stzu.stlbe                                 as BillOfMaterialAuthsnGrp,
      stzu.kbaus                                 as BOMIsConfigurable,
      stzu.kbaus                                 as IsConfiguredMaterial,
      stzu.versnind                              as IsVersionBillOfMaterial,
      cast( case
        when stzu.altst = 'X' then 'M'
        when stzu.varst = 'X' then 'V'
        else ' '
        end   as tetyp_d preserving type )       as BOMTechnicalType,
      stzu.ztext                                 as BOMHeaderText,
      stzu.exstl                                 as BOMGroup,
      stzu.hisdt                                 as IndicatorIsBOMWithDateHistory,
      stzu.histk                                 as IndicatorIsBOMChangedWithHist,
      stko.datuv                                 as HeaderValidityStartDate,
      stko.aennr                                 as HeaderEngineeringChgNmbrDoc,
      stko.lkenz                                 as DeletionIndicator,
      stko.loekz                                 as BOMIsArchivedForDeletion,
      stko.andat                                 as RecordCreationDate,
      stko.annam                                 as CreatedByUser,
      stko.aedat                                 as LastChangeDate,
      stko.aenam                                 as LastChangedByUser,
      stko.bmein                                 as BOMHeaderBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
      stko.bmeng                                 as BOMHeaderQuantityInBaseUnit,
      stko.cadkz                                 as DocumentIsCreatedByCAD,
      stko.labor                                 as LaboratoryOrDesignOffice,
      stko.ltxsp                                 as LongTextLanguage,
      stko.stktx                                 as BOMAlternativeText,
      stko.stlst                                 as BillOfMaterialStatus,
      stko.wrkan                                 as BOMOrBOMAltvCrtedInPlnt,
      stko.alekz                                 as IsALE,
      stko.guidx                                 as BillOfMaterialHeaderUUID,
      stko.valid_to                              as HeaderValidityEndDate,
      stko.ecn_to                                as ChgToEngineeringChgDocument,
      stko.versnst                               as BOMVersionStatus,
      stko.versnlastind                          as IsLatestBOMVersion,
      stko.lastchangedatetime                    as LastChangeDateTime,
      stko.bom_ain_ind                           as BOMAssetNtwkHndovrIsRelevant,
      stko.bom_prev_versn                        as BOMPredecessorVersion

}
where stko.stlty   = 'M'

Learn More