C_RequirementTrackingPurRFQ

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_RequirementTrackingPurRFQ.
-- 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: CREQTRACKRFQ

CREATE VIEW C_RequirementTrackingPurRFQ AS
SELECT
  I_PurchasingDocumentItem.PurchasingDocument AS RequestForQuotation,
  cast (I_PurchasingDocumentItem.PurchasingDocumentItem as vdm_requestforquotationitem preserving type) AS RequestForQuotationItem,
  I_SupplierQuotationItemEnh.SupplierQuotation AS SupplierQuotation,
  I_SupplierQuotationItemEnh.SupplierQuotationItem AS SupplierQuotationItem,
  concat(concat(I_PurchasingDocumentItem.PurchasingDocument, '/'), I_PurchasingDocumentItem.PurchasingDocumentItem) AS FormattedRFQItem,
  _RFQEnhancedWeb.RequestForQuotationName AS RequestForQuotationName,
  _RFQEnhancedWeb.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  _SupplierQuotationDocument._CreatedByUser.UserDescription AS UserDescription,
  _RFQEnhancedWeb.CreationDate AS CreationDate,
  I_SupplierQuotationItemEnh.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _RFQEnhancedWeb.RFQPublishingDate AS RFQPublishingDate,
  I_PurchasingDocumentItem.PurchaseRequisition AS PurchaseRequisition,
  _SupplierQuotation.CreationDate AS SupplierCreationDate,
  _SupplierQuotationDocument.QuotationSubmissionDate AS QuotationSubmissionDate,
  I_PurchasingDocumentItem.Material AS Material,
  cast( _PurgDocScheduleLine.ScheduleLineOrderQuantity as vdm_requested_quantity preserving type ) AS ScheduleLineOrderQuantity,
  ScheduleLineOrderQuantity AS PlannedQuantity,
  I_PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  cast(I_SupplierQuotationItemEnh.NetAmount as vdm_supplier_submit_quot_value) AS NetAmount,
  I_SupplierQuotationItemEnh.DocumentCurrency AS DocumentCurrency,
  cast(cast(I_SupplierQuotationItemEnh.AwardedQuantity * I_SupplierQuotationItemEnh.NetPriceAmount as abap.curr( 18, 2 )) as vdm_supplier_award_quot_value) AS PriceQuotation,
  I_PurchasingDocumentItem.Plant AS Plant,
  _SupplierQuotationDocument.Supplier AS Supplier,
  _RFQEnhancedWeb._RFQLifecycleStatus._Text[1: Language = $session.system_language].RFQLifecycleStatusName AS RFQLifecycleStatusName,
  _RFQEnhancedWeb.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  AwardedQuantity,
  _RFQEnhancedWeb.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_PurchasingDocumentItem.RequirementTracking AS RequirementTracking,
  I_PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
  I_PurchasingDocumentItem.PurchasingDocumentItemText AS PurchasingText,
  _RFQEnhancedWeb.PurchasingOrganization AS PurchasingOrganization,
  _RFQEnhancedWeb.PurchasingGroup AS PurchasingGroup,
  _RFQEnhancedWeb.CompanyCode AS CompanyCode,
  I_PurchasingDocumentItem.StorageLocation AS StorageLocation,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  _RFQEnhancedWeb.PurchasingDocumentType AS PurchasingDocumentType,
  _RFQEnhancedWeb.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_PurchasingDocumentItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  cast( '' as knttp ) AS AccountAssignmentCategory,
  _PurchasingDocument.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate
FROM I_PurchasingDocumentItem
LEFT OUTER JOIN I_SupplierQuotationItemEnh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestForQuotationEnhanced AS _RFQEnhancedWeb ON RequestForQuotation = _RFQEnhancedWeb.RequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON RequestForQuotation = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ProcmtBlockedSupplierTxt AS _ProcmtBlockedSupplierTxt ON _ProcmtBlockedSupplierTxt.PurchasingIsBlockedForSupplier = 'X' AND _ProcmtBlockedSupplierTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _SupplierQuotationDocument ON SupplierQuotation = _SupplierQuotationDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _PurgDocScheduleLine ON _PurgDocScheduleLine.PurchasingDocument = RequestForQuotation AND _PurgDocScheduleLine.PurchasingDocumentItem = RequestForQuotationItem AND _PurgDocScheduleLine.ScheduleLine = '0001'  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = purchasingorganization  -- association [1..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = purchasinggroup  -- association [1..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = companycode  -- association [1..1]
LEFT OUTER JOIN I_RequestForQuotationType AS _RFQType ON purchasingdocumenttype = _RFQType.RFQType  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON purgdocexternalitemcategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SupplierQuotation AS _SupplierQuotation ON _SupplierQuotation.SupplierQuotation = SupplierQuotation  -- association [1..1]
;