topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

abdulazeez12 — Tue, 12 Sep 2006 18:21:37 GMT

Hii all,

I have created a ztable and want to use a new transaction (custom tcode) for the table maintenance. How can i do that. Can anyone give me steps of how to achieve?

Another thing is, is it possible to create a table with the name starting with Z_ ?

coz when i do that, a message is displayed stating that 2nd and 3rd places cannot have under-scores in names..

Thanks

Re: Table maintenance

Former Member — Tue, 12 Sep 2006 18:27:43 GMT

1) Create a table maintainance/View for the Z* Table.

Once you create the view goto SE93~~>Select Parameter transaction and give the short desc.~~>

Give the transaction as SM30(Skip the first screen-optional)~~>Check all check boxes under GUI support~~>In the default values(grid)section first row give the VIEWNAME as you created initially and the second row UPDATE as X.

2)The SAP naming convention reserves underlining in the second or third position for special objects. The object which you are processing does not belong to these special objects.

<b>Procedure</b>

Correct your entry. The second and third positions of the object name may not contain underlining.

Re: Table maintenance

Former Member — Tue, 12 Sep 2006 18:29:16 GMT

Hi,

GOTO SE93 Enter the transaction code..

Enter the description and choose " Transaction with parameters (paramter transaction)".

In the transaction enter SM30 and check the skip initial screen.

In the bottom of the screen for the default values enter the values..

<b>NAME OF THE SCREEN FIELD VALUE</b>

VIEWNAME ZTABLE

UPDATE 'X'

2) It is not possible to create a customer with 'Z_'.

Thanks,

Naren

Re: Table maintenance

Former Member — Tue, 12 Sep 2006 18:37:36 GMT

Suggestion,

If possible, make the transaction the same as the table name. That way, there is only one name to remember.

Rgrds,

Dan Perecky

p.s. Please indicate if helpful. Thanks.

Re: Table maintenance

Former Member — Tue, 12 Sep 2006 18:39:38 GMT

Hai Shakir,

1. specially function group.. what is its significance

When we generate table maintenance,

the system , based upon the table fields,

automatically,

generates

PROGRAM CODE, SCREEN FOR ENTERING DATA,

LOGIC FOR SAVING DATA, LOGIC FOR DISPLAYING DATA

ETC.

2. All this are BUNCHED under

a FUNCTION GROUP

(if you open that function group in se80, after

creatting table maintenacne,

u will see the program code, screens, gui status etc)

3. Hence, to BUNCH all these various objects,

SAP uses the concept of function group.

*----

4. And also why do we need to give two screens there

Its not necessary to have to screens.

5. ONE SCREEN MEANS:

only one screen with table control to enter data

TWO SCREEN means :

first screen : only primary key fields will appear

second screen : rest of the fields will appear to enter data

6. When the table consists of many fields,

its practically more convenient to have two screens,

so that all fields come vertically downwards.

(instead of scrolling horizontally in the table

control, in case of one screen concept)

The use of the FG is only this the Table Maintainance Generator part. Neednt be declared anywhere else.

yes u need to create a FG and the use it in Table maint. gen.

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

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

Table maintenance - parameter transaction:

Easier way is to regenerate the table maintenance.

In SE11 take the table and go in Change mode.

Then go to Utilities->Table Maintenance Generator.

In the next screen press the Change button. In the resulting

screen check the boxes

which are relevant and press enter.

Regards

Sreeni