on 10-22-2008 9:25 AM
Hi Guys,
Im quite new in XI version 7.0. Can anybody help me about my problem.
I will do the tranformation of data from SQL ->XI ->R/3.
my main problem is when i tried to test the instance under message mapping at test tab
and paste the result from sxmb_moni under payload folder..
It doesnt see the values from sql ..this is the sample result.
(left side) (right side)
mt_travel bapi_salesorder_createfromdata2
>row >order_header_in
doc_type = ztrv doc_type = ztrv
sales_org = 400 sales_org = 400
distr_chan = 40 distr_chan = 40
division = 41 division = 41
sales_grp = 411 >order_partners
partn_role = SP partn_role = SP
partn_numbr = 0001110074
the result doesnt see my data for sales_grp and parnt_numbr..but when i tried to set the constant values
for sales_grp and partn_numb ..the result can see the value.
How can I solve this? Is there a problem with mapping?
Please help
Thanks in advance
aVaDuDz
are you copy pasting the inbound payload by selecting
view-->source
can you plz elaborate u r Qs?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rameshkumar ,
I tried to test the value of the result of payload folder under sxmb_moni and load to test instance at design integration (xml).
after testing i notice that the values that is not constant like sales_grp does not appeared to the result..unlike doc_type which
has a constant value equal to ztrv the result of the bapi for doc see.
Here is the sample scenario of the result :
travel upload bapi_createsalesorder
row order_header_in
doc_type = ztrv doc_type = ztrv
sales_grp = 400 order_partners
part_role = AG part_role = AG
part_numb = 001174
Im quite confused why the sales_grp and part_number fields that data coming from sql table is not seen by the result under bapi?
but when i tried to constant the values for sales_grp and parnt_numb ..the execution of the bapi is successful..
I tried to specify all mondatory fields..but only constant values can be seen by the result not the data from the sql.
so it is clear now ?
Please help.
<?xml version="1.0" encoding="utf-8"?>
<ns:MT_TRAVEL_SENDER xmlns:ns="HTTP://TRAVEL.COM/TRANSACTIONS">
<row>
<DOC_TYPE>ZTRV</DOC_TYPE>
<SALES_ORG>4000</SALES_ORG>
<DISTR_CHAN>40</DISTR_CHAN>
<DIVISION>41</DIVISION>
<SALES_GRP>411</SALES_GRP>
<SALES_OFF>4101</SALES_OFF>
<PURCH_DATE>10/20/2008</PURCH_DATE>
<PMNTTRMS>Z015</PMNTTRMS>
<PURCH_NO_C>AVADIUDS </PURCH_NO_C>
<PARTN_ROLE>AG</PARTN_ROLE>
<PARTN_NUMB>0001100074</PARTN_NUMB>
<INSERTED>0</INSERTED>
</row>
</ns:MT_TRAVEL_SENDER>
This is the test result
<?xml version="1.0" encoding="UTF-8"?>
<ns1:BAPI_SALESORDER_CREATEFROMDAT2 xmlns:ns1="urn:sap-com:document:sap:rfc:functions">
<ORDER_HEADER_IN>
<DOC_TYPE>ZTRV</DOC_TYPE>
<SALES_ORG>4000</SALES_ORG>
<DISTR_CHAN>40</DISTR_CHAN>
<DIVISION>41</DIVISION>
</ORDER_HEADER_IN>
<ORDER_HEADER_INX>
<UPDATEFLAG>I</UPDATEFLAG>
<DOC_TYPE>X</DOC_TYPE>
<SALES_ORG>X</SALES_ORG>
<DISTR_CHAN>X</DISTR_CHAN>
<DIVISION>X</DIVISION>
<SALES_GRP>X</SALES_GRP>
<SALES_OFF>X</SALES_OFF>
<PURCH_DATE>X</PURCH_DATE>
<PMNTTRMS>X</PMNTTRMS>
<PURCH_NO_C>X</PURCH_NO_C>
</ORDER_HEADER_INX>
<ORDER_PARTNERS>
<item>
<PARTN_ROLE>SP</PARTN_ROLE>
</item>
</ORDER_PARTNERS>
</ns1:BAPI_SALESORDER_CREATEFROMDAT2>
Hi Ram,
Occurrences of all fields in sender is 1.1 and the occurrences of receiver is base from the occurance of BAPI_SALESORDER_CREATEFROMDAT2
can i have your email add so i can send you the sample picture the mapping?
Its very difficult to explain it here ..hope SDN may allow to send attachment..?
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.