Skip to Content
avatar image
Former Member

Selecting/Deleting data from SAP CRM table

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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

    EMPLOYEE NAME

    Dave

    Mark

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

    Add comment
    10|10000 characters needed characters exceeded