I_MfgBOM

DDL: I_MFGBOM SQL: IMFGBOM Type: view BASIC
42 Fields 2 Data Sources

Manufacturing Bill Of Material

I_MfgBOM is a Basic CDS View that provides data about "Manufacturing Bill Of Material" in SAP S/4HANA. It reads from 2 data sources (I_MaterialBOM, I_MfgBOMUsage) and exposes 42 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, Material.

Data Sources (2)

SourceAliasJoin Type
I_MaterialBOM MaterialBOM from
I_MfgBOMUsage MfgBOMUsage inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBOM view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Manufacturing Bill Of Material view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
KEY BillOfMaterial I_MaterialBOM BillOfMaterial BOM
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
KEY Material I_MaterialBOM Material Vehicle Model
KEY Plant I_MaterialBOM Plant Valuation Area
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
BillOfMaterialUUID I_MaterialBOM BillOfMaterialUUID Character Field of Length 12
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
IsMultipleBOMAlt I_MaterialBOM IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount I_MaterialBOM BOMHeaderInternalChangeCount Counter
BOMPrioritizedVersion I_MaterialBOM BOMPrioritizedVersion Selection ID
BOMExplosionApplication I_MaterialBOM BOMExplosionApplication BOM Application
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 I_MaterialBOM BOMTechnicalType Tech type
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
EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument Change Number
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
_BillOfMaterialItem I_MaterialBOM _BillOfMaterialItem
_BillOfMaterialVariantUsage I_MaterialBOM _BillOfMaterialVariantUsage
_UnitOfMeasure I_MaterialBOM _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_MfgBOM.
-- 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: IMFGBOM

CREATE VIEW I_MfgBOM AS
SELECT
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.BillOfMaterial AS BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  MaterialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MaterialBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  MaterialBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  MaterialBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  MaterialBOM.BOMExplosionApplication AS BOMExplosionApplication,
  MaterialBOM.BOMUsagePriority AS BOMUsagePriority,
  MaterialBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  MaterialBOM.BOMVersionStatus AS BOMVersionStatus,
  MaterialBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  MaterialBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  MaterialBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  MaterialBOM.BOMTechnicalType AS BOMTechnicalType,
  MaterialBOM.BOMGroup AS BOMGroup,
  MaterialBOM.BOMHeaderText AS BOMHeaderText,
  MaterialBOM.BOMAlternativeText AS BOMAlternativeText,
  MaterialBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  MaterialBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  MaterialBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  MaterialBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  MaterialBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  MaterialBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  MaterialBOM.IsALE AS IsALE,
  MaterialBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  MaterialBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  MaterialBOM.RecordCreationDate AS RecordCreationDate,
  MaterialBOM.LastChangeDate AS LastChangeDate,
  MaterialBOM.CreatedByUser AS CreatedByUser,
  MaterialBOM.LastChangedByUser AS LastChangedByUser,
  MaterialBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  MaterialBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  MaterialBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  MaterialBOM._BillOfMaterialItem AS _BillOfMaterialItem,
  MaterialBOM._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  MaterialBOM._UnitOfMeasure AS _UnitOfMeasure
FROM I_MaterialBOM AS MaterialBOM
INNER JOIN I_MfgBOMUsage AS MfgBOMUsage ON /* join condition not captured in parsed metadata */
;

Learn More