Maintenance view and table in Oracle

[manthana_c]

Dear Experts:

I check in one field by press F1 and see Maintenance view  V_TIVCNCCTADD.

I wonder how to select this data in Oracle.

I connect as sqlplus / as sysdba.

I have try the select * from SAPSR3.V_TIVCNCCTADD;

but ORA-00942 table or view does not exist.

Please help.

[stefan_koehler · Accepted solution]

Hello Mandy,

that's normal. Maintenance views are not created on database level. You can verify this by using another (read only) view - these views are also created on oracle itself.

I guess SAP has decided for this handling, because of the "DML limitations" on views.

For more information - please check the documentation (Part "Using Views in Queries" and "Updating a Join View"): http://docs.oracle.com/cd/E11882_01/server.112/e25494/views001.htm

Regards

Stefan

[manthana_c · Accepted solution]

so which statement I should do in ABAP to read this maintenance view please.

[stefan_koehler · Accepted solution]

Hello Mandy,

you can perform a SQL trace (transaction ST05). Enable the trace, query the view V_TIVCNCCTADD via SAP R/3 and check the trace file for the generated SQL on the tables underneath.

Regards

Stefan

[former_member184059]

Dear Mandy,

SQL> select owner from DBA_VIEWS where view_name='V_TIVCNCCTADD';

SQL> select * from <owner>.V_TIVCNCCTADD;

Regards,

Rajendra Kielka

[manthana_c]

select owner from DBA_VIEWS where view_name='V_TIVCNCCTADD'

response is "no rows selected"

please help again.