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.)
Master Data
- G/L Accounts
- Customer Accounts
- Vendor Accounts
- Asset Accounts
- Cost Elements
- Cost Centers
- Profit Center
Transaction Data
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,
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
Configure the Doc Type “UL” with separate No. ranges for Upload.
G/L Line Items
- Transfer Balance sheet account balances through F-02 LSMW program. Pass the following JV entry.
- After uploading the balances, pass an adjustment entry for these clearing accounts. Any way total balance for uploading clearing accounts should be zero.
Open Items for Customers
- Transfer Balance sheet account balances through F-02/ F-22 LSMW program. Pass the following JV entry, After uploading the balances pass an adjustment entry for these clearing accounts. Any way total balance for uploading clearing accounts should be zero.
Open Items for Vendors
- Transfer Balance sheet account balances through F-02/ F-43 LSMW program. After uploading the balances pass an adjustment entry for these clearing accounts. Any way total balance for uploading clearing accounts should be zero.
Asset Balances
- create the Asset Master data through AS91, during which enter Asset APV and Depreciation values (Asset takeover values) in Asset accounting module.
- post in G/L account, go to t-code: OAMK
- transfer Balance sheet account balances through F-02 LSMW program.
- 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.
- reconcile Asset values in Asset Accounting module with GL balances using t-code: ABST2
- after uploading the balances pass an adjustment entry for these clearing accounts.
- total balance for uploading clearing accounts should be zero.
Material Balances
- Balances are uploaded via t- code MB1C from MM side.
- 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 pass an adjustment entry for these clearing accounts.
- Any way total balance for uploading clearing accounts should be zero.
Cost Center Planning
- LSMW program for the KP06, extract template, upload Cost center planning data for previous number of years (Optional)
Profit Center Planning
- LSMW program for the 7KE1, extract the template and upload Cost center planning data for previous number of years (Optional)