I want to write condition while creating table/maintaining table using SM30

[Former Member]

Hello all,

I am creating table Z_CUST with only 2 fields Client, Customer number using SE11 transcation then maintain using SM30 transcation.

User should only be allowed to enter customer number that is in account group(KNA1-KTOKD) ‘Z011’. This validation should be performed during data entry.

[Former Member]

Hi,

Write a form routine in table maintanance generator.

1. SE11 > utilities > table maintenance generator

2. environment > modification > event

define the event and form routine to make use of the tigger. in the form routine define an object for the class and call the relevant method.

Thanks and regards

[abdulazeez12]

Hi

You can do it

Go to Table maintenance generator main screen. Use the menu option, Enivornment-Modification--Events. click on Events.

In the list, selct the event while saving..and you will get a FORM--ENDFORM..write ur validation code in between...

Shakir

[Former Member]

Hi Chandra\shakir,

I am going through same steps which u have given.

But when I click on Environment-> Event it gives following error 'No data maintenance authorization; display only'.It opens next window in only display mode I am not able to made changes in that. so please guide me

[Former Member]

Hi,

I think u dont have authorization for data maintanance. Take authorization for data maintanace from ur security consultant.\

Thanks and regards

[Former Member]

Hi,

Crete the table maintenance generator for your Ztable.

below is the brief procedure to create table maintenance.

Table maintenance generator is basically used to do table operations like (insert, delete, modify...).

if you create table maintenance for your table it will build a module pool program, by using you do the above operations.

below is the procedure to create table maintenance generator.

1) Create one function group.

2) after activating your Ztable, choose 'Utilities'----> 'Table maintenance genrator'.

3) then give the authorization group and function group created abobe in the next screen.

4) Then choose the "create" button in your application tool bar, which will creates the module pool program.

5) then create one Tcode by chosing "Transaction with parameters( parameter transaction)".

6) in transaction field give "SM30", select the check box "Skip initial screen".

7) in the below of that screen you can find the "Default values" frame.

😎 there under the "name of screen field" select the "View name' and 'update".

9) in value column against to "view name" give you table name, and against to "Update" put 'X' in capital letters.

save it then you can straight away use this newly created Tcode to maintain your table.

Note:- 1) make the modification while saving the data into your table using this newly generated program to carry out your validation (even though it looks like standard program; no need to enter the access key).

2) if you do any changes to your table and press the activate button automatically the table maintenace generator will be goes off, you need to create this again.

Reward if useful.

Thanks,

Sreeram.