SAP FI DATA MIGRATION ACTIVITY

former_member493884 · ‎09-19-2018

Data Migration is one the critical and final phase in the ASAP Methodology road map. During this phase the cut over period is defined at which the data entry in legacy system is halted, collected and taken to migrate to SAP system. One of the crucial data to migrate during this activity is the Finance, based on accuracy of this your whole implementation is analyze because it is the final outcome or the result seen by the Management. In this blog, I have discussed the data migration steps, techniques and procedures to migrate Financial data to SAP ERP.

SAP FI DATA MIGRATION ACTIVITY

Broadly, SAP FI Data migration Activity has been divided into two categories,

Master data (G/L accounts, customers, vendors, assets, cost elements, cost centers, profit centers etc.)

Transnational Data (Open Items for customers and vendors, G/L line items, Asset Balances, Material balances, Cost Center planning, profit center plan data load etc.)

1- Master Data

1- G/L Accounts

– Make LSMW Upload for t-code FS00. Extract template, Fill data and Upload.

2- Customer Accounts

– Make LSMW Upload for t-code XD01. Extract template, Fill data and Upload.

3- Vendor Accounts

– Make LSMW Upload for t-code XK01. Extract template, Fill data and Upload.

4- Asset Accounts

– Make LSMW Upload for t-code AS91. Extract template, Fill data and Upload.

5- Cost Elements

– Make LSMW Upload for t-code KA01. Extract template, Fill data and Upload.

6- Cost Centers

– Make LSMW Upload for t-code XS01. Extract template, Fill data and Upload.

7- Profit Center

– Make LSMW Upload for t-code KE51. Extract template, Fill data and Upload.

2- Transaction Data

Pre-Requisites

Pre-Requisites required by FINANCE Department:

Define cut over phase, during which FINANCE has to,

Closed the P&L in Retained earning account.

Check Balance sheet balances through equation,

Assets – Liabilities= Equities

You have to create 6 G/L upload clearing accounts through FS00

G/L Upload clearing

Vendors Upload clearing

Customers upload clearing

Assets upload clearing

Material Upload Account

Main Upload account

Also, configure the Doc Type “UL” with separate No. ranges for Upload.

1- G/L Line Items

Transfer Balance sheet account balances through F-02 LSMW program. Pass the following JV entry,

Example:

PK 40 - G/L uploading clearing account Dr 100

PK 50 - Capital -------------------------------- Cr 100

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

Example:

PK 40 - Main Upload Account --------- Dr 100

PK 50 -G/hL upload clearing a/c --------- Cr 100

2- Open Items for Customers

Transfer Balance sheet account balances through F-02/ F-22 LSMW program. Pass the following JV entry,

Example:

PK 01 - Customer 1 ----------------- Dr 100

PK 01 - Customer 2 ----------------- Dr 100

PK 01 - Customer 3 ----------------- Dr 100

PK 50 - Customer Upload clearing -- Cr 300

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

Example:

PK 40 - Customer upload clearing -- Dr 100

PK 50 - Main Upload Account -------------- Cr 100

3- Open Items for Vendors

Transfer Balance sheet account balances through F-02/ F-43 LSMW program. Pass the following JV entry,

Example:

PK 50 - Vendor Upload clearing -- Dr 300

PK 31 - Vendor 1 -------------------- Cr 100

PK 31 - Vendor 2 -------------------- Cr 100

PK 31 - Vendor 3 -------------------- Cr 100

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

Example:

PK 40 - Main Upload Account -------------- Dr 100

PK 50 - Vendor upload clearing ---------- Cr 100

4- Asset Balances

As, you have already created the Asset Master data through AS91, during which you have also enter Asset APV and Depreciation values (Asset takeover values) in Asset accounting module.

To post in G/L account, go to t-code: OAMK and change the control of reconciliation account to "BLANK"

Transfer Balance sheet account balances through F-02 LSMW program. Pass the following JV entry,

Example:

PK 70 – Fixed Asset 1-------------- Dr 100

PK 70 – Fixed Asset 2-------------- Dr 100

PK 50 – Asset Upload clearing---- Cr 100

PK 50 – Acc. Dep Account--------- Cr 100

Post G/L balances and go to OAMK and restore control of reconciliation account to " ASSETS"

2^nd Option for G/L posting is through t-code: OASV. In this you don’t have to use t-codes: OMAK & F-02.

Now, you have to reconcile Asset values in Asset Accounting module with GL balances using t-code: ABST2

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

Example:

PK 40 - Main Upload Account ------- Dr 100

PK 50 - Asset Upload clearing --------- Cr 100

5- Material Balances

Balances are uploaded via t- code MB1C from MM side.

When you upload using 561 movement type, the accounting entry should be,

Example:

PK 89 - Inventory ----------------- Dr 100

PK 50 – Material Upload Account -- Cr 300

The system would read the material master price for the plant and multiply the same with quantity of the material. This will be the value which will be updated as the stock value in the inventory account G/L as well as stock balance in Materials Management.

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

Example:

PK 40 – Material Upload account -- Dr 100

PK 50 - Main Upload Account -------------- Cr 100

6- Cost Center Planning

Make LSMW program for the KP06, extract the template and upload Cost center planning data for previous number of years (Optional)

7- Profit Center Planning

Make LSMW program for the 7KE1, extract the template and upload Cost center planning data for previous number of years (Optional)

In the above article the major focus is on the data migration steps and techniques used to migrate Finance data. If anyone want to acquired more knowledge on the subject matter, then it is requested to go through the below links in references. I appreciate the time you took to read this blog, hope this article is helpful and knowledgeable to the readers.

References:

https://archive.sap.com/discussions/message/7659562#7659562

http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

https://archive.sap.com/discussions/thread/1715997

https://archive.sap.com/discussions/message/4334704#4334704

https://archive.sap.com/discussions/thread/3405366

https://archive.sap.com/discussions/thread/3854371