dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table DB6TREORG

DB6: Database REORG Check Information: Tables

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table DB6TREORG (DB6: Database REORG Check Information: Tables) is a standard table in SAP ERP. It belongs to the package STU6.

Technical Information

Table DB6TREORG
Short Text DB6: Database REORG Check Information: Tables
Package STU6
Table Type Transparent Table

Fields for Table DB6TREORG

Field Name Key Description Data Element Type Length Check Table
SYSID ✔ Name of SAP System SYSYSID CHAR 8
DB6TOWNER ✔ DB6: Schema Name DB6SCHEMA CHAR 20
DB6TNAME ✔ DB6: Table Name DB6TABNAM CHAR 18
DB6TSPACE SYSCAT;Tablespace Name CHAR 18
DB6TSIZE ADMIN_GET_TAB_INFO: Table Size at last runstats INT4 10
DB6F1 REORGCHK_TB_STATS: Formula 1 for REORGCHK Table CHAR 3
DB6F2 REORGCHK_TB_STATS: Formula 2 of REORGCHK Analysis CHAR 3
DB6F3 REORGCHK_TB_STATS: Formula 3 of REORGCHK Analysis CHAR 3
DB6REORG REORGCHK_TB_STATS:REORGCHK - Recommendation CHAR 3
DB6DATETIM DBA: ISO conform timestamp with ms precission DB6DATETIM CHAR 26
DB6RUNTIME SAP Reorg Jobs: Runtime of Last REORG TIMS 6
DB6REODATE SAP Reorg Jobs:Date of Last REORG DATS 8
DB6REOSIZE SAP Reorg Jobs:Table size at last reorg INT4 10
TSPTYPE SYSCAT:Tablespace Type CHAR 1
PCTPAGESAVED SYSCAT: Percentage of pages saved by compression INT4 10
COMPRESSION SYSCAT: Type of compression CHAR 1
DATA_OBJ_L_SIZE Number of logically allocated data pages DEC 22
DATA_OBJ_P_SIZE Number of physically allocated data pages DEC 22
INDEX_OBJ_L_SIZE Number of logically allocated index pages DEC 22
INDEX_OBJ_P_SIZE Number of physically allocated index pages DEC 22
LONG_OBJ_L_SIZE Number of logically allocated long pages DEC 22
LONG_OBJ_P_SIZE Number of physically allocated long pages DEC 22
LOB_OBJ_L_SIZE Number of logically allocated LOB pages DEC 22
LOB_OBJ_P_SIZE Number of physically allocated LOG pages DEC 22
XML_OBJ_L_SIZE Number of logically allocated XML pages DEC 22
XML_OBJ_P_SIZE Number of physically allocated XML pages DEC 22
LOAD_STATUS LOAD Status (IN_PROGRESS/PENDING) CHAR 32
LARGE_RIDS Large RIDs (YES/NO) CHAR 10
REORG_PENDING REORG pending (YES/NO) CHAR 10
INDEX_TYPE Index Type (Type-1/Type-2) CHAR 10
AVAILABLE Availability (YES/NO) CHAR 10