topic Insert data in sap tables in Application Development and Automation Discussions

Insert data in sap tables

Former Member — Wed, 02 Jul 2008 06:07:31 GMT

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

Re: Insert data in sap tables

Former Member — Wed, 02 Jul 2008 06:14:03 GMT

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

Re: Insert data in sap tables

former_member188827 — Wed, 02 Jul 2008 06:14:51 GMT

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

Re: Insert data in sap tables

Former Member — Wed, 02 Jul 2008 06:16:08 GMT

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

Re: Insert data in sap tables

Former Member — Wed, 02 Jul 2008 06:20:04 GMT

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.

Re: Insert data in sap tables

Former Member — Wed, 02 Jul 2008 06:27:15 GMT

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.

Re: Insert data in sap tables

Former Member — Wed, 02 Jul 2008 06:40:14 GMT

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.

Re: Insert data in sap tables

Former Member — Wed, 02 Jul 2008 07:15:42 GMT

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