Skip to Content

Selecting/Deleting data from SAP CRM table

Apr 11 at 12:33 PM


avatar image
Former Member

Hi guys,

I came across I limitation I did not know about. It seems you cannot issue SQL commands down to SAP from within a DS script:

What I need to do, is to extract data from a Oracle 11g DB table into a SAP CRM table, but first I have to delete data from this table, all of it based on BODS parameters.


Delete from CRM.TabA where BODS parameter values

Select from Oracle.TabA --> Insert into CRM.TabA where CRM.TabB values

Is this a real limitation or I'm I doing something wrong? Any other ideas to achieve this?


aaa.png (11.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 11 at 04:00 PM

Isn't it even possible to assign multiples values to a global variable derived from a table, and use this variable to filter an query transform?

I'm surely doing something wrong, but a workaround I found to overcome my issue is:

CRM.TabA --> query transform --> Template table

My template table holds my filter values, and I can write an SQL in a script to get them, however it seems there is no way to get more than one value.

For example




How do you code the SQL statement to get both values in a Global variable within a script?

10 |10000 characters needed characters left characters exceeded