C_CentralReqForQuotationItemTP

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_CentralReqForQuotationItemTP.
-- 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: CCNTRLRFQITEMTP

CREATE VIEW C_CentralReqForQuotationItemTP AS
SELECT
  _CentralReqForQuotationItemTP.CentralRequestForQuotation AS CentralRequestForQuotation,
  _CentralReqForQuotationItemTP.CentralRequestForQuotationItem AS CentralRequestForQuotationItem,
  _CentralReqForQuotationItemTP.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _CentralReqForQuotationItemTP.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _CentralReqForQuotationItemTP.PurchasingCentralMaterial AS PurchasingCentralMaterial,
  _CentralReqForQuotationItemTP.ProductType AS ProductType,
  _CentralReqForQuotationItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  _CentralReqForQuotationItemTP.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _CentralReqForQuotationItemTP.Manufacturer AS Manufacturer,
  _CentralReqForQuotationItemTP.MaterialGroup AS MaterialGroup,
  _CentralReqForQuotationItemTP.Plant AS Plant,
  _CentralReqForQuotationItemTP._Plant.PlantName AS PlantName,
  _CentralReqForQuotationItemTP.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _CentralReqForQuotationItemTP.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  _CentralReqForQuotationItemTP.AddressID AS AddressID,
  _CentralReqForQuotationItemTP.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _CentralReqForQuotationItemTP.IncotermsClassification AS IncotermsClassification,
  _CentralReqForQuotationItemTP.IncotermsTransferLocation AS IncotermsTransferLocation,
  _CentralReqForQuotationItemTP.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _CentralReqForQuotationItemTP.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  _CentralReqForQuotationItemTP.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _CentralReqForQuotationItemTP.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _CentralReqForQuotationItemTP.OrderQuantityUnit AS OrderQuantityUnit,
  _CentralReqForQuotationItemTP.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  _CentralReqForQuotationItemTP.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  _CentralReqForQuotationItemTP.BaseUnit AS BaseUnit,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  cast( '' as mm_rfq_process_type ) AS RFQExternalProcessingType,
  _CentralReqForQuotationItemTP._IncotermsClassification AS _IncotermsClassification,
  _CentralReqForQuotationItemTP._MaterialGroup AS _MaterialGroup,
  _CentralReqForQuotationItemTP._ManufacturerMaterial AS _ManufacturerMaterial,
  _CentralReqForQuotationItemTP._Plant AS _Plant,
  _CentralReqForQuotationItemTP._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  _CentralReqForQuotationItemTP._OrderQuantityUnit AS _OrderQuantityUnit,
  _CentralReqForQuotationItemTP._BaseUnit AS _BaseUnit
FROM I_CentralReqForQuotationItemTP AS _CentralReqForQuotationItemTP
LEFT OUTER JOIN C_CentralRequestForQuotationTP AS _CentralRequestForQuotationTP ON _CentralRequestForQuotationTP.CentralRequestForQuotation = CentralRequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON PurchasingCentralMaterial = _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_CentralRFQItemDistributionTP AS _CentralRFQItemDistributionTP ON _CentralRFQItemDistributionTP.CentralRequestForQuotationItem = CentralRequestForQuotationItem AND _CentralRFQItemDistributionTP.CentralRequestForQuotation = CentralRequestForQuotation  -- 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]
LEFT OUTER JOIN C_CntrlPurContrMaterialVH AS _CntrlPurMaterialVH ON _CntrlPurMaterialVH.Material = PurchasingCentralMaterial AND _CntrlPurMaterialVH.MaterialGroup = MaterialGroup AND _CntrlPurMaterialVH.MaterialName = PurchasingDocumentItemText AND _CntrlPurMaterialVH.MaterialBaseUnit = OrderQuantityUnit  -- association [0..*]
;