C_RFQItemHierarchyTP

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 C_RFQItemHierarchyTP.
-- 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: CRFQITMHIER

CREATE VIEW C_RFQItemHierarchyTP AS
SELECT
  RequestForQuotationItem.RequestForQuotation AS RequestForQuotation,
  RequestForQuotationItem.RequestForQuotationItem AS RequestForQuotationItem,
  RequestForQuotationItem.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  RequestForQuotationItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  RequestForQuotationItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  RequestForQuotationItem.Material AS Material,
  RequestForQuotationItem._Material._Text[ Language = $session.system_language ].MaterialName AS MaterialName,
  RequestForQuotationItem.ProductType AS PurgDocProductType,
  RequestForQuotationItem.ManufacturerMaterial AS ManufacturerMaterial,
  RequestForQuotationItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  RequestForQuotationItem.Manufacturer AS Manufacturer,
  RequestForQuotationItem.MaterialGroup AS MaterialGroup,
  _MaterialGroupValueHelp.MaterialGroupName AS MaterialGroupName,
  _MaterialGroupValueHelp.MaterialGroupText AS MaterialGroupText,
  RequestForQuotationItem.Plant AS Plant,
  RequestForQuotationItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  RequestForQuotationItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  RequestForQuotationItem.AddressID AS AddressID,
  RequestForQuotationItem.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  RequestForQuotationItem.IncotermsClassification AS IncotermsClassification,
  RequestForQuotationItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  RequestForQuotationItem.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  RequestForQuotationItem.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  RequestForQuotationItem.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  RequestForQuotationItem.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  RequestForQuotationItem.OrderQuantityUnit AS OrderQuantityUnit,
  RequestForQuotationItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  RequestForQuotationItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  RequestForQuotationItem.BaseUnit AS BaseUnit,
  RequestForQuotationItem.PurchaseRequisition AS PurchaseRequisition,
  RequestForQuotationItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast( '' as mm_pur_requisition_frmtdpritem) AS FormattedPurRequisitionItem,
  RequestForQuotationItem.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  cast( '' as mm_rfq_process_type ) AS RFQExternalProcessingType,
  RequestForQuotationItem.PurchasingParentItem AS PurchasingParentItem,
  RequestForQuotationItem.IsStatisticalItem AS IsStatisticalItem,
  RequestForQuotationItem.PurgExternalSortNumber AS PurgExternalSortNumber,
  RequestForQuotationItem.HierarchyNode AS HierarchyNode,
  RequestForQuotationItem.HierarchyParentNode AS HierarchyParentNode,
  RequestForQuotationItem.HierarchyLevel AS HierarchyLevel,
  RequestForQuotationItem.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  RequestForQuotationItem.HierarchyDrillState AS HierarchyDrillState,
  RequestForQuotationItem.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  RequestForQuotationItem.IsOutline AS IsOutline,
  RequestForQuotationItem._IncotermsClassification AS _IncotermsClassification,
  RequestForQuotationItem._MaterialGroup AS _MaterialGroup,
  RequestForQuotationItem._Material AS _Material,
  RequestForQuotationItem._ManufacturerMaterial AS _ManufacturerMaterial,
  RequestForQuotationItem._Plant AS _Plant,
  RequestForQuotationItem._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  RequestForQuotationItem._OrderQuantityUnit AS _OrderQuantityUnit,
  RequestForQuotationItem._BaseUnit AS _BaseUnit,
  RequestForQuotationItem._ProductType AS _ProductType
FROM I_RFQItemEnhWD AS RequestForQuotationItem
LEFT OUTER JOIN C_RequestForQuotationEnhWD AS _RequestForQuotation ON _RequestForQuotation.RequestForQuotation = RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = Material AND _MaterialValueHelp.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant  -- association [0..*]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = PurgDocProductType  -- association [0..1]
LEFT OUTER JOIN C_AddressTP AS _AddressTP ON _AddressTP.AddressID = ItemDeliveryAddressID  -- association [1..1]
;