uploading data

[Former Member]

Hi sap gurus,

1) What r the datas we have to upload before golive

2) How can i divided to upload data, like open items, cleard items $ balances like this

thanku

raj

[Former Member · Accepted solution]

Hello Ramesh,

initially you need to upload in Development and check everything is working fine and uploaded properly. You need to create master data in each client. You cannot transport master data. Initially upload in development then if everything is fine upload the same file in production.

For uploading you need to create 5 GL masters you create one account group for upload accounts. In which you create 5 GL masters with following data Tax Category:* Line Item Display: Yes, Open Item Display: Yes, Sort: 0001(Gl), 012(Vend),031(Cust)018(Asst) etc, FSG: g001.

Under that grp you need to create all 5 accounts. All are balance sheet Accounts. GL Balance Upload Ac, Customer Balance Upload Ac, Vendor Master Upload Ac, Asset Master Upload Ac, Material Upload Ac. You should take the trail balance of the company and chose all gl accounts with balances. Use LSMW upload GL balance upload.

Ex-Salaries: these GLu2019s always shows debit balances. When upload GLu2019s the entry will be

Salaries A/c Dr

To GL Upload A/c

Ex-Vendor Account: Vendor balances always shows credit balance and client want to upload line item wise ex line items are: 1000, 2000, and 3000 then

Vendor Upload Ac Dr

To Vendor Ac 1000 To Vendor Ac 2000 To Vendor Ac 3000

Ex-Customer Account: Customer balances always shows debit balance

Customer A/c Dr

To Customer upload A/c

Ex-Assets: for assets you need to use AS91 which will create asset master data and upload balance in Asset master data and for uploading GL balance you use TC-OASV/OA97. System does not create any accounting entries.

Ex-Materials: for material initial upload use TC-MB1C and movement type will be 561

After upload block all the 5 gl masters which you have created for upload donu2019t show this Gl in Financial statement versions.

Thanks

Para

[Former Member · Accepted solution]

Hi V K Para

in our case we have to upload g/l balancess upto 31.03.2008, after that we have to upload transactional data. what to do for this and what t code we r using for uploading for g/l, ap, ar and asset account.

can u eaxplain please

raj

[Former Member · Accepted solution]

Hi Raja

VK para is correct. In addition to VK para i would like to add some more..

• For uploading GL account balances you use tode F-02

• For uploading AP transactional data you use tcode FB60 or F-43

• For uploading AR transactional data you use tcode F-22

• For uploading asset balances use Tcode AS91 or for Asset GL balances use tcode OASV

• Every time you should use one side GL (Debit or Credit) as a uploading GL account.and finally that Uploading GL account must have nil balance.

I hope this must helps you

Cheers,

Nils