ABAP NATIVE SQL and DB Link

NATIVE SQL and DB Link  

DB Link means the connection between Database systems. It also enables connection between servers which are located in other place physically.

Below is the standard DB Link statment.

Table Name@DB Link Name

You can select data from remove DB by DB link

EXEC SQL.     SELECT matnr FROM MARA@ SERVER2 ENDEXEC.

You should ask BC(Basis Consultant) to create DB link. then, BC would use below statement.

CREATE [public | private] DATABASE LINK (name) CONNECT TO (id) IDENTIFIED BY (password) using '(connection name)';