topic Re: modify problem in Application Development and Automation Discussions

modify problem

Former Member — Sun, 01 Nov 2009 15:35:13 GMT

hi ,

i want to modify DB table FROM table type (inside method ) and i get this error ,

any idea why ?

MODIFY TABLE z_R_DATA FROM it_rs_finel_usrs_data.

it_rs_finel_usrs_data IS TABLE TYPE

the error whicn i get is :

Field z_R_DATA is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement.

i cant use the term

tables z_R_DATA since in method

and when i try to

MODIFY z_R_DATA FROM it_rs_finel_usrs_data.

i get this error :

You cannot use an internal table as a work area.

Regards

Joy

Re: modify problem

matt — Sun, 01 Nov 2009 15:54:13 GMT

Have another look at the syntax for Modify when applied to a database table.

matt

Re: modify problem

Former Member — Sun, 01 Nov 2009 19:06:43 GMT

HI Matt,

Thanks ,

I take a look in F1 but there is no comments about modify table .

the database table and table type are almost the same except the Mandt field.

my question is if i can do modify for table from internal table .

Thanks again

Joy

Re: modify problem

venkat_o — Mon, 02 Nov 2009 01:27:56 GMT

Hi Joy, Try this statement.


MODIFY z_r_data FROM TABLE it_rs_finel_usrs_data.

Thanks Venkat.O

Re: modify problem

Former Member — Mon, 02 Nov 2009 06:26:59 GMT

Thanks ,

when i try it i get

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

"IT_RS_FINEL_USRS_DATA" are not Unicode convertible. convertible.

any idea?

Re: modify problem

Former Member — Mon, 02 Nov 2009 06:32:13 GMT

You should create a work area for your internal table.

loop at inernal table into wa.

modify ztab from wa,

endloop.

This will work fine.Use the name of your Z table and intarnal tables , I have just given an example.

Re: modify problem

Former Member — Mon, 02 Nov 2009 06:41:41 GMT

Hi,

Try this:-

MODIFY z_r_Data FROM TABLE T_RS_FINEL_USRS_DATA.

and make the type of internal table T_RS_FINEL_USRS_DATA as type Z_R_DATA to be able to use it diretly.

Otherwise you should loop it and use it from workarea.

Regards,

Subhashini