Skip to Content
0
Former Member
Feb 15, 2010 at 05:40 AM

Condition expression in validation

30 Views

Hi Friends!

I want to create a validation rule in line item level for bank GL accounts.

I have 3 bank accounts

190000- Main Bank Account

190001-Check Deposti account

190002-Check Issue account

1) Want to restrict postings to main account, other than with doc type ZR

2) Want to restrict credit postings with PK50 to +++++1 account, other than with doc type ZR

3) Want to restrict Debit postings with PK40 to +++++2 account, other than with doc type ZR

ZR is my reconcilation doc type, used by FF67.

For one accounts, if we want to restrict i can directly write a condition like

Prerequesite: BSEG-HKONT = '190000'

Check: BKPF-BLART = 'ZR'

Message: Error Message

But if i want to restrict several main bank accounts from diff company codes, what will be the right procedure to do it.

If i choose Post automatically only in GL master, i cannot post entries even through FF67 also.

Can i use set IDs for this? i have created a set ID with table BSEG and field HKONT through GS01.

But how to express the set ID in the prerequesite section.

single values will be like BSEG-HKONT = '190000', but for set ID usage to what will be condition expression?

Kindly guide me.

Thanks,

Srinu