cancel
Showing results for 
Search instead for 
Did you mean: 

XAcute Query with Xml Transaction output

former_member190457
Contributor
0 Kudos

Hi all,

Transaction "getPOList" return as XML output parameter a list of Production Orders.

I want to display this list in a UI Grid Display Template so I create a XAcute Query which in turn references "getPOList"

I select the right xml output parameter in the "Transaction details" screen.

However when I test the XAcute query, the result screen is totally empty, not even the headers are showed.

The actual transaction return >300 records.

I expected to see at least the header in the test screen with all the PO properties, just the way it works with normal SQL queries.

Am I missing something?

The help doc is not really clear on this.

thanks, regards

Vincenzo

Accepted Solutions (1)

Accepted Solutions (1)

agentry_src
Active Contributor
0 Kudos

Hi Vincenzo,

Build your data into an MII XML Output document. This will put the data in the correct format (<Rowsets><Rowset><Row>).

Try that and let us know if that worked.

Thanks,

Mike

Answers (1)

Answers (1)

swapnil_mohite
Explorer
0 Kudos

Hi VINCENZO,

Check this blog

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6688] [original link is broken] [original link is broken];

I guess your requirement is same passing multiple items in one BAPI input.

Please check the Bapi request XML in repeater and confirm whether it is forming the right structure,.

Also check whether your transaction is giving the correct result as expected by u. Then pass the same inputs as transaction ones to the xacute query u have created.

Rewards points for answers.

Thanks

Swapnil