EBS statements with MT940 : Search strings

I spent a few hours fine tuning my clients EBS settings.
The best way to customize the Posting is to analyze real time EBS statements , and fine tune them with search strings. The problem with that, is that MT940 statements are posting with different transaction codes, for the same bank, but in a different country. You can create search strings for almost any data found in the note to payee field. For the company in Poland for example, they activated Business Area as a segment for document splitting in order to be able to generate financial statements per business areas, within a single company code. The business area's are used to report on different business area's per country. So in order to automatically recognize the correct business area, there were exchange rates mentioned. For example : Any time there was a CSZ exchange rate mentioned, I knew it belonged to a particular business area for CZ ,and whenever HUF exchange rate is mentions, I use another for HU country. This is a good way for statement items which can be defined. but for other area's where it is not clear from the note to payee field, the business area is a mandatory field for posting, so the statement posting rule just goes to a red traffic light and users can just complement the posting in FEBA. There are usually not many issues with outgoing payments that have cleared open vendor items. As long as they have been mapped to the correct sub-account such items are usually auto-cleared in FEBA.
A bigger challenge is posting entries for a Market fund account, especially when the interest earned is not separately defined. such entries get tagged with an automatic payment advice note. Within FEBA, you can then change the principal amount on the payment advice, take off the interest part, post the difference to the interest earning account and clear the principal against the originial investment placed.
There are some gray area's where information is missing, so you need to park the statement on a suspense account. for example, in some cases, a investment account needs to be posted to. but there are different transactions, whith different currencies, requiring different GL Accounts. In those cases, you sometimes have to let the user decide where the posting will go to.
You make a initial posting to sub-account (reflecting a green traffic light) and then let the user transfer post the suspense account item to the actual GL account.
 Configuring Electronic Bank statements on SCN

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...

SAP CO-PA Re-alignment and historic views

Can I run copa realignment for the first period of a new fiscal year, without changing the data posted in prior years eg derivation rules for profit centre changed after period 1 closed; data posted in period 1 needs realigning?

this topic was discussed on LinkedIn .