C_RFQItemEnhWD

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_RFQItemEnhWD.
-- 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: CMMRFQITMENH

CREATE VIEW C_RFQItemEnhWD AS
SELECT
  I_RFQItemEnhWD.RequestForQuotation AS RequestForQuotation,
  I_RFQItemEnhWD.RequestForQuotationItem AS RequestForQuotationItem,
  I_RFQItemEnhWD.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_RFQItemEnhWD.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_RFQItemEnhWD.Material AS Material,
  I_RFQItemEnhWD.ProductType AS ProductType,
  I_RFQItemEnhWD.ManufacturerMaterial AS ManufacturerMaterial,
  I_RFQItemEnhWD.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_RFQItemEnhWD.Manufacturer AS Manufacturer,
  I_RFQItemEnhWD.MaterialGroup AS MaterialGroup,
  I_RFQItemEnhWD.Plant AS Plant,
  I_RFQItemEnhWD._Plant.PlantName AS PlantName,
  I_RFQItemEnhWD.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_RFQItemEnhWD.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  I_RFQItemEnhWD.AddressID AS AddressID,
  I_RFQItemEnhWD.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  I_RFQItemEnhWD.IncotermsClassification AS IncotermsClassification,
  I_RFQItemEnhWD.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_RFQItemEnhWD.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_RFQItemEnhWD.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  I_RFQItemEnhWD.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_RFQItemEnhWD.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_RFQItemEnhWD.OrderQuantityUnit AS OrderQuantityUnit,
  I_RFQItemEnhWD.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  I_RFQItemEnhWD.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  I_RFQItemEnhWD.BaseUnit AS BaseUnit,
  I_RFQItemEnhWD.PurchaseRequisition AS PurchaseRequisition,
  I_RFQItemEnhWD.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast( '' as mm_pur_requisition_frmtdpritem) AS FormattedPurRequisitionItem,
  I_RFQItemEnhWD.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  I_RFQItemEnhWD.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  cast( '' as mm_rfq_process_type ) AS RFQExternalProcessingType,
  I_RFQItemEnhWD.PurchasingParentItem AS PurchasingParentItem,
  I_RFQItemEnhWD.IsStatisticalItem AS IsStatisticalItem,
  I_RFQItemEnhWD.PurgExternalSortNumber AS PurgExternalSortNumber,
  I_RFQItemEnhWD.HierarchyNode AS HierarchyNode,
  I_RFQItemEnhWD.HierarchyParentNode AS HierarchyParentNode,
  I_RFQItemEnhWD.HierarchyLevel AS HierarchyLevel,
  I_RFQItemEnhWD.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  I_RFQItemEnhWD.HierarchyDrillState AS HierarchyDrillState,
  I_RFQItemEnhWD.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  I_RFQItemEnhWD.IsOutline AS IsOutline,
  I_RFQItemEnhWD._IncotermsClassification AS _IncotermsClassification,
  I_RFQItemEnhWD._MaterialGroup AS _MaterialGroup,
  I_RFQItemEnhWD._Material AS _Material,
  I_RFQItemEnhWD._ManufacturerMaterial AS _ManufacturerMaterial,
  I_RFQItemEnhWD._Plant AS _Plant,
  I_RFQItemEnhWD._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_RFQItemEnhWD._OrderQuantityUnit AS _OrderQuantityUnit,
  I_RFQItemEnhWD._BaseUnit AS _BaseUnit,
  I_RFQItemEnhWD._ProductType AS _ProductType
FROM I_RFQItemEnhWD
LEFT OUTER JOIN C_RequestForQuotationEnhWD AS _RequestForQuotationEnhWD ON _RequestForQuotationEnhWD.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_MaterialText AS _ManufacturerMaterialText ON ManufacturerMaterial = _ManufacturerMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- 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 = ProductType  -- association [0..1]
LEFT OUTER JOIN C_AddressTP AS _AddressTP ON _AddressTP.AddressID = ItemDeliveryAddressID  -- association [1..1]
;