I_ChgImpactBOMItmLinks

DDL: I_CHGIMPACTBOMITMLINKS SQL: ICHEBOMMBOMLINKS Type: view BASIC
11 Fields 1 Data Sources

Eng BOM Mfg BOM Item Links

I_ChgImpactBOMItmLinks is a Basic CDS View that provides data about "Eng BOM Mfg BOM Item Links" in SAP S/4HANA. It reads from 1 data source (stpo_links) and exposes 11 fields with key field LinkUUID.

Data Sources (1)

SourceAliasJoin Type
stpo_links BOMItemLinks from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHEBOMMBOMLINKS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Eng BOM Mfg BOM Item Links view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (11)

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

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_ChgImpactBOMItmLinks.
-- 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: ICHEBOMMBOMLINKS

CREATE VIEW I_ChgImpactBOMItmLinks AS
SELECT
  BOMItemLinks.link AS LinkUUID,
  BOMItemLinks.ebom_stlty AS EngBillOfMaterialCategory,
  BOMItemLinks.ebom_stlnr AS EngBillOfMaterial,
  BOMItemLinks.ebom_stlal AS EngBillOfMaterialVariant,
  BOMItemLinks.ebom_versn AS EngBillOfMaterialVersion,
  BOMItemLinks.ebom_stvkn AS EngBOMItmInhtdNodeNmbr,
  BOMItemLinks.mbom_stlty AS MfgBillOfMaterialCategory,
  BOMItemLinks.mbom_stlnr AS MfgBillOfMaterial,
  BOMItemLinks.mbom_stlal AS MfgBillOfMaterialVariant,
  BOMItemLinks.mbom_versn AS MfgBillOfMaterialVersion,
  BOMItemLinks.mbom_stvkn AS MfgBOMItmInhtdNodeNmbr
FROM stpo_links AS BOMItemLinks
;

Learn More