EBS and TRM setup for new bank accounts

[former_member693168]

Hi to all, I have the following account symbols for EBS: CHECKOUT" 1110++ "TRANSFEROUT" 1111++ "CHECKIN" 1112++ "RECEIPTS" 1113++. We use the two last digits ++ for identify the bank account linked to the g/l account, it allowed us to have 99 bank accounts linked to their g/l, but now we have more than 99 bank accounts, so we start to use symbols CHECKOUT" 1116++ "TRANSFEROUT" 1117++ "CHECKIN" 1118++ "RECEIPTS" 1119++. It works fine for new bank accounts, but it made the ebs stop to work for old bank accounts, when we post electronic bank statement by t-code F.55, the same problem occurs with postings by TBB1 t-code. How can I make the account symbols for electronic bank statement and TRM works for old bank accounts (fourth digit 0 1 2 and 3) and for new bank accounts (fourth digit 6 7 8 and 9)?

Thanks regards.

[sandip_kurewar · Accepted solution]

Dear mrrjesus, Account modification will help you to overcame from this scenario, you have to work with your ABAP team to work on the following exit, and write a logic to get the different GL accounts based on the account modification field, in the following fig, I have given you the hit, how I have handle this in one of my requirement.

Best Regards,

Sandip

[former_member693168 · Accepted solution]

Ok. Thank you so much.

[Lakshmipathi · Accepted solution]

When you post a query and give further updates, please add the content under "Comments" and not under "Answer" as you were not answering to a query but only providing additional informations as asked by the members. Also, when you add the text under Comments, it will be intimated to the person to whom you are responding whereas, if you add the text under Answer, the member will not be intimated. By the way, your above answer has been converted as comment by me but not the other one as it has a subsequent response

[MarekTurczynski]

Hi mrrjesus

the userexit is not only solution and also not the best one (why code things that can be reflected in customizing?). You can create a search string that maps sets each account modification via OTPM. Only and only then if you do not suceeed (too complex rules etc.) please think about userexit.

Regards,
Marek Turczyński

[former_member693168]

Thanks for you contribuition Mr. Sandip, but in my company we are making a back to standard procedure, so the use of enhancements and user exits is not a option for us. I need a standard solution, using configurations. Do you know any solution without the use of ABAP code?

Solution from others SAP professionals also are welcome.

Thanks and regards.

[sanilbhandari]

Hello mrrjesus

The solution provided by sandipkurewar is the most optimum one. If that do not want that, than talk to your bank if they can send some specific text in the bank statement and you can set up search string as well to post depending on the bank account. However, search string configuration is cumbersome and increases your maintenance. The use of search string is also dependent on the flexibility your bank has towards sending a specific test.

The last option would be to create new set of Bank Account GL and create masking accordingly.

Thanks & Regards

Sanil Bhandari