Skip to Content
0

Selecting/Deleting data from SAP CRM table

Apr 11 at 12:33 PM

23

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.

Basically,

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?

Thanks

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
0

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

EMPLOYEE NAME

Dave

Mark

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

Share
10 |10000 characters needed characters left characters exceeded