I_BillOfMaterialAPITP

DDL: I_BILLOFMATERIALAPITP SQL: IBOMHEADERTP Type: view TRANSACTIONAL Package: CS_OP
41 Fields 1 Data Sources 2 Associations

Bill of Material Header(Transactional Processing)

I_BillOfMaterialAPITP is a Transactional CDS View that provides data about "Bill of Material Header(Transactional Processing)" in SAP S/4HANA. It reads from 1 data source (I_MaterialBOM) and exposes 41 fields with key field BillOfMaterialHeaderUUID. It has 2 associations to related views. Part of development package CS_OP.

Data Sources (1)

SourceAliasJoin Type
I_MaterialBOM bom_header from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Product _Product $projection.Material = _Product.Product
[0..*] I_BillOfMaterialItemAPITP _BillOfMaterialItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBOMHEADERTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of Material Header(Transactional Processing) view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
BillOfMaterial I_MaterialBOM BillOfMaterial BOM
BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument Change Number
EngineeringChangeDocForEdit I_MaterialBOM EngineeringChangeDocument Change Number
Material I_MaterialBOM Material Vehicle Model
Plant I_MaterialBOM Plant Valuation Area
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
IsMultipleBOMAlt I_MaterialBOM IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount I_MaterialBOM BOMHeaderInternalChangeCount Counter
BOMUsagePriority I_MaterialBOM BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp I_MaterialBOM BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus I_MaterialBOM BOMVersionStatus BOM Version Status
IsVersionBillOfMaterial I_MaterialBOM IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion I_MaterialBOM IsLatestBOMVersion Latest Rel Version
IsConfiguredMaterial _Product ProductIsConfigurable Configurable
BOMIsConfigurable I_MaterialBOM BOMIsConfigurable ConfigurableBOM
BOMTechnicalType
BOMGroup I_MaterialBOM BOMGroup BOM group
BOMHeaderText I_MaterialBOM BOMHeaderText BOM Description
BOMAlternativeText I_MaterialBOM BOMAlternativeText Alt Text
BillOfMaterialStatus I_MaterialBOM BillOfMaterialStatus BOM Status
HeaderValidityStartDate I_MaterialBOM HeaderValidityStartDate Valid From
HeaderValidityEndDate I_MaterialBOM HeaderValidityEndDate to
ChgToEngineeringChgDocument I_MaterialBOM ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion I_MaterialBOM IsMarkedForDeletion Purch.org. data
IsALE I_MaterialBOM IsALE ALE indicator
BOMHeaderBaseUnit I_MaterialBOM BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit I_MaterialBOM BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate I_MaterialBOM RecordCreationDate Created On
LastChangeDate I_MaterialBOM LastChangeDate Time Stamp
CreatedByUser I_MaterialBOM CreatedByUser User Name
LastChangedByUser I_MaterialBOM LastChangedByUser User Name
BOMIsToBeDeleted I_MaterialBOM BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD I_MaterialBOM DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice I_MaterialBOM LaboratoryOrDesignOffice Lab/Office
LastChangeDateTime I_MaterialBOM LastChangeDateTime Timestamp
SelectedBillOfMaterialVersion
_BillOfMaterialItem _BillOfMaterialItem

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_BillOfMaterialAPITP.
-- 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: IBOMHEADERTP

CREATE VIEW I_BillOfMaterialAPITP AS
SELECT
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.BillOfMaterial AS BillOfMaterial,
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocForEdit,
  bom_header.Material AS Material,
  bom_header.Plant AS Plant,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.IsLatestBOMVersion AS IsLatestBOMVersion,
  _Product.ProductIsConfigurable AS IsConfiguredMaterial,
  bom_header.BOMIsConfigurable AS BOMIsConfigurable,
  cast ( bom_header.BOMTechnicalType as tetyp_d preserving type) AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.IsALE AS IsALE,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bom_header.LastChangeDateTime AS LastChangeDateTime,
  cast(' ' as abap.char( 4 ) ) AS SelectedBillOfMaterialVersion
FROM I_MaterialBOM AS bom_header
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemAPITP AS _BillOfMaterialItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More