I_MfgRefStrucItemWithDetails

DDL: I_MFGREFSTRUCITEMWITHDETAILS Type: view_entity COMPOSITE
11 Fields 1 Data Sources 2 Associations

MRS Item with Additional Details

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

Data Sources (1)

SourceAliasJoin Type
I_MfgReferenceStructureItem I_MfgReferenceStructureItem from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MfgReferenceStructureItmTxt _MfgReferenceStructureItmTxt $projection.MfgRefStructureUsage = _MfgReferenceStructureItmTxt.MfgRefStructureUsage and $projection.MfgRefStrucHeaderObject = _MfgReferenceStructureItmTxt.MfgRefStrucHeaderObject and $projection.MfgRefStrucItmRefDesignator = _MfgReferenceStructureItmTxt.MfgRefStrucItmRefDesignator
[0..1] E_MfgReferenceHierarchyItem _Extension $projection.MfgRefStructureUsage = _Extension.MfgRefStructureUsage and $projection.MfgRefStrucHeaderObject = _Extension.MfgRefStrucHeaderObject and $projection.MfgRefStrucItmRefDesignator = _Extension.MfgRefStrucItmRefDesignator

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRS 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 (11)

KeyFieldSource TableSource FieldDescription
KEY MfgRefStructureUsage MfgRefStructureUsage Usage
KEY MfgRefStrucHeaderObject MfgRefStrucHeaderObject Reference Object
KEY MfgRefStrucItmRefDesignator MfgRefStrucItmRefDesignator MRS Designator ID
MfgRefStrucItmRefDsgntrName MfgRefStrucItmRefDsgntrName MRS Designator
MfgRefStrucItemObject MfgRefStrucItemObject Reference Object
MfgRefObjectGroup MfgRefObjectGroup Ref. Object Group
MfgRefStrucItemSortPositionVal MfgRefStrucItemSortPositionVal Sort Position
MfgRefStructureItemExternalID MfgRefStructureItemExternalID MRS Item Ext. ID
IsObsolete IsObsolete Deprecated
MfgRefStructureItemUUID MfgRefStructureItemUUID MRS Item UUID
_MfgReferenceStructureItmTxt _MfgReferenceStructureItmTxt

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_MfgRefStrucItemWithDetails.
-- 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_MfgRefStrucItemWithDetails AS
SELECT
  MfgRefStructureUsage,
  MfgRefStrucHeaderObject,
  MfgRefStrucItmRefDesignator,
  MfgRefStrucItmRefDsgntrName,
  MfgRefStrucItemObject,
  MfgRefObjectGroup,
  MfgRefStrucItemSortPositionVal,
  MfgRefStructureItemExternalID,
  IsObsolete,
  MfgRefStructureItemUUID
FROM I_MfgReferenceStructureItem
LEFT OUTER JOIN I_MfgReferenceStructureItmTxt AS _MfgReferenceStructureItmTxt ON MfgRefStructureUsage = _MfgReferenceStructureItmTxt.MfgRefStructureUsage AND MfgRefStrucHeaderObject = _MfgReferenceStructureItmTxt.MfgRefStrucHeaderObject AND MfgRefStrucItmRefDesignator = _MfgReferenceStructureItmTxt.MfgRefStrucItmRefDesignator  -- association [0..*]
LEFT OUTER JOIN E_MfgReferenceHierarchyItem AS _Extension ON MfgRefStructureUsage = _Extension.MfgRefStructureUsage AND MfgRefStrucHeaderObject = _Extension.MfgRefStrucHeaderObject AND MfgRefStrucItmRefDesignator = _Extension.MfgRefStrucItmRefDesignator  -- association [0..1]
;

Learn More