P_MX_GLAccountBalance3

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_MX_GLAccountBalance3.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_AlternativeGLAccount : figlmx_prim, P_RestrictedMigrationSource : figlmx_migsource, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_CompanyCode : fis_bukrs, P_Ledger : fins_ledger

CREATE VIEW P_MX_GLAccountBalance3 AS
SELECT
  TrialBalanceItem.Ledger AS Ledger,
  TrialBalanceItem.CompanyCode AS CompanyCode,
  TrialBalanceItem.ChartOfAccounts AS ChartOfAccounts,
  TrialBalanceItem.GLAccount AS GLAccount,
  ReportedGLAcctLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedGLAcctLog.StatryRptCategory AS StatryRptCategory,
  ReportedGLAcctLog.StatryRptRunID AS StatryRptRunID,
  TrialBalanceItem.FiscalPeriod AS FiscalPeriod,
  TrialBalanceItem.ReportingCurrency AS ReportingCurrency,
  TrialBalanceItem.StartingBalanceAmtInRptgCrcy AS StartingBalanceAmtInRptgCrcy,
  TrialBalanceItem.DebitAmountInReportingCurrency AS DebitAmountInReportingCurrency,
  TrialBalanceItem.CreditAmountInReportingCrcy AS CreditAmountInReportingCrcy,
  TrialBalanceItem.EndingBalanceAmtInRptgCrcy AS EndingBalanceAmtInRptgCrcy,
  TrialBalanceItem.AlternativeGLAccountIsUsed AS P_FromPostingDate,
  P_ToPostingDate: $parameters.P_ToPostingDate AS P_ToPostingDate,
  P_FromFiscalPeriod: $parameters.P_FromFiscalPeriod AS P_FromFiscalPeriod,
  P_ToFiscalPeriod: $parameters.P_ToFiscalPeriod AS P_ToFiscalPeriod,
  P_AlternativeGLAccount: $parameters.P_AlternativeGLAccount AS P_AlternativeGLAccount,
  P_RestrictedMigrationSource: $parameters.P_RestrictedMigrationSource AS P_RestrictedMigrationSource,
  P_CompanyCode: $parameters.P_CompanyCode AS P_CompanyCode,
  TrialBalanceItem.AlternativeGLAccountIsUsed AS AlternativeGLAccountIsUsed
FROM I_StRpGLAccountLog AS ReportedGLAcctLog
INNER JOIN P_MX_GLAccountBalance2 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_StRpGLAccountLog
;