Table maintainance generator

[Former Member]

How to do validations in Table maintainance generator ?

[Former Member]

Hi,

Refer to the link

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

Regards

Bala

[Former Member]

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.

[Former Member]

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