C_MX_GLAccountBalance

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_MX_GLAccountBalance.
-- 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_FinancialStatementVariant : versn_011, P_AlternativeGLAccount : figlmx_prim, P_MigrationItemIsMigrated : 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 C_MX_GLAccountBalance AS
SELECT
  TrialBalanceItem.Ledger AS Ledger,
  TrialBalanceItem.CompanyCode AS CompanyCode,
  TrialBalanceItem.ChartOfAccounts AS ChartOfAccounts,
  FSV.GLAccount AS GLAccount,
  TrialBalanceItem.StatryRptCategory AS StatryRptCategory,
  TrialBalanceItem.StatryRptgEntity AS StatryRptgEntity,
  TrialBalanceItem.StatryRptRunID AS StatryRptRunID,
  TrialBalanceItem.FiscalPeriod AS FiscalPeriod,
  FSV.GLAccountType AS GLAccountType,
  FSV.GLAccountInfo AS GLAccountInfo,
  TrialBalanceItem.ReportingCurrency AS ReportingCurrency,
  TrialBalanceItem.StartingBalanceAmtInRptgCrcy AS StartingBalanceAmtInRptgCrcy,
  TrialBalanceItem.DebitAmountInReportingCurrency AS DebitAmountInReportingCurrency,
  TrialBalanceItem.CreditAmountInReportingCrcy AS CreditAmountInReportingCrcy,
  TrialBalanceItem.EndingBalanceAmtInRptgCrcy AS EndingBalanceAmtInRptgCrcy
FROM P_MX_GLAccountBalance4
INNER JOIN P_MX_FinancialStmntStructure2 ON /* join condition not captured in parsed metadata */
;