on 09-17-2009 11:22 AM
Hi Experts,
I would like to know how 'Insert' and 'Delete' operation can be performed on a table using Message Mapping. Where do we have to write the query and How should be the target structure to include 'action' and 'table' attributes?
Regards,
Vishal
Hi,
We can select the data from DATABASE for Lookup purpose in Msg mapping but can not be used stmnts like INSERT, DELETE;
In mapping program u can manupulate data after reading the original data ;
If u want normal structure of tgt using any SQL stmnt then it is like below one:
Stmnt name > ACTION > DB TABLE NAME > ACCESS > KEY ( WHERE COND).
welcome.
Deva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
After creating the Insert structure as suggested in the link,I was unable to confirm if the data is inserted as it showed 0 rows selected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As mentioned by Raj an advanced UDF will only help. You can't use jdbclookup here
Regards
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you check this help section : http://help.sap.com/saphelp_nwpi71/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm
Format is mentioned in there....map your action node accordingly to have a Insert, Update, Delete
Regards,
Abhishek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<?xml version="1.0" encoding="UTF-8"?>
<ns0:InsertTable xmlns:ns0="urn:abc:xyz:1.0">
<Insert>
<TableName Action="INSERT">
<Table></Table>
<access>
<ID></ID>
<DATE></DATE>
<FLAG>N</FLAG>
</access>
</TableName>
</Insert>
</ns0:InsertTable>
is the structure that I created for Insert statement. It doesn't throw any error in moni. But I am unable to see the data inserted in the table. Any modifications to be made in the structure?
Thanks,
Vishal
Hi Vishal,
<?xml version="1.0" encoding="UTF-8"?>
<ns0:InsertTable xmlns:ns0="urn:abc:xyz:1.0">
<Insert>
<TableName Action="INSERT">
<Table></Table>
<access>
<ID></ID>
<DATE></DATE>
<FLAG>N</FLAG>
</access>
</TableName>
</Insert>
</ns0:InsertTable>
Have you used this structure for insertion in message mapping? Or is it used in receiver DB side?
Regards
Suraj
Thank you..
http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=%28J2EE3414700%29ID0423606350DB1068935254051249519... blog is very helpful for inserting date..
Hi,
Yes you can,but you need to write advaced user defined function to conenct to data base and using statemnt object you can execute query.
cheers,
raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.