Updating statistics
DB02 – Space – Single Table Analysis
Enter the parent table name for the index and press Index Analysis
Select the indexes one at a time and select UPDATE STATISTICS
Wednesday, November 30, 2016
Thursday, November 24, 2016
Idoc Metadata Monitor - PI
If you change Idoc structure (or field lengths) in ECC - You need to Reload Idoc in Metadata Monitor in PI. You also need to reimport Idoc in ESR and change mappings.
Thursday, November 10, 2016
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
Friday, November 4, 2016
Transactions called from another transaction
For info – table TCDCOUPLES to see what transactions can be called from another.
E.g.
In F-44 the other transactions that can be called are
F-44 F-28 SAP
F-44 F-32 SAP
F-44 F-44 SAP
F-44 F-51 SAP
F-44 F-53 SAP
F-44 FB00 SAP
F-44 FB01 SAP
F-44 FB02 SAP
F-44 FB03 SAP
F-44 FB05 SAP
F-44 FB07 SAP
F-44 FB1K SAP
F-44 FK01 SAP
F-44 SE01 SAP
F-44 SE11 SAP
F-44 SE37 SAP
F-44 SE38 SAP
F-44 SE80 SAP
F-44 SM30 SAP
Subscribe to:
Posts (Atom)