topic Re: data base update.. in Application Development and Automation Discussions

data base update..

Former Member — Thu, 04 Oct 2007 06:01:30 GMT

hi al,,

i am updating my database table by internal table.

but its giivng me a error"""

"ie..the workarea internal table is not long enough?

can u give me a relevant answer?

thnkx

bhanu

Re: data base update..

Former Member — Thu, 04 Oct 2007 06:03:10 GMT

Hi,

Declare work area & internal table same as the Database table

data : watab type ztable,

itab type standard table of ztable.

************

DATA scarr_wa TYPE scarr.

scarr_wa-carrid = 'FF'.

scarr_wa-carrname = 'Funny Flyers'.

scarr_wa-currcode = 'EUR'.

scarr_wa-url = 'http://www.funnyfly.com'.

INSERT INTO scarr VALUES scarr_wa.

Best regards,

Prashant

Re: data base update..

Former Member — Thu, 04 Oct 2007 06:04:29 GMT

hi,

when are you getting this error.

can i know which table you are updating.

first try updating single record from selection screen parameters..

then go for the whole it_table.

Re: data base update..

Former Member — Thu, 04 Oct 2007 06:04:34 GMT

Hi ,

The work area u created is not correct,

Try to create a work area using types statement

example: types: begin of ty_w,

matnr type mara-matnr,

end of ty_w.

then create a workarea.

i.e data: wa_work type ty_w.

as u might be declaring workarea right from table ie

example wa_work type databasetable

so the porblem is coming.

regards,

Santosh Thorat

Re: data base update..

Former Member — Thu, 04 Oct 2007 06:05:48 GMT

Hi Bhanu,

Your internal table and workarea structure should be exactly same as that of database table. Please check this.

Regards,

Archana

Re: data base update..

varma_narayana — Thu, 04 Oct 2007 06:06:30 GMT

Hi Bhanu..

The internal table / Work area must have the Same structure as the DB table.

Then only we can INSERT the records.

So check this Eg:

DATA it_carr TYPE table of scarr with header line.

it_carr-carrid = 'XX'.

it_carr-carrname = 'Test Airline'.

it_carr-currcode = 'INR'.

append it_carr

INSERT SCARR from table IT_CARR accepting duplicate keys.

REWARD IF HELPFUL.