I_MfgBOMItemWithPhantomHier

DDL: I_MFGBOMITEMWITHPHANTOMHIER Type: view_entity COMPOSITE
7 Fields 2 Data Sources

MBOM items with phantom hierarchy

I_MfgBOMItemWithPhantomHier is a Composite CDS View that provides data about "MBOM items with phantom hierarchy" in SAP S/4HANA. It reads from 2 data sources (I_BillOfMaterial, I_BOMItemLinksWithPhantom) and exposes 7 fields with key fields MfgBillOfMaterialCategory, MfgBillOfMaterial, MfgBillOfMaterialVariant, MfgBillOfMaterialVersion, MfgBOMItmInhtdNodeNmbr.

Data Sources (2)

SourceAliasJoin Type
I_BillOfMaterial BOMHeader inner
I_BOMItemLinksWithPhantom BOMItemLinks from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MBOM items with phantom hierarchy view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MfgBillOfMaterialCategory I_BOMItemLinksWithPhantom MfgBillOfMaterialCategory BOM category
KEY MfgBillOfMaterial
KEY MfgBillOfMaterialVariant I_BOMItemLinksWithPhantom MfgBillOfMaterialVariant AlternativeBOM
KEY MfgBillOfMaterialVersion I_BOMItemLinksWithPhantom MfgBillOfMaterialVersion BOM Version
KEY MfgBOMItmInhtdNodeNmbr I_BOMItemLinksWithPhantom MfgBOMItmInhtdNodeNmbr Item node
SourceBOMPhantomNodeUUID I_BOMItemLinksWithPhantom SourceBOMPhantomNodeUUID Node ID
MfgBOMItemIsPhantomChild

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_MfgBOMItemWithPhantomHier.
-- 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_MfgBOMItemWithPhantomHier AS
SELECT
  BOMItemLinks.MfgBillOfMaterialCategory AS MfgBillOfMaterialCategory,
  cast( BOMItemLinks.MfgBillOfMaterial as cs_stlnr preserving type ) AS MfgBillOfMaterial,
  BOMItemLinks.MfgBillOfMaterialVariant AS MfgBillOfMaterialVariant,
  BOMItemLinks.MfgBillOfMaterialVersion AS MfgBillOfMaterialVersion,
  BOMItemLinks.MfgBOMItmInhtdNodeNmbr AS MfgBOMItmInhtdNodeNmbr,
  BOMItemLinks.SourceBOMPhantomNodeUUID AS SourceBOMPhantomNodeUUID,
  cast( 'X' as mpe_bom_phantom_child preserving type ) AS MfgBOMItemIsPhantomChild
FROM I_BOMItemLinksWithPhantom AS BOMItemLinks
INNER JOIN I_BillOfMaterial AS BOMHeader ON /* join condition not captured in parsed metadata */
;

Learn More