on 04-13-2009 2:20 PM
Hi Experts,
Our requirement is after creation of Purchase Order No. in SAP we have to transport that no. to another database which is same as our SAP DB( that is Oracle 10G).
Please help me to do that....
Eagerly waiting for reply.
Thanks & Regards,
Biswajit
Hello Biswajit
Please make your question little more clear, as your SAP sytems must be residing on some DATABASE like oracle9i or 10g or db2, and what this other database oracle 10g, what is the application on it ?
thanks
Bhudev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Actually the thing is there is an Java related application from which we are transporting data to SAP via JACO.
but we need to transport data also from SAP to that application in run time . That we can not do via JACO coz it only works while JAVA to SAP connection is made but we need to transfer data from SAP to java even when JAVA to SAP via JACO is not connected .
I want to know how can we do that?
Here is simple flow....
Application1
JAVA--
>SAP
return
DB<--JAVA<
|
Here JACO is always needed to connect SAP.....
But our requirement is
Application1
DB<----
SAP
(not via JACO)
Waiting for reply...
Thanks ........
Hi,
1. you would define a remote database connection to your non-SAP Oracle DB via DBCON transaction.
2. Use this connection i.e. in an ABAP FM that connects to the Oracle DB
3. Update the table(s) via the connection
i.e. in your SAP database via DBCON you defined a connection ORADB pointing to your remote Oracle DB:
Later you use this conenction in an ABAP Function module:
...
EXEC SQL.
CONNECT TO 'ORADB' AS 'ODB'
ENDEXEC.
EXEC SQL .
Insert into oradb_table values (:your_SAPdata_field1, :your_SAPdata_field2 )
ENDEXEC.
EXEC SQL.
CLOSE 'ODB'
ENDEXEC.
...
you need some program skills in native SQL with Oracle
Check for DBCON , native SQL, remote database connection
bye
yk
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.