Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table Maintainance Generator

Former Member
0 Likes
1,355

Hi experts,

when i am doing the TMG for my customized table it is giving the heading as '+' . How to avoid this.

And also suggest me how to create tcode for this same.

Thanks in Advance,

Anil.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,324

Hi Anil,

To avoid this +, ensure the data element for your table field as all of the texts maintained.

Regards,

Nick

9 REPLIES 9
Read only

Former Member
0 Likes
1,324

Hi,

steps for table Maintenance

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.

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.

OR

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 -


X

VIEWNAME -


Name of your table

Save all these.

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

Regards,

Satish

Read only

Former Member
0 Likes
1,324
Read only

Former Member
0 Likes
1,325

Hi Anil,

To avoid this +, ensure the data element for your table field as all of the texts maintained.

Regards,

Nick

Read only

Former Member
0 Likes
1,324

i don’t know what function group you gave ,

i taking the table name and create function group in this name ,

and with it i create the Table Maintenance Generator.

now , goto to se80 , choose function group

and choose the one that you used to create

the table .

go to the screen and edit all the data you

want, headers , field length

Read only

Former Member
0 Likes
1,324

The data elements should have the texts maintained.

If they cannot be maintained, do it manually in the screen generated in the function group. Change the field labels in generated screen.

Read only

Former Member
0 Likes
1,324

Hi,

You can replace the own field heading instead of + in SM30, you just follow the below steps,

1.Goto Table Maintenance generator screen(which you have done already), get the function group which you used for this development and screen number(s). Make sure that this function group may be used by some other tables.

2.Goto SE80 and give the function group name in the left side and select display button, then it will give all the items under this function group.

3. Goto screens, and select the particular screen which you are using for this table, then double click on the screen number.

4.Select screen painter button in the application tool bar, then it will take to u to tcode se51, then after click on change button and double click on field headings which are coming in + symbol.

5.Next change the text for that field what exactly you want.

6. Save and activate it.

7. Open one new session with tcode SM30 and try to check.....

Hope if you do this then you can achieve....

Rgds,

Bujji

Read only

Former Member
0 Likes
1,324

Hi,

Assign data element for all fields of table.Otherswise u have to change manualy

L.Velu

Read only

Former Member
0 Likes
1,324

Thanks

Read only

Former Member
0 Likes
1,324

Hi Anil,

To avoid the "+" sign while maintaining the table via SM30 you must make sure that all the fields must be defined using a "Data Element". Data Element contains the semantics i.e. field labels which are used as column headers during Table maintenance.

Regards,

Danish.

.