Skip to Content
avatar image
Former Member

Is new opensql available in bw routines ?

Hi,

I'm creating a transformation on a bw 7.4 SP8 and I was wondering if I could use new opensql in a start routine.

I did the following :

*$*$ begin of 2nd part global - insert your code only below this line  *

DATA: s_C_MYINFOOBJ TYPE RANGE of /BIC/OIC_MYINFOOBJ.

...

...

*$*$ begin of routine - insert your code only below this line        *-*

SELECT   C_MYINFOOBJ as low,

        'I' as sign,

        'EQ' as option

into corresponding fields of table @s_C_MYINFOOBJ

FROM ZDEL_MYINFOOBJ_LIST.

DELETE SOURCE_PACKAGE WHERE MYSOURCEFIELD IN s_C_MYINFOOBJ.

When I check if the syntax is correct, i have no error. But when I try to activate the transformation, it says that there's an error in the start routine.

Is there really something incorrect in my code or new opensql is not allowed in BW transfo?

Thanks for your help

Christophe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 14, 2015 at 06:47 PM

    Hi Christophe,

    I suggest to move your coding under the comment line:

    *$*$ begin of 2nd part global - insert your code only below this line  *

    DATA: s_C_MYINFOOBJ TYPE RANGE of /BIC/OIC_MYINFOOBJ.

    ...

    to another place:

    *$*$ begin of global - insert your code only below this line  *

    The 2nd part of global is not part of the new ABAP Objects framework for 7.0 Transformations. It is meant as a migration area for obsolete 3.x Transfer Rules/Update Rules. You can refer to SAP Note 1052648 - Migrating transfer rules and update rules for BW7.x for more information.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Christophe

      Where did you find this coding example?

      Although I am not familiar with your programming example, I expect that it should also work in the context of a BW Transformation.

      However, let's check it. I suggest to make a small custom program using t/code SE38 and test the coding here. I use this approach regularly to be sure that my syntax is correct and it's very easy to debug it from here.

      Please share your findings. Thanks in advance.

      Best regards,

      Sander