SAP ROOT_HIST table - Oracle monitoring: Root history details in SAP


SAP ROOT_HIST table summary

Object Name: ROOT_HIST
Dictionary Type: Structure
Description: Oracle monitoring: Root history


Field list for ROOT_HIST table on an S/4 SAP system

Details
ROOT_HIST-DATE table field - Oracle monitoring

Description: Oracle monitoring
Field Name: DATE
Data Element: DB02_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE

ROOT_HIST-CWEEK table field - Oracle monitoring: calendar week

Description: Oracle monitoring: calendar week
Field Name: CWEEK
Data Element: DB02_CWEEK
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CWEEK

ROOT_HIST-DTYPE table field - Oracle monitoring: flag

Description: Oracle monitoring: flag
Field Name: DTYPE
Data Element: DB02_FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DTYPE

ROOT_HIST-OWNER table field - Oracle monitoring: owner

Description: Oracle monitoring: owner
Field Name: OWNER
Data Element: DB02_OWNER
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNER

ROOT_HIST-ROOT_NAME table field - Oracle monitoring: segment name

Description: Oracle monitoring: segment name
Field Name: ROOT_NAME
Data Element: DB02_SEGNAME
Data Type: CHAR
length (Dec): 90(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_90
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOT_NAME

ROOT_HIST-ROOT_TYPE table field - Oracle monitoring: segment type

Description: Oracle monitoring: segment type
Field Name: ROOT_TYPE
Data Element: DB02_TYPE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOT_TYPE

ROOT_HIST-TABLESPACE table field - Oracle monitoring: Tablespace

Description: Oracle monitoring: Tablespace
Field Name: TABLESPACE
Data Element: DB02_TS
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_30
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLESPACE

ROOT_HIST-SIZE table field - Oracle monitoring: number with 3 decimals

Description: Oracle monitoring: number with 3 decimals
Field Name: SIZE
Data Element: DB02_SIZE_3
Data Type: DEC
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE

ROOT_HIST-EXT_NUM table field - Oracle monitoring: decimal number

Description: Oracle monitoring: decimal number
Field Name: EXT_NUM
Data Element: DB02_DEC
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXT_NUM

ROOT_HIST-BLOCKS table field - Oracle monitoring: blocks

Description: Oracle monitoring: blocks
Field Name: BLOCKS
Data Element: DB02_BLOCKS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKS

ROOT_HIST-PAR_NUM table field - Oracle monitoring: number

Description: Oracle monitoring: number
Field Name: PAR_NUM
Data Element: DB02_NUM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAR_NUM

ROOT_HIST-LOB_NUM table field - Oracle monitoring: number

Description: Oracle monitoring: number
Field Name: LOB_NUM
Data Element: DB02_NUM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOB_NUM

ROOT_HIST-CHG_SIZE table field - Oracle monitoring: number with 3 decimals

Description: Oracle monitoring: number with 3 decimals
Field Name: CHG_SIZE
Data Element: DB02_SIZE_3
Data Type: DEC
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHG_SIZE

ROOT_HIST-CHG_EXT_NUM table field - Oracle monitoring: decimal number

Description: Oracle monitoring: decimal number
Field Name: CHG_EXT_NUM
Data Element: DB02_DEC
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHG_EXT_NUM

ROOT_HIST-CHG_BLOCKS table field - Oracle monitoring: blocks

Description: Oracle monitoring: blocks
Field Name: CHG_BLOCKS
Data Element: DB02_BLOCKS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_DEC_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHG_BLOCKS

ROOT_HIST-CHG_PAR_NUM table field - Oracle monitoring: number

Description: Oracle monitoring: number
Field Name: CHG_PAR_NUM
Data Element: DB02_NUM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHG_PAR_NUM

ROOT_HIST-CHG_LOB_NUM table field - Oracle monitoring: number

Description: Oracle monitoring: number
Field Name: CHG_LOB_NUM
Data Element: DB02_NUM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: ORA_INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHG_LOB_NUM


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table