table maintenance .....

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

Hi

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

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

[Former Member]

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

[Former Member]

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

[Former Member]

Thanx for the answer.

[varma_narayana]

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>

[Former Member]

Create a Sm30 view for the table and call the

FM

VIEW_MAINTENANCE_CALL

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

[Former Member]

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.