topic Re: Table Maintenance Generator in Application Development and Automation Discussions

Table Maintenance Generator

Former Member — Thu, 03 Jul 2008 15:13:32 GMT

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

Re: Table Maintenance Generator

JozsefSzikszai — Thu, 03 Jul 2008 15:22:34 GMT

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

Re: Table Maintenance Generator

Former Member — Thu, 03 Jul 2008 15:24:50 GMT

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

Re: Table Maintenance Generator

JozsefSzikszai — Thu, 03 Jul 2008 15:27:31 GMT

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).

Re: Table Maintenance Generator

Former Member — Fri, 04 Jul 2008 04:31:20 GMT

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

Re: Table Maintenance Generator

former_member195383 — Fri, 04 Jul 2008 04:52:37 GMT

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..

Re: Table Maintenance Generator

JozsefSzikszai — Fri, 04 Jul 2008 06:34:04 GMT

"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)