Table Maintenance Generator SAP ABAP INTERVIEW Questions

In this Post, we will discuss what is table maintenance generator?What is the use of it?

As all of you know, we can create database tables in SAP using transaction code
SE11. A table can be manipulated by a program or manually.

When creating table, you will find a check box 'Table maintenance allowed'. If we
check that option, we can manually enter entries using SE16 or table
maintenance generator screen.

SE16 is for data browser.

How to create table maintenance generator?
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?


Answer.

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.