I_CentralSupplierQuotationTP

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_CentralSupplierQuotationTP.
-- 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: ICNTRLQTNTP

CREATE VIEW I_CentralSupplierQuotationTP AS
SELECT
  Document.CentralSupplierQuotation AS CentralSupplierQuotation,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentType AS PurchasingDocumentType,
  Document.Supplier AS Supplier,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDate AS CreationDate,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.Language AS Language,
  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.PricingProcedure AS PricingProcedure,
  Document.CentralSuplrQuotationCondition AS CentralSuplrQuotationCondition,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  Document.ExchangeRate AS ExchangeRate,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.CentralRequestForQuotation AS CentralRequestForQuotation,
  Document.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  Document.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  Document.QtnLifecycleStatus AS QtnLifecycleStatus,
  Document.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  Document.PurgDocFollowOnDocumentType AS FollowOnDocumentType,
  Document.PurContrValidityStartDate AS PurContrValidityStartDate,
  Document.PurContrValidityEndDate AS PurContrValidityEndDate,
  Document.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _CentralSuplrQtanCalcFieldsTP.TotalNetAmount AS TotalNetAmount
FROM R_CentralSupplierQuotation AS Document
LEFT OUTER JOIN I_CntrlSupplierQuotationItemTP AS _CntrlSupplierQuotationItemTP ON _CntrlSupplierQuotationItemTP.CentralSupplierQuotation = CentralSupplierQuotation  -- association [1..*]
LEFT OUTER JOIN R_CentralRequestForQuotation AS _CentralRequestForQuotation ON _CentralRequestForQuotation.CentralRequestForQuotation = CentralRequestForQuotation  -- association [0..1]
LEFT OUTER JOIN P_CentralSuplrQtanCalcFieldsTP AS _CentralSuplrQtanCalcFieldsTP ON _CentralSuplrQtanCalcFieldsTP.CentralSupplierQuotation = CentralSupplierQuotation  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _CentralSupplierQuotationExtn ON CentralSupplierQuotation = _CentralSupplierQuotationExtn.PurchasingDocument  -- association [1..1]
;