P_SalesOrderBOMHeader

DDL: P_SALESORDERBOMHEADER SQL: PKBOMHEADER Type: view BASIC
57 Fields 1 Data Sources

Private view for Sales order BoM header

P_SalesOrderBOMHeader is a Basic CDS View that provides data about "Private view for Sales order BoM header" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterial) and exposes 57 fields with key fields BillOfMaterialHeaderUUID, BillOfMaterialVariantUsage, BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterial orderBOM from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PKBOMHEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Private view for Sales order BoM header view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialHeaderUUID I_BillOfMaterial BillOfMaterialHeaderUUID Guid
KEY BillOfMaterialVariantUsage I_BillOfMaterial BillOfMaterialVariantUsage Usage
KEY BillOfMaterialCategory I_BillOfMaterial BillOfMaterialCategory BOM category
KEY BillOfMaterial I_BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant I_BillOfMaterial BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_BillOfMaterial BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument I_BillOfMaterial EngineeringChangeDocument Change Number
KEY Material _Kdst Material Vehicle Model
KEY Plant _Kdst Plant Valuation Area
SalesOrder _Kdst SalesOrder SD Document
SalesOrderItem _Kdst SalesOrderItem Sales Order Item
BOMCharUUID
BillOfMaterialUUID I_BillOfMaterial BillOfMaterialUUID Character Field of Length 12
IsMultipleBOMAlt I_BillOfMaterial IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount I_BillOfMaterial BOMHeaderInternalChangeCount Counter
BOMPrioritizedVersion I_BillOfMaterial BOMPrioritizedVersion Selection ID
BOMExplosionApplication I_BillOfMaterial BOMExplosionApplication BOM Application
BOMUsagePriority I_BillOfMaterial BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp I_BillOfMaterial BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus I_BillOfMaterial BOMVersionStatus BOM Version Status
MaterialToLotSizeQuantity
MatFromLotSizeQuantity
IsVersionBillOfMaterial I_BillOfMaterial IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion I_BillOfMaterial IsLatestBOMVersion Latest Rel Version
BOMTechnicalType I_BillOfMaterial BOMTechnicalType Tech type
BOMGroup I_BillOfMaterial BOMGroup BOM group
IndicatorIsBOMWithDateHistory I_BillOfMaterial IndicatorIsBOMWithDateHistory Date hist
IndicatorIsBOMChangedWithHist I_BillOfMaterial IndicatorIsBOMChangedWithHist History ID
BOMHeaderText I_BillOfMaterial BOMHeaderText BOM Description
BOMAlternativeText I_BillOfMaterial BOMAlternativeText Alt Text
LongTextLanguage I_BillOfMaterial LongTextLanguage Long Text Lang
LongTextExists
BillOfMaterialStatus I_BillOfMaterial BillOfMaterialStatus BOM Status
HeaderValidityEndDate I_BillOfMaterial HeaderValidityEndDate to
HeaderValidityStartDate I_BillOfMaterial HeaderValidityStartDate Valid From
ChgToEngineeringChgDocument I_BillOfMaterial ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion I_BillOfMaterial IsMarkedForDeletion Purch.org. data
BOMIsArchivedForDeletion I_BillOfMaterial BOMIsArchivedForDeletion Deletion flag
IsConfiguredMaterial I_BillOfMaterial IsConfiguredMaterial Configured matl
BOMIsConfigurableasBOMIsConfigurable
IsALEasIsALE
BOMHeaderBaseUnit I_BillOfMaterial BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit I_BillOfMaterial BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate I_BillOfMaterial RecordCreationDate Created On
LastChangeDate I_BillOfMaterial LastChangeDate Time Stamp
LastChangedByUser I_BillOfMaterial LastChangedByUser User Name
CreatedByUser I_BillOfMaterial CreatedByUser User Name
BOMIsToBeDeleted I_BillOfMaterial BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD I_BillOfMaterial DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice I_BillOfMaterial LaboratoryOrDesignOffice Lab/Office
LastChangeDateTime I_BillOfMaterial LastChangeDateTime Timestamp
BOMAssetNtwkHndovrIsRelevant I_BillOfMaterial BOMAssetNtwkHndovrIsRelevant BOM to AIN Handover
MaterialBOMObjectID
BOMPredecessorVersion Predecessor Version
BOMPredecessorVersion I_BillOfMaterial BOMPredecessorVersion Predecessor Version
_Kdst _Kdst
_UnitOfMeasure _UnitOfMeasure

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_SalesOrderBOMHeader.
-- 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: PKBOMHEADER

CREATE VIEW P_SalesOrderBOMHeader AS
SELECT
  orderBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  orderBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  orderBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  orderBOM.BillOfMaterial AS BillOfMaterial,
  orderBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  orderBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  orderBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  _Kdst.Material AS Material,
  _Kdst.Plant AS Plant,
  _Kdst.SalesOrder AS SalesOrder,
  _Kdst.SalesOrderItem AS SalesOrderItem,
  orderBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  orderBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  orderBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  orderBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  orderBOM.BOMExplosionApplication AS BOMExplosionApplication,
  orderBOM.BOMUsagePriority AS BOMUsagePriority,
  orderBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  orderBOM.BOMVersionStatus AS BOMVersionStatus,
  cast( 0 as losvn ) AS MaterialToLotSizeQuantity,
  cast( 0 as losbs ) AS MatFromLotSizeQuantity,
  orderBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  orderBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  orderBOM.BOMTechnicalType AS BOMTechnicalType,
  orderBOM.BOMGroup AS BOMGroup,
  orderBOM.IndicatorIsBOMWithDateHistory AS IndicatorIsBOMWithDateHistory,
  orderBOM.IndicatorIsBOMChangedWithHist AS IndicatorIsBOMChangedWithHist,
  orderBOM.BOMHeaderText AS BOMHeaderText,
  orderBOM.BOMAlternativeText AS BOMAlternativeText,
  orderBOM.LongTextLanguage AS LongTextLanguage,
  cast('' as ltxzu ) AS LongTextExists,
  orderBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  orderBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  orderBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  orderBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  orderBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  orderBOM.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  orderBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  orderBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  orderBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  orderBOM.RecordCreationDate AS RecordCreationDate,
  orderBOM.LastChangeDate AS LastChangeDate,
  orderBOM.LastChangedByUser AS LastChangedByUser,
  orderBOM.CreatedByUser AS CreatedByUser,
  orderBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  orderBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  orderBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  orderBOM.LastChangeDateTime AS LastChangeDateTime,
  orderBOM.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant,
  cast('' as cs_matbom_key ) AS MaterialBOMObjectID,
  orderBOM.BOMPredecessorVersion AS BOMPredecessorVersion
FROM I_BillOfMaterial AS orderBOM
;

Learn More