How to read data in a program from a MAINTENANCE View

[Former Member]

Hi Experts,

Requirement:

1. I have maintained a maintenance view on three Database tables.

2.Data can be entered in the view as it is a Maintenace view as i have created maintenance generator for that and it is a requirement.

3. In one of my programs i need to read this data, into an internal table, that is maintained through this view.

Problem: When i am firing a SELECT query on this view, it goves me a syntax error that i cannot get data by select query on a Maintenance view.

Solution required for: Is there any way i can get the data from this Maintenance view.

Thanks in advance for your exteemed replies.

Regards,

Raghavendra Goutham P.

[Former Member]

Hi Experts,

Requirement:

1. I have maintained a maintenance view on three Database tables.

2.Data can be entered in the view as it is a Maintenace view as i have created maintenance generator for that and it is a requirement.

3. In one of my programs i need to read this data, into an internal table, that is maintained through this view.

Problem: When i am firing a SELECT query on this view, it goves me a syntax error that i cannot get data by select query on a Maintenance view.

Solution required for: Is there any way i can get the data from this Maintenance view.

Thanks in advance for your exteemed replies.

Regards,

Raghavendra Goutham P.

[Former Member]

Hi,

check out below link

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

Regards

Amole

[Former Member]

Hi,

Only projection view or database view can be used

in select query.

Find the tables used in view and

Select data into report program by

joining tables .

Regards

Amole