topic Re: inserting into table in Application Development and Automation Discussions

inserting into table

Former Member — Thu, 25 Sep 2008 08:27:08 GMT

Hi,

i have created 2 tables and i need to insert the records into them from screens. i have created my internal table according to the screen fields and also tables.but i'm getting a error message as

" The type of the database table and work area (or internal table)

"IT_HEADER" are not compatible. "

any help..

Re: inserting into table

Former Member — Thu, 25 Sep 2008 08:29:18 GMT

Can you pls share how you have declared

Regards

Re: inserting into table

Former Member — Thu, 25 Sep 2008 08:30:33 GMT

Hi,

I think your database table and internal table structure is different. just change your internal table field based upon database tabel and try.

Re: inserting into table

Former Member — Thu, 25 Sep 2008 08:32:17 GMT

Hi,

Use MOVE-CORRESPONDING to move the files from the Screen to the work area of first itab. This work area should be of the same type as ur first table.

The use MOVE-CORRESPONDING to move the fields of the Screen to the work are of the second itab. This work area should be of the same type as ur second table.

After moving the screen fields to the respective work areas, perform the insert operation on the 2 DB tables from its respective workarea's.

Best regards,

Advait.

Re: inserting into table

Former Member — Thu, 25 Sep 2008 08:33:36 GMT

my database table and internal table have same structure.

but in screens the fieldlengths is my concern..

in screen if the length has 18.

in table i have declared it as length is 14 and decimals 2..so ouput length is 18..is it the right way..

Re: inserting into table

Sathish — Thu, 25 Sep 2008 08:35:00 GMT

1. Check the definition of work area.

2. The fields in the table are not the same as fields in work area. Do check on this.

Re: inserting into table

satsrockford — Thu, 25 Sep 2008 08:35:48 GMT

Hi,

Check these demo programs

demo_dynpro_tabcont_loop.

demo_dynpro_tabcont_loop_at.

DEMO_DYNPRO_TABLE_CONTROL_1 Table Control with LOOP Statement

DEMO_DYNPRO_TABLE_CONTROL_2 Table Control with LOOP AT ITAB

to know more, read into

https://forums.sdn.sap.com/click.jspa?searchID=2934287&messageID=673474

Regards

Satish

Re: inserting into table

Sathish — Thu, 25 Sep 2008 08:37:09 GMT

Apart from being same structure, the field length should also match. Otherwise loop at the internal table and assign the value to the table field.

Loop at itab.

dbtab-f1 = itab-f1. (Or) move itab-f1 to dbtab-f1.

endloop.

Re: inserting into table

Former Member — Thu, 25 Sep 2008 08:40:54 GMT

Hi,

Declare like this....

No.of Characters : 13

Decimal place : 3

Now total output length : 18

Hope it will helps

Re: inserting into table

Former Member — Thu, 25 Sep 2008 08:47:55 GMT

Hi,

If its a decimal, then for lenght 14 with decimal 2 means,

12(whole number).2(decimal places)

You said you have declared a structure for the screen. Make sure that the data types used in that structure correspond to those used in ur underlying database tables.

Best regards,

Advait.

Re: inserting into table

Former Member — Thu, 25 Sep 2008 09:01:16 GMT

the visible length in the screen for the field is 18.

but it accepts only 13.its of type decimal in the screen..

then how should i declare it in the table for the field?

Re: inserting into table

Former Member — Thu, 25 Sep 2008 09:31:59 GMT

Hi,

Post your code segment for troubleshooting.

Regards

Karthik D

Re: inserting into table

Former Member — Fri, 26 Sep 2008 07:14:57 GMT

Hi,

1st of all when designing the fields in the screen press F6 to get the fields from the program. do not manually create any screen fields. otherwise there would be a lot of mismatch...