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

Insert data in sap tables

Former Member
0 Likes
23,841

HI guru's,

Iam new to sap... un expectly deleted some entries from tables..i want to some fields in sap table: T030 how to add it.. plz send me example programm..

regards

JK

1 ACCEPTED SOLUTION
Read only

Former Member
7,475

Hi

Goto ->utilities->Table contents->create entries

7 REPLIES 7
Read only

Former Member
7,476

Hi

Goto ->utilities->Table contents->create entries

Read only

former_member188827
Active Contributor
7,475

u can create entries for dis table directly.

open table in se11.

go to utilities..>table contents..>create entries

and create ur entries.

plz reward points if dis helps

Read only

Former Member
0 Likes
7,475

hi,

Use Maintenance generator for that table..

then u can easily upload ur datas to tat standard table

Table Maintenance Generator (TMG) is a tool which is used to create a equipment by which customized tables created by end users can be changed as required,such as making an entry to that table,deleating an entry etc.

Go to SE11, give the table name and click on change. Then Go to utilities--> Table maintenance generator.

https://forums.sdn.sap.com/click.jspa?searchID=12043942&messageID=2272486

https://forums.sdn.sap.com/click.jspa?searchID=12043942&messageID=5019762

siva

Read only

Former Member
0 Likes
7,475

For mass data entry u can try tran. SE16n

Steps:

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

Janardhan,

one more amend reply to others i think you were talking also how to add fields into table right than you have to use append structure.

Amit.

Read only

Former Member
0 Likes
7,475

1. If u have access key u can add fields to the standard tables. (Goto Edit and do it if u have access key).

[OR]

2. Goto append structure -> create New append structure. Give your fields in the structure and activate it. Then activate sap table also in which u have added your fields.

[OR]

3. By program. Use insert or modify statement to add the fields.

Read only

Former Member
0 Likes
7,475

Hi Janardhan,

For entering data

Go to SE11, give the table name and click on change. Then Go to utilities--> Table maintenance generator.

After making Table maintenence generator,

Go back to table and again Go to utilities---> Create Enteries.

There you can add as many records as you want.

And for adding fields to an existing table,

you can open your table in Change Mode,

and there only you can add new fields.

If you want to insert any field in between two fields, Right Click on the second field and select Insert Line.

Reward if proved useful to you.

Regards

Natasha Garg