topic Re: select data from view ( V_T856 ). in Application Development and Automation Discussions

select data from view ( V_T856 ).

Former Member — Thu, 16 Jul 2009 02:20:09 GMT

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.

Re: select data from view ( V_T856 ).

Former Member — Thu, 16 Jul 2009 02:33:54 GMT

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.

Re: select data from view ( V_T856 ).

Former Member — Thu, 16 Jul 2009 03:17:14 GMT

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