topic Table Entry Validation in Application Development and Automation Discussions

Table Entry Validation

jaheer_hussain — Tue, 08 Apr 2014 12:39:14 GMT

Hi,

For table entry validation I have two events.

01 BEF_SAVE

02. AF_CORR.when I change currency I am triggering this event.

I am checking validation for currency in the second event 02-AF_CORR.If currency does not match ,I am throwing error message,but wrong currency(say example USD) is getting updated in the table.It should not happen as per my expectation.

This is code which I have put in the event 02 AF_CORR. Can some body throw light on this issue please? How to stop wrong currency is getting updated in my Z table. Is there any coding problem?

FORM AF_CORR.

LOOP AT TOTAL.

SELECT SINGLE * FROM T001K WHERE BWKEY = TOTAL+21(4).

IF SY-SUBRC EQ 0.

SELECT SINGLE * FROM T001 WHERE BUKRS = T001K-BUKRS.

IF TOTAL+70(5) <> T001-WAERS.

MESSAGE 'Currency is not valid, Please Check' TYPE 'S' DISPLAY LIKE 'E'.

vim_abort_saving = 'X'.

CLEAR SY-SUBRC.

EXIT.

ENDIF.

ENDLOOP.

ENDFORM.

Re: Table Entry Validation

Former Member — Tue, 08 Apr 2014 12:49:50 GMT

Jaheer, As per SAP documentation the DISPLAY LIKE edition does no impact the behavior determined by the message type, but only the time of display.

So why not try just displaying an error message?

Re: Table Entry Validation

Former Member — Tue, 08 Apr 2014 12:53:10 GMT

Write this , it will work...

MESSAGE 'Currency is not valid, Please Check' TYPE 'E'.

Re: Table Entry Validation

jaheer_hussain — Tue, 08 Apr 2014 13:37:43 GMT

Hi,

I put MESSAGE 'Currency is not valid, Please Check' TYPE 'E'. in my coding,but still the issue.

which event I have to use for editing particular field(currency)? I am using 08,it is correct?

With Regards,

Jaheer

Re: Table Entry Validation

Former Member — Tue, 08 Apr 2014 15:21:16 GMT

You can try event 18 - After checking if data is changed or better 01 - Before save

Re: Table Entry Validation

anubhab — Thu, 10 Apr 2014 06:06:23 GMT

Hello Jaheer,

I'll suggest to use Event 21 along with message type 'E'. Although it's description says Fill hidden fields, it can be used for validation too.

Please let us know, if it works fine in your case or not.

Regards,

Anubhab