Sunday, December 26, 2010
  • Use DB6PMHT_HD (DB6: Summary Record of Table and Index Space Statistics) table to check the database table size.

REPORT ztest_notepad.
TABLES :db6pmht_hd.

SELECT  SINGLE *
FROM  db6pmht_hd
WHERE  stattype    = 'D'    "D-daily
AND  objectname  = 'MARA'
AND  objecttype  = 'T'.   "T-table.

WRITE:/ 'Table', 'MARA', 'size', db6pmht_hd-sizekb. 

  • To double check with above result, goto->DB02-Double click on Tables and Indexes tree node->Give table name as MARA instead * and click OK button->You will see size(KB) field

0 comments:

Post a Comment

Your useful comments, suggestions are appreciated.Your comments are moderated.

Followers

Contact Form

Name

Email *

Message *

Web Dynpro ABAP Book

An SAP Consultant

Follow US


Want to Contribute ?

If you are interested in writing about the new stuff you learn everyday while working, please write to the.sap.consultants@gmail.com.

Click on Contribution for more details.