I_SalesOrderBOMHeader
Sales Order Bill Of Material Header
I_SalesOrderBOMHeader is a Basic CDS View that provides data about "Sales Order Bill Of Material Header" in SAP S/4HANA. It reads from 2 data sources (P_SalesOrderBOMHeader, I_SalesDocument) and exposes 56 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, EngineeringChangeDocument, Material. It has 2 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_SalesOrderBOMHeader | bom_header | from |
| I_SalesDocument | I_SalesDocument | inner |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant |
| [0..*] | I_BomChanges | _BOMChangeNumbers | $projection.BillOfMaterial = _BOMChangeNumbers.BillOfMaterial and $projection.BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant and $projection.Material = _BOMChangeNumbers.Material and $projection.Plant = _BOMChangeNumbers.Plant and $projection.BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IKBOMHEADER | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Sales Order Bill Of Material Header | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view |
Fields (56)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillOfMaterialCategory | P_SalesOrderBOMHeader | BillOfMaterialCategory | |
| KEY | BillOfMaterial | |||
| KEY | BillOfMaterialVariant | P_SalesOrderBOMHeader | BillOfMaterialVariant | |
| KEY | EngineeringChangeDocument | P_SalesOrderBOMHeader | EngineeringChangeDocument | |
| KEY | Material | P_SalesOrderBOMHeader | Material | |
| KEY | Plant | P_SalesOrderBOMHeader | Plant | |
| BillOfMaterialVariantUsage | P_SalesOrderBOMHeader | BillOfMaterialVariantUsage | ||
| BillOfMaterialHeaderUUID | P_SalesOrderBOMHeader | BillOfMaterialHeaderUUID | ||
| BillOfMaterialVersion | P_SalesOrderBOMHeader | BillOfMaterialVersion | ||
| SalesOrder | P_SalesOrderBOMHeader | SalesOrder | ||
| SalesOrderItem | P_SalesOrderBOMHeader | SalesOrderItem | ||
| SoldToParty | I_SalesDocument | SoldToParty | ||
| PurchaseOrderByCustomer | I_SalesDocument | PurchaseOrderByCustomer | ||
| BOMCharUUID | ||||
| IsMultipleBOMAlt | P_SalesOrderBOMHeader | IsMultipleBOMAlt | ||
| BOMHeaderInternalChangeCount | P_SalesOrderBOMHeader | BOMHeaderInternalChangeCount | ||
| BOMPrioritizedVersion | P_SalesOrderBOMHeader | BOMPrioritizedVersion | ||
| BOMExplosionApplication | P_SalesOrderBOMHeader | BOMExplosionApplication | ||
| BOMUsagePriority | P_SalesOrderBOMHeader | BOMUsagePriority | ||
| BillOfMaterialAuthsnGrp | P_SalesOrderBOMHeader | BillOfMaterialAuthsnGrp | ||
| BOMVersionStatus | P_SalesOrderBOMHeader | BOMVersionStatus | ||
| MaterialToLotSizeQuantity | P_SalesOrderBOMHeader | MaterialToLotSizeQuantity | ||
| MatFromLotSizeQuantity | P_SalesOrderBOMHeader | MatFromLotSizeQuantity | ||
| IsVersionBillOfMaterial | P_SalesOrderBOMHeader | IsVersionBillOfMaterial | ||
| IsLatestBOMVersion | P_SalesOrderBOMHeader | IsLatestBOMVersion | ||
| BOMTechnicalType | P_SalesOrderBOMHeader | BOMTechnicalType | ||
| BOMGroup | P_SalesOrderBOMHeader | BOMGroup | ||
| IndicatorIsBOMWithDateHistory | P_SalesOrderBOMHeader | IndicatorIsBOMWithDateHistory | ||
| IndicatorIsBOMChangedWithHist | P_SalesOrderBOMHeader | IndicatorIsBOMChangedWithHist | ||
| BOMHeaderText | P_SalesOrderBOMHeader | BOMHeaderText | ||
| BOMAlternativeText | P_SalesOrderBOMHeader | BOMAlternativeText | ||
| LongTextLanguage | P_SalesOrderBOMHeader | LongTextLanguage | ||
| LongTextExists | P_SalesOrderBOMHeader | LongTextExists | ||
| BillOfMaterialStatus | P_SalesOrderBOMHeader | BillOfMaterialStatus | ||
| HeaderValidityEndDate | P_SalesOrderBOMHeader | HeaderValidityEndDate | ||
| HeaderValidityStartDate | P_SalesOrderBOMHeader | HeaderValidityStartDate | ||
| ChgToEngineeringChgDocument | P_SalesOrderBOMHeader | ChgToEngineeringChgDocument | ||
| IsMarkedForDeletion | P_SalesOrderBOMHeader | IsMarkedForDeletion | ||
| BOMIsArchivedForDeletion | P_SalesOrderBOMHeader | BOMIsArchivedForDeletion | ||
| IsConfiguredMaterial | P_SalesOrderBOMHeader | IsConfiguredMaterial | ||
| BOMIsConfigurableasBOMIsConfigurable | ||||
| IsALEasIsALE | ||||
| BOMHeaderBaseUnit | P_SalesOrderBOMHeader | BOMHeaderBaseUnit | ||
| BOMHeaderQuantityInBaseUnit | P_SalesOrderBOMHeader | BOMHeaderQuantityInBaseUnit | ||
| RecordCreationDate | P_SalesOrderBOMHeader | RecordCreationDate | ||
| LastChangeDate | P_SalesOrderBOMHeader | LastChangeDate | ||
| LastChangedByUser | P_SalesOrderBOMHeader | LastChangedByUser | ||
| CreatedByUser | P_SalesOrderBOMHeader | CreatedByUser | ||
| BOMIsToBeDeleted | P_SalesOrderBOMHeader | BOMIsToBeDeleted | ||
| DocumentIsCreatedByCAD | P_SalesOrderBOMHeader | DocumentIsCreatedByCAD | ||
| LaboratoryOrDesignOffice | P_SalesOrderBOMHeader | LaboratoryOrDesignOffice | ||
| LastChangeDateTime | P_SalesOrderBOMHeader | LastChangeDateTime | ||
| BOMAssetNtwkHndovrIsRelevant | P_SalesOrderBOMHeader | BOMAssetNtwkHndovrIsRelevant | ||
| MaterialBOMObjectID | P_SalesOrderBOMHeader | MaterialBOMObjectID | ||
| _Plant | _Plant | |||
| _BOMChangeNumbers | _BOMChangeNumbers |
@AbapCatalog.sqlViewName: 'IKBOMHEADER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Sales Order Bill Of Material Header'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
define view I_SalesOrderBOMHeader as select from P_SalesOrderBOMHeader as bom_header
inner join I_SalesDocument on bom_header.SalesOrder = I_SalesDocument.SalesDocument
//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.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.BillOfMaterialCategory as BillOfMaterialCategory,
//key bom_header.BillOfMaterial as BillOfMaterial,
key cast( bom_header.BillOfMaterial as char8 preserving type ) as BillOfMaterial,
key bom_header.BillOfMaterialVariant as BillOfMaterialVariant,
key bom_header.EngineeringChangeDocument as EngineeringChangeDocument,
key bom_header.Material as Material,
key bom_header.Plant as Plant,
bom_header.BillOfMaterialVariantUsage as BillOfMaterialVariantUsage,
bom_header.BillOfMaterialHeaderUUID as BillOfMaterialHeaderUUID,
bom_header.BillOfMaterialVersion as BillOfMaterialVersion,
bom_header.SalesOrder as SalesOrder,
bom_header.SalesOrderItem as SalesOrderItem,
//@ObjectModel.foreignKey.association: '_SoldToParty'
I_SalesDocument.SoldToParty as SoldToParty,
I_SalesDocument.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,
bom_header.MaterialToLotSizeQuantity,
bom_header.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 ,
// _Material,
// _BillOfMaterialVariantUsage,
// _UnitOfMeasure,
_Plant,
_BOMChangeNumbers
// _Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT",
"P_SALESORDERBOMHEADER"
],
"ASSOCIATED":
[
"I_BOMCHANGES",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/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