Data deletion from staging tables SLT

[former_member182537]

expert,

We are working on scenario whee SLT is getting data from non sap and feeding to S4 HANA Central Finance, now we have couple of staging tables in SLT like line item , customer extension, etc.. due to increase in disk space, we need to plan clean up of staging tables, can you suggest quick solution to clear the data and o e solution for long term too.

Is there a method or any housekeeping job which can clear data crom staging tables automatically once data gets posted to S4

[MarcE · Accepted solution]

As per SAP note 2826493 there is no way provided in standard to delete the data in these tables for the third party interface. If you are using a system such as data services to load data into the SLT staging tables you could use that to remove data, or you could create a simple ABAP program to perform the delete and run at regular intervals. If it is urgent then you could request your DB admin team to purge the records for you as well.

Thanks

[former_member182537]

Thanks Marc for your response, much appreciated !

[former_member182537]

Pls can someone suggest best way to delete staging tables data..