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,
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,
Assets – Liabilities= Equities
Example:
PK 40 – G/L uploading clearing account Dr 100
PK 50 – Capital ——————————– Cr 100
Example:
PK 40 – Main Upload Account ——— Dr 100
PK 50 -G/hL upload clearing a/c ——— Cr 100
2- Open Items for Customers
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
Example:
PK 40 – Customer upload clearing — Dr 100
PK 50 – Main Upload Account ————– Cr 100
3- Open Items for Vendors
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
Example:
PK 40 – Main Upload Account ————– Dr 100
PK 50 – Vendor upload clearing ———- Cr 100
4- Asset Balances
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
Example:
PK 40 – Main Upload Account ——- Dr 100
PK 50 – Asset Upload clearing ——— Cr 100
5- Material Balances
Example:
PK 89 – Inventory —————– Dr 100
PK 50 – Material Upload Account — Cr 300
Example:
PK 40 – Material Upload account — Dr 100
PK 50 – Main Upload Account ————– Cr 100
6- Cost Center Planning
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:
Upload Opening Balances
http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc
SAP Legacy data Migration Starategy/Process
Uploading the account balances to legacy to SAP System.
Upload Asset Balances?
Initial Inventory Balance upload question
Okumaya devam et...
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.
- 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”
- 2nd 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)
- 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:
Upload Opening Balances
http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc
SAP Legacy data Migration Starategy/Process
Uploading the account balances to legacy to SAP System.
Upload Asset Balances?
Initial Inventory Balance upload question
Okumaya devam et...