P_BillOfMaterialHeaderDEX

DDL: P_BILLOFMATERIALHEADERDEX Type: view_entity BASIC Package: CS_MODEL
39 Fields 2 Data Sources

Data extraction Header

P_BillOfMaterialHeaderDEX is a Basic CDS View that provides data about "Data extraction 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.

Data Sources (2)

SourceAliasJoin Type
stko stko from
stzu stzu inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Data extraction Header view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stko stlty Single-Character Flag
KEY BillOfMaterial
KEY BillOfMaterialVariant stko stlal AlternativeBOM
KEY BOMHeaderInternalChangeCount stko stkoz Counter
BillOfMaterialVariantUsage stzu stlan Usage
BillOfMaterialVersion stko bom_versn BOM Version
BillOfMaterialAuthsnGrp stzu stlbe Auth group
BOMIsConfigurable stzu kbaus ConfigurableBOM
IsConfiguredMaterial stzu kbaus ConfigurableBOM
IsVersionBillOfMaterial stzu versnind Versioning Relevant
BOMHeaderText stzu ztext Text
BOMGroup stzu exstl BOM group
IndicatorIsBOMWithDateHistory stzu hisdt Date hist
IndicatorIsBOMChangedWithHist stzu histk History ID
HeaderValidityStartDate stko datuv Valid-from date
HeaderEngineeringChgNmbrDoc stko aennr Change Number
DeletionIndicator stko lkenz Deletion Ind.
BOMIsArchivedForDeletion stko loekz Status
RecordCreationDate stko andat Created On
CreatedByUser stko annam Created By
LastChangeDate stko aedat Obsolete
LastChangedByUser stko aenam User Name
BOMHeaderBaseUnit stko bmein Unit 'piece'
BOMHeaderQuantityInBaseUnit stko bmeng Quantity
DocumentIsCreatedByCAD stko cadkz CAD Indicator
LaboratoryOrDesignOffice stko labor Work Center
LongTextLanguage stko ltxsp Long text lang
BOMAlternativeText stko stktx Alt Text
BillOfMaterialStatus stko stlst Order level
BOMOrBOMAltvCrtedInPlnt stko wrkan Created in plt
IsALE stko alekz PurchOrder
BillOfMaterialHeaderUUID stko guidx Guid
HeaderValidityEndDate stko valid_to Validity End Time
ChgToEngineeringChgDocument stko ecn_to Change No. To
BOMVersionStatus stko versnst BOM Version Status
IsLatestBOMVersion stko versnlastind Latest Rel Version
LastChangeDateTime stko lastchangedatetime Timestamp
BOMAssetNtwkHndovrIsRelevant stko bom_ain_ind BOM to AIN Handover
BOMPredecessorVersion stko bom_prev_versn Predecessor Version

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_BillOfMaterialHeaderDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_BillOfMaterialHeaderDEX AS
SELECT
  stko.stlty AS BillOfMaterialCategory,
  cast(stko.stlnr as char8 preserving type ) AS BillOfMaterial,
  stko.stlal AS BillOfMaterialVariant,
  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,
  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,
  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
FROM stko
INNER JOIN stzu ON /* join condition not captured in parsed metadata */
;

Learn More