Skip to Content

Trigger HANA Stored procedure after SLT job

Feb 08 at 06:59 AM


avatar image

Hi Experts,

We have a requirement to trigger a HANA Stored Procedure after successful completion of the SLT process.

To explain in detail, we have a custom ABAP program in SAP which loads the data into a table in SAP and we are currently replicating this table into HANA. After all the records are replicated, we wanted to trigger a Stored Procedure in HANA which reads this replicated table and performs a business logic and stores the data in another table.

I'm struck here, I don't know how to find if the replication of all records are done successfully.

Since this SAP table is a drop and re-load, my thought was to stop the replication of this table and by using a scheduling tool like Control M, I will run the initial replication job for this table by using an ABAP program which will trigger the initial load. After the completion of this job, I will schedule my stored procedure.

But I'm not sure if I can trigger the Initial Load using any ABAP program or is there any way that I can sequence this process.

Kindly let me know if you need anymore details.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Feb 08 at 08:13 AM

That's not what SLT is made for. Your scenario would be better suited by using SDI or SDA where you can completely control when the data transfer should happen.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for the comment Lars. But is there any way that we can trigger the SLT through an ABAP program or Function Module. So that can schedule program/FM and then the stored procedure sequentially.