topic Re: Table maintenance using SM30 help please in Application Development and Automation Discussions

Table maintenance using SM30 help please

Former Member — Tue, 09 Oct 2007 06:17:27 GMT

Hello experts,

I have a problem and maybe some one here know how to do this. I would be very grateful if some one could detailedly show me how to do.

My question is:

How to create a table maintenance transaction using SM30? I want to create a transaction using SM30 so that I could directly maintain a table using this transaction.

I would appreciate your help please.

Thank you.

Nadin

Re: Table maintenance using SM30 help please

abdulazeez12 — Tue, 09 Oct 2007 06:21:13 GMT

follow below steps

1) go to se11 check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers

this dialog box appears when you click on create

button

6) save and activate table

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.

Check these threads:

For further help look into these links

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

reward if helpful

Re: Table maintenance using SM30 help please

Former Member — Tue, 09 Oct 2007 06:21:50 GMT

Hi Ram,

Create the table using SE11.

Goto Utilities click on table maintenance generator.

Enter Authorization Group as &NC&.

then Enter the functional group. then click on "find scr number". it wil propose the number. then save it.

Now Go to se93 enter the T-Code click on create.

enter the Transcation as SM30. Then save it.

Thanks.

Re: Table maintenance using SM30 help please

Former Member — Tue, 09 Oct 2007 06:25:45 GMT

You need to create a "Parameter Transaction".

What this means is that you will have a transaction (let's call it "ZMAINT") which calls "SM30" and passes in your table name.

Go to transaction SE93 and enter your new transaction code. Enter in the Tcode description and choose "Transaction with Parameters" (it shouldbe the last radio button).

Enter in the default transaction "SM30" and tick the "Skip Initial Screen" check box. Hit Enter.

Now scroll to the bottom of the screen and you will see a Table Control where you will need to enter in the values to the SM30 selection screen.

Because you hit ENTER, the program will have loaded in the Selection Screen parameters into it's memory. Hit the drop down for "Name of Screen Field" and select "VIEWNAME" and then enter in your Z Table in the "Value" column.

Now go to the next line and hit the drop down and select "UPDATE" in the "Name of Screen Field". Enter in a "X" in the value column.

Now save the transaction and there you have it.

You need to create a Parameter transaction - In SE93 while creating the tcode, specify the last option (Transaction with Parameters or Parameter Transaction).

In the subsequent screen, under the Defaults block, specify the transaction as SM31 and select the check-box 'Skip initial screen'.

At the bottom of this screen, in the list you would specify the following-

Name of screen field -

Values

UPDATE -

VIEWNAME -

Name of your table

Save all these.

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

<b>Reward if usefull</b>

Re: Table maintenance using SM30 help please

Former Member — Tue, 09 Oct 2007 06:47:40 GMT

Thank you Shakir, Thank you Viji, Thank you N Naresh for your expertise on this subject. I would try this in the next coming days and I would then reward points for the closest of all answers.

Once more thank you.

Nadin

Re: Table maintenance using SM30 help please

Former Member — Tue, 16 Oct 2007 11:23:22 GMT

Hi every one who contributed to this thread. Naresh Nelapatla answer was the closest of all and it did indeed solve the problem. I have awarded all the points to Naresh Nelapatla . Thank you all once more.

Nadin