Hello,
I'm setting up a sync SELECT query to a Receiver and I believe I have the XML-SQL formatted correctly. I ran the SQL and verified that it returns a record. The message processes and appears to send the SELECT XML-SQL to the database, but I never see a return message. Is there a step I'm missing for identifying the return message to XI? Below is the XML-SQL and my understanding of this structure will result in the following SQL statement.
SELECT * FROM PO_HEADER WHERE MANDT='040' AND EBELN='EP10000300' AND ACTION_KEY='C' AND CR_TIME='12:12:13' AND CR_DATE='20050505'
<?xml version="1.0" encoding="UTF-8" ?>
- http://xxx.com/usa/sap_appl/finance/po/">
- <SELECT_HEADER>
- <PO_HEADER action="SELECT">
<table>PO_HEADER</table>
- <access>
<MANDT />
<EBELN />
<ACTION_KEY />
<CR_DATE />
<CR_TIME />
<BSART />
<KDATB />
<KDATE />
<LIFNR />
<LIFNR_OA />
<EKGRP />
<EKORG />
<AEDAT />
<WAERS />
<BUKRS />
</access>
- <key>
<MANDT>040</MANDT>
<EBELN>EP10000300</EBELN>
<ACTION_KEY>C</ACTION_KEY>
<CR_DATE>20050505</CR_DATE>
<CR_TIME>12:12:13</CR_TIME>
</key>
</PO_HEADER>
</SELECT_HEADER>
</ns:PO_HEADER_in>