cancel
Showing results for 
Search instead for 
Did you mean: 

no values on test result

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

are you copy pasting the inbound payload by selecting

view-->source

can you plz elaborate u r Qs?

Former Member
0 Kudos

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.

Former Member
0 Kudos

can plz copy paste ur inbound xml and ur message type xsd for the same.

Former Member
0 Kudos

<?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>

Former Member
0 Kudos

<SALES_GRP>411</SALES_GRP>

is this filed mapped to the target filed?

what is the occurance of that fileds heade field?

or the target filed which you mapped is enabled or not?

regards

Rams

Former Member
0 Kudos

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..?

Answers (0)