I_BillOfMaterialAPITP_1

DDL: I_BILLOFMATERIALAPITP_1 SQL: IBOMHEADERAPITP Type: view_entity TRANSACTIONAL Package: CS_MODEL_API
45 Fields 1 Data Sources 3 Associations

Bill of Material Header(Transactional Processing)

I_BillOfMaterialAPITP_1 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 45 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It has 3 associations to related views. Part of development package CS_MODEL_API.

Data Sources (1)

SourceAliasJoin Type
I_MaterialBOM bom_header from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProductDescription _ProductDescription $projection.Material = _ProductDescription.Product and _ProductDescription.Language = $session.system_language
[0..1] I_PlantStdVH _Plants $projection.Plant = _Plants.Plant
[0..*] I_BillOfMaterialItemAPITP_1 _BillOfMaterialItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of Material Header(Transactional Processing) view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_MaterialBOM BillOfMaterial BOM
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument Change Number
KEY Material I_MaterialBOM Material Vehicle Model
KEY Plant I_MaterialBOM Plant Valuation Area
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
EngineeringChangeDocForEdit I_MaterialBOM EngineeringChangeDocument Change Number
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 I_MaterialBOM IsConfiguredMaterial Configured matl
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
MatFromLotSizeQuantity I_MaterialBOM MatFromLotSizeQuantity From Lot Size
MaterialToLotSizeQuantity I_MaterialBOM MaterialToLotSizeQuantity To Lot Size
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
ProductDescription _ProductDescription ProductDescription Description
PlantName _Plant PlantName Plant Name
SelectedBillOfMaterialVersion
BillOfMaterialHdrDetailsText
_BillOfMaterialItem _BillOfMaterialItem
_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 I_BillOfMaterialAPITP_1.
-- 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: IBOMHEADERAPITP

CREATE VIEW I_BillOfMaterialAPITP_1 AS
SELECT
  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.Material AS Material,
  bom_header.Plant AS Plant,
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocForEdit,
  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,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  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.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  bom_header.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  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,
  _ProductDescription.ProductDescription AS ProductDescription,
  _Plant.PlantName AS PlantName,
  cast(' ' as abap.char( 4 ) ) AS SelectedBillOfMaterialVersion,
  cast(' ' as abap.char( 255 ) ) AS BillOfMaterialHdrDetailsText
FROM I_MaterialBOM AS bom_header
LEFT OUTER JOIN I_ProductDescription AS _ProductDescription ON Material = _ProductDescription.Product AND _ProductDescription.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plants ON Plant = _Plants.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemAPITP_1 AS _BillOfMaterialItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More