Skip to Content
0
Aug 01, 2023 at 09:44 PM

How to read data from an ADSO with AMDP End routine in transformation

460 Views

Greetings to all and thanks in advance for your responses.

I have an ADSO already loaded with data of type Standard DataStore Object with Write Change Log. Let's say ADSO_A.

I have another ADSO, let's say ADSO_B, and at the moment of loading data I must read information from ADSO_A. The transformation runtime I use to achieve the above is of type SAP HANA Runtime and I have a final routine (AMDP).

All good until in the code I try to read table 2 or 7 of ADSO_A, this is "/BIC/AXXXX2" or "/BIC/AXXXX7".

As an example I put a very simple code that still generates the mentioned error.

METHOD GLOBAL_END BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY.
-- *** Begin of routine - insert your code only below this line ***

-- Note the _M class are not considered for DTP execution.
-- AMDP Breakpoints must be set in the _A class instead.

 tmp_01 = SELECT * FROM "/BIC/AZXXXX7";

 outTab = SELECT * FROM :inTab;

-- *** End of routine - insert your code only before this line ***
ENDMETHOD.

The error that is generated is:

error.png

Now, the database schema name is added but it throws me yet another error. Also, I don't think it's the right thing to do since when I pass it to production I won't be able to change the name of the schema. The second example with the modified code is:

METHOD GLOBAL_END BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY.
-- *** Begin of routine - insert your code only below this line ***

-- Note the _M class are not considered for DTP execution.
-- AMDP Breakpoints must be set in the _A class instead.

 tmp_01 = SELECT * FROM sXXXX."/BIC/AZXXXX7";
outTab = SELECT * FROM :inTab; -- *** End of routine - insert your code only before this line *** ENDMETHOD.

and the new error is:

error-02.png

Surely I am doing something wrong, but so far I have not found how to solve them. I know that if I change the transformation runtime to ABAP I won't have any problem but that is not the intention.

Any ideas?.

Thank you

Attachments

error.png (2.9 kB)
error-02.png (6.2 kB)