I_PT_SAFTPaymentCube

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_PT_SAFTPaymentCube.
-- 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.
-- Parameters: P_CompanyCode : bukrs, P_StartDate : begda, P_EndDate : endda

CREATE VIEW I_PT_SAFTPaymentCube AS
SELECT
  CompanyCode,
  PaymentReference,
  cast( FiscalYear as fis_gjahr_no_conv ) AS FiscalYear,
  DocumentItemNumber,
  PT_SeriesDocumentType,
  DocumentBillingStatus,
  PT_SeriesDocumentNumber,
  CompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  CustomerPaymentMethodName,
  PaymentAmount,
  PaymentDate,
  NetAmount,
  GrossAmount,
  BusinessPartnerCustomer,
  ExchangeRate,
  TransactionCurrency,
  TotalGrossAmountInTransCrcy,
  PT_SAFTInvoiceReference,
  InvoiceDate,
  IN_InvoiceDate
FROM I_PT_SAFTPaymentStructure AS a
;