R_RFQItemHierarchyNodeRelation

DDL: R_RFQITEMHIERARCHYNODERELATION SQL: RRFQITMHIERRLN Type: view COMPOSITE Package: ODATA_MM_PUR_RFQ_MAINTAIN
46 Fields 1 Data Sources 3 Associations

Source View for RFQ items Hierarchy

R_RFQItemHierarchyNodeRelation is a Composite CDS View that provides data about "Source View for RFQ items Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotationItem) and exposes 46 fields with key fields RequestForQuotation, RequestForQuotationItem. It has 3 associations to related views. Part of development package ODATA_MM_PUR_RFQ_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_RequestForQuotationItem I_RequestForQuotationItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_RequestForQuotationEnhanced _RequestForQuotation $projection.RequestForQuotation = _RequestForQuotation.RequestForQuotation
[0..1] R_RFQItemHierarchyNodeRelation _Parent $projection.PurchasingParentItem = _Parent.RequestForQuotationItem and $projection.RequestForQuotation = _Parent.RequestForQuotation ----Extension
[1..1] E_PurchasingDocumentItem _RequestQtnItemExtension $projection.RequestForQuotation = _RequestQtnItemExtension.PurchasingDocument and $projection.RequestForQuotationItem = _RequestQtnItemExtension.PurchasingDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RRFQITMHIERRLN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Source View for RFQ items Hierarchy view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation RequestForQuotation RFQ
KEY RequestForQuotationItem RequestForQuotationItem RFQ Item
PurgConfigurableItemNumber PurgConfigurableItemNumber Hierarchy Number
PurchasingParentItem PurchasingParentItem Parent Item No
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
Material Material Vehicle Model
PurgDocProductType ProductType Product Type Group
ManufacturerMaterial ManufacturerMaterial MPN: Material
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
Manufacturer Manufacturer Manufacturer
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ReferenceDeliveryAddressID ReferenceDeliveryAddressID Reference Address
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
BaseUnit BaseUnit Unit of Measure
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
RequirementTracking RequirementTracking Tracking Number
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory Sub-items
PurgExternalSortNumber PurgExternalSortNumber External Sort No.
_BaseUnit _BaseUnit
_IncotermsClassification _IncotermsClassification
_ManualDeliveryAddress_2 _ManualDeliveryAddress_2
_Manufacturer _Manufacturer
_ManufacturerMaterial _ManufacturerMaterial
_Material _Material
_MaterialGroup _MaterialGroup
_OrderQuantityUnit _OrderQuantityUnit
_Plant _Plant
_ProductType _ProductType
_PurgDocumentItemCategory _PurgDocumentItemCategory
_ReferenceDeliveryAddress_2 _ReferenceDeliveryAddress_2
_RequestForQuotation _RequestForQuotation
_SupplierQuotationItem _SupplierQuotationItem
_Parent _Parent
_PurchasingDocumentCategory _PurchasingDocumentCategory

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 R_RFQItemHierarchyNodeRelation.
-- 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: RRFQITMHIERRLN

CREATE VIEW R_RFQItemHierarchyNodeRelation AS
SELECT
  RequestForQuotation,
  RequestForQuotationItem,
  PurgConfigurableItemNumber,
  PurchasingParentItem,
  PurchasingDocumentCategory,
  PurchasingDocumentItemText,
  Material,
  ProductType AS PurgDocProductType,
  ManufacturerMaterial,
  ManufacturerPartNmbr,
  Manufacturer,
  MaterialGroup,
  Plant,
  ManualDeliveryAddressID,
  ReferenceDeliveryAddressID,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  OrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  BaseUnit,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RequirementTracking,
  PurchasingDocumentItemCategory,
  IsStatisticalItem,
  PurgDocAggrgdSubitemCategory,
  PurgExternalSortNumber
FROM I_RequestForQuotationItem
LEFT OUTER JOIN I_RequestForQuotationEnhanced AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN R_RFQItemHierarchyNodeRelation AS _Parent ON PurchasingParentItem = _Parent.RequestForQuotationItem AND RequestForQuotation = _Parent.RequestForQuotation  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _RequestQtnItemExtension ON RequestForQuotation = _RequestQtnItemExtension.PurchasingDocument AND RequestForQuotationItem = _RequestQtnItemExtension.PurchasingDocumentItem  -- association [1..1]
;

Learn More