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.