I_SalesOrderBOMHeader

DDL: I_SALESORDERBOMHEADER SQL: IKBOMHEADER Type: view BASIC
56 Fields 2 Data Sources 2 Associations

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)

SourceAliasJoin Type
P_SalesOrderBOMHeader bom_header from
I_SalesDocument I_SalesDocument inner

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

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

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 I_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: IKBOMHEADER

CREATE VIEW I_SalesOrderBOMHeader AS
SELECT
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( bom_header.BillOfMaterial as char8 preserving type ) AS BillOfMaterial,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.Material AS Material,
  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,
  I_SalesDocument.SoldToParty AS SoldToParty,
  I_SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  bom_header.BOMExplosionApplication AS BOMExplosionApplication,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  bom_header.MatFromLotSizeQuantity AS 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,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  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
FROM P_SalesOrderBOMHeader AS bom_header
INNER JOIN I_SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BomChanges AS _BOMChangeNumbers ON BillOfMaterial = _BOMChangeNumbers.BillOfMaterial AND BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory AND BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant AND Material = _BOMChangeNumbers.Material AND Plant = _BOMChangeNumbers.Plant AND BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage  -- association [0..*]
;

Learn More