Condition expression in validation

[Former Member]

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

[Former Member]

Dear,

You have done the right thing of creating Set in GS01. If you have created set like ZGLVAL so you can express in validation like...

BSEG-HKONT IN ZGLVAL instead of BSEG-HKONT = '410000' for standalone GL.

Regards,

Chintan Joshi

[Former Member]

Hi Joshi,

Thanks for your input, since i have got the same solution from my ABAPer after posting my question.

I just want to know, is there is any standard functionlity to block postings as per my question.

And during FF67, the bank reference value (Chk no for outgoing payments) is not being updated to FCH6 as encashment date.

I tried using Interpretation algorithm during business transaction creation for reco entries.

After using the above, i am getting a warning message if i dont enter any value in bank reference field.

Can that message be made as error message...?

 'Bank reference' field not filled
             Message no. FV094                 

And one more is that, if i use that interpretation algerithom, the BI session is not automatically picking the outgoing payment line items from my +++++2 account. It is being stuck at open item selection screen only.

I have seen somewhere that we cant use interpre alg in manual bank statement---is it true?

You can check the same in my below question.

Thanks,

Srinu

[Former Member]

Dear Srini,

Can that message be made as error message...?

'Bank reference' field not filled

Message no. FV094

This message attribute will not be changed in transaction OBA5 but you will have to use transction OBMSG to change the attribute of this message to Error.

And one more is that, if i use that interpretation algerithom, the BI session is not automatically picking the outgoing payment line items from my +++++2 account. It is being stuck at open item selection screen only.

I have seen somewhere that we cant use interpre alg in manual bank statement---is it true?

Do not have much idea so rather would not like to comment.

Regards,

Chintan Joshi

[Former Member]

Hi,

In OBMSG, i have added msg no 094 of app area FV.

There another 3 field available like Allowed, Standard, and Switch Off.

What needs to enter in those fileds?

-

---

Even if i remove the interpretation alg to my business transaction, while entering bank statement transactions, after entering bank reference number, system is giving another wanring message FV095.

-

---

My requirement is to update the value date of my transaction as Encashment date in FCH6 against my cheque.

Is it a bug? ot missing functionlity?

Or is there any standard workaround is available?

Please suggest.

Thanks,

Srinu

[Former Member]

Dear,

In OBMSG, i have added msg no 094 of app area FV.

There another 3 field available like Allowed, Standard, and Switch Off.

What needs to enter in those fileds?

In Allowed, enter WE (this means you can set this message as warning or Error in OBA5)

Standard:Enter W (stadard attribute of the system is warning not error)

Switch off: do not use this.

Once you have done this then go to OBA5 and make FV 094 as an error.

Regards,

Chintan Joshi