Multiple records error in Xacute Query, xMII 12.0

[Former Member]

Hi Gurus,

I am on xMII 12.0. I have a transaction where i am getting multiple line items from a BAPI is ECC system & want to display these on to the browser. I have an output parameter where I am passing all the values. In my tracer I can see all the values of the ouput parameters correctly being recieved from the bapi.

I have created a Xacute Query to display my transaction output on the browser & linked it with my transaction. I am expecting to get the same output as i get in the tracer on the IE screen but i do not get it. The output parameter gives me the values of the last record only. But on individually executing the transaction the same variable gives me all the values.

Can someone help please.

Thanks & Regards

Abhik

[Former Member · Accepted solution]

Hi

I have gone through your post and I think that the info provided by yu is not sufficent to answer yur question exactly but i would suggest yu the following solutions :-

1. It may be the case that yu are not looping on the Response XML from the BAPI. You need to loop on the repeating node of the Response XML of the BAPI and on each loop yu need to append the record read to a xMII Output XML document using Row structure. Finally Yu can assign the document to the Output variable.

2. Check for the type of Output Variable. I guess that it's String type. In that case, convert it to xml type.

Hope it helps.

Amit

[Former Member]

Hi Amit,

Thanks so much, you suggestion really helped, I have given you full points also.

However I have another question which is about the performance & will post it in another link.

Also thanks Christian for the help link.

Everyones help is appriciated.

Abhik

[Former Member]

Thanks guys for the extended help,

My transaction has the following steps in sequence.

1. JCO Interface to get details of BAPI (working fine)

2. Repeator looped on the response table with data.

3. Tracer on which global variable is displayed. In the Outgoing tab of the likns editor i am filling in the global variable (I have tried bothe types XML & String)

The records are getting displayed correctly on the tracer message but when i link this to a Xacute Query then i am getting only the last record. I understand that the variable is getting overwritten.

Amit I'll try to append all values to the row structure & then assign it to the output parameter of type XML. As from futher workings & your comments it sounds logical. I understand that the Xacute Query executes the whole transaction & gets the final value on to the screen so i get the last record only & this should solve when i always append the global variable in my transaction to the rowset. I will award the points once i finish the exercise. Logically i guess this should work.

Thanks a lot for you help guys.

Abhik

[Former Member]

http://help.sap.com/saphelp_xmii115/helpdata/en/Business_Logic_Services/IlluminatorDocument.htm

[Former Member]

Abhik

Is your output parameter type XML?