TAANA table analysis

There is a transaction TAANA that does table analysis.

To set it up:  Transaction TAANA -> Table Analysis Menu -> Perform -> Enter Table Name e.g. CDCLS

Now go into the advance selection options for Analysis Variant.

Then select the "Ad Hoc Variant" button at the bottom.

Next move the OBJECTCLAS column from the right to left pane and select the green tick.

Make sure the ad hoc variant is ticked and use the green tick to leave this screen.

You should now be back at the first screen. Make sure "In the Background" is selected and use the green tick. Schedule whenever suits.

Once it has finished running you can go back to TAANA and select the CDCLS node and double click the green line - this will display all the

entry counts per object type.  

In our example we could see the majority of records by far were object type COND_A (PRICING CONDITIONS)

Table TCDOB - will tell you which tables are covered by which object and a description for each object