Business Area validatin for cash journal

[Former Member]

Hi Experts,

I have 4 Company codes, Each company code is having 5 business aras.

Accourding to Our client Requirement Cash journals are created as per business area wise. Now I want to validate the cash journal for particular business area.

C.Code 1000

Business areas 1000,1001,1002,1003,1004

Cashjournals 1000,1001,1002,1003,1004

the csh journal 1000 should allow business area 1000, if we enter any other business area , it should show the error,

Please give the solution, it is very helpful for me.

Thanks and regards

Ramu

[Former Member]

Hi,

You can considder using FI validations with an Exit to validation Business area combinations for Cash journal.

Hope this helps.

[Former Member]

Dear Pradeep

Please Can you give me more details on this validattion,

Regards

Ramu

[Former Member]

Dear Ramu,

I have the same requirement as yours i.e Validation of business area & cash journal number.

If you have any solution for this, please share.

Thanks

Gopal Muni

[ibrahim-gad]

Hi Gopal,

1- if your case as the original post,

Try FI substitution exit (callup point 2) to substitute business area directly to cash journal GL

- if >>> cash journal 1000 should allow business area 1000 only

* business area will be derived automatically from your substitution in FI posting and no need to be entered during the entry

.......

2 - If you want to allow more than one business area to a specific cash journal,

you may use validation to restrict incorrect FI posting

a- something like this

use expert mode

Prerequisite:

Transaction Code = 'FBCJ' AND

Reference Key :11-14: = '1000' AND

Reference Key :15-18: = '1000'

* reference key consist of (CJ internal Doc. Number+cash journal code+ company code)

check:

Business Area = '1000' OR Business Area = '1100'

and define your own error message.

b- or you can validation with exit

....

Kindly, note that the above will work only in FI posting and won't in FBCJ transaction.

which means you will not be able to post the document to FI.

3- if you want to get the modification in FBCJ itself.

you can go for BAdi  CJ_DOCUMENT

Thanks,

Ibrahim

[Former Member]

Thanks a lot Ibrahim,

This is the correct answer & this can be possible for one or two cash journal & business area.

But my client having nearly 40 numbers of cash journal & business area.

So can it be possible doing validation by creating sets. to do one to one validation.

Please suggest..

Thanks

Gopal Muni.

[Former Member]

Hi..

I think that you need your ABAPer’s help to insert your logic with mapping table for validation check to  FI validation user exit (T-code : ob28)

Refer to "3.User Exits in Validation" Section of this web site "http://www.sapficoconsultant.com/pdf/SAP%20Validation.pdf"

[ibrahim-gad]

Hi Gopal,

it is a pleasure that my reply helped you.

I have a little bit similar situation as yours;

we've about 11 BA with nearly 400 CJ

so, we did as Big Choi recommendation (exit)

in my case one BA for each CJ

so, we've gone for substitution exit.

I do recommend Big Choi's link it will help you a lot

Regards,

Ibrahim