Table Tstc (This Table Stores The Transaction Codes And Other Technical Information Such As Program Name, Screen Number, Etc.) Table Tstct (This Table Includes The Transaction Codes And Their Description In All Languages) The Second Table, Tstct, Is Most Useful As It Includes All Sap Code And.
For finding the number of rows in tables, goto transaction se16…enter th=. Sap provides a number of transaction types that cover most common business transactions. Analyzing the size with transaction st14.
How To Find The Size Of Tables On Disk (Bytes) In Hana.
You have to go the table tstcp (table for parameter transaction). Go to tcode db02old, click on “detailed analysis“, and fill the fields as follows: Post migration, we were trying to list out the size of tables to evaluate how much disk space we saved on which tables after migration.
Suhas Saha On Jan 22, 2010 11:22 Am.
The usual sap terminology create, read, update and delete (crud) is here abbreviated referred to as change or maintain. Soffcont1 table grows quickly in sap landscapes and is often found in the top 10 largest tables in the system (tip: “&sap_edit” (uase16n) sd11 data model sm30, sm31 sap table view maintenance oaor se54 (sobj) table / view cluster se37 function module editor se38 / se39 program editor / split screen sa38 program execution
Using Add Filter Button, Sap Hana Studio Users Can Addd Filters Like Table Disk Size, Table Name Or Schema Name To Minimize The List Of Tables You Are Dealing With On The Return List.
The following query is another interesting sql script which reports on individual sap hana table name and size on disk. Unlike the transaction type groups, you can add new transaction types as needed. Go to current sizes / space statistics / freespace statistics.if psap[sid] tablespace size is reaching 95% level, it’s.
Go To Transaction Code St05 And Activate Trace For Your Sap User Id.
Easy way to check the biggest tables in sap. Db02 as did before migration. I would like to share just a simple tip to get a list with the biggest tables in sap.