Skip to Content
0
Former Member
Jul 13, 2005 at 03:09 PM

Receiver SELECT message?

21 Views

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>