What is Table Maintenance Generator . What is 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.

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:


When we choose one step, we have to give the screen number in Overview Screen field.
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.

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

Go to SM30; give table name for which you have created table maintenance-
Overview screen will be displayed; To create entries click on ‘new entries’, you can
enter the records on the same screen. You can enter multiple records 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).

Other Related Topics :

What is a check table and What is a value table?
What are matchcodes? Describe?
What are ranges? What are number ranges?
Transparent table?
Cluster table?
Pooled table?
Structure?
Type of a table or structure?

ABAP Dictionary?

Click Here to Read More !!!!

Data structure Format

1) A format (noun, pronounced FOHR-mat) is a preestablished layout for data. A computer program accepts data as input in a certain format, processes it, and provides it as output in the same or another format. All data is stored in some format with the expectation that it will be processed by a program that knows how to handle that format. Generically, data formats tend to fall into bitmaps (strings of 0s and 1s) that describe images or sound patterns (or both), text formats (in which usually each byte value is mapped to a character), and numeric data formats (used by spreadsheet and other database programs).



A hard disk or other storage device is also said to be formatted when its space has been organized and divided into pieces that can be controlled for convenient storage and access. For example, a hard disk may be formatted into areas called sectors, tracks, and clusters.

2) To format (verb) a document or file for printing or displaying is to add the necessary information to it so that the output device will know how to present the output.

3) To format (verb) a hard disk or diskette is to set up the space divisions on the medium and initiate a space allocation table that will know exactly how to reach each bit of data that may be stored there later.

Click Here to Read More !!!!

Data structure

A data structure is a specialized format for organizing and storing data. General data structure types include the array, the file, the record, the table, the tree, and so on.


Any data structure is designed to organize data to suit a specific purpose so that it can be accessed and worked with in appropriate ways. In computer programming, a data structure may be selected or designed to store data for the purpose of working on it with various algorithms. Click Here to Read More !!!!