can we create transaction code for a table

[Former Member]

Hello All,

Can we create transaction code for a table as we create a tcode for module programs.

IF yes pls let me knw how to go abt it.

Thanks,

Sunny

[varma_narayana]

Hi Suny..

Yes we can Create a Tcode to maintain the Ztable records.

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>

[gopi_narendra]

Follow these steps..

1. Go to transaction SE93 ,

2. Give the name of ur tcode say zxxxx, for maintaining your ztable.

3. Click on create button,now a page opens.

4. Choose the radio button Transaction with parameters (PARAMETER TRANSACTION).

5. In the next screen enter transaction as : SM30

7. Also check all the three check boxes for the GUI support.

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

Name of the screen field | value

___________________________________

VIEWNAME | your ztable name

UPDATE | X

Regards

Gopi

[Former Member]

Hi suny,

Yes u can create tcode for the table mainentance of a ztable

Its possible

first create a table mainentance for ur ztable

In se93 give ur ztable and

in viewname ztable

update X

<b>Regards,

Azhar</b>

[Former Member]

Hello Suny,

Table Maintenance generator is required to do Manual entries in the Table.

If the requirement is to update the table only programmatically

and not manually then table maint generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified )

using transaction SM 30, if the table maintenance for the table is generated.

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

chk a sample 1.

refer.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

******************

how to create a a T-code of that

Go to se93.

Then create the new T.code.

Under that select parameter Transaction.

Then give the sm30 in the t.code in default values tab.

check the checkbox skip initial screen.

in classification tab.

click checkbox inherit gui attributes..

Now below..

In the default values..

WRITE

viewname = give ur table name.

show = X

save and check it once...

now u can able to call ur table through ur new t.code...

Reward If Helpful.

Regards

--

Sasi.

[Former Member]

Hi.

Method 1:

create one z program and in it call the FM'

CALL FUNCTION 'TABLE_CUSTOMIZING_MAINTENANCE'

EXPORTING

tabname = tablename.

and save it and create the Tcode for this Z program.

Method 2:

Specify the Tcode name in SE93 and select the 'Parameter Transacttion' Option and specify the Tcode as SE30....

and also specify the default value... Here you need to specify your table name...

Satya,.

[Former Member]

Hi

Go to SE93 TCODE.

Need to Pass the transaction code as ZXXX.

Need to click on create buton.

Need to pass the development class as ZXX.

Need to pass the transaction text XXXXXXXXXXXX

Under transaction need to pass SM30.

Under default values pass below values.

Name of Screen Field Value

VIEW_NAME ZXXXXX(Table)

UPDATE X

Click on Save Button.

Reward points if useful.

Thanks & Regards,

Vasudeva Rao

[Former Member]

thanks