E8.12 List of all Z files along with corresponding Purge UBEs

[Rauf]

I would like to minimize size of the JDE Production database.
To do this, I would like to know all the possible Z files and corresponding purge UBEs so that I can safely purge the tables.

 

[JohnDanter2]

There are 188 in F9860 where SIOBNM Like Z and SIFUNO = TBLE (on 9.2)

There are 60 UBEs on the same table with Purge in the title.
you'd have to use XRef mate

 

[franck_blettner]

Hello

For Z Files, the interoperability interface table will give you all the tables an corresponding purge UBE :

Interoperability Guide

This section provides a table that lists applications that have interoperability features.interface tablelist of processes

docs.oracle.com

But Z are not the only files, there is some technical tables containing logs and EDI tables (F47xxxx).
Also if you want to minimize size of the database, you have to think to archive and purges transactions tables
F0911, F03B11, F03B13, F03B14, F0411, F0413, F0414 for accounting. Standard process exists to purge and archive
F42199 : logs for sales order. This table can be safely purged but this has to be confirmed by business teams

Regards