P_MngJrnlEntrPrkdDocAmount

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_MngJrnlEntrPrkdDocAmount.
-- 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 P_MngJrnlEntrPrkdDocAmount AS
SELECT
  SourceCompanyCode,
  SourceAccountingDocument,
  SourceFiscalYear,
  cast( '' as fis_hwaer ) AS CompanyCodeCurrency,
  TransactionCurrency,
  sum( cast( 0 as fis_cr_hsl ) ) AS CreditAmountInCoCodeCrcy,
  sum( cast( 0 as fis_dr_hsl ) ) AS DebitAmountInCoCodeCrcy,
  sum(CreditAmountInTransCrcy) AS CreditAmountInTransCrcy,
  sum(DebitAmountInTransCrcy) as DebitAmountInTransCrcy AS SourceFiscalYearkeySourceCompanyCode,
  sum(DebitAmountInTransCrcy) AS DebitAmountInTransCrcy
FROM R_MngJrnlEntrPrkdDocumentItem
LEFT OUTER JOIN P_MngJrnlEntrPrkdDocAmount1 AS _differentCurrency ON _differentCurrency.CompanyCode = R_MngJrnlEntrPrkdDocumentItem.SourceCompanyCode AND _differentCurrency.AccountingDocument = R_MngJrnlEntrPrkdDocumentItem.SourceAccountingDocument AND _differentCurrency.FiscalYear = R_MngJrnlEntrPrkdDocumentItem.SourceFiscalYear  -- association [0..1]
-- UNION with additional select branch(es): R_MngJrnlEntrPrkdDocumentItem
;