Is there a way to stop the system writing into table TMPSRPT (Temporary print key table)?

Question

I have a client with this table growing at a rate of 15G per day and its already over 300G 
 
 There is no documentation as to what this table does can we truncate this table using a batch task is there any implications?

Rafael · Accepted Answer

Hello, 
 You could use the History/purge function (GESAHI) to purge data from the ATMP (Temporary tables). AREPORTM is included in this this purge function. On the right hand side of the screen you can select Purge parameters to enter specific criteria as to what to purge. 
 Attempt this in a Test environment prior to attempting in a production environment, of course. 
 
 Thanks, 
 Rafael

Nacho_Alferez · Answer

Hi Nzou: 
 Although the table has no assigned activity code, I think that TMPSRPT table is related to the KPO activity code (Portuguese localization). 
 If you are not using the Portuguese localization, you can decativate the KPO activity code. 
 The TMPSRPT table is very similar to the AREPORTM table. It is used to print Crystal Reports documents. I usually delete all the AREPORTM records from time to time without any problem. But I don't know what impact it will have to delete records from the TMPSRPT table. 
 Maybe some Portuguese colleague can help us. 
 Regards, 
 Nacho Alf&eacute;rez.

Sage X3

Is there a way to stop the system writing into table TMPSRPT (Temporary print key table)?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING