topic Re: Insert Statement in Application Development and Automation Discussions

Insert Statement

Former Member — Fri, 11 Jul 2008 14:22:09 GMT

I have retrieve data using 3 tables. here i used for all entries. Here i am displaying 80 fields. In read statement i move to all 80 fields.

Here i used insert statement directly append final internal table.

But it is not adding the records to final internal table.

Please tell me how to rectify this problem?

Regards,

lakshmi.

Former Member — Fri, 11 Jul 2008 17:05:19 GMT

check the order of fields.the structure of source internal table should be same as target internal table

Former Member — Fri, 11 Jul 2008 17:12:24 GMT

Can you show your code?

Former Member — Fri, 11 Jul 2008 18:03:17 GMT

Hi,

Check the value of SY-SUBRC value after each select statement in debugging mode

show your code so that we could give solution exactly..

Regards

Narin Nandivada

venkatasriram_mygapula — Mon, 14 Jul 2008 02:35:17 GMT

can you send your code.

Former Member — Mon, 14 Jul 2008 02:42:18 GMT

HI,

Use APPENDING FIELDS TO TABLE instead of INTO CORRESPONDING FIELDS OF TABLE.

This should work.

Regards,

Subramanian

Former Member — Mon, 14 Jul 2008 05:11:29 GMT

Hi sri,

Please make sure that you are appending the field properly..if possible please post your code too..

Regards,

bhumika