Keeping you Chart of Accounts in Sync across multiple systems..

Are you trying to keep your Chart of Accounts in Sync, accross the same company code in multiple systems ? Sap Provides a way to transport the Generic Chart of Accounts (table SKA1), but not the Company Code Specific Version (table SKB1). The following technique allows you to do Both.

• Use the transaction FS15 to export your chart of accounts to a file (on the application server)

• (Double click on the message. you can copy the file name and path to your clipboard. )

• Use transaction CG3Y to download the file to your own PC.

• Log in to the other system,

• Use transaction CG3Z to upload the file to the other system

• For each client, run FS16 to upload your chart of accounts.

(keep track of the file path on each server so you know where it will look for the file)

You can use transaction AL11 to list files on the app server.

Sharing Status Spreadsheets in Excel

Did you Ever needed to track what other people updated on your spreadsheets?

Just activate the "track changes" under tools. (Excel 2003) .

Then send your spreadsheet out to several people.

Once you get the response back. you can merge all copies into one as a grouped update.

Note: don't forget to activate "track changes" BEFORE you send out your original, since Merging is only available on Shared copies...

If anyone uses Office 2007, please leave a comment with the option where you can find this in Excel 2007.