help finding OS-level database object names

[Former Member]

Hello all...

I need to perform an online reorganization of some tables on my QAS system.

However, some of the tables have more than 8 characters on SAP and I need to know what's the corresponding object name on the database library at OS level, so I can use the RGZPFM command.

Could you please let me know how to find out the object's name?

I can't find that information on SE14 or SE11...

Thanks

Antonio

[Former Member · Accepted solution]

Hello Antonio,

in SAP you can use ST04, Detail analysis menu, System catalog views (under Additional functions). In the next screen select SYSTABLES. In column System tab/view name you find the corresponding name of a table on the DB.

Regards,

Juergen Scheckelhoff

[Former Member · Accepted solution]

thank you all,

Volker and Juergen:

both your answers are EXACTLY what I need... thank you!

Bhavik:

yes, I'm using that SAP note...

thanks!

Antonio

[former_member524429]

Hi,

Have you referred this useful [SAP Note 84081 - IBM i: Reorganization of database tables (RGZPFM)|https://service.sap.com/sap/support/notes/84081] ?

Regards,

Bhavik G. Shroff

[Former Member]

Hi Antonio,

I always use the following SQL:

SELECT SYSTEM_TABLE_NAME, TABLE_NAME

FROM r3t01data/systables

WHERE

table_name like 'MAR%'

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de