SELECT * CONNECTION not work

[Former Member]

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'.

[custodio_deoliveira]

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

[Former Member]

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,

TS

[custodio_deoliveira]

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

[Former Member]

Hi Custodio,

Thanks.

[ThangaPrakash]

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