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