on 08-07-2008 7:59 AM
Hi:
Pretty new to SAP and currently doing data conversion for GL Balances and GL Open Items. Would like to know if anyone could help.
Is there a difference for conversion rules to convert different kinds of accounts? Like Intercompany accounts, revenue accounts, inventory accounts, expense accounts, etc. Is there something to do with the subledger?
Thanks in advance.
Hi Matthew,
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 Dr 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
Thanks,
Rau
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rau:
Thanks for the info. I roughly understand by what you mean, but I am only given the data from tables GLT0, BKPF, BSIS, BSID, BSIK I think I need to filter according to company codes, GL accounts and controlling objects like cost center, profit center, trading partner etc. and do a posting for each unique combination using FB01/FBB1?
Is this the correct way it should be? My existing limitation is only the data I have from spreadsheets and using LSMW tools.
Hope you can provide more infomation. Thanks.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.