I_BillOfMaterialHeader
BOM Header details
I_BillOfMaterialHeader is a Composite CDS View that provides data about "BOM Header details" in SAP S/4HANA. It reads from 2 data sources (P_BillOfMaterialHeader, I_SalesDocument) and exposes 67 fields with key fields BillOfMaterialHeaderUUID, BillOfMaterialVariantUsage, BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant. It has 9 associations to related views. Part of development package CS_MODEL.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_BillOfMaterialHeader | bom_header | from |
| I_SalesDocument | I_SalesDocument | left_outer |
Associations (9)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_BillOfMaterialItem | _BillOfMaterialItem | $projection.BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory and $projection.BillOfMaterial = _BillOfMaterialItem.BillOfMaterial and $projection.BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant |
| [0..1] | I_VersionStatus | _VersionStatus | $projection.BOMVersionStatus = _VersionStatus.BOMVersionStatus and _VersionStatus.Language = $session.system_language |
| [0..1] | I_Material | _Material | $projection.Material = _Material.Material |
| [0..1] | I_BillOfMaterialUsage | _BillOfMaterialVariantUsage | $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage and _BillOfMaterialVariantUsage.Language = $session.system_language |
| [0..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant |
| [0..1] | I_UnitOfMeasure | _UnitOfMeasure | $projection.BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure |
| [0..*] | I_BomChanges | _BOMChangeNumbers | $projection.BillOfMaterial = _BOMChangeNumbers.BillOfMaterial and $projection.BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BOMChangeNumbers.BillOfMaterialVersion and $projection.Material = _BOMChangeNumbers.Material and $projection.Plant = _BOMChangeNumbers.Plant and $projection.BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage |
| [0..1] | I_ChangeMaster | _ChangeNumbers | $projection.EngineeringChangeDocument = _ChangeNumbers.ChangeNumber |
| [0..1] | I_Product | _Product | $projection.Material = _Product.Product |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IBOMHEADER | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | BOM Header details | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (67)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillOfMaterialHeaderUUID | P_BillOfMaterialHeader | BillOfMaterialHeaderUUID | |
| KEY | BillOfMaterialVariantUsage | P_BillOfMaterialHeader | BillOfMaterialVariantUsage | |
| KEY | BillOfMaterialCategory | P_BillOfMaterialHeader | BillOfMaterialCategory | |
| KEY | BillOfMaterial | P_BillOfMaterialHeader | BillOfMaterial | |
| KEY | BillOfMaterialVariant | P_BillOfMaterialHeader | BillOfMaterialVariant | |
| KEY | BillOfMaterialVersion | P_BillOfMaterialHeader | BillOfMaterialVersion | |
| KEY | EngineeringChangeDocument | P_BillOfMaterialHeader | EngineeringChangeDocument | |
| KEY | Material | P_BillOfMaterialHeader | Material | |
| KEY | Plant | P_BillOfMaterialHeader | Plant | |
| SalesOrder | P_BillOfMaterialHeader | SalesOrder | ||
| SalesOrderItem | P_BillOfMaterialHeader | SalesOrderItem | ||
| SoldToParty | SoldToParty | |||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | |||
| BOMCharUUID | ||||
| BillOfMaterialUUID | P_BillOfMaterialHeader | BillOfMaterialUUID | ||
| IsMultipleBOMAlt | P_BillOfMaterialHeader | IsMultipleBOMAlt | ||
| BOMHeaderInternalChangeCount | P_BillOfMaterialHeader | BOMHeaderInternalChangeCount | ||
| BOMPrioritizedVersion | P_BillOfMaterialHeader | BOMPrioritizedVersion | ||
| BOMExplosionApplication | P_BillOfMaterialHeader | BOMExplosionApplication | ||
| BOMUsagePriority | P_BillOfMaterialHeader | BOMUsagePriority | ||
| BillOfMaterialAuthsnGrp | P_BillOfMaterialHeader | BillOfMaterialAuthsnGrp | ||
| BOMVersionStatus | P_BillOfMaterialHeader | BOMVersionStatus | ||
| MaterialToLotSizeQuantity | MaterialToLotSizeQuantity | |||
| MatFromLotSizeQuantity | MatFromLotSizeQuantity | |||
| IsVersionBillOfMaterial | P_BillOfMaterialHeader | IsVersionBillOfMaterial | ||
| IsLatestBOMVersion | P_BillOfMaterialHeader | IsLatestBOMVersion | ||
| BOMTechnicalType | P_BillOfMaterialHeader | BOMTechnicalType | ||
| BOMGroup | P_BillOfMaterialHeader | BOMGroup | ||
| IndicatorIsBOMWithDateHistory | P_BillOfMaterialHeader | IndicatorIsBOMWithDateHistory | ||
| IndicatorIsBOMChangedWithHist | P_BillOfMaterialHeader | IndicatorIsBOMChangedWithHist | ||
| BOMHeaderText | P_BillOfMaterialHeader | BOMHeaderText | ||
| BOMAlternativeText | P_BillOfMaterialHeader | BOMAlternativeText | ||
| LongTextLanguage | P_BillOfMaterialHeader | LongTextLanguage | ||
| LongTextExists | P_BillOfMaterialHeader | LongTextExists | ||
| BillOfMaterialStatus | P_BillOfMaterialHeader | BillOfMaterialStatus | ||
| HeaderValidityEndDate | P_BillOfMaterialHeader | HeaderValidityEndDate | ||
| HeaderValidityStartDate | P_BillOfMaterialHeader | HeaderValidityStartDate | ||
| ChgToEngineeringChgDocument | P_BillOfMaterialHeader | ChgToEngineeringChgDocument | ||
| IsMarkedForDeletion | P_BillOfMaterialHeader | IsMarkedForDeletion | ||
| BOMIsArchivedForDeletion | P_BillOfMaterialHeader | BOMIsArchivedForDeletion | ||
| IsConfiguredMaterial | P_BillOfMaterialHeader | IsConfiguredMaterial | ||
| BOMIsConfigurableasBOMIsConfigurable | ||||
| IsALEasIsALE | ||||
| BOMHeaderBaseUnit | P_BillOfMaterialHeader | BOMHeaderBaseUnit | ||
| BOMHeaderQuantityInBaseUnit | P_BillOfMaterialHeader | BOMHeaderQuantityInBaseUnit | ||
| RecordCreationDate | P_BillOfMaterialHeader | RecordCreationDate | ||
| LastChangeDate | P_BillOfMaterialHeader | LastChangeDate | ||
| LastChangedByUser | P_BillOfMaterialHeader | LastChangedByUser | ||
| CreatedByUser | P_BillOfMaterialHeader | CreatedByUser | ||
| BOMIsToBeDeleted | P_BillOfMaterialHeader | BOMIsToBeDeleted | ||
| DocumentIsCreatedByCAD | P_BillOfMaterialHeader | DocumentIsCreatedByCAD | ||
| LaboratoryOrDesignOffice | P_BillOfMaterialHeader | LaboratoryOrDesignOffice | ||
| LastChangeDateTime | P_BillOfMaterialHeader | LastChangeDateTime | ||
| BOMAssetNtwkHndovrIsRelevant | P_BillOfMaterialHeader | BOMAssetNtwkHndovrIsRelevant | ||
| MaterialBOMObjectID | P_BillOfMaterialHeader | MaterialBOMObjectID | ||
| BOMPredecessorVersion | ||||
| BOMPredecessorVersion | P_BillOfMaterialHeader | BOMPredecessorVersion | ||
| IsBOMVersionInactive | ||||
| _Material | _Material | |||
| _BillOfMaterialItem | _BillOfMaterialItem | |||
| _BillOfMaterialVariantUsage | _BillOfMaterialVariantUsage | |||
| _VersionStatus | _VersionStatus | |||
| _UnitOfMeasure | _UnitOfMeasure | |||
| _Plant | _Plant | |||
| _BOMChangeNumbers | _BOMChangeNumbers | |||
| _Product | _Product | |||
| _SoldToParty | _SoldToParty |
@AbapCatalog.sqlViewName: 'IBOMHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BOM Header details'
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #TRANSACTIONAL}
define view I_BillOfMaterialHeader as select from P_BillOfMaterialHeader as bom_header
left outer join I_SalesDocument on bom_header.SalesOrder = I_SalesDocument.SalesDocument
association [0..*] to I_BillOfMaterialItem as _BillOfMaterialItem on $projection.BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory
and $projection.BillOfMaterial = _BillOfMaterialItem.BillOfMaterial
and $projection.BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant
association [0..1] to I_VersionStatus as _VersionStatus on $projection.BOMVersionStatus = _VersionStatus.BOMVersionStatus
and _VersionStatus.Language = $session.system_language
association [0..1] to I_Material as _Material on $projection.Material = _Material.Material
association [0..1] to I_BillOfMaterialUsage as _BillOfMaterialVariantUsage on $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage
and _BillOfMaterialVariantUsage.Language = $session.system_language
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure
association [0..*] to I_BomChanges as _BOMChangeNumbers on $projection.BillOfMaterial = _BOMChangeNumbers.BillOfMaterial
and $projection.BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory
and $projection.BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant
and $projection.BillOfMaterialVersion = _BOMChangeNumbers.BillOfMaterialVersion
and $projection.Material = _BOMChangeNumbers.Material
and $projection.Plant = _BOMChangeNumbers.Plant
and $projection.BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage
association [0..1] to I_ChangeMaster as _ChangeNumbers on $projection.EngineeringChangeDocument = _ChangeNumbers.ChangeNumber
association [0..1] to I_Product as _Product on $projection.Material = _Product.Product
{
key bom_header.BillOfMaterialHeaderUUID as BillOfMaterialHeaderUUID,
key bom_header.BillOfMaterialVariantUsage as BillOfMaterialVariantUsage,
key bom_header.BillOfMaterialCategory as BillOfMaterialCategory,
key bom_header.BillOfMaterial as BillOfMaterial,
key bom_header.BillOfMaterialVariant as BillOfMaterialVariant,
key bom_header.BillOfMaterialVersion as BillOfMaterialVersion,
key bom_header.EngineeringChangeDocument as EngineeringChangeDocument,
key bom_header.Material as Material,
key bom_header.Plant as Plant,
bom_header.SalesOrder as SalesOrder,
bom_header.SalesOrderItem as SalesOrderItem,
//@ObjectModel.foreignKey.association: '_SoldToParty'
SoldToParty as SoldToParty,
PurchaseOrderByCustomer as PurchaseOrderByCustomer,
//bom_header.BillOfMaterialVariantUsage as BillOfMaterialVariantUsage,
// bom_header.BillOfMaterialHeaderUUID as BillOfMaterialHeaderUUID,
-- bintohex( bom_header.BillOfMaterialHeaderUUID ) as BOMCharUUID,
bom_header.BillOfMaterialUUID as BillOfMaterialUUID,
bom_header.IsMultipleBOMAlt as IsMultipleBOMAlt,
//@ObjectModel.readOnly: true
bom_header.BOMHeaderInternalChangeCount as BOMHeaderInternalChangeCount,
//@ObjectModel.readOnly: true
bom_header.BOMPrioritizedVersion as BOMPrioritizedVersion,
@Consumption.hidden: true
//@ObjectModel.readOnly: true
bom_header.BOMExplosionApplication as BOMExplosionApplication,
//@ObjectModel.readOnly: true
bom_header.BOMUsagePriority as BOMUsagePriority,
bom_header.BillOfMaterialAuthsnGrp as BillOfMaterialAuthsnGrp,
bom_header.BOMVersionStatus as BOMVersionStatus,
MaterialToLotSizeQuantity,
MatFromLotSizeQuantity,
bom_header.IsVersionBillOfMaterial as IsVersionBillOfMaterial,
bom_header.IsLatestBOMVersion as IsLatestBOMVersion,
bom_header.BOMTechnicalType as BOMTechnicalType,
bom_header.BOMGroup as BOMGroup,
bom_header.IndicatorIsBOMWithDateHistory as IndicatorIsBOMWithDateHistory,
bom_header.IndicatorIsBOMChangedWithHist as IndicatorIsBOMChangedWithHist,
bom_header.BOMHeaderText as BOMHeaderText,
bom_header.BOMAlternativeText as BOMAlternativeText,
bom_header.LongTextLanguage as LongTextLanguage,
bom_header.LongTextExists as LongTextExists,
bom_header.BillOfMaterialStatus as BillOfMaterialStatus,
//@ObjectModel.readOnly: true
// @Semantics.businessDate.to: true
bom_header.HeaderValidityEndDate,
@Semantics.businessDate.from: true
bom_header.HeaderValidityStartDate,
bom_header.ChgToEngineeringChgDocument as ChgToEngineeringChgDocument,
bom_header.IsMarkedForDeletion as IsMarkedForDeletion,
bom_header.BOMIsArchivedForDeletion,
bom_header.IsConfiguredMaterial as IsConfiguredMaterial, -- MAST-KZKFG
bom_header.BOMIsConfigurable as BOMIsConfigurable, -- MAST-KZKFG
//@ObjectModel.readOnly: true
bom_header.IsALE as IsALE,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_UnitOfMeasure'
bom_header.BOMHeaderBaseUnit as BOMHeaderBaseUnit,
@Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
@DefaultAggregation :#NONE
bom_header.BOMHeaderQuantityInBaseUnit as BOMHeaderQuantityInBaseUnit,
bom_header.RecordCreationDate as RecordCreationDate,
bom_header.LastChangeDate as LastChangeDate,
bom_header.LastChangedByUser as LastChangedByUser,
bom_header.CreatedByUser as CreatedByUser,
bom_header.BOMIsToBeDeleted as BOMIsToBeDeleted,
bom_header.DocumentIsCreatedByCAD as DocumentIsCreatedByCAD,
bom_header.LaboratoryOrDesignOffice as LaboratoryOrDesignOffice,
bom_header.LastChangeDateTime as LastChangeDateTime,
bom_header.BOMAssetNtwkHndovrIsRelevant as BOMAssetNtwkHndovrIsRelevant,
bom_header.MaterialBOMObjectID as MaterialBOMObjectID,
-- '' as BOMPredecessorVersion,
bom_header.BOMPredecessorVersion,
-- bom_header.IsBOMVersionInactive as IsBOMVersionInactive,
_Material,
_BillOfMaterialItem,
_BillOfMaterialVariantUsage,
_VersionStatus,
_UnitOfMeasure,
_Plant,
_BOMChangeNumbers,
_Product,
_SoldToParty
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA