topic Re: T-code for edit data from table in Application Development and Automation Discussions

T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:22:05 GMT

Dear cons

I want to edit some data from table. what is the T-CODE.

NRK

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:23:13 GMT

Hi,

tcode SM30

rgds

Paras

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:26:49 GMT

If the table has a table maintenance generator attached with it then use tran SM30/SE54 etc.

Otherwise SE16/SE16n etc.

Steps:SE16

Go to SE16 transaction

Give any table name and press Enter , Ex: MARA

Now execute (F8) this screen

Choose the record you want to manipulate and display (F7)

Go to Debug mode (/H) and press u2018Enteru2019 2 times

Change the value of the variable u2018CODEu2019. By default, it is 'SHOW'

Change the code value as 'EDIT' for modifications, 'INSR' for insert and 'DELE' for delete.

Steps:SE16n

Goto transaction SE16N

Give the table name

In command box write u2018&sap_editu2019 then press u2018Enteru2019

Press execute button

Regards,

Joy,

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:27:13 GMT

HI,

Is it a standard table or Ztable.

If Ztable:

GOto Se11

Enter table name

Click change

Click On Contents (CtrlShiftF10)

Press Execute

Select entry you want to change

Click On Table Entries--> Change(F6)

Change the Value.

If its a Std table.. Plz tell me the Table name

Regards

VIjay

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:27:33 GMT

Nirupama,

To update the data of any table, go to transaction SE16N, type u201C&SAP_EDITu201D. It will activate SAP editing function.

Esle.

Opern any record in SE16.Double click on the record so that all the fileds will be displayed in vertical format.

start debugging by /H

change the value of "code" to "DELE" and execute.

Amit.

Re: T-code for edit data from table

former_member787646 — Tue, 01 Jul 2008 07:28:37 GMT

Hi,

Using SE11 and SE16 trasaction codes you can change the

data in a table.

Hope it helps you.

Murthy

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:35:30 GMT

Hi,

write a module pool program to modify a record if it is a ztable. To modify several records write a bdc program for that transaction.

For standard tables write bdc program for the standard transaction (which is updating the record of standard table) to modify or edit several records.

Reward if useful.

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 07:42:08 GMT

Follow the steps given below:

1)Craete a TMG for the table through SE11.

2)Go to Transaction SE93.

3)Create the transaction as PARAMETER TRANSACTION (Last radio button).

4)Give transaction name as SM30

5)mark "Skip Initial Screen" as "X"

6)hit "Enter"

7)Mark the GUI support

8)Go to "Default values" section

9)Give the "VIEWNAME" = your view name

10)Give "UPDATE" as "X"

11)Save under a transport to production.

Re: T-code for edit data from table

Former Member — Tue, 01 Jul 2008 08:55:42 GMT

hi,

if your table having the table maintenance generator option.

then go to sm30 transaction.

there enter your table and edit waht ever you want.

Rgds,

Venkat N