DBIF_RSQL_TABLE_UNKNOWN Table AUSPN_V1 does not exist in the database with ID R/3

[Former Member]

Hi All,

We are encountering numerous short dumps in our system caused by Table AUSPN_V1 does not exist in the database with ID R/3.

Can anyone advise how to solve the issue? Please find below portion of the short dumps.

Category               ABAP Programming Error
Runtime Errors         DBIF_RSQL_TABLE_UNKNOWN
ABAP Program           SAPLCLVF
Application Component  CA-CL-CL
Date and Time          11.06.2014 12:08:28

Short text
     A table is unknown or does not exist.

What happened?
     Error in the ABAP Application Program

     The current ABAP program "SAPLCLVF" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.

What can you do?
     Note down which actions and inputs caused the error.

     To process the problem further, contact you SAP system
     administrator.

     Using Transaction ST22 for ABAP Dump Analysis, you can look
     at and manage termination messages, and you can also
     keep them for a long time.

Error analysis
     A table is referred to in an SAP Open SQL statement that either does not
      exist or is unknown to the ABAP Data Dictionary.
     The table involved is "AUSPN_V1" or another table accessed in the statement.

Source Code Extract

Line  SourceCde

  104     if dupl = kreuz.
  105       insert auspc_v2 client specified from table auspcv2
  106                              accepting duplicate keys.
  107     else.
  108       insert auspc_v2 client specified from table auspcv2.
  109       if syst-subrc ne 0.
  110         message a585 with tabausp.
  111       endif.
  112     endif.
  113     refresh auspcv2.
  114   endif.
  115   read table auspcv3 index 1.
  116   if syst-subrc = 0.
  117     if dupl = kreuz.
  118       insert auspc_v3 client specified from table auspcv3
  119                              accepting duplicate keys.
  120     else.
  121       insert auspc_v3 client specified from table auspcv3.
  122       if syst-subrc ne 0.
  123         message a585 with tabausp.
  124       endif.
  125     endif.
  126     refresh auspcv3.
  127   endif.
  128   read table auspnv1 index 1.
  129   if syst-subrc = 0.
  130     if dupl = kreuz.
  131       insert auspn_v1 client specified from table auspnv1
  132                              accepting duplicate keys.
  133     else.
>>>>>       insert auspn_v1 client specified from table auspnv1.
  135       if syst-subrc ne 0.
  136         message a585 with tabausp.
  137       endif.
  138     endif.

  139     refresh auspnv1.

  140   endif.

  141   read table auspnv2 index 1.

  142   if syst-subrc = 0.

  143     if dupl = kreuz.

  144       insert auspn_v2 client specified from table auspnv2

  145                              accepting duplicate keys.

  146     else.

  147       insert auspn_v2 client specified from table auspnv2.

  148       if syst-subrc ne 0.

  149         message a585 with tabausp.

  150       endif.

  151     endif.

  152     refresh auspnv2.

  153   endif.

[Caetano]

Hello

Please check on transaction SE11 if this table exists and if it is active.

Also, it may be a database issue. What is your database?

BR

Caetano

[Caetano]

Hello

If you are using DB2 check this note:

1554750 - DB6: SQL0204N When Accessing a View Over an Existing Table

BR

Caetano