C_MngJournalEntryTotalAmount

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_MngJournalEntryTotalAmount.
-- 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_MngJournalEntryTotalAmount AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  cast('' as fis_hwae2) AS AdditionalCurrency1,
  cast('' as fis_hwae3) AS AdditionalCurrency2,
  sum(CreditAmountInTransCrcy) AS CreditAmountInTransCrcy,
  sum(CreditAmountInCoCodeCrcy) AS CreditAmountInCoCodeCrcy,
  sum(CreditAmountInGlobalCrcy) AS CreditAmountInGlobalCrcy,
  sum(CreditAmountInFunctionalCrcy) AS CreditAmountInFunctionalCrcy,
  sum(CreditAmountInFreeDfndCrcy1) AS CreditAmountInFreeDfndCrcy1,
  sum(CreditAmountInFreeDfndCrcy2) AS CreditAmountInFreeDfndCrcy2,
  sum(CreditAmountInFreeDfndCrcy3) AS CreditAmountInFreeDfndCrcy3,
  sum(CreditAmountInFreeDfndCrcy4) AS CreditAmountInFreeDfndCrcy4,
  sum(CreditAmountInFreeDfndCrcy5) AS CreditAmountInFreeDfndCrcy5,
  sum(CreditAmountInFreeDfndCrcy6) AS CreditAmountInFreeDfndCrcy6,
  sum(CreditAmountInFreeDfndCrcy7) AS CreditAmountInFreeDfndCrcy7,
  sum(CreditAmountInFreeDfndCrcy8) AS CreditAmountInFreeDfndCrcy8,
  cast(abap.curr'0.00' as fis_dmbe2) AS CreditAmountInAddlCrcy1,
  cast(abap.curr'0.00' as fis_dmbe3) AS CreditAmountInAddlCrcy2,
  sum(DebitAmountInTransCrcy) AS DebitAmountInTransCrcy,
  sum(DebitAmountInCoCodeCrcy) AS DebitAmountInCoCodeCrcy,
  sum(DebitAmountInGlobalCrcy) AS DebitAmountInGlobalCrcy,
  sum(DebitAmountInFunctionalCrcy) AS DebitAmountInFunctionalCrcy,
  sum(DebitAmountInFreeDfndCrcy1) AS DebitAmountInFreeDfndCrcy1,
  sum(DebitAmountInFreeDfndCrcy2) AS DebitAmountInFreeDfndCrcy2,
  sum(DebitAmountInFreeDfndCrcy3) AS DebitAmountInFreeDfndCrcy3,
  sum(DebitAmountInFreeDfndCrcy4) AS DebitAmountInFreeDfndCrcy4,
  sum(DebitAmountInFreeDfndCrcy5) AS DebitAmountInFreeDfndCrcy5,
  sum(DebitAmountInFreeDfndCrcy6) AS DebitAmountInFreeDfndCrcy6,
  sum(DebitAmountInFreeDfndCrcy7) AS DebitAmountInFreeDfndCrcy7,
  sum(DebitAmountInFreeDfndCrcy8) AS DebitAmountInFreeDfndCrcy8,
  cast(abap.curr'0.00' as fis_dmbe2) AS DebitAmountInAddlCrcy1,
  cast(abap.curr'0.00' as fis_dmbe3) AS DebitAmountInAddlCrcy2,
  cast('BSEG' as tabname) AS DatabaseTable
FROM R_ManageJournalEntryLedgerView AS _Item
-- UNION ALL with additional select branch(es): R_ManageJournalEntryItem, R_MngJrnlEntrTechLedgerView, R_MngJrnlEntrPrkdDocumentItem
;