How to Create a T-Code for a Table ?

[Former Member]

Hi,

I had a doubt - can we create a T-code for a user defined table.

Because in SE93 , there is no such specific option specified.

Kindly Clarify.

Advance Thanks.

[former_member186741]

use se80...create a transaction...click transaction with parameters and use SM30 as the basis....set VIEWNAME to the table's name and UPDate to X (no quotes)

[gopi_narendra]

Hi Harini

1. you need generate the table maintenance using the Menu Utilities->Table maintenance generator

2. give the authorization group, package, function group, overview screen number etc.

3.create the table maintenance

4. now go to se93

5. give custom tcode and say create

then enter description , and then

choose the radio button Transaction with parameters

6. now enter tcode as SM30 and check the check box skip intial screen

7. Check all gui support buttons

8. now go down and enter VIEWNAME from F4 help and value as table name

9. and add UPDATE(choose it from F4) and value as 'X'.

VIEWNAME ZTABLE

UPDATE X

and save it, now check the Tcode.

Regards

- Gopi

[Former Member]

First you need to create table maintenance generator for that table. Then create a view for that table and then you can assign a tcode for that view.

TCode can be created using transaction SE93. Use the last option 'Transaction with Parameters). Specify Transaction as SM30 and in the default values give field name as VIEWNAME and value as your DB table name.

Save and activate.

Now you can use this new TCode.

U can follow the below steps

1.SE11.

2.CHOOSE TABLE.

3.UTILITIES--->TABLE MAINT GENERATOR.

4.AUTH GRP : W/O AUTH.

5.FUNCTION GRP: PROJ DEPENDENT (SEE CREATE FUNC GROUP).

6.MAINT TYPE : 2 STEP.

7.MAINT. SCR NO. : CLICK APPL BUTTON | FIND SCR. NUMBER(S) |

8.CHOOSE PROPOSE SCREEN NO FROM POPUP.

9.REMEMBER OVERVIEW SCR NO.

10.CLICK CREATE BUTTON ON APPL TOOL BAR.

11.CLICK SAVE ON FUNC TOOL BAR.

12.GO TO SE93. TO CREATE TRANSACTION CODE.

13.WRITE SUTIABLE TRAN NAME..CLICK CREATE

14.CHOOSE TRANSACTION WITH PARAMETERS(LAST).

15.FILL SHORT TEXT.

16.OK

17.TRANSACTION : SM30.

18.CHECK SKIP INITAL SCREEN CHKBOX

19.SCREEN NO : FROM STEP 9.

20.IN TABLE BELOW

NAME OF SCREEN FIELD VALUE.

VIEWNAME [TABLENAME]

UPDATE X

21.SAVE

22.RUN TRAN CODE IN COMMAND BOX.

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

[Former Member]

HI,

you have created the view with utilities-->table maintanance.

the go to se93>select parameterized tansaction.>

give transaction sm30 and

check 'skip initial screen' and

in the table contol give

name of screen field value

VIEWNAME your table name

SHOW X(if you want to oepn in display

mode)

[Former Member]

Hey Harini,

Just follow the steps :

1. Goto SE93.

2. Create a Tcode with Start Object as 'Transaction With Parameters.

3. Give the Default value of transaction as 'Se11' or 'Se16' as per requirement.

4. Check the Checkbox 'Skip Initial Screen'.

5. For Default values give Name of screen field as 'Databrowse-tablename' and the value 'vbrp' or 'mara' as per requirement.

6. Save the Transaction.

Ravi

[Former Member]

hi,

Goto se80 , n locate ur table.

Right-click on the table and create -> transaction.

Choose the necessry gui attributes , Then

Name of the screen field Value

VIEWNAME (Table name)

UPDATE X

Transaction will be created.

[Former Member]

hi harini,

this is the way u create.

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

Or

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

-

---

Name of the screen field | value

-

---

VIEWNAME | your ztable name

SHOW | X

Save your work.

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'

with regards,

magesh