topic Re: Loading Initial balances in Application Development and Automation Discussions

Loading Initial balances

Former Member — Thu, 19 Oct 2006 14:16:36 GMT

Hi,

Is there a way to load the Initial balances in Finance. Please let me know.

Thanks.

Re: Loading Initial balances

Former Member — Thu, 19 Oct 2006 14:26:32 GMT

For which account?

- Customers: KNC1/KNC3

- Vendors: LFC1/LFC3

- G/L: GLT0

Max

Re: Loading Initial balances

Former Member — Thu, 19 Oct 2006 14:32:51 GMT

Are these the Tcodes to post legacy balances ?

Re: Loading Initial balances

Former Member — Thu, 19 Oct 2006 14:45:59 GMT

Not the tables where the balances are stored.

If you need to load an initial balance you should pot some documents for that account.

Max

Re: Loading Initial balances

Former Member — Thu, 19 Oct 2006 16:05:14 GMT

When we went live almost eleven years ago, we did the following:

Created a mapping table that mapped all of the legacy system financial account information to the new SAP accounts. For example, a legacy account might map to a single GL account/cost center/profit center.

I wrote a program in the legacy system that read all of the financial balances for the old accounts, read the mapping table to get the new SAP accounts and wrote a file (actually a number of files) that could be read by standard SAP program RFBIBL00.

We FTPd the files to the SAP application server and ran RFBIBL00 to pick up the files and create financial accounting documents using transaction FB01.

The net result was that the balances of the legacy system were transfered to SAP as a single line item per account.

Rob