terça-feira, 8 de fevereiro de 2011

SAP acessando banco de dados externo

  • Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical.
  • Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE
  • Using SVRMGRL>  (it's not a transaction.. it's a Oracle Utility)


create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)
drop table ZTABLE; (table dropped)
create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created)

  • Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN
  • Enter value in key fields and hit execute. (displays rows from the remote table)

Fonte: http://www.saptechies.com/how-to-access-an-external-database-from-abap-via-dblink-oracle/

Nenhum comentário :

Postar um comentário

Related Posts Plugin for WordPress, Blogger...