topic Re: Modify Database Table From Dynamic Internal Table. in Application Development and Automation Discussions

Modify Database Table From Dynamic Internal Table.

Former Member — Sun, 14 Oct 2007 14:00:12 GMT

Hi Experts,

Created a report which calls a RFC and gets data from Quality Server into Development server. Also creates dynamic internal table.

The RFC fetches data from Q server and comes to Dev Server, now I need to Modify database table in Dev Server with the data from Q Server.

Please Help.

This is the code which I use for Modify

*Declarations

FIELD-SYMBOLS: <outtab> TYPE ANY TABLE,

<l_line> TYPE ANY,

<l_field> TYPE ANY.

DATA: new_table TYPE REF TO data.

DATA: new_line TYPE REF TO data.

PARAMETERS: tab TYPE dd02l-tabname OBLIGATORY ,

****

loop at <outtab> into <l_line>.

modify (tab) from <l_line>.

endloop.

It gives a Error

"The types of the operands "dbtab" and "wa" are not mutually convertible."

Please Help.

Regards,

Raghu

Re: Modify Database Table From Dynamic Internal Table.

Former Member — Sun, 14 Oct 2007 16:11:13 GMT

Hi,

I dont think you can just modify by using modify (tab) from <l_line>.

I think you have to ASSIGN COMPONENT to the <l_field> and pass those values to the wa of the table you are trying to modify and finally modify the table.

I am not sure though...can give it a try.

Sri

Re: Modify Database Table From Dynamic Internal Table.

former_member195698 — Sun, 14 Oct 2007 17:01:53 GMT

If you have all your data in the table <outtab> you can directly modify the database table using the statement

modify (tab) from table <outtab>

Have you done the proper assignment of the field symbols to the required types?

Regards,

Abhishek

Re: Modify Database Table From Dynamic Internal Table.

Former Member — Mon, 15 Oct 2007 06:57:16 GMT

I have all data in the table <outtab>

i tried Modify (tab) from table <outtab>

but it gives me dump with error

"Alignment of lines in an internal table is not sufficient."

Please Help

Regards,

Raghu