on 12-22-2015 6:31 AM
Hello Experts,
I have one requirement in a RFC to JDBC scenario, that first the data returned from BAPI will be Inserted in a Staging Table and after that one Stored Procedure will be executed from that same interface.
Is it possible to achieve this in a single interface using JDBC adapter?
Regards,
Sayanti
Hi Sayanti,
As Maheswarareddy Konda mentioned above if you are pointing to the same database you can do all the operations that you want in asynchronous interface in one shoot. If you let me a little advice i would wrap the bapi in the sender side with a Z RFC or Z Report to use a sender abap proxy to do this part of the communication.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yeah its possible,
you can create stricture like below,
<MT_root>
<StatementName1>
<dbTableName action=”UPDATE” | “UPDATE_INSERT”>
<table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2new</col2>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName1>
<StatementName2>
<storedProcedureName action=” EXECUTE”>
<table>realStoredProcedureeName</table>
<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName2>
<MT_root>
since you are thinking at a time only one should be executed , so i suggest you to maintain createIF (node function) condition for <StatementName1> and <StatementName2>
Note: to maintain above condition you should have one identical field to differentiate which statement should be executed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.