Anderson
19th April 2002, 13:16
Hello
Does anybody have a list of temporary tables B4c4 that I can purge on regular basis (twice a month or more often)?
Maybe anybody could explain how to get this list?

Thanks in advance

Darren Phillips
19th April 2002, 15:35
If you want to generate a list of tables and their description then you can use Count number of records by table ttaad4222m000 and output it to a file then filter the file for word temp.

Baan seems to do a reasonable job of cleaning up its temp tables
I have had to purge tdpsc910 tempory table for supply chain receipts if the session has crashed. Sometimes I clear the the planned MPS orders tables before running MPS and the mrp planned orders and MRP Planned schedules before MRP run.

There is also the printer queue table ttaad320 in company 000 but you can use purge device queue ttaad3221m000 to do this.