fetching of fields from a view

[Former Member]

Hi All,

Can we fetch the value of the fields from a view directly as we fetch from a database table in teh script?

Or is there any other way to be follwoed?

Pl help me out...

Regards,

Priya

[Former Member]

Done

[Vijay]

hi

the same way as we do in case of table.

infact in case of view also data is fetched from the table itself in the background.

regards

vijay

reward points if helpful

[Former Member]

Hey Vijay,

Thanks for the help but i have done the same as i fetched from a table..

suppose i have a field from view V_024-TELFX , I have written the code in teh script as

&V_024-TELFX&. But still even though there is the value in the view, itis not at all getting fetched in the script...

What can i dofurther? pl reply..

Regards,

Priya

[Former Member]

hi

write ur selectg query from VIEW put fatched data in any internal table then now put fields of this internal table on SAP script.

this may help u .

we can make same select query on VIEW as we do with DB Tables.

reward if helpful.

[Former Member]

Hi Priya,

It would help if you use the table T024 instead of the view.

Thanks,

Dishant.

[Former Member]

Hi

Selection conditions that are used as a filter can be defined for a view.

Specifying these conditions under the Selection conditions tab when creating a view in the dictionary would have an effect which is similar to specifying a where clause when writing a select query to restrict data.