R_CentralReqForQuotationItem

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_CentralReqForQuotationItem.
-- 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: RCNTRLRFQITEM

CREATE VIEW R_CentralReqForQuotationItem AS
SELECT
  R_PurchasingDocumentItem.PurchasingDocument AS CentralRequestForQuotation,
  cast (R_PurchasingDocumentItem.PurchasingDocumentItem as vdm_centralreqforquotationitem preserving type) AS CentralRequestForQuotationItem,
  R_PurchasingDocumentItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  R_PurchasingDocumentItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  ProductType,
  R_PurchasingDocumentItem.ProductTypeCode AS ProductTypeCode,
  R_PurchasingDocumentItem.ManufacturerMaterial AS ManufacturerMaterial,
  R_PurchasingDocumentItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  R_PurchasingDocumentItem.Manufacturer AS Manufacturer,
  R_PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
  R_PurchasingDocumentItem.Plant AS Plant,
  R_PurchasingDocumentItem.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  R_PurchasingDocumentItem.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  _Plant.AddressID AS AddressID,
  R_PurchasingDocumentItem.IncotermsClassification AS IncotermsClassification,
  R_PurchasingDocumentItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  R_PurchasingDocumentItem.IncotermsLocation1 AS IncotermsLocation1,
  R_PurchasingDocumentItem.IncotermsLocation2 AS IncotermsLocation2,
  R_PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  R_PurchasingDocumentItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  R_PurchasingDocumentItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  R_PurchasingDocumentItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  R_PurchasingDocumentItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  R_PurchasingDocumentItem.BaseUnit AS BaseUnit,
  R_PurchasingDocumentItem.PurchaseRequisition AS PurchaseRequisition,
  R_PurchasingDocumentItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  R_PurchasingDocumentItem.RequirementTracking AS RequirementTracking,
  R_PurchasingDocumentItem.PurchasingCentralMaterial AS PurchasingCentralMaterial,
  R_PurchasingDocumentItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  R_PurchasingDocumentItem.NetPriceAmount AS NetPriceAmount,
  R_PurchasingDocumentItem._ProductType AS _ProductType,
  DocumentCurrency
FROM R_PurchasingDocumentItem
LEFT OUTER JOIN R_CentralRequestForQuotation AS _CentralRequestForQuotation ON CentralRequestForQuotation = _CentralRequestForQuotation.CentralRequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN R_CntrlSupplierQuotationItem AS _CntrlSupplierQuotationItem ON CentralRequestForQuotation = _CntrlSupplierQuotationItem.CentralRequestForQuotation AND CentralRequestForQuotationItem = _CntrlSupplierQuotationItem.CentralRequestForQuotationItem  -- association [0..*]
LEFT OUTER JOIN R_CntrlReqForQtanScheduleLine AS _CntrlReqForQtanScheduleLine ON CentralRequestForQuotation = _CntrlReqForQtanScheduleLine.CentralRequestForQuotation AND CentralRequestForQuotationItem = _CntrlReqForQtanScheduleLine.CentralRequestForQuotationItem AND _CntrlReqForQtanScheduleLine.ScheduleLine = '0001'  -- association [0..1]
LEFT OUTER JOIN R_CentralRFQItemDistribution AS _CentralRFQItemDistribution ON CentralRequestForQuotation = _CentralRFQItemDistribution.CentralRequestForQuotation AND CentralRequestForQuotationItem = _CentralRFQItemDistribution.CentralRequestForQuotationItem  -- association [0..*]
;