topic Re: can we create transaction code for a table in Application Development and Automation Discussions

can we create transaction code for a table

Former Member — Mon, 03 Sep 2007 09:00:45 GMT

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

Re: can we create transaction code for a table

varma_narayana — Mon, 03 Sep 2007 09:03:02 GMT

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.

FieldName FieldValue

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.

Reward if Helpful.

Re: can we create transaction code for a table

gopi_narendra — Mon, 03 Sep 2007 09:04:49 GMT

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

Re: can we create transaction code for a table

Former Member — Mon, 03 Sep 2007 09:07:03 GMT

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

Regards,

Azhar

Re: can we create transaction code for a table

Former Member — Mon, 03 Sep 2007 09:09:25 GMT

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%20implement%20events%20in%20table%20maintenance.doc

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

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.

Re: can we create transaction code for a table

Former Member — Mon, 03 Sep 2007 09:11:40 GMT

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,.

Re: can we create transaction code for a table

Former Member — Mon, 03 Sep 2007 10:01:28 GMT

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

Re: can we create transaction code for a table

Former Member — Mon, 03 Sep 2007 11:26:31 GMT

thanks