Skip to Content
0
Former Member
Oct 20, 2011 at 01:10 PM

Capturing the result of an SQL Call in B1i

351 Views

I have used a SQL Call atom in a B1i-package.

You can see the SQL-statement below :

- <Payload id="atom1" method="Query Statement(Query Statement)" Role="C" disable-output-escaping="false"

sql="SELECT TABLENAME, FIELDALIAS, PK FROM OMLT WHERE TRANENTRY=445" mode="single"

system="0010000135">

- <ResultSet xmlns="urn:com.sap.b1i.adapter:jdbcadapter" rowCount="1">

- <Row>

<TABLENAME>OITM</TABLENAME>

<FIELDALIAS>ItemName</FIELDALIAS>

<PK>Item</PK>

</Row>

</ResultSet

</Payload>

I have defined a local variable TEST with the following link :

/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom1']/ResultSet/Row/PK

When I test this in debug I always get an empty value.

What could be wrong ? I donu2019t see it.

Thx,

Mario