Trigger HANA Stored procedure after SLT job

[former_member375266]

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.

Regards

Ganapathi

[lbreddemann]

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.

[former_member375266]

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.