topic Re: table maintenance ..... in Application Development and Automation Discussions

table maintenance .....

Former Member — Fri, 09 Nov 2007 18:53:09 GMT

Hi all,

I need to get a selection screen of 8 fields from a ztable. when i press F8 ,depending upon the selections , i should get a table maintenance screen (like sm30 screen) where i can delete,modify or update the ztable. Can anyone please give me an idea how to proceed with this. Points are rewarded.

Re: table maintenance .....

Former Member — Fri, 09 Nov 2007 18:56:45 GMT

You can do this through the table maintenance generator in SE11.

Rob

Re: table maintenance .....

Former Member — Fri, 09 Nov 2007 19:10:09 GMT

welcome to SDN forum

Create the table maintenance generator for that table as below and goto SM30 and enter the data

table maintanance Generator is used to manually

input values using transaction sm30

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.

Regards

Anji

Re: table maintenance .....

Former Member — Fri, 09 Nov 2007 22:09:25 GMT

Hi Kavitha,

I think Table maintenance generator will suits your requirement. But I am not understanding why you want to go through a selection screen and after executing, you want to have a screen to edit and then save to table.Directly you can use table maintenance know.

Anyway, please try the following for creating table maintenance if you need the steps.

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

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

Also, a helpful blog on this topic.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Hope this helps.

Thanks,

Srinivasa

Re: table maintenance .....

Former Member — Mon, 12 Nov 2007 11:34:03 GMT

Hi Kavitha,

From your question I understood that the table consists more than 8 fields,

If I am correct, I feel you need to gowith a custome transaction instead of tablematanance genarator. create an execuitable program with selection paramaters equal to the eight fields and just insert these field values into table. alll validation and checks you need to write.

thanks & regards,

Surya

Re: table maintenance .....

Former Member — Mon, 12 Nov 2007 18:21:40 GMT

Thanx for the answer.

Re: table maintenance .....

varma_narayana — Tue, 13 Nov 2007 04:02:48 GMT

hI Kavitha..

Try with Parameter Transaction:

Parameter Transaction can be created for Table Maintenance program of a Custom Table in SAP.

Steps:

1. Create a Z table and Activate - SE11

2. Generate the Table Maintenance using SE54

It will Generate the Function group and Screens.

3. Create a Parameter transaction to Call this Table maintenace program

Goto SE93.

Create a Tcode :

Name : ZTCODE1

Type : Parameter Transaction

In the Attributes of Parameter Transaction

Enter The Transaction SM30

Select the Checkbox : Skip first Screen

Enter the Following Fields below in the Table provide.

<b> FieldName FieldValue</b>

VIEWNAME <YOUR ZTABLE>

UPDATE X

Save the Parameter Transaction and execute it like ant other Tcode..

It will allow you to maintain the Table entries.

<b>reward if Helpful.</b>

Re: table maintenance .....

Former Member — Tue, 13 Nov 2007 09:29:59 GMT

Create a Sm30 view for the table and call the

VIEW_MAINTENANCE_CALL

by passing the view name nad update as 'X'.

Re: table maintenance .....

Former Member — Wed, 12 Dec 2007 15:09:09 GMT

Hi Gurus,

Varma,

I created a Parameter Transaction to maintain a Z table. I follow the steps that u mentioned. The thing is, whenever i add new entries, after saving, there is always the need to generate a transport order !! Is there any way to save de data without transport order ?

I think it has to do with the table attributes, but i already changed the "delievery and maintenance" options and technical settings, and it still ask 4 transport order !

Thanks in advance,

Mário.