In this blog post I would cover on how to do an FI balance load from an alternate ledger. This could particularly be helpful for classic GL systems where FI totals table doesn’t have right break down by all the dimensions.

For classic GL systems FI totals table is GLT0. This table is used by Central Finance extraction routines to extract yearend and monthly balances. However, this table stores balances by GL Account and Company Code only. In almost all the cases the balance is also needed to be broken by other dimensions as well. From what I have seen minimum is by GL account and Profit Center.

There is a feature given by SAP where balances can be extracted from an alternate ledger. View V_CFIN_LDGER_DET should be updated in source system to make this work.

Given below is a screenshot of how the table is configured.

Balance Load from Alternate Ledger

Important things to note:

1. This configuration doesn’t load balances of reconciliation (AP, AR) accounts and OIM accounts from alternate ledger. Those are still loaded via usual mechanism.
2. Overall account balance at GL Account level must match to ledger 0 balances in GLT0. If that doesn’t happen then extraction routine issues a hard error.

Hope this post was helpful to you. Please feel free to leave your feedback and questions in comments section.