topic Re: SELECT STATEMENT TO CAPTURE A VIEW!!!! in Application Development and Automation Discussions

SELECT STATEMENT TO CAPTURE A VIEW!!!!

Former Member — Fri, 16 Feb 2007 21:05:57 GMT

DEAR ALL,

I have an issue where I have to capture data from a maintanance view and I am not sure how to acomplish that.

V_TROLZ01 in the maintanance view and I am not able to read from this view.

SELECT * FROM V_TROLZ01 WHERE ALAND = 'US'

AND AZONE = 'MINSTER'

AND LLAND = 'US'

AND LZONE = 'JACKSON '

INTO ITAB_PLAN.

can any one suggest me some sample code to accomplish this

Former Member — Fri, 16 Feb 2007 21:12:45 GMT

Hi,

You can use select statement only for database tables, projection view or database view.

You cannot use select statement on maintenance view..

Thanks,

Naren

Former Member — Fri, 16 Feb 2007 21:16:28 GMT

Hi,

You can get data from the underlying SAP databases (TROLZ, TTGR, ...) but not from V_TROLZ01 which is a maintenance view.

Please use select inner join statement between table TROLZ and TTGR on the TRAGR field for example.

Regards,

Ferry Lianto

Former Member — Fri, 16 Feb 2007 21:26:44 GMT

Hi,

maintenance view doesn't allow to retrieve data by select stmt. So u can get data by joining all table as view has done.

Former Member — Fri, 16 Feb 2007 21:32:41 GMT

Hello,

Maintenance View are used to create the Table maintenance for a table .

You might come across the SM30 of a table. For this a maintenance view is used. So you cant retrieve data from M view...

Vasanth

Former Member — Mon, 19 Feb 2007 20:56:44 GMT

can some one please give examples of the select innerjoin statement to acpomplish the task of finding the route

Former Member — Mon, 19 Feb 2007 21:02:41 GMT

I think you can just Select from TROLZ, it has all the fields that you are using.

SELECT * FROM TROLZ
WHERE ALAND = 'US'
AND AZONE = 'MINSTER'
AND LLAND = 'US'
AND LZONE = 'JACKSON '
INTO ITAB_PLAN.