How to Delete Entries in Data Provisioning from HANA Studio.
Symptom: I have deleted entries in our LT server from LTR t-code to create new one due to some issues. Now when I check Data Provisioning from HANA Studio I still see OLD entry. Now the question is How to delete it.
Follow below steps:
Delete SLT user from HANA Studio. This will delete SLT user and SLT schema with all tables.
Go to SQL Query mode and execute below command.
DELETE FROM “SYS_REPL”.”RS_REPLICATION_COMPONENTS”;
This will delete every configuration in Data Provisioning.
If you want to delete table entry from Data Provisioning in HANA Studio use below command:
DELETE FROM <SLT-SCHEMA>.RS_STATUS WHERE TABLENAME = ‘<TABLE NAME>’
Note: This should perform in Training system only. Performing DEV, QTY and PRD servers is not recommended. Please contact SAP before you perform.