Skip to Content
Jun 21, 2021 at 03:43 PM

SAP PO JDBC SQL_DML statement built within mapping fails because quotes are removed

40 Views Last edit Jun 21, 2021 at 03:44 PM 2 rev

Hi experts,

I've built my query statement as per this help page.

The resulting xml is the following.

<?xml version="1.0" encoding="UTF-8"?>
<ns1:root xmlns:ns1="http://namespace">
		<table action="SQL_DML">
			<access>select [col1] as name1, 'A' as type, [.. sql statement ..] where date = '$Date$'</access>

The placeholders replacement works fine (I used '$<keyField>$' in the mapping as suggested in the help page).

But the jdbc receiver adapter removes my quotes. I need to keep them otherwise the query is not working. How can I do that?