2007 Oct 09 5:38 AM
Hi,
I have to fetch data from a view, unfotunately that view is a mainteance view. Is there any other way to select/fetch data from that view in my report program ?
Regards,
Bharath Mohan B
Hi,
I have to fetch data from a view, unfotunately that view is a mainteance view. Is there any other way to select/fetch data from that view in my report program ?
Regards,
Bharath Mohan B
2007 Oct 09 5:46 AM
Hi
You can't fetch data from the Maintenance View
You can only fetch data from Database View
Find the Transparent tables of that Maintenance View and try to fetch the data from that Tables related to that maintenance View.
Regards
Anji
2007 Oct 09 5:52 AM
Hi Anji,
Thanks for the inputs....... In the maintenace view there are a lot of transparent tables and join conditions used. I think it would be difficlut to fetch directly from the transp. tables.....
would it help if i create a database view....?
Thanks
Bharath Mohan B
2007 Oct 09 6:22 AM
Hi
U cannot access the data from maintanence view.
Only projection and database view can be used in ABAP code.
If u want to access the Data from more the one table , Create the DATABASE VIEW and use this view in ur program.
For example : UR Database view name is Ztest
in ur program
table Ztest.
select * from Ztest ***************
*******************UR Business Logic
<b>Reward if useful</b>
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |