P_MX_GLAccountBalance3

DDL: P_MX_GLACCOUNTBALANCE3 Type: view COMPOSITE
32 Fields 4 Data Sources

P_MX_GLAccountBalance3 is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (P_MX_GLAccountBalance2, P_MX_GLAccountBalance2, I_StRpGLAccountLog, I_StRpGLAccountLog) and exposes 32 fields with key fields Ledger, CompanyCode, ChartOfAccounts, GLAccount, StatryRptgEntity.

Data Sources (4)

SourceAliasJoin Type
P_MX_GLAccountBalance2 P_MX_GLAccountBalance2 from
P_MX_GLAccountBalance2 P_MX_GLAccountBalance2 union_all
I_StRpGLAccountLog ReportedGLAcctLog inner
I_StRpGLAccountLog ReportedGLAcctLog inner

Parameters (6)

NameTypeDefault
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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMXGLACCTBAL3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Ledger TrialBalanceItem Ledger Ledger
KEY CompanyCode TrialBalanceItem CompanyCode Receiver Company Code
KEY ChartOfAccounts TrialBalanceItem ChartOfAccounts Node Class
KEY GLAccount TrialBalanceItem GLAccount General Ledger
KEY StatryRptgEntity I_StRpGLAccountLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpGLAccountLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpGLAccountLog StatryRptRunID Report Run ID
FiscalPeriod TrialBalanceItem FiscalPeriod Tax period
ReportingCurrency TrialBalanceItem ReportingCurrency Currency
StartingBalanceAmtInRptgCrcy TrialBalanceItem StartingBalanceAmtInRptgCrcy
DebitAmountInReportingCurrency TrialBalanceItem DebitAmountInReportingCurrency
CreditAmountInReportingCrcy TrialBalanceItem CreditAmountInReportingCrcy
EndingBalanceAmtInRptgCrcy TrialBalanceItem EndingBalanceAmtInRptgCrcy
P_FromPostingDate
P_ToPostingDate
P_FromFiscalPeriod
P_ToFiscalPeriod
P_AlternativeGLAccount
Ledger Ledger
KEY CompanyCode TrialBalanceItem CompanyCode Receiver Company Code
KEY ChartOfAccounts TrialBalanceItem ChartOfAccounts Node Class
KEY GLAccount TrialBalanceItem GLAccount General Ledger
KEY StatryRptgEntity I_StRpGLAccountLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpGLAccountLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpGLAccountLog StatryRptRunID Report Run ID
FiscalPeriod TrialBalanceItem FiscalPeriod Tax period
ReportingCurrency TrialBalanceItem ReportingCurrency Currency
StartingBalanceAmtInRptgCrcy TrialBalanceItem StartingBalanceAmtInRptgCrcy
DebitAmountInReportingCurrency TrialBalanceItem DebitAmountInReportingCurrency
CreditAmountInReportingCrcy TrialBalanceItem CreditAmountInReportingCrcy
EndingBalanceAmtInRptgCrcy TrialBalanceItem EndingBalanceAmtInRptgCrcy
AlternativeGLAccountIsUsed TrialBalanceItem AlternativeGLAccountIsUsed

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

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,
  TrialBalanceItem.AlternativeGLAccountIsUsed AS AlternativeGLAccountIsUsed
FROM P_MX_GLAccountBalance2
INNER JOIN I_StRpGLAccountLog AS ReportedGLAcctLog ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MX_GLAccountBalance2
;

Learn More