C_PT_SAFTPaymentDocValueC

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_PT_SAFTPaymentDocValueC.
-- 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.

CREATE VIEW C_PT_SAFTPaymentDocValueC AS
SELECT
  Doc.CompanyCode AS CompanyCode,
  Doc.AccountingDocument AS ClearingAccountingDocument,
  Doc.FiscalYear AS FiscalYear,
  '999999990' AS BusinessPartnerCustomer,
  Doc.FiscalPeriod AS FiscalPeriod,
  Doc.DocumentDate AS DocumentDate,
  Doc.PostingDate AS PostingDate,
  Doc.CompanyCodeCurrency AS CompanyCodeCurrency,
  Doc.AccountingDocumentCategory AS AccountingDocumentCategory,
  Doc.AccountingDocumentType AS AccountingDocumentType,
  cast( '' as sipt_kunnr_with_version ) AS PortugueseCustomerWithVersion,
  Doc.Supplier AS Supplier,
  abs(PayTotal.TotalCreditAmount - PayTotal.TotalDebitAmount + PayTotal.SettlementAmount) AS NetAmount,
  abs(PayTotal.TotalCreditAmount - PayTotal.TotalDebitAmount + PayTotal.SettlementAmount) AS GrossAmount,
  abs(PayTotal.SettlementAmount) AS SettlementAmount,
  case when PayTotal.TransactionCurrency <> Doc.CompanyCodeCurrency and PayTotal.TransactionCurrency is not initial then PayTotal.ExchangeRate end as ExchangeRate AS ExchangeRateendasExchangeRate,
  Doc.ReferenceDocumentType AS ReferenceDocumentType,
  Doc.OriginalReferenceDocument AS OriginalReferenceDocument,
  Doc._CompanyCodeCurrency AS _CompanyCodeCurrency,
  Doc._AccountingDocumentCategory AS _AccountingDocumentCategory,
  Doc._CompanyCode AS _CompanyCode,
  Doc._AccountingDocumentType AS _AccountingDocumentType,
  Doc._FiscalYear AS _FiscalYear
INNER JOIN I_PT_SAFTPaymentTotal AS PayTotal ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClrgInfoRelationForAcctgDoc AS Clear ON /* join condition not captured in parsed metadata */
INNER JOIN I_AccountingDocumentType AS AcctDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_DgtlSgntrNmbrRngeAcctg AS NrRange ON /* join condition not captured in parsed metadata */
INNER JOIN P_PT_BusinessPartner_Delivery AS CustInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SAFTAccountingTaxCheck AS _TotalItems ON _TotalItems.AccountingDocument = Doc.AccountingDocument AND _TotalItems.CompanyCode = Doc.CompanyCode AND _TotalItems.FiscalYear = Doc.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_SAFTCustTaxRegnNmbr AS _CustLand ON Doc.Customer = _CustLand.CustomerNum AND Doc.DelivOfGoodsDestCountry = _CustLand.Country  -- association [0..1]
LEFT OUTER JOIN P_PT_SAFTTAXLAND AS _CustLandExists ON Doc.Customer = _CustLandExists.Customer  -- association [0..1]
;