topic Re: Data from View in Application Development and Automation Discussions

Data from View

Former Member — Thu, 12 Mar 2009 13:32:27 GMT

Hi All...

I need to extract data from a view (V_T511K) through the select statement. Can somebody advise me on this how it can be done?

Regards

Somu

Re: Data from View

Former Member — Thu, 12 Mar 2009 13:34:24 GMT

select fieldname1 fieldname2 from v_t511k into table your_internal_table.

Re: Data from View

vinod_vemuru2 — Thu, 12 Mar 2009 13:36:59 GMT

HI Som,

There is no difference between view and table in select query point of view. U can use same syntax and all addition of select query.

Thanks,

Vinod.

Re: Data from View

Former Member — Thu, 12 Mar 2009 13:38:29 GMT

Hi,

Thanks for your reply.

Could you tell me how to declare that view before extracting the data from that?

Regards

Somu

Re: Data from View

vinod_vemuru2 — Thu, 12 Mar 2009 13:41:28 GMT

Hi ,

View is a data dictionary object similar to database table.

U can create the view in SE11. Give some Zname and click on create. In next screen u can specify JOIN tables and JOIn conditions and output fields.

View doesn't store the data unlike database table. But when u execute the view, ABAP runtime creates INNER JOIN select query in back end and fetces the data from JOIN tables and display in the same a as when u execute the table.

Thanks,

Vinod.

Re: Data from View

Former Member — Thu, 12 Mar 2009 13:44:23 GMT

Total Questions: 8 (8 unresolved) - please follow up on your old questions

This is a maintenance view.

Re: Data from View

Former Member — Thu, 12 Mar 2009 13:47:43 GMT

Hi,

Declare an Internal table with the help of types,

eg.

TYPES: begin of t_itab.

.... all the fields of the VIEW.....

end of t_itab.

DATA: i_itab type standard table of t_itab, -

> Internal Table

i_itab_line like line of i_itab. -

> Work Area.

Now use the Select as u use for the Ztables and use this Internal table and the work Area.

Thanks and Regards

Suraj S. Nair.