Restrict Inter company Transactions for a given User ID

[former_member228896]

Hi All,

Scenario - Given user ( say USB2) should not be allowed to post an  inter company entries either by MIRO , FB01 for company codes 1000 & 1001

                  however the user is provided access to post independent transactions ( NOT INTER COMP TRANS) in C.Code 1000 & 1001

In the above scenario I have two queries:- 

1. Do you suggest validation approach ( i.e. GGB0) or any other approach ?

2. When I tried validation approach , validation rule is  not working

Validation Rule

Line Item

Prerequisite

BKPF-BUKRS = 1000' OR BKPF-BUKRS = '1001' AND BKPF-BVORG <> ' '

AND BKPF-USNAM = 'USB2'

Check

BSEG-HKONT = '999000' OR BSEG-HKONT = '999001'

Message

Message Type "E"

Message Number "007"

Rds

Sanjai

[ajaycwa1981 · Accepted solution]

Hi Sanjai

Try this

Try below validation

Validation Rule

Full Document

Prerequisite

(BKPF-BUKRS = 1000' OR BKPF-BUKRS = '1001') AND BKPF-USNAM = 'USB2'

Check

BSEG-VBUND = ' ' (BLANK) {i.e. Trading Partner = Blank)

Message

Message Type "E"

Message Number "007

After this validation, activate it in OB28 and run program RGUGBR00 selecting

Application Area = FI, Call Up Point = *,

Regenrate Main Program

All Other options wherever you see the term "Validation"

Ajay M

[former_member228896 · Accepted solution]

Hi Ajay,

May I know why you are giving check as BSEG-VBUND = ' ', when the check is BSEG-HKONT = 999000 or BSEG-HKONT= 999001.

I have done as per your validation , but system is not allowing to save the validaton " Formula cannot be saved because it is incomplete"

Rds

Sanjai

[former_member198650 · Accepted solution]

Hi Sanjai,

Have you tried to create validation as mentioned in my last reply?

Regards,

Mukthar

[ajaycwa1981 · Accepted solution]

Hi Sanjai

Create the Validation by choosing the fields from the List. This error may come if you type the fields manually

I asked to choose VBUND because Trading Partner is usually used for Inter Co. transactions.

If you want to try with Recon accounts, you can. But try to run RGUGBR00 and see if your validation works.

I think Trading Partner is a logical approach

Ajay M

[former_member228896 · Accepted solution]

Hi Ajay,

Thanks for the inputs, I have used VBUND logic and Its working fine.

However I have not run RGUGBR00 and OB28, still its working fine, should we do anything on this front.

Further when we move specific validations from development to Testing , rest of other validations were also moved from Development to QA Client .

Can you share your thoughts on this.

Regards

Sanjai

[ajaycwa1981 · Accepted solution]

Hi Sanjai

1. No need to run those programs if it is working fine

2. For the transport issue, you need to be very careful.

assume you have 10 validation steps in Dev. Quality has only 8.

now you add 11th step in Dev, and want to move to Q and Prd before Steps 9,10

in this case, you must delete steps 9,10 in dev first. Generate a TR and release it. Then add back the steps 9,10 removed by you earlier

basically it will transport everything from dev. So make sure you have only the required ones while you create a TR

Ajay

[ajaycwa1981 · Accepted solution]

If resolved, please close the thread

[former_member228896 · Accepted solution]

Ajay ,

Thanks for your valuable inputs ... really appreciate

I have marked relevant thread as  correct answer, hope this closes and assigns points automatically.

Rds

Sanjai

[Aniket_D]

Hello Sanjai

Please verify the Check statement. Error message will be displayed if prerequisite is met and check is "NOT" fulfilled. If GL accounts 999000 and 999001 are for intercompany posting as per your check statement it is fulfilled and hence error message is not displayed.

Try below validation

Validation Rule

Document header

Prerequisite

BKPF-BUKRS = 1000' OR BKPF-BUKRS = '1001' AND BKPF-BVORG <> ' '

Check

BKPF-USNAM <> 'USB2'

Message

Message Type "E"

Message Number "007

Regards

Aniket

[former_member228896]

Hi Anket,

I tried yours too, but validation is not working.

Rds

Sanjai

[former_member228896]

Hi Mukthar,

The trace is strangely picking up Vendor Reconciliation account

Rds

Sanjai

[former_member198650]

Hi Sanjai,

You can achieve it by creating validation for the GL for the user id.

Prerequisite

BKPF-BUKRS = 1000' OR BKPF-BUKRS = '1001' AND SYST-UNAME = 'USB2'

Check

BSEG-HKONT = '999000' OR BSEG-HKONT = '999001'

Message

Message Type "E"

Message Number "007"

After create it, you have to activate for the co.code in OB28.

Regards,

Mukthar

[former_member228896]

Hi Mukthar,

When I used above validation, system is not allowing for any of the GL Accounts

Not sure why ? any thoughts....

Regards

Sanjai

[former_member198650]

Hi Sanjai,

Define validation as shown below:

Prerequisite

SYST-UNAME <> 'USB2'

Check

BSEG-HKONT = '999000' OR BSEG-HKONT = '999001'

Message

Message Type "E"

Message Number "007"

After create it, you have to activate for both the co.codes in OB28.

Regards,

Mukthar