topic Open SQL Statement: Table AUFK does not exist. in Application Development and Automation Discussions

Open SQL Statement: Table AUFK does not exist.

Former Member — Fri, 01 Nov 2013 03:19:11 GMT

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,

Re: Open SQL Statement: Table AUFK does not exist.

venkat_aileni — Fri, 01 Nov 2013 03:34:08 GMT

Hi-

Check below link:

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

Thanks.

Re: Open SQL Statement: Table AUFK does not exist.

Former Member — Fri, 01 Nov 2013 03:37:14 GMT

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

Re: Open SQL Statement: Table AUFK does not exist.

Former Member — Fri, 01 Nov 2013 03:54:44 GMT

Problem solved. The connection hasn't been built.