I_BillOfMaterialItemLinks

DDL: I_BILLOFMATERIALITEMLINKS SQL: IBOMITEMLINKS Type: view BASIC
11 Fields 1 Data Sources

CDS View for STPO_LINKS table

I_BillOfMaterialItemLinks is a Basic CDS View that provides data about "CDS View for STPO_LINKS table" in SAP S/4HANA. It reads from 1 data source (stpo_links) and exposes 11 fields with key fields BillOfMaterialItemUUID, MfgBillOfMaterialCategory, MfgBillOfMaterial, MfgBillOfMaterialVariant, BillOfMaterialItemNodeNumber.

Data Sources (1)

SourceAliasJoin Type
stpo_links stpo_links from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBOMITEMLINKS view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label CDS View for STPO_LINKS table view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialItemUUID link URL
KEY MfgBillOfMaterialCategory mbom_stlty BOM category
KEY MfgBillOfMaterial mbom_stlnr BOM
KEY MfgBillOfMaterialVariant mbom_stlal AlternativeBOM
KEY BillOfMaterialItemNodeNumber mbom_stvkn Item node
KEY MfgBillOfMaterialVersion mbom_versn BOM Version
EngBillOfMaterialCategory ebom_stlty BOM category
EngBillOfMaterial ebom_stlnr BOM
EngBillOfMaterialVariant ebom_stlal AlternativeBOM
BillOfMaterialItemNumber ebom_stvkn Item node
EngBillOfMaterialVersion ebom_versn BOM Version

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_BillOfMaterialItemLinks.
-- 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: IBOMITEMLINKS

CREATE VIEW I_BillOfMaterialItemLinks AS
SELECT
  link AS BillOfMaterialItemUUID,
  mbom_stlty AS MfgBillOfMaterialCategory,
  mbom_stlnr AS MfgBillOfMaterial,
  mbom_stlal AS MfgBillOfMaterialVariant,
  mbom_stvkn AS BillOfMaterialItemNodeNumber,
  mbom_versn AS MfgBillOfMaterialVersion,
  ebom_stlty AS EngBillOfMaterialCategory,
  ebom_stlnr AS EngBillOfMaterial,
  ebom_stlal AS EngBillOfMaterialVariant,
  ebom_stvkn AS BillOfMaterialItemNumber,
  ebom_versn AS EngBillOfMaterialVersion
FROM stpo_links
;

Learn More