C_SuplrQtnItemHierarchyTP

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_SuplrQtnItemHierarchyTP.
-- 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: CQTNITMHIER

CREATE VIEW C_SuplrQtnItemHierarchyTP AS
SELECT
  I_SuplrQuotationItemEnhWD.SupplierQuotation AS SupplierQuotation,
  I_SuplrQuotationItemEnhWD.SupplierQuotationItem AS SupplierQuotationItem,
  I_SuplrQuotationItemEnhWD.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SuplrQuotationItemEnhWD.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  cast ( '' as vdm_inforecordcategory ) AS PurchasingInfoRecordCategory,
  _SupplierQuotation.CreationDate AS CreationDate,
  _SupplierQuotation.Supplier AS Supplier,
  _SupplierQuotation._Supplier.SupplierName AS SupplierName,
  I_SuplrQuotationItemEnhWD.Material AS Material,
  I_SuplrQuotationItemEnhWD.ProductType AS PurgDocProductType,
  I_SuplrQuotationItemEnhWD.ManufacturerMaterial AS ManufacturerMaterial,
  I_SuplrQuotationItemEnhWD.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_SuplrQuotationItemEnhWD.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_SuplrQuotationItemEnhWD.Manufacturer AS Manufacturer,
  I_SuplrQuotationItemEnhWD.MaterialGroup AS MaterialGroup,
  I_SuplrQuotationItemEnhWD.Plant AS Plant,
  I_SuplrQuotationItemEnhWD.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_SuplrQuotationItemEnhWD.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  I_SuplrQuotationItemEnhWD.AddressID AS AddressID,
  I_SuplrQuotationItemEnhWD.ItemDeliveryAddressID AS ItemDeliveryAddressID,
  I_SuplrQuotationItemEnhWD.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_SuplrQuotationItemEnhWD.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  cast( _RFQScheduleLine.ScheduleLineOrderQuantity as vdm_requested_quantity preserving type ) AS RequestedQuantity,
  I_SuplrQuotationItemEnhWD.AwardedQuantity AS AwardedQuantity,
  I_SuplrQuotationItemEnhWD.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_SuplrQuotationItemEnhWD.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_SuplrQuotationItemEnhWD.OrderPriceUnit AS OrderPriceUnit,
  I_SuplrQuotationItemEnhWD.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_SuplrQuotationItemEnhWD.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  I_SuplrQuotationItemEnhWD.OrderQuantityUnit AS OrderQuantityUnit,
  I_SuplrQuotationItemEnhWD.NetAmount AS NetAmount,
  I_SuplrQuotationItemEnhWD.GrossAmount AS GrossAmount,
  I_SuplrQuotationItemEnhWD.EffectiveAmount AS EffectiveAmount,
  I_SuplrQuotationItemEnhWD.NetPriceAmount AS NetPriceAmount,
  I_SuplrQuotationItemEnhWD.NetPriceQuantity AS NetPriceQuantity,
  I_SuplrQuotationItemEnhWD.DocumentCurrency AS DocumentCurrency,
  I_SuplrQuotationItemEnhWD.PurchaseRequisition AS PurchaseRequisition,
  I_SuplrQuotationItemEnhWD.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast( '' as mm_pur_requisition_frmtdpritem) AS FormattedPurRequisitionItem,
  I_SuplrQuotationItemEnhWD.RequestForQuotation AS RequestForQuotation,
  cast( '' as mm_pur_rfq_frmtdpritem) AS FormattedRFQItem,
  I_SuplrQuotationItemEnhWD.RequestForQuotationItem AS RequestForQuotationItem,
  I_SuplrQuotationItemEnhWD.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  I_SuplrQuotationItemEnhWD.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_SuplrQuotationItemEnhWD.PurchasingParentItem AS PurchasingParentItem,
  I_SuplrQuotationItemEnhWD.PurgConfigurableItemNumber AS PurgConfigurableItemNumber,
  I_SuplrQuotationItemEnhWD.IsStatisticalItem AS IsStatisticalItem,
  I_SuplrQuotationItemEnhWD.PurgExternalSortNumber AS PurgExternalSortNumber,
  I_SuplrQuotationItemEnhWD.HierarchyNode AS HierarchyNode,
  I_SuplrQuotationItemEnhWD.HierarchyParentNode AS HierarchyParentNode,
  I_SuplrQuotationItemEnhWD.HierarchyLevel AS HierarchyLevel,
  I_SuplrQuotationItemEnhWD.HierarchyNodeSubTreeSize AS HierarchyNodeSubTreeSize,
  I_SuplrQuotationItemEnhWD.HierarchyDrillState AS HierarchyDrillState,
  I_SuplrQuotationItemEnhWD.HierarchyNodeOrdinalNumber AS HierarchyNodeOrdinalNumber,
  I_SuplrQuotationItemEnhWD.IsOutline AS IsOutline,
  I_SuplrQuotationItemEnhWD._DocumentCurrency AS _DocumentCurrency,
  I_SuplrQuotationItemEnhWD._Material AS _Material,
  I_SuplrQuotationItemEnhWD._MaterialGroup AS _MaterialGroup,
  I_SuplrQuotationItemEnhWD._ManufacturerMaterial AS _ManufacturerMaterial,
  I_SuplrQuotationItemEnhWD._Plant AS _Plant,
  I_SuplrQuotationItemEnhWD._PurgDocumentCategory AS _PurgDocumentCategory,
  I_SuplrQuotationItemEnhWD._ProductType AS _ProductType
FROM I_SuplrQuotationItemEnhWD
LEFT OUTER JOIN C_SuplrQuotationEnhWD AS _SuplrQuotation ON _SuplrQuotation.SupplierQuotation = SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN P_RFQScheduleLine AS _RFQScheduleLine ON _RFQScheduleLine.RequestForQuotation = RequestForQuotation AND _RFQScheduleLine.RequestForQuotationItem = RequestForQuotationItem  -- association [0..1]
LEFT OUTER JOIN I_SupplierQuotation AS _SupplierQuotation ON _SupplierQuotation.SupplierQuotation = SupplierQuotation  -- association [1..1]
LEFT OUTER JOIN C_MM_ProductTypeValueHelp AS _ProductTypeValueHelp ON _ProductTypeValueHelp.ProductType = PurgDocProductType  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = Material AND _MaterialValueHelp.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- 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 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]
;