Table Main.. Mandatory fields

[Former Member]

Hi Frnds,

I crtd a ztable and i needs to do table maintenance. I read some threads i got idea how to do but i need to check before updating the table, one/two fields must have some data.

How can i do this. is there any option to click those fields mandatory user must enter some data.

Regards,

NK

[Former Member]

Go to SE11, give the table name and click on change. Then Go to utilities--> Table maintenance generator.

In the table maintenance generator screen, we should give Authorization Group, Function Group name (Function Group name can be same as table name), Maintenance type can be one step or two step, usually we will create with one step. we should give maintenance screen number. After clicking on create button, a table maintenance generator will be created.

To check it go to SM30 . In SM30, we find display, Maintain options.

We can view the table contents by choosing Display and we can create table entries by choosing Maintain.

Why we have to go for Table maintenance generator, when we can edit the table by SE16 or SE11, utilities->create entries?

In the production system, end-users will not be having access to transaction codes like SE11 and SE16. Developers will not be having access to many transaction codes including the above two.

To view the contents of the database table, we will use SE16n in Production system. Please find out the difference between SE16 and SE16n.All these authorizations will be maintained by BASIS team, by creating access profiles.

So in order to edit or create the contents of a database table, we should go for table maintenance generator. In real time, authorizations will be maintained in production system. (even in development and Test systems to some extent).

There is an audit like Sarbanes-Oxley Act for American clients, where every thing will be audited by government agency. To know more about SOX, use the links on the right hand side of this page.

The second reason is, we can edit or create multiple entries at a time, using table maintenance generator.

Apart from that we have options like 'Enter conditions' in table maintenance screen SM30. Please try to find out the use of those, by creating an example.Table Maintenance generator: Difference between one step and two steps.

While creating table maintenance generator, we find below options:

1. When we choose one step, we have to give the screen number in Overview Screen field.

2. When we choose two step, we have to give both overview screen number and single screen number.

You can give any number for screen. Don’t give 1000 screen number. As this number is reserved for selection screen.

When we choose two step, two screens will be created for table maintenance. For single step only one screen will be created.

When we choose two step, table maintenance will work as follows:

Go to SM30, give the table name for which you have created table maintenance-

Overview screen will be displayed. To create entries, when you click on ‘new entries’.

Another screen will be displayed, where you give input and save.

You can enter one record at a time.

We use single step generally, as it is user friendly.

To completely understand the difference and above points please do exercise by creating table maintenance generator in both ways (using single step and two step).

Reward if Helpful

[Former Member]

Hi Murali,

How can i put mandatory option for particular fields. i.e when user entering data some fields must have data.

Regards,

NK

[Former Member]

hi,

Just check the Key checkbox after entering the field name that u want to make it mandatory...

if u do this the user has to enter value for this field only then it 'll be processed.

Thanks,

Arunprasad.P

Reward if useful.

[Former Member]

Hi Arun,

Thanks for reply. Can u plz explain, actually i am in 4.5 version there is very low options.

Regards,

NK

[Former Member]

Direc method is

1.go to se80

2.select function group

3. give the function group that u used to genrate the table maintainence.

4. select the screen of ur table.

5. form the scrren layout double click on the field that u want to make it mandatory

6. in the attributes tab go to program in that

fo r input option give < required>

This will work

Thanks

[Former Member]

Hi

While Creating TMG, You will be providing some information in Maintanence Screen , there you have an option for doing your requirements.

Exactly on the Maintanence Screen -> After giving Screen Type.

Where you can see Overview screen & single Screen. Double Click over there , you will be entered through the Screen Painter Where you can select the Field attributes of the field you want to make mandate.

Program Attributes of Field mention as Reqd..

Thats it.

Regards

Rewards Points If its useful.

[Former Member]

Thanks for all...