Table Maintenance Generator

[Former Member]

Hi Experts,

I am new to ABAP.

I want to put validations to ZTABLE field ZUSER1.

I want to validate it with USR02 field BNAME.

End users is given with a transaction where they can enter new values to this table, if they enter a value not present in USR02 they should be prompted to enter correct user names.

I want to go by TMG way, by creating events.

Cld you suggest on the steps and what code do I need to enter in the FORM part.

Say I want to prompt user with following message :

'Please enter valid name'

Rgs,

Michael

[JozsefSzikszai]

hi,

you don't need to code anything for this. Just go to SE11 and for this field add a check table (USR01 - this is the main table for user master). After this (re)generate the table maintenance.

hope this helps

ec

[Former Member]

Hi Eric C,

thnks for reply.

How do u regenerate the table maintenance ?

Rgs,

Michael

Edited by: michael v on Jul 3, 2008 5:25 PM

[JozsefSzikszai]

Go to SE11 and from the menu start the table maintenance and click on Change (i assume it is generated already, if not, click on Create)

Also important is that your field (ZUSER) has to have the same data element, like in USR01-BANME (the data element is XUBNAME).

[Former Member]

Hi Eric C,

would this work if user is given a different transaction to insert data ?

I heard in that case you need to use TMG, where you code in ur event.

Michael

[former_member195383]

Hi...

Go to..se11>utilities>table maintainance gerater-->then go to >Environmanets->Modification->events->There u can click on the the text symbol...and write your code...

Wat ever validations and error messages u wanna put...u can put it thr...hope it works...

Reward points..if useful..

[JozsefSzikszai]

"would this work if user is given a different transaction to insert data ?"

just check what is that transaction is doing:

-if it calls SM30 with this Z... table, than it is OK (if it calls FM CALL_MAINTENANCE_VIEW ==> same story)

-if it calls a Z... program, than you have to modify that Z... program

"I heard in that case you need to use TMG, where you code in ur event."

this is an option as well, however it requires some coding.

Again: if the Z... table is maintained through SM30 and generated table maintenance view, than the easiest solution is to go for the check table (my first reply in this thread)