I_MaterialBOMLink

DDL: I_MATERIALBOMLINK SQL: IMATTOBOMLINK Type: view BASIC
12 Fields 1 Data Sources

Material Link for Bill of Material

I_MaterialBOMLink (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Bill Of Material · R&D Engineering

I_MaterialBOMLink is a Basic CDS View (Fact) that provides data about "Material Link for Bill of Material" in SAP S/4HANA. It reads from 1 data source (mast) and exposes 12 fields with key fields BillOfMaterial, BillOfMaterialVariant, Material, Plant, BillOfMaterialVariantUsage.

SAP Help Documentation

CategoryCDS Views for Bills of Material
Data CategoryFact
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is BOM number associated with a material for a material BOM? What is the plant assigned to the material BOM? What is the BOM alternative, BOM usage, and BOM category for the material BOM? Is the material configured (material variant)? Who is the last user by whom the BOM has been changed? Which user created the BOM? What is the range of lot size for the material BOM?

Prerequisites
You have access to material BOM.

Structure
Important Fields Important fields in this view include the following: Field Name Description BillOfMaterial Bill of Material BillOfMaterialVariant Alternative BOM Material Material Plant Plant

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentLO-MD-BOM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is BOM number associated with a material for a material BOM?</p></li> <li><p>What is the plant assigned to the material BOM?</p></li> <li><p>What is the BOM alternative, BOM usage, and BOM category for the material BOM?</p></li> <li><p>Is the material configured (material variant)?</p></li> <li><p>Who is the last user by whom the BOM has been changed?</p></li> <li><p>Which user created the BOM?</p></li> <li><p>What is the range of lot size for the material BOM?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
mast mast from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMATTOBOMLINK view
AbapCatalog.preserveKey true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Link for Bill of Material view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BillOfMaterial view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial stlnr Bill of Material
KEY BillOfMaterialVariant stlal Alternative BOM
KEY Material matnr Material Number
KEY Plant werks Receiving Plant
KEY BillOfMaterialVariantUsage stlan BOM Usage
BillOfMaterialCategory BOM category
MatFromLotSizeQuantity losvn Lot Size From
MaterialToLotSizeQuantity losbs To Lot Size
IsConfiguredMaterial cslty Indicator: configured material (material variant)
MaterialBOMObjectID material_bom_key Material BOM Concatenated Key
CreatedByUser annam User who created record
LastChangedByUser aenam Name of Person Who Changed Object

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_MaterialBOMLink.
-- 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: IMATTOBOMLINK

CREATE VIEW I_MaterialBOMLink AS
SELECT
  stlnr AS BillOfMaterial,
  stlal AS BillOfMaterialVariant,
  matnr AS Material,
  werks AS Plant,
  stlan AS BillOfMaterialVariantUsage,
  cast ('M' as stlty preserving type) AS BillOfMaterialCategory,
  losvn AS MatFromLotSizeQuantity,
  losbs AS MaterialToLotSizeQuantity,
  cslty AS IsConfiguredMaterial,
  material_bom_key AS MaterialBOMObjectID,
  annam AS CreatedByUser,
  aenam AS LastChangedByUser
FROM mast
;

Learn More