cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Legacy data Migration Starategy/Process

Former Member
0 Kudos

Hi Friends

I would request you, if anybody let me knwo the process of legacy data migration into sap. What are steps I have to follow while doing legacy data migration. My questions are:

1) How to upload GL balances from legacy to SAP

2) How to upload Vendor and Customer open items into sap

3) Asset balances How to upload

4) what is the use of Migration clearing accounts.

Kindly provide if any documents for legacy data migration into sap.

Thanks in advance

Rao

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Thanks for the valuable information.

former_member187989
Active Contributor
0 Kudos
1) How to upload GL balances from legacy to SAP

Check this links

2) How to upload Vendor and Customer open items into sap

Check this links

3) Asset balances How to upload

Check this link

Kindly provide if any documents for legacy data migration into sap

Check this links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80a18e9f-a90c-2c10-3b82-f6a891711...

former_member188028
Active Contributor
0 Kudos

Hi,

1. you have to create a LSMW/BDC to upload the balances to SAP.

Record a LSMW for F-02. If you are not familiar to LSMW, ask your abaper to create BDC for transaction F-02

Maintain data in excel file according to the format of LSMW/BDC.

Upload it into system.

Also remember:-

You have to create 4 GL upload clearing accounts.

1. GL Upload clearing

2. Vendors pload clearing

3. Customers upload clearing

4. Assets upload clearing

After uploading the balances you can a pass an adjustment entry for these clearing accotns. Any way total balance for uploading clearing accounts should be zero.

also check the following link.

Rgds

Murali. N

Former Member
0 Kudos

Hi Murali

Thanks for the information. But can you please explain elaborately for What type of GLs (expenses, revenues balance sheets GLs) I have take for uploading based on the Trail balance.

My doubt is I have to take expenses balances, revenues etc. Kindly please give with examples.

Thanks in advance.

Former Member
0 Kudos

HI Murali

As you said finally we have to pass adjustment entry. What adjustment entry. Please explain elaborately.

Thanks

Rao

former_member188028
Active Contributor
0 Kudos

Hi,

1. You have to take balances of balance sheet accounts only.

2. For P&L accounts, you have to take the balance only either profit/loss and have to post to Retained earnings account which you will assign in OB53.

See, to upload the balances you are using clearing accounts.

e.g.

GL uploading clearing account Dr 100

to Capital 100

Customer Dr 100

to Customer uploading clearing a/c 100.

See, here gl uploading clearing a/c and customer uploading clearing a/c we are using only for balance upload. Individually these accounts show balance, but together balance is Zero.

After uploading finally you have to post the following entry.

Customer uploading clearing a/c Dr 100

GL uploading clearing a/c 100.

Rgds

Murali. N

kishore_babu15
Active Contributor
0 Kudos

Dear Rao,

Just check the bwlow link you can understand easly to upload the balances.

http://www.saptechies.com/sap-pdf-books-download/SAP_Go_live_strategy11248141773.pdf

Check the bwlow procedure for the same way do it.

First create 5 Dummy GL codes. These GL code should be zero at the end of uploading balances.

1 GL Offset Account Dr

Asset Offset Account Cr

AP Offset Account Cr

Sales Cr

Other GL's Cr

2 Cash Dr

Consumption Dr

Asset Offset Account Dr

AR Offset Account Dr

Material Offset Account Dr

Other GL's Dr

GL Offset Account x Cr

3 AP Offset Account Dr

Vendor 1 Cr

Vendor 2 Cr

Vendor 3 Cr

4 Customer 1 Dr

Customer 2 Dr

Customer 3 Dr

AR Offset Account Cr

5 Fixed Asset 1 Dr

Fixed Asset 2 Dr

Asset Offset Account Cr

Acc. Depreciation Account Cr

6 Stock Inventory Account Dr

Material Offset Account Cr

Regards,