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.

Sap Resources on esnips

Has quite some interesting resources on SAP. esnips is a community that shares resources amongst its members.

Are you up to the SAP 2008 Developer Challenge?

Then you are too late. the applications were accepted until yesterday, April 22, 2008.
This years topics were:

• Green IT
• Social Computing
• Mobilizing SAP
  

Data Unification How-to Guides for SAP NetWeaver 7.0

Data Unification How-to Guides for SAP NetWeaver 7.0 on SDN gives you an overview of How-to Guides for Netweaver.

You can also find other How-to Guides by topic by clicking here.

SAP Table Relations

Whenever I needed to create functional specifications for a report, I have a hard time remembering all the technical names of the tables. This PDF Document has been on the net for a while, and has been really helpful.

And here you can find an array of useful tables used in Configuration. Ever since ECC 5.0, you can access most configurations, using SM30, then find related maintenance views, to configure area's in SAP. Sometimes, SAP does not use very good descriptions for their configuration tasks, so this table will help.

The Site here has some helpful information too.


If you know of any other tools to help with tables in SAP, Please post a comment here.

Getting Custom Partner Functions from SD to COPA

Although even SAP suggest a method of extending structures, and enhancing user exits, and regenerating function modules to extend Custom partner functions, there is an easy "pure configuration" way.

I simply don't get it. this is now the second time in 1 week that one of my collegues has issues in getting the custom partner functions into COPA.

Custom partner functions are used to set relationships between a sales order (and subsequent documents) and persons or other relational entities.
a partner function can refer to another customer master, and employee master, or a vendor master. This allows you to add for example a external agent in a sales order, who is also a vendor, or a internal sales agent or rep, who is also an employee, or simply another customer who has some kind of relationship with the current customer (sold-to).

SAP recommends applying an OSS note to get this relationship into COPA. But this oss note is in my opinion totally redundant, and complex.

There is now an easier solution, which is pure configuration, to add a custome partner function into copa.
I am planning to create a detailed solution paper about this, in the coming days.
So subscribe to this feed, and watch your RSS feeds folks! Sap Simplification is coming...