I_CentralRequestForQuotationTP

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_CentralRequestForQuotationTP.
-- 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: ICNTRLRFQHDRTP

CREATE VIEW I_CentralRequestForQuotationTP AS
SELECT
  Document.CentralRequestForQuotation AS CentralRequestForQuotation,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentType AS PurchasingDocumentType,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDate AS CreationDate,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.Language AS Language,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.PaymentTerms AS PaymentTerms,
  Document.CashDiscount1Days AS CashDiscount1Days,
  Document.CashDiscount2Days AS CashDiscount2Days,
  Document.CashDiscount1Percent AS CashDiscount1Percent,
  Document.CashDiscount2Percent AS CashDiscount2Percent,
  Document.NetPaymentDays AS NetPaymentDays,
  Document.RFQPublishingDate AS RFQPublishingDate,
  Document.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  Document.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  Document.TargetAmount AS TargetAmount,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.RFQLifecycleStatus AS RFQLifecycleStatus,
  Document.RequestForQuotationName AS RequestForQuotationName,
  Document.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  Document.LatestRegistrationDate AS LatestRegistrationDate,
  Document.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  Document.PurgDocFollowOnDocumentType AS FollowOnDocumentType,
  Document.PurContrValidityStartDate AS PurContrValidityStartDate,
  Document.PurContrValidityEndDate AS PurContrValidityEndDate,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document._CompanyCode AS _CompanyCode,
  Document._DocumentCurrency AS _DocumentCurrency,
  Document._IncotermsClassification AS _IncotermsClassification,
  Document._IncotermsVersion AS _IncotermsVersion,
  Document._PaymentTerms AS _PaymentTerms,
  Document._PurchasingDocumentType AS _PurchasingDocumentType,
  Document._PurchasingGroup AS _PurchasingGroup,
  Document._PurchasingOrganization AS _PurchasingOrganization,
  Document._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  Document._Language AS _Language,
  Document._CreatedByUser AS _CreatedByUser,
  Document._RFQLifecycleStatus AS _RFQLifecycleStatus,
  Document._FollowOnDocumentType AS _FollowOnDocumentType,
  Document._FollowOnDocumentCategory AS _FollowOnDocumentCategory,
  Document._RFQType AS _RFQType
FROM R_CentralRequestForQuotation AS Document
LEFT OUTER JOIN I_CentralReqForQuotationItemTP AS _CentralReqForQuotationItemTP ON _CentralReqForQuotationItemTP.CentralRequestForQuotation = CentralRequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_CntrlReqForQuotationBidderTP AS _CntrlReqForQuotationBidderTP ON _CntrlReqForQuotationBidderTP.CentralRequestForQuotation = CentralRequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_CentralSupplierQuotationTP AS _CentralSupplierQuotationTP ON _CentralSupplierQuotationTP.CentralRequestForQuotation = CentralRequestForQuotation  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocument AS _CentralReqForQuotationExtn ON _CentralReqForQuotationExtn.PurchasingDocument = CentralRequestForQuotation  -- association [0..1]
;