Call custom method within BW Transformation AMDP

[josheuesden]

Hi

I am trying to write some SQLScript to assess the performance improvement to replace an ABAP end routine.

The end routine works out the ageing of debtors based on the netduedate of the transaction.

I realise that row by row operation is not the recommended course for an AMDP but wanted to see if it was possible.

The approach I took was to write a procedure with a method so that I could pass the unique dates, calculate the difference to the current date then pass a table back with the date and the day difference. Then I could join the InTab in the procedure with the returned table based on the netduedate and populate the age.

When I try to call the procedure in the AMDP using the syntax CALL "<Class>=><Method>(Parameters)"; the code activates successfully however I then get a number of errors when activating the transformation, below, when I comment out the function call then the errors disappear and I can activate the transformation.

My questions are:

1. Am I asking the impossible?

2. Am I using the correct syntax?

We are currently on BW 750 SP10 with the BW4HANA starter add on activated.

Kind regards

Josh