cancel
Showing results for 
Search instead for 
Did you mean: 

How to find out how much bytes/ diskspace a tables uses ?

former_member560074
Participant
0 Kudos

Hi out there,

How can I need find out how much bytes/diskspace (data & index) a certain tables(BKPF/BSEG) uses ?

Thank You

Best wishes Martin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Martin,

Go to DB02 transaction and then select "segments"

Best regards,

Orkun Gedik

former_member560074
Participant
0 Kudos

Hi Orkun,

do You know who its works for clustered tables ?

For BKPF the amount I get seems to high.

For BSEG the amount I get it seems to low.In fact uts the initial allocated size).

To me it seems that DB02 is based on the native (Oracle) SQL table names.

The (ABAP Dictionnary Tablenames) are not 1:1 equivalent to native (Oracle) SQL table names.

Thank You !

Martin

Former Member
0 Kudos

Hi Martin,

>> The (ABAP Dictionnary Tablenames) are not 1:1 equivalent to native (Oracle) SQL table names.

It is correct for pool/cluster tables

>> To me it seems that DB02 is based on the native (Oracle) SQL table names.

I don't know an exact report name, but you can check the native table names on DB02 and match with DD02L-TABNAME and DD02L-SQLTAB fields

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi Martin,

I found out RSTABLESIZE program, in my notes. It may help you to determine table size with DDIC table names.

Best regards,

Orkun Gedik

former_member560074
Participant
0 Kudos

Hi Orkun,

thank You. Tis worked out.

Martin

Answers (0)