2015 Jan 13 9:14 AM
Hi Experts,
Business users creates an XML file and store it in AL11 tcode.I have created an XI interface to send a file to file scenario but I need to know how to create an outbound proxy or a program to take the file from AL11 and send it to this XI interface so we can send it to the respective other part of the connection?
Thank you,
2015 Feb 01 5:48 AM
Hi,
I have used the Open data set and the file is read perfectly. But what I need is, I want to update a customized DB table before sending the file through the interface. So, can I write a code in the outbound proxy to update a Ztable with the file data then the interface will send it to the other side of the connection??
Thank you,
2015 Jan 13 10:03 AM
Hi Emam,
use OPEN DATA set to read al11 contents in read mode.
Then send the file as an attachemnt or individual fields.
check this link for creating and sending attachment+data through outbound proxy.
http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=240189709
Thanks,
Anil
2015 Feb 01 5:48 AM
Hi,
I have used the Open data set and the file is read perfectly. But what I need is, I want to update a customized DB table before sending the file through the interface. So, can I write a code in the outbound proxy to update a Ztable with the file data then the interface will send it to the other side of the connection??
Thank you,
2015 Feb 01 7:08 AM
Hi Eman,
Yes, you can do that. You can update Z table in this way.
2015 Feb 01 7:15 AM
Yes but how?. as in outbound proxy it doesn't allowing me to do the change?
2015 Feb 01 7:45 AM
Hi Eman,
I hope you have generated the proxy in your client.
For outbound proxies, you need to create a Z report and call the method generated in SPROXY.
In this Z report, you can update your Z table first and then call the method to send the data to XI.
You will get many tutorials on the same.
2015 Feb 01 7:50 AM
Here is the sample code:
DATA:
l_wa_proxy_invent TYPE zdt_nl_stock_inventories_stock, *---Proxy Structure
l_wa_output TYPE zmt_nl_stock_inventories, *---Output Data
l_i_proxy_invent TYPE zdt_nl_stock_inventories_s_tab. *---Table to pass to proxy
FIELD-SYMBOLS:
<l_fs_final> TYPE ty_final.
DATA:
l_o_proxy TYPE REF TO zco_l_nl_ops_proxy_stock_inven. *---Object for proxy class
*-Add Data to Proxy table
LOOP AT fp_i_final ASSIGNING <l_fs_final>.
IF <l_fs_final>-stock IS NOT INITIAL.
l_wa_proxy_invent-maitem = <l_fs_final>-matnr. *-----Material
l_wa_proxy_invent-maloc = <l_fs_final>-lgort. *-----Location
l_wa_proxy_invent-maavail_date = <l_fs_final>-hsdat. *-----Production date
l_wa_proxy_invent-maexp_date = <l_fs_final>-vfdat. *-----Best before date
l_wa_proxy_invent-maqty = <l_fs_final>-stock. *-----Stock
APPEND l_wa_proxy_invent TO l_i_proxy_invent.
ENDIF.
ENDLOOP.
IF NOT l_i_proxy_invent IS INITIAL.
l_wa_output-mt_nl_stock_inventories-stock_inventories =
l_i_proxy_invent.
TRY.
*-Create Proxy Object
CREATE OBJECT l_o_proxy.
CALL METHOD l_o_proxy->execute_asynchronous
EXPORTING
output = l_wa_output.
*Catch exceptions if any.
CATCH cx_ai_system_fault INTO v_sys_excep.
RETURN.
CATCH cx_ai_application_fault INTO v_app_excep.
RETURN.
ENDTRY.
COMMIT WORK.
ENDIF.