topic Re: add a new record in database table without using table maintance generator in Application Development and Automation Discussions

add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:10:44 GMT

Hi Expart ,

Plz. tell me how to add new record in database table without using table maintance ganerator ....give me one ex.

Regards

Bhabani

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:13:44 GMT

Hi Bhabaani,

Through the program you can enter records into database table.

take an internal table populate it with the data.

Now use Insert dbtable from table itab.

Regards,

Sujit

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:14:23 GMT

hi,

Use Modify Statement.

Regards

jana

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:14:57 GMT

Hi,

is this an SAP-table or an own table?

Regards, Dieter

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:15:53 GMT

Hi,

Try using INSERT query either record by record or total one internal table.

If you create a view based on this table, if you inert records in that view underlying database table also updated.

Regards

Ravisankar

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:22:06 GMT

Hi,

The other way to safely handle the modification of tables is through is by programs that can be done with SE38 or SE80.

To insert into database table we use INSERT statement :

1. To insert a single line into a database table, use the following:

INSERT INTO <target> VALUES <wa>.
INSERT <target> FROM <wa>.

2. To insert a several lines into a database table, use the following:

INSERT <target> FROM TABLE <itaba>.

Or even we can use MODIFY statementas this single statement is used to insert as well as update the records of database table.

MODIFY <target> FROM <wa>.
or MODIFY <target> FROM TABLE <itab>.

thanx.

Edited by: Dhanashri Pawar on Sep 10, 2008 12:25 PM

Edited by: Dhanashri Pawar on Sep 10, 2008 12:30 PM

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:22:23 GMT

declare an internal table of the structure of DB table.

Populate the internal table with data.

MODIFY <DBtab> FROM <int_tab>.

Re: add a new record in database table without using table maintance generator

former_member451655 — Wed, 10 Sep 2008 10:25:28 GMT

Hi ,

Its not recomonded to do this if its a SAP standard Table , hope you are reffering a Z table .

1). Goto Se16n

2). type &sap_edit in the Command field and press Enter

3). open the relavant Table , there you have additional data maintainace buttons ( create record , delete ..ect )

Hope this will be useful

Br ,

Dilum

Re: add a new record in database table without using table maintance generator

Former Member — Wed, 10 Sep 2008 10:37:14 GMT

Hi ,

use this syntax

MODIFY <Database-tab> FROM <int_tab>.

Thanks&Regards,

Naresh.