topic Re: Transfer data from SAP TABLES to a SQL table in Application Development and Automation Discussions

Transfer data from SAP TABLES to a SQL table

Former Member — Wed, 20 Sep 2006 13:44:20 GMT

Hi,

I need to transfer data from SAP tables to a SQL table. Please suggest the best way as well as the steps please.

Regards,

Kamlesh

Re: Transfer data from SAP TABLES to a SQL table

Former Member — Wed, 20 Sep 2006 13:55:58 GMT

Step 1: Create an entry for the External database in DBCON table using Trxn: DBCA.

Field Name Description Value (For: E.g.:)

CON_NAME Logical name

for database con RAJ

DBMS Database system MSS

USER_NAME Database user <username>

PASSWORD Password for setting up

the connection

to the database <pwd>/<pwd>

CON_ENV Database-specific MSSQL_SERVER=depotserver MSSQL_DBNAME=HOF_INDORE

DB_RECO Availability type for an open database connect

Then, you can define internal table and code the following way:

DATA: BEGIN OF wa,

c_locid(3),

c_locname(50),

c_locstate(5),

END OF wa.

EXEC SQL.

CONNECT TO 'RAJ' AS 'V'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'V'

ENDEXEC.

< Populate SAP data into an internal table >

Loop on itab.

EXEC SQL.

< code here for populating data into MS-SQL Server table>

ENDEXEC.

Endloop.

Regards,

Raj

Re: Transfer data from SAP TABLES to a SQL table

Former Member — Wed, 20 Sep 2006 14:14:37 GMT

Hi Raj,

DBCA transaction does not exit.

Re: Transfer data from SAP TABLES to a SQL table

Former Member — Wed, 20 Sep 2006 16:32:45 GMT

Hi Raj,

I am getting a runtime error

ABAP runtime Errors DBIF_DSQL2_CONNECTSTR_ERROR.

I suppose i am not getting connected. please help me out

Re: Transfer data from SAP TABLES to a SQL table

Former Member — Wed, 20 Sep 2006 16:37:07 GMT

EXEC SQL.

CONNECT TO 'test'

ENDEXEC.