topic Re: Table maintenance Validations in Application Development and Automation Discussions

Table maintenance Validations

Former Member — Wed, 24 May 2006 08:26:47 GMT

Hi All,

I created a table with 2 fields, also created a maintenance generator. Now my requirement is i need to have 1-1 relation with the fields, what i mean is, no value can repeat with in either of the fields.

I need to validate this condition.

Suppose user enters a value 1234 in first field, again if he enters the same, i need to throw a error message.

I went to transaction SE54, the following is the code

PROCESS BEFORE OUTPUT.

MODULE liste_initialisieren.

LOOP AT extract WITH CONTROL

tctrl_zzbank CURSOR nextline.

MODULE liste_show_liste.

ENDLOOP.

PROCESS AFTER INPUT.

MODULE liste_exit_command AT EXIT-COMMAND.

MODULE liste_before_loop.

LOOP AT extract.

MODULE liste_init_workarea.

CHAIN.

FIELD zzbank-zzau1.

FIELD zzbank-hbkid.

MODULE set_update_flag ON CHAIN-REQUEST.

ENDCHAIN.

FIELD vim_marked MODULE liste_mark_checkbox.

CHAIN.

FIELD zzbank-zzau1.

MODULE liste_update_liste.

ENDCHAIN.

ENDLOOP.

MODULE liste_after_loop.

<b> MODULE check_dupe.</b>

the line in bold is what i added, how do i proceed from here, could anyone please help.

Re: Table maintenance Validations

Former Member — Wed, 24 May 2006 08:36:01 GMT

Hi,

if I understand right, I think its easier to declare both fields as key fields, so that SAP automatically will not allow saving records that are allready in the table.

Or you mean, one value is not to be accepted in either field, no matter what the value for the other field is ??

FIELD1 FIELD2

111 222

444 555

222 333 <- not valid ??

in that case, user SEARCH in your table for the current value and if SY-SUBRC = 0, then the value exists allready.

Greetings

Re: Table maintenance Validations

Former Member — Wed, 24 May 2006 08:37:35 GMT

Hi,

You ca do this validations in the events part of Table Maintenance.

Chk out this link:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc

Regards,

Anjali

Re: Table maintenance Validations

Former Member — Wed, 24 May 2006 12:56:01 GMT

goto se54--view name-meny bar-environment-modification...

n write ur piece of code...in the relevant code..

Re: Table maintenance Validations

Former Member — Wed, 24 May 2006 13:38:54 GMT

Hi Deepti,

As Jorge Alonso said, if you declare both fields as key fields then SAP will take care of the validation and raise a error message .

Assuming both fields are key fields, if the records are like this.

111 222

then SAP will raise a error message.

Otherwise, if you don't want first or second field to be repeated any where again, then include the code in your check_dupe module.

GET CURSOR LINE <lin> or GET CURSOR FIELD <f> LINE <lin>.

select * from ztable into itab.

loop at itab.

if itab-first_field CS table_first_field or itab-first_field CS table_second_field or itab-second_field CS table_first_field or itab-second_field CS table_second_field.

If sy-subrc eq 0.

MESSAGE E0004 WITH 'Duplicate key'.

ENDIF.

endloop.

Hope this will help you,

Regards,

Vicky

PS: Award points if helpful