topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Thu, 21 May 2009 16:01:58 GMT

Hi,

I created a ZTABLE having 5 fields,three fields are primay key fields.

i generated table maintainence for the same.

But user requirement was,when he enters into SM30 transaction,

he wants three priamry key fields should be mandatory.

How can i do this one.

Can any body help me

Former Member — Thu, 21 May 2009 16:11:23 GMT

Goto Maintainance generator screen in EDIT mode and make the field Mandatory from the Field properties.

To get the program name and screen number Hit F1 on table maintainance window.

gautam_totekar — Thu, 21 May 2009 16:13:06 GMT

Table maintenance generator will not allow entry to be inserted with primary key field to be empty.

KK07 — Thu, 21 May 2009 16:20:12 GMT

Hi,

Double click on the screen in the table maintainence generator,it will take you to the screen.

There you can change the field attributes as required(default not possible).that becomes a mandatory filed.

Former Member — Thu, 21 May 2009 16:34:50 GMT

remove the flag as initial at the table level for key fields and activate..

then if the primary key fields are initial it will not allow you to save in the table maintainance..

Prabhudas

Peranandam — Thu, 21 May 2009 17:14:16 GMT

Hi try with TMG event 01 and 05.

form 01.

if ztable-keyfield1 is initial.

message 'enter value in field1' type 'E'.

endif.

endform.