‎2009 Nov 01 3:35 PM
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
‎2009 Nov 02 1:27 AM
Hi Joy,
Try this statement.
Thanks
Venkat.O
MODIFY z_r_data FROM TABLE it_rs_finel_usrs_data.
‎2009 Nov 01 3:54 PM
Have another look at the syntax for Modify when applied to a database table.
matt
‎2009 Nov 01 7:06 PM
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
‎2009 Nov 02 1:27 AM
Hi Joy,
Try this statement.
Thanks
Venkat.O
MODIFY z_r_data FROM TABLE it_rs_finel_usrs_data.
‎2009 Nov 02 6:26 AM
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?
‎2009 Nov 02 6:32 AM
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.
‎2009 Nov 02 6:41 AM
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