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

T-code for edit data from table

Former Member
35,342

Dear cons

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

NRK

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
14,540

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.

8 REPLIES 8
Read only

Former Member
0 Likes
14,540

Hi,

tcode SM30

rgds

Paras

Read only

Former Member
0 Likes
14,540

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,

Read only

Former Member
0 Likes
14,540

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

Read only

Former Member
0 Likes
14,540

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.

Read only

former_member787646
Contributor
0 Likes
14,540

Hi,

Using SE11 and SE16 trasaction codes you can change the

data in a table.

Hope it helps you.

Murthy

Read only

Former Member
0 Likes
14,540

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.

Read only

Former Member
0 Likes
14,541

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.

Read only

Former Member
0 Likes
14,540

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