topic Re: SELECT * CONNECTION not work in Application Development and Automation Discussions

SELECT * CONNECTION not work

Former Member — Mon, 03 Mar 2014 03:03:55 GMT

Hi,

It is found that SELECT * does not work with CONNECTION. For example, I use the following statement to retrieve data from another system and an error states that SQL error 207 when accessing table 'MARA'. 'Invalid column name 'ANIMAL_ORIGIN''. If columns are specified, data can then be retrieved. The SAP BASIS version is 7.31.

SELECT SINGLE *

INTO CORRESPONDING FIELDS OF ls_mara

FROM MARA

CLIENT SPECIFIED

CONNECTION ('G01')

WHERE MANDT = '100'.

Re: SELECT * CONNECTION not work

custodio_deoliveira — Mon, 03 Mar 2014 03:41:14 GMT

Hi TS,

You gave the answer already, but look at the HELP:

To allow the Open SQL command to be run for the secondary database connection, the table definitions in the connection must be the same as those in the standard database.

Cheers,

Custodio

Re: SELECT * CONNECTION not work

Former Member — Mon, 03 Mar 2014 04:29:32 GMT

Hi Custodio,

Thanks for you prompt reply, but would you please elaborate more? If I use the same statement to retrieve data from table MAKT, it works.

Thanks,

Re: SELECT * CONNECTION not work

custodio_deoliveira — Mon, 03 Mar 2014 04:52:34 GMT

Hi TS,

What I mean is, check if the structure of MARA is the same in both systems. I believe it's not and that's why SELECT * fails.

Cheers,

Custodio

Re: SELECT * CONNECTION not work

Former Member — Mon, 03 Mar 2014 06:24:16 GMT

Hi Custodio,

Thanks.

Re: SELECT * CONNECTION not work

ThangaPrakash — Mon, 03 Mar 2014 07:41:12 GMT

Hi TS,

Have you checked whether your database connection G01 exists in DBCON table to check whether there is a existing database connection with that name.

Regards,

Thanga