SELECT STATEMENT TO CAPTURE A VIEW!!!!

[Former Member]

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]

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]

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]

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]

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]

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

[Former Member]

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.