07-16-2009 3:20 AM
Hi All,
i need to download transaction type and text from V_T856 , but the data is not selected from V_T856 view.
how to select data from a view, is there any special conditions.
i declared V_T856 in tables statement, even though select statement not exicuted.
pls suggest me with relevant information..
thank you
Regards
Ramesh.
07-16-2009 3:33 AM
hi ramesh,
using Select statement you cannot retrieve the data from view.
use the FM - VIEW_GET_DATA.
call function 'VIEW_GET_DATA' " func. mod to get data from maintenance view.
exporting
view_name = view
tables
data = gt_data.
Regards,
Sakthi.
07-16-2009 3:33 AM
hi ramesh,
using Select statement you cannot retrieve the data from view.
use the FM - VIEW_GET_DATA.
call function 'VIEW_GET_DATA' " func. mod to get data from maintenance view.
exporting
view_name = view
tables
data = gt_data.
Regards,
Sakthi.
07-16-2009 4:17 AM
Hi Rajesh ,
Since the view V_T865 is a Maint. view hence you cannot use select statement to retreive data from it , only database views can be used in select statements.
The solution i would suggest it to use a Join statement on T856 and T856T tables to get the data.
Regards,
Arun