C_CntrlSupplierQuotationItemTP

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_CntrlSupplierQuotationItemTP.
-- 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: CCNTRLQTNITMTP

CREATE VIEW C_CntrlSupplierQuotationItemTP AS
SELECT
  _CntrlSupplierQuotationItemTP.CentralSupplierQuotation AS CentralSupplierQuotation,
  _CntrlSupplierQuotationItemTP.CentralSupplierQuotationItem AS CentralSupplierQuotationItem,
  _CntrlSupplierQuotationItemTP.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _CntrlSupplierQuotationItemTP.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _CentralSupplierQuotation.CreationDate AS CreationDate,
  _CentralSupplierQuotation.Supplier AS Supplier,
  _CentralSupplierQuotation._Supplier.SupplierName AS SupplierName,
  _CntrlSupplierQuotationItemTP.PurchasingCentralMaterial AS PurchasingCentralMaterial,
  _CntrlSupplierQuotationItemTP.Material AS Material,
  _CntrlSupplierQuotationItemTP.ProductType AS ProductType,
  _CntrlSupplierQuotationItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  _CntrlSupplierQuotationItemTP.SupplierMaterialNumber AS SupplierMaterialNumber,
  _CntrlSupplierQuotationItemTP.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _CntrlSupplierQuotationItemTP.Manufacturer AS Manufacturer,
  _CntrlSupplierQuotationItemTP.MaterialGroup AS MaterialGroup,
  _CntrlSupplierQuotationItemTP.Plant AS Plant,
  _CntrlSupplierQuotationItemTP._Plant.PlantName AS PlantName,
  _CntrlSupplierQuotationItemTP.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  _CntrlSupplierQuotationItemTP.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  _CntrlSupplierQuotationItemTP.AddressID AS AddressID,
  _CntrlSupplierQuotationItemTP.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  _CntrlSupplierQuotationItemTP.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _CntrlSupplierQuotationItemTP.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  _CntrlReqForQuotationItemInfo.ScheduleLineOrderQuantity AS RequestedQuantity,
  _CntrlSupplierQuotationItemTP.AwardedQuantity AS AwardedQuantity,
  _CntrlSupplierQuotationItemTP.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _CntrlSupplierQuotationItemTP.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _CntrlSupplierQuotationItemTP.OrderPriceUnit AS OrderPriceUnit,
  _CntrlSupplierQuotationItemTP.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  _CntrlSupplierQuotationItemTP.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  _CntrlSupplierQuotationItemTP.OrderQuantityUnit AS OrderQuantityUnit,
  _CntrlSupplierQuotationItemTP.NetAmount AS NetAmount,
  _CntrlSupplierQuotationItemTP.GrossAmount AS GrossAmount,
  _CntrlSupplierQuotationItemTP.EffectiveAmount AS EffectiveAmount,
  _CntrlSupplierQuotationItemTP.NetPriceAmount AS NetPriceAmount,
  _CntrlSupplierQuotationItemTP.NetPriceQuantity AS NetPriceQuantity,
  _CntrlSupplierQuotationItemTP.DocumentCurrency AS DocumentCurrency,
  _CntrlSupplierQuotationItemTP.PurchaseRequisition AS PurchaseRequisition,
  _CntrlSupplierQuotationItemTP.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _CntrlSupplierQuotationItemTP.CentralRequestForQuotation AS CentralRequestForQuotation,
  cast( '' as mm_pur_rfq_frmtdpritem) AS FormattedRFQItem,
  _CntrlSupplierQuotationItemTP.CentralRequestForQuotationItem AS CentralRequestForQuotationItem,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  _CntrlSupplierQuotationItemTP.PurchasingInfoRecord AS PurchasingInfoRecord,
  _CntrlSupplierQuotationItemTP._DocumentCurrency AS _DocumentCurrency,
  _CntrlSupplierQuotationItemTP._Material AS _Material,
  _CntrlSupplierQuotationItemTP._MaterialGroup AS _MaterialGroup,
  _CntrlSupplierQuotationItemTP._ManufacturerMaterial AS _ManufacturerMaterial,
  _CntrlSupplierQuotationItemTP._Plant AS _Plant,
  _CntrlSupplierQuotationItemTP._PurgDocumentCategory AS _PurgDocumentCategory
FROM I_CntrlSupplierQuotationItemTP AS _CntrlSupplierQuotationItemTP
LEFT OUTER JOIN C_CentralSupplierQuotationTP AS _CentralSupplierQuotationTP ON _CentralSupplierQuotationTP.CentralSupplierQuotation = CentralSupplierQuotation  -- association [1..1]
LEFT OUTER JOIN C_CntrlSupplierQtanItemDistrTP AS _CntrlSupplierQtanItemDistrTP ON _CntrlSupplierQtanItemDistrTP.CentralSupplierQuotation = CentralSupplierQuotation AND _CntrlSupplierQtanItemDistrTP.CentralSupplierQuotationItem = CentralSupplierQuotationItem  -- association [0..*]
LEFT OUTER JOIN C_CntrlSuplrQtanItemPricingTP AS _CntrlSuplrQtanItemPricingTP ON _CntrlSuplrQtanItemPricingTP.CentralSupplierQuotation = CentralSupplierQuotation AND _CntrlSuplrQtanItemPricingTP.CentralSupplierQuotationItem = CentralSupplierQuotationItem  -- association [1..*]
LEFT OUTER JOIN C_CntrlReqForQuotationItemInfo AS _CntrlReqForQuotationItemInfo ON _CntrlReqForQuotationItemInfo.CentralRequestForQuotation = CentralRequestForQuotation AND _CntrlReqForQuotationItemInfo.CentralRequestForQuotationItem = CentralRequestForQuotationItem  -- association [0..1]
LEFT OUTER JOIN R_CentralSupplierQuotation AS _CentralSupplierQuotation ON _CentralSupplierQuotation.CentralSupplierQuotation = CentralSupplierQuotation  -- association [1..1]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = ProductType  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _ManufacturerMaterialText ON ManufacturerMaterial = _ManufacturerMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN C_MM_PlantValueHelp AS _PlantValueHelp ON _PlantValueHelp.Plant = Plant  -- association [0..*]
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..*]
;