topic Table maintainance generator in Application Development and Automation Discussions

Table maintainance generator

Former Member — Wed, 13 Jun 2007 07:41:50 GMT

How to do validations in Table maintainance generator ?

Re: Table maintainance generator

Former Member — Wed, 13 Jun 2007 07:48:15 GMT

Hi,

Refer to the link

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Regards

Bala

Re: Table maintainance generator

Former Member — Wed, 13 Jun 2007 07:53:24 GMT

Hi,

1. You need to create a authorization group. Pls. refer this thread

2. Goto SE80. Select Function Group and enter your table name. Entire auto generated program would be displayed. Change the code as per your requirement

u can do validations for table entries done vai SM30. u can do this in the program for table maintenance.

1. go to se11

2. utilities -> table maintenance generator. or SE55

3. now environment -> modifications -> events

here u can select event '05' for validations to be done before saving an entry into DBtable.

Creating a new entry 05 means when a new entry is created in the screen and not in the database. They can even cancel and choose not to save it..

But the event 01 is called before saving the data...

TO access the field you have to do the following..

DATA: BEGIN OF WA.

INCLUDE STRUCTURE ZTABLE.

INCLUDE STRUCTURE VIMTBFLAGS.

DATA: END OF WA.

For 05 event

wa = <table1>.

if wa-field_name..

....

endif.

For 01 event

LOOP AT TOTAL.

WA = TOTAL.

if wa-fielname.

.....

endif.

ENDLOOP.

You have to move the values to the work area WA to access the fieldnames...You cannot directly use TOTAL-FIELDNAME OR <TABLE1>-FIELD..As it will give you a syntax error.

Regards,

Priyanka.

Re: Table maintainance generator

Former Member — Wed, 13 Jun 2007 08:02:12 GMT

Hi Bhagavan

If you have a maintenance view created for this custom table, you could do field validations by following these steps:

1) From SE11, select the maintenance view and EDIT it.

2) Go to table maintenance generator

3) From menu, select Environment -> Modification -> Events

4) From the displayed screen, select the most suitable event (in column T) for handling your validation.

5) Identify the routine for your validation.

6) Save changes and activate your view.

go through this link

http://fuller.mit.edu/tech/view_clusters.pdf

Reward all helpfull answers

Regards

Pavan