SAP KD

When you want to set up external database connection, you need to use DBCO Transaction.

When using DBCO you are setting up the properties for an external database.

REPORT ztest.

DATA: BEGIN OF wa,
ncust(40) TYPE c,
name(35) TYPE c,
END OF wa.

DATA: dbs TYPE dbcon-con_name.
DATA: con(20) TYPE c.
DATA : ls_wa LIKE wa.

con = ‘TREMS’. “DB Connection you made in DBCO

EXEC SQL.
connect to :con

ENDEXEC.

EXEC SQL.
GET CONNECTION :con
ENDEXEC.

WRITE : con.

EXEC SQL PERFORMING loop_write.
select ncust, name from cust into :ls_wa
ENDEXEC.

*
**&———————————————————————*
**& Form LOOP_OUTPUT
**&———————————————————————*
** text
**———————————————————————-*
FORM loop_output.
WRITE: / ls_wa-ncust,
ls_wa-name.
ENDFORM. “LOOP_WRITE ENDLOOP.