I_StandardBOMLink

DDL: I_STANDARDBOMLINK Type: view_entity BASIC Package: CS_MODEL

Standard Link for BOM

I_StandardBOMLink (Basic)

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

R&D Engineering

I_StandardBOMLink is a Basic CDS View that provides data about "Standard Link for BOM" in SAP S/4HANA. It reads from 1 data source (stst) and exposes 7 fields with key fields StandardObject, Plant, BillOfMaterialVariantUsage, BillOfMaterial, BillOfMaterialVariant. It has 1 association to related views. Part of development package CS_MODEL.

SAP Help Documentation

CategoryCDS Views for Bill of Material
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the BOM number associated with the standard object for a standard BOM? What is the plant assigned to the standard BOM? What is the BOM alternative, BOM usage, and BOM category for the standard BOM?

Prerequisites
You have authorization to access the standard BOM.

Structure
Attributes Some important attributes are: Standard Order Plant BOM Variant BOM Variant Usage BOM Category Bill of Material

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessR&D Engineering
Application ComponentLO-MD-BOM-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageR&D/Engineering for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What is the BOM number associated with the standard object for a standard BOM?</p> </li> <li> <p>What is the plant assigned to the standard BOM?</p> </li> <li> <p>What is the BOM alternative, BOM usage, and BOM category for the standard BOM?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
stst stst from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BillOfMaterialUsage _BillOfMaterialUsage $projection.BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage and _BillOfMaterialUsage.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Standard Link for BOM view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StandardObject stobj Standard object
KEY Plant werks Receiving Plant
KEY BillOfMaterialVariantUsage stlan BOM Usage
KEY BillOfMaterial stlnr Bill of Material
KEY BillOfMaterialVariant stlal Alternative BOM
BillOfMaterialCategory BOM category
_BillOfMaterialUsage _BillOfMaterialUsage

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_StandardBOMLink.
-- 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.

CREATE VIEW I_StandardBOMLink AS
SELECT
  stobj AS StandardObject,
  werks AS Plant,
  stlan AS BillOfMaterialVariantUsage,
  stlnr AS BillOfMaterial,
  stlal AS BillOfMaterialVariant,
  cast ('S' as stlty preserving type) AS BillOfMaterialCategory
FROM stst
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialUsage ON BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage AND _BillOfMaterialUsage.Language = $session.system_language  -- association [0..1]
;