Table maintenance

[Former Member]

hi all,

i want to create a table maintenance for a table by selecting the following..

maintenance type -

---

two step

overview screen --0.

single screen --0.

is this possible.....

can we give both overview screen and single screen 0??

plz help me.

thanx,

shivaa.

[Former Member]

No u can't also u can't give 1000 as screen number.they were two different screens

[Former Member]

hi k.p.n,

thanx for yor reply.

can you please elaborate why cant we create a table maintenance with

a. maintenance step--- two type,

b. overview screen --- 0,

c. single screen --- 0.

when i try to create with above selections , the table maintenance is created.

but, when i got to sm30, and click DISPLAY/MAINTAIN , i get RUNTIME ERROR---

PERFORM_NOT_FOUND.

plz help me.its very urgent.

[Former Member]

Hi Shiva,

The purpose of table maintenance generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utilities->table maintenance generator

You need to enter the values of following fields:

1. Table name

2. Authorization group, and authorization object (select the suitable one)

3. Function group and package

4. Maintenance type: single or double screen maintenance view depending on the option selected.

5. Maintain screen number: you may specify a value or let the system generate one for you.

The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only, by adding suitable code in the logic or directly disabling the input in table control in the layout.

Table maintenance is for creating, adding data to an existing table.

it is for adding multiple records at a time in the table

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.

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.

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 steps, 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.

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).

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

/message/2831202#2831202 [original link is broken]

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

Regards.

Eshwar.

[Former Member]

hi shiva,

you can create with your requirement defently.....

pls see the below link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-87652872...

thanks

karthik

reward me if usefull

[Former Member]

Hello Shiva,

If you are using the 'Two Step' maintenance type for your table/view, it means you need an overview screen, as well as a detailed screen.

Therefore, quite obviously you need to give two different screen numbers in the SE54.

Moreover, you seem to be getting the error PERFORM_NOT_FOUND. This doesn't seem likely to be from the screen, but rather from some missing Event definition.

Plz goto SE54, enter view/table name, and goto Environment -> Modifications -> Events. Here, see if you have maintained some event and a FORM ROUTINE name for it. You have probably not created this form routine though, inside the include.

In such case, either delete this event entry, or create the form routine and activate the same.

The error should be eliminated.

Regards,

Rekha

[Former Member]

Hi,

You can select ONE STEP or TWO STEP.

If you give ONE STEP then you have to provide only one screen number other than 1000 which is a standard selection screen number.

If you use TWO STEP then you have to give 2 different screen numbers.

The main difference between these two is that if you use one step, you get only one screen for display and create entries where as in other it is not the case.

You cannot use 0 as screen numbers.

Reward points if helpful.

Thanks and Regards.

[Former Member]

Hi Siva,

its not possible to use 0 as screen number

when creating tablemaintenance you will have two options

1)single step

2)two step

single step:In single step you have to specify the overview screen only.but you can give 1 to 999 only.1000 is reserved for sap standard screen.the important thing you have to notice is you are not able to use a screen number which is already used for another table.

two step:here you have to specify overview screen and single screen both but must be different and you have to notice is you are not able to use a screen number which is already used for another table.

rewards points if helpful.