Open SQL Statement: Table AUFK does not exist.

[Former Member]

Hi,

I encountered a weird situation. At the code attached, I try to read data from another server, but an error states that table AUFK is unknow or does not exist. If I comment CLIENT SPECIFIED and CONNECTION (GC_CONT), everything works well. What's the problem?

Best regards,

ts

[venkat_aileni]

Hi-

Check below link:

http://help.sap.com/abapdocu_70/en/ABAPFROM_CLAUSE.htm#&ABAP_ADDITION_4@4@

Thanks.

[Former Member]

hi, T S,

Addition 4

... CONNECTION {con|(con_syntax)}

Note

This addition is for internal use only.
It cannot be used in application programs

Effect

The Open SQL command is not executed on the standard database but on the specified secondary database connection. The database connection can be specified statically with con or dynamically as the content of con_syntax, where the field con_syntax must belong to the type c or string. The database connection must be specified with a name that is in column CON_NAME in table DBCON.

The addition CONNECTION must be specified immediately after the name of the database table or after the addition CLIENT SPECIFIED.

Regards,

Archer

[Former Member]

Problem solved. The connection hasn't been built.