Skip to Content
Former Member
Jan 15, 2015 at 02:12 PM

SAP HANA Expert Script Lookup


Dear all,

I'm trying to create a sap hana expert script for a transformation from a DSO to another DSO. Starting with a 1:1 transformation works fine, but when I try to create a complex hana expert script with lookup from other database tables (like I would do in a endroutine of a standard transformation), I can't activate the transformation.

Here my problem:

I created the transformation and started to create the hana expert script.

I want to read additional data from a database table called "ZPROD". In my hana expert script i added a new line with the code:

lt_tab = select * from ZPROD;

Now an error for this line occurs with the message, that I have to declare additional tables in the method statement. I've done this with the key word USING and afterwards the table name. This works and I didn't get any errors, so I can save and activate the hana expert script.

But after activating the script, my transformation returns to a standard transformation when saving it. It seems, that the relation to the hana expert script is lost. This happens everytime I add something to the method statement.

Do you have any idea to solve this problem? Is my way to do a lookup wrong?

Thanks for some informations!

PS: I use SAP BW 7.4 with SP9 and HANA SP8.