Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

modify problem

Former Member
0 Likes
722

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

1 ACCEPTED SOLUTION
Read only

venkat_o
Active Contributor
0 Likes
675

Hi Joy, Try this statement.


MODIFY z_r_data FROM TABLE it_rs_finel_usrs_data.
Thanks Venkat.O

6 REPLIES 6
Read only

matt
Active Contributor
0 Likes
675

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

matt

Read only

Former Member
0 Likes
675

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

Read only

venkat_o
Active Contributor
0 Likes
676

Hi Joy, Try this statement.


MODIFY z_r_data FROM TABLE it_rs_finel_usrs_data.
Thanks Venkat.O

Read only

Former Member
0 Likes
675

HI

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?

Read only

Former Member
0 Likes
675

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.

Read only

Former Member
0 Likes
675

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