Runtime Errors DBIF_RSQL_TABLE_UNKNOWN

[Former Member]

Dears,

I performed homogeneous system copy from production to my development server.

SAP release-ECC5,OS-Windows 2003 server,Database-Oracle 9i.

System copy has been completed successfully with all post configration steps:

But now I am getting dump while executing some tcodes like if i go to system->status it also gives

following dump:

Runtime Errors DBIF_RSQL_TABLE_UNKNOWN

Short text:

Table is unknown or does not exist.

What happened:

Error in ABAP application program.

The current ABAP program "SAPLSDH3"be terminated because one of the

statements could not be executed.

This is probably due to an error in the ABAP program.

Error Analysis:

An SAP Open SQL statement contains a table that does not exist in the

database or is not listed in the ABAP Data Dictionary.

The table is "M_MAT1A".

When I checked, I found that M_MAT1A is view.

Please suggest me how can i resolve the issue.

Shivam

[Former Member]

Hi

Oracle cannot find table "M_MAT1A".. This means that is is deleted... or that it was imported with a databse schema that is not SAPR/ or SAP[SID]...

First Check it out why this table has been missed.

Restart the server and try.

Regards

Bhaskar

[Former Member]

Hi Bhaskar,

I think you are correct that issue might be of database schema but not exatcly getting how.

I have done copy from prd SID-PRD to dev,SID-DEV.

Initally schema was SAPDEV and now it is SAPPRD.

but as data is also of prd so i am not confrm how it is related.how we can check.

Shivam

[Former Member]

Hi,

If you have executed the ORADBUSR.SQL script then the error is not due to SCHEMA.

And also confirm that you have the Kernel level same as your production server.

What is result of R3trans-d ??

Regards,

Satyabrat

.

Edited by: Satyabrat Mohanty on Jul 31, 2008 3:40 PM

[Former Member]

Hi

Check the return code of the R3trans -d.

or else

u have to login as sidadm and change some of the table entries.

any way paste the return code of the above.

Regards

Bhaskar

[Former Member]

Hi, Shivam.

Activate the view at SE11.

The error is because the view is created as a dictionary but it is not created on the database.

It is an inconsistency.

We face the same problem few days ago.

I guess you have solved this problem now.

Please share imformation if you find out what caused this problem.

Naomi S.