P_AR_CustomerReceivableTotal

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 P_AR_CustomerReceivableTotal.
-- 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: PACUSTRECTOT

CREATE VIEW P_AR_CustomerReceivableTotal AS
SELECT
  I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  case when Customer.FiscalAddress <> '' then Customer.FiscalAddress else Customer.Customer end as Customer AS CustomerendasCustomer,
  I_OperationalAcctgDocItem.FinancialAccountType AS FinancialAccountType,
  cast( max(I_OperationalAcctgDocItem.NetDueDate) as farp_netdt preserving type ) AS NetDueDate,
  cast( max(I_OperationalAcctgDocItem.ClearingDate) as fis_augdt preserving type ) AS ClearingDate,
  cast( max(I_OperationalAcctgDocItem.ClearingJournalEntry) as fis_augbl preserving type ) AS ClearingAccountingDocument,
  I_OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( sum(I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency) as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  I_OperationalAcctgDocItem.TransactionCurrency AS TransactionCurrency,
  cast( sum(I_OperationalAcctgDocItem.AmountInTransactionCurrency) as fis_wsl preserving type ) AS AmountInTransactionCurrency,
  I_OperationalAcctgDocItem._CompanyCode AS _CompanyCode,
  I_OperationalAcctgDocItem._JournalEntry AS _JournalEntry,
  I_OperationalAcctgDocItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_OperationalAcctgDocItem._TransactionCurrency AS _TransactionCurrency,
  I_OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode
FROM I_OperationalAcctgDocItem
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
;