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

table maintenance task

Former Member — Mon, 28 May 2007 06:41:18 GMT

Hi everybody!

I am new to SAP and I need to do two tasks:

1. add records to table manually

2. create tolerance key for the table.

The thing is that I have just name of view... So I guess I need to find out table names that are related to view.... How to do it?

And after I have needed table, need to create table maintanance (if it is not created yet) and after adding records manually, need to create tolerance key.

Help will be rewarded!

Kind regards,

Mindaugas.

Re: table maintenance task

Former Member — Mon, 28 May 2007 06:42:54 GMT

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.

Reward points if useful

Regards

Anji

Re: table maintenance task

Former Member — Mon, 28 May 2007 06:43:50 GMT

Hi,

To find out the tables used in view, go to SE11, type view name, go to join conditions tab, you will find all the table used in the view.

Reward points if useful.

Regards,

Atish

Re: table maintenance task

Former Member — Mon, 28 May 2007 08:42:19 GMT

Hi,

thanks for the input, but what about tolerance key?

How to set it up?

BR,

Mindaugas