P_BOMHeaderValidity

DDL: P_BOMHEADERVALIDITY SQL: PBOMHEADVALIDTO Type: view BASIC Package: CS_MODEL
8 Fields 2 Data Sources

View to calculate the validity for BOM header

P_BOMHeaderValidity is a Basic CDS View that provides data about "View to calculate the validity for BOM header" in SAP S/4HANA. It reads from 2 data sources (stko, stko) and exposes 8 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant. Part of development package CS_MODEL.

Data Sources (2)

SourceAliasJoin Type
stko a from
stko b left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PBOMHEADVALIDTO view
AbapCatalog.preserveKey true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.lifecycle.contract.type #NONE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stko stlty Single-Character Flag
KEY BillOfMaterial stko stlnr BOM
KEY BillOfMaterialVariant stko stlal AlternativeBOM
BOMHeaderInternalChangeCount stko stkoz Counter
HeaderValidityStartDate stko datuv Valid-from date
HeaderValidityEndDate
HeaderEngineeringChgNmbrDoc stko aennr Change Number
BillOfMaterialVersion stko bom_versn BOM 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_BOMHeaderValidity.
-- 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.
-- SQL view name: PBOMHEADVALIDTO

CREATE VIEW P_BOMHeaderValidity AS
SELECT
  a.stlty AS BillOfMaterialCategory,
  a.stlnr AS BillOfMaterial,
  a.stlal AS BillOfMaterialVariant,
  a.stkoz AS BOMHeaderInternalChangeCount,
  a.datuv AS HeaderValidityStartDate,
  cast ( min ( b.datuv ) as datub preserving type ) AS HeaderValidityEndDate,
  a.aennr AS HeaderEngineeringChgNmbrDoc,
  a.bom_versn AS BillOfMaterialVersion
FROM stko AS a
LEFT OUTER JOIN stko AS b ON /* join condition not captured in parsed metadata */
;

Learn More