Legacy Data Migration for FI-CO

[Former Member]

Dear SAP Gurus,

I am new for implementation projects.

I am assigned with the task of migrating the data from the client legacy system into the SAP system. My technical guys had some LSMW formats for the purposes of data migration.

Can anyone explain me where i need to concentrate with respect to a successful data migration and what procedure need to be adopted.

I am asked to provide a presentation on how we plan to do the data migration with respect to the following -

1) AP Vouchers (each and every line item of the vendor invoices due)

2) AR Invoices (each and every line item of the vendor invoices due)

3) GL Balances

4) Fixed Assets

5) CO-PA Line Items (how it can be done..??)

Can anyone throw some light on the above..?? Especially with respect to CO-PA line items and Fixed Assets..??

Any help in this regard will be highly appreciated.

Thanks & Regards,

Chaps

[Former Member]

For CO-PA we created our own LSMW template and also a BDC recording thru T-Code KE21N and uploaded the line items.

[Former Member]

Hi,

The upload of GL Balances have to split into several steps:

1. Normal GL Accounts: In this case line items are not required and totals are to be updated in SAP. This can be done using GL fast entry if the number is not too high.

2. Open Item Managed GL Accounts: All the open line items are required to be uploaded in SAP from Legacy in order to clear them. Hence, a LSMW / BDC program has to be developed to upload the line items.

BAPI_ACC_DOCUMENT_POST - for GL/AP/AR

BAPI_ACC_INVOICE_RECEIPT_POST - for AP

BAPI_ACC_GL_POSTING_POST - for GL

GL Balance

F-02 or RFBIBL00 or BAPI

Dr GL a/c Credit Data migration Account or Clearing Account

3. Customer & Vendor Open Items: All open line items in Customer and Vendor Accounts have to be brought in into SAP. For this also a LSMW / BDC program needs to be developed and upload the line items.

Vendor Balances

F-02 or RFBIBL00 or BAPI

Credit Vendor a/c (individually) and Dr Data migration Account or Clearing Account

Customer balances

F-02 or RFBIBL00 or BAPI

Dr Customers a/c (individually) and Cr Data migration Account or Clearing Account

4. Asset Accounting: In case asset accounting is implemented the individual balances of each asset (Gross Value and Accumulated Depreciation) have to be uploaded using transaction AS91. For this also you need to develop a LSMW / BDC program. Further, you also need to update the GL Accounts related to Asset Accounts with totals for each asset class T.Code OASV.

For uploading the Assets

AS91 -> for uploading assets in AA

OSAV --> for uploading assets in GL entry Dr Asset (individually) Cr Data migration Account or Clearing Account

You can use LSMW for uploading all these things

After uploading all, your data migration account will become zero

COPA:What kind of approach are you using cost based or account based?

Thanks,

Rau

[Former Member]

GReat Rau

[Former Member]

Dear Mr. Rau,

Thank you very much for that perfect reply. Really appreciate that...

For CO-PA the client had accepted for a costing based approach.

And for Assets i came to know from another forum that we need to have 2 different approaches with respect to -

1) Assets purchased upto the close of the previous fiscal year; and

2) Assets purchased during the current fiscal year.

And one more thing - can we use the same LSMW template for uploading both the book depreciation and tax depreciation values..??

Thanks again for your time and help.

Regards,

Chaps