R_CentralRequestForQuotation

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_CentralRequestForQuotation.
-- 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: RCNTRLRFQHDR

CREATE VIEW R_CentralRequestForQuotation AS
SELECT
  cast (R_PurchasingDocument.PurchasingDocument as vdm_cntrlrequestforquotation preserving type) AS CentralRequestForQuotation,
  R_PurchasingDocument.CompanyCode AS CompanyCode,
  R_PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  cast(R_PurchasingDocument.PurchasingDocumentType as vdm_rfq_doc_type preserving type ) AS PurchasingDocumentType,
  R_PurchasingDocument.CreatedByUser AS CreatedByUser,
  R_PurchasingDocument.CreationDate AS CreationDate,
  R_PurchasingDocument.LastChangeDateTime AS LastChangeDateTime,
  R_PurchasingDocument.Language AS Language,
  cast(R_PurchasingDocument.PurchasingOrganization as ekorg_ll preserving type ) AS PurchasingOrganization,
  R_PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  R_PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  R_PurchasingDocument.IncotermsClassification AS IncotermsClassification,
  R_PurchasingDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  R_PurchasingDocument.IncotermsVersion AS IncotermsVersion,
  R_PurchasingDocument.IncotermsLocation1 AS IncotermsLocation1,
  R_PurchasingDocument.IncotermsLocation2 AS IncotermsLocation2,
  R_PurchasingDocument.PaymentTerms AS PaymentTerms,
  R_PurchasingDocument.CashDiscount1Days AS CashDiscount1Days,
  R_PurchasingDocument.CashDiscount2Days AS CashDiscount2Days,
  R_PurchasingDocument.CashDiscount1Percent AS CashDiscount1Percent,
  R_PurchasingDocument.CashDiscount2Percent AS CashDiscount2Percent,
  R_PurchasingDocument.NetPaymentDays AS NetPaymentDays,
  R_PurchasingDocument.ValidityStartDate AS ValidityStartDate,
  R_PurchasingDocument.ValidityEndDate AS ValidityEndDate,
  cast( R_PurchasingDocument.PurchasingDocumentOrderDate as vdm_rfq_publishing_date preserving type) AS RFQPublishingDate,
  R_PurchasingDocument.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  R_PurchasingDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  R_PurchasingDocument.TargetAmount AS TargetAmount,
  cast ( R_PurchasingDocument.PurchasingProcessingStatus as vdm_rfq_lfst_cd preserving type) AS RFQLifecycleStatus,
  cast ( R_PurchasingDocument.PurchasingDocumentName as vdm_rfq_name preserving type) AS RequestForQuotationName,
  R_PurchasingDocument.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  cast (R_PurchasingDocument.LatestRegistrationDate as vdm_apply_by preserving type) AS LatestRegistrationDate,
  R_PurchasingDocument.CorrespncInternalReference AS CorrespncInternalReference,
  R_PurchasingDocument.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  R_PurchasingDocument.FollowOnDocumentType AS FollowOnDocumentType,
  R_PurchasingDocument.FollowOnDocumentType AS PurgDocFollowOnDocumentType,
  R_PurchasingDocument.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  R_PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  R_PurchasingDocument._PurchasingDocumentType AS _PurchasingDocumentType,
  R_PurchasingDocument._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  R_PurchasingDocument._PaymentTerms AS _PaymentTerms,
  R_PurchasingDocument._CreatedByUser AS _CreatedByUser,
  R_PurchasingDocument._DocumentCurrency AS _DocumentCurrency,
  R_PurchasingDocument._CompanyCode AS _CompanyCode,
  R_PurchasingDocument._PurchasingGroup AS _PurchasingGroup,
  R_PurchasingDocument._Language AS _Language,
  R_PurchasingDocument.ValidityStartDate AS PurContrValidityStartDate,
  R_PurchasingDocument.ValidityEndDate AS PurContrValidityEndDate
FROM R_PurchasingDocument
LEFT OUTER JOIN R_CentralReqForQuotationItem AS _CentralReqForQuotationItem ON CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation  -- association [1..*]
LEFT OUTER JOIN R_CntrlReqForQuotationBidder AS _CntrlReqForQuotationBidder ON CentralRequestForQuotation = _CntrlReqForQuotationBidder.CentralRequestForQuotation  -- 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 FollowOnDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN R_CentralSupplierQuotation AS _CentralSupplierQuotation ON CentralRequestForQuotation = _CentralSupplierQuotation.CentralRequestForQuotation  -- association [0..*]
LEFT OUTER JOIN I_RFQLifecycleStatus AS _RFQLifecycleStatus ON RFQLifecycleStatus = _RFQLifecycleStatus.RFQLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _CentralReqForQuotationExtn ON _CentralReqForQuotationExtn.PurchasingDocument = CentralRequestForQuotation  -- association [0..1]
;