database updation

[Former Member]

i need to update the database from the internal table , my internal table contains only few fields refering to the database table fields , so when i am using stmt,

insert dbase values workarea.

it is saying workarea is not long enough.

[MarcinPciak]

Do like this:

"Define strucutre of your dbtable
TABLES: dbtable.

"Now move all corresponding fields of your work area to this structure
MOVE-CORRESPONDING workarea TO your_table.

"now you are able to insert the entry to dbtable from this db strucutre
insert dbtable from dbtable.

[former_member206439]

Hi

for data base updates you can do one thing

Use MODIFTY table from ITAB.

it will update the record values if that record already exsists and if not it will insert that record in to the data base

[abdul_hakim]

Hi

First Clearly explain you want to Insert into database table or Update a Database table.

If you want to update a particular field of database table use the below statement.

UPDATE <dbtab> SET field1 = value1 field2 = value2 WHERE field3 = value3.

Incase if you want to insert then.

DATA <workarea> LIKE <dbtab>.

*Fill the work area with the required fields and the use the below statement.

INSERT <dbtab> FROM <waarea>.

Cheers,

Hakim