I_MfgRefHierItemWithDetails

DDL: I_MFGREFHIERITEMWITHDETAILS Type: view_entity COMPOSITE
8 Fields 1 Data Sources 2 Associations

MRS Hierarchy Item with Additional Details

I_MfgRefHierItemWithDetails is a Composite CDS View that provides data about "MRS Hierarchy Item with Additional Details" in SAP S/4HANA. It reads from 1 data source (I_MfgReferenceHierarchyItem) and exposes 8 fields with key fields MfgRefStructureUsage, MfgRefStrucHeaderObject, MfgRefStrucItmRefDesignator, MfgRefPathUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgReferenceHierarchyItem I_MfgReferenceHierarchyItem from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MfgReferenceHierarchyItmTxt _MfgReferenceHierarchyItmTxt $projection.MfgRefStructureUsage = _MfgReferenceHierarchyItmTxt.MfgRefStructureUsage and $projection.MfgRefStrucHeaderObject = _MfgReferenceHierarchyItmTxt.MfgRefStrucHeaderObject and $projection.MfgRefStrucItmRefDesignator = _MfgReferenceHierarchyItmTxt.MfgRefStrucItmRefDesignator and $projection.MfgRefPathUUID = _MfgReferenceHierarchyItmTxt.MfgRefPathUUID
[0..1] E_MfgReferenceHierarchyItem _Extension $projection.MfgRefStructureUsage = _Extension.MfgRefStructureUsage and $projection.MfgRefStrucHeaderObject = _Extension.MfgRefStrucHeaderObject and $projection.MfgRefStrucItmRefDesignator = _Extension.MfgRefStrucItmRefDesignator and $projection.MfgRefPathUUID = _Extension.MfgRefPathUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRS Hierarchy Item with Additional Details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MfgRefStructureUsage MfgRefStructureUsage Usage
KEY MfgRefStrucHeaderObject MfgRefStrucHeaderObject Reference Object
KEY MfgRefStrucItmRefDesignator MfgRefStrucItmRefDesignator MRS Designator ID
KEY MfgRefPathUUID MfgRefPathUUID Reference Path UUID
HierMfgReferenceDesignatorName HierMfgReferenceDesignatorName MRS Designator
MfgRefHierarchyItemExternalID MfgRefHierarchyItemExternalID Hier. Item Ext. ID
MfgRefHierarchyItemUUID MfgRefHierarchyItemUUID Hierarchy Item UUID
_MfgReferenceHierarchyItmTxt _MfgReferenceHierarchyItmTxt

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_MfgRefHierItemWithDetails.
-- 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_MfgRefHierItemWithDetails AS
SELECT
  MfgRefStructureUsage,
  MfgRefStrucHeaderObject,
  MfgRefStrucItmRefDesignator,
  MfgRefPathUUID,
  HierMfgReferenceDesignatorName,
  MfgRefHierarchyItemExternalID,
  MfgRefHierarchyItemUUID
FROM I_MfgReferenceHierarchyItem
LEFT OUTER JOIN I_MfgReferenceHierarchyItmTxt AS _MfgReferenceHierarchyItmTxt ON MfgRefStructureUsage = _MfgReferenceHierarchyItmTxt.MfgRefStructureUsage AND MfgRefStrucHeaderObject = _MfgReferenceHierarchyItmTxt.MfgRefStrucHeaderObject AND MfgRefStrucItmRefDesignator = _MfgReferenceHierarchyItmTxt.MfgRefStrucItmRefDesignator AND MfgRefPathUUID = _MfgReferenceHierarchyItmTxt.MfgRefPathUUID  -- association [0..*]
LEFT OUTER JOIN E_MfgReferenceHierarchyItem AS _Extension ON MfgRefStructureUsage = _Extension.MfgRefStructureUsage AND MfgRefStrucHeaderObject = _Extension.MfgRefStrucHeaderObject AND MfgRefStrucItmRefDesignator = _Extension.MfgRefStrucItmRefDesignator AND MfgRefPathUUID = _Extension.MfgRefPathUUID  -- association [0..1]
;

Learn More