Data from View

[Former Member]

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

[Former Member]

select fieldname1 fieldname2 from v_t511k into table your_internal_table.

[vinod_vemuru2]

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.

[Former Member]

Hi,

Thanks for your reply.

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

Regards

Somu

[vinod_vemuru2]

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.

[Former Member]

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

This is a maintenance view.

[Former Member]

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.