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

[Former Member]

Hi Expart ,

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

Regards

Bhabani

[Former Member]

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

[Former Member]

hi,

Use Modify Statement.

Regards

jana

[Former Member]

Hi,

is this an SAP-table or an own table?

Regards, Dieter

[Former Member]

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

[Former Member]

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

[Former Member]

declare an internal table of the structure of DB table.

Populate the internal table with data.

MODIFY <DBtab> FROM <int_tab>.

[former_member451655]

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

[Former Member]

Hi ,

use this syntax

MODIFY <Database-tab> FROM <int_tab>.

Thanks&Regards,

Naresh.