Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data not getting Inserted and/or Deleted in DB. No error in channel.

Hi,

I am using the below structure for both 'Insert' and 'Delete' operation.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:InsertDeleteTable xmlns:ns0="abc:xyz">

<StatementName1>

<TableName Action="INSERT">

<Table>TableName</Table>

<access>

<ID></ID>

<DATE hasQuot="No"></DATE>

<FLAG></FLAG>

</access>

</TableName>

</StatementName1>

<StatementName2>

<Name Action="SQL_DML">

<access>delete statement</access>

</Name>

</StatementName2>

</ns0:InsertDeleteTable>

There's no error in the receiver channel, but the data is not getting and/or deleted fro the table. When I excluded the 'delete' structure, insert was happening properly. I would like to know if it's not possible to do both operations simultaneously from a single mapping.

Thanks,

Vishal

Former Member
Not what you were looking for? View more on this topic or Ask a question