I_RequestForQuotation

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 I_RequestForQuotation.
-- 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: IMMRFQ

CREATE VIEW I_RequestForQuotation AS
SELECT
  cast (I_PurchasingDocument.PurchasingDocument as vdm_requestforquotation preserving type) AS RequestForQuotation,
  I_PurchasingDocument.CompanyCode AS CompanyCode,
  I_PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  cast(I_PurchasingDocument.PurchasingDocumentType as vdm_rfq_doc_type preserving type ) AS PurchasingDocumentType,
  I_PurchasingDocument.CreatedByUser AS CreatedByUser,
  I_PurchasingDocument.CreationDate AS CreationDate,
  I_PurchasingDocument.LastChangeDateTime AS LastChangeDateTime,
  I_PurchasingDocument.Language AS Language,
  cast(I_PurchasingDocument.PurchasingOrganization as ekorg_ll preserving type ) AS PurchasingOrganization,
  I_PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  I_PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  I_PurchasingDocument.IncotermsClassification AS IncotermsClassification,
  I_PurchasingDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_PurchasingDocument.IncotermsVersion AS IncotermsVersion,
  I_PurchasingDocument.IncotermsLocation1 AS IncotermsLocation1,
  I_PurchasingDocument.IncotermsLocation2 AS IncotermsLocation2,
  I_PurchasingDocument.PaymentTerms AS PaymentTerms,
  I_PurchasingDocument.CashDiscount1Days AS CashDiscount1Days,
  I_PurchasingDocument.CashDiscount2Days AS CashDiscount2Days,
  cast (I_PurchasingDocument.CashDiscount1Percent as vdm_discount_percent_1 preserving type) AS CashDiscount1Percent,
  cast (I_PurchasingDocument.CashDiscount2Percent as vdm_discount_percent_2 preserving type) AS CashDiscount2Percent,
  I_PurchasingDocument.NetPaymentDays AS NetPaymentDays,
  I_PurchasingDocument.ValidityStartDate AS ValidityStartDate,
  I_PurchasingDocument.ValidityEndDate AS ValidityEndDate,
  cast( I_PurchasingDocument.PurchasingDocumentOrderDate as vdm_rfq_publishing_date preserving type) AS RFQPublishingDate,
  I_PurchasingDocument.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_PurchasingDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  I_PurchasingDocument.TargetAmount AS TargetAmount,
  cast ( I_PurchasingDocument.PurchasingProcessingStatus as vdm_rfq_lfst_cd preserving type) AS RFQLifecycleStatus,
  cast ( I_PurchasingDocument.PurchasingDocumentName as vdm_rfq_name preserving type) AS RequestForQuotationName,
  I_PurchasingDocument.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  cast (I_PurchasingDocument.LatestRegistrationDate as vdm_apply_by preserving type) AS LatestRegistrationDate,
  I_PurchasingDocument.CorrespncInternalReference AS CorrespncInternalReference,
  I_PurchasingDocument.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  I_PurchasingDocument.FollowOnDocumentType AS FollowOnDocumentType,
  I_PurchasingDocument.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  I_PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_PurchasingDocument._PurchasingDocumentType AS _PurchasingDocumentType,
  I_PurchasingDocument._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_PurchasingDocument._PaymentTerms AS _PaymentTerms,
  I_PurchasingDocument._CreatedByUser AS _CreatedByUser,
  I_PurchasingDocument._DocumentCurrency AS _DocumentCurrency,
  I_PurchasingDocument._CompanyCode AS _CompanyCode,
  I_PurchasingDocument._PurchasingGroup AS _PurchasingGroup,
  I_PurchasingDocument._Language AS _Language
FROM I_PurchasingDocument
LEFT OUTER JOIN I_RequestForQuotationItem AS _RequestForQuotationItem ON RequestForQuotation = _RequestForQuotationItem.RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_RFQBidder AS _RFQBidder ON RequestForQuotation = _RFQBidder.RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_PurchasingDocumentType AS _FollowOnDocumentType ON PurchasingDocumentCategory = _FollowOnDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _FollowOnDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_RequestForQuotationType AS _RFQType ON PurchasingDocumentType = _RFQType.RFQType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _FollowOnDocumentCategory ON PurchasingDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SupplierQuotation AS _SupplierQuotation ON RequestForQuotation = _SupplierQuotation.RequestForQuotation  -- association [0..*]
LEFT OUTER JOIN I_RFQLifecycleStatus AS _RFQLifecycleStatus ON RFQLifecycleStatus = _RFQLifecycleStatus.RFQLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _RequestQtnExtension ON RequestForQuotation = _RequestQtnExtension.PurchasingDocument  -- association [0..1]
;