SAP DB2_RECOM_REORGTS table - Structure for REORGTS Recommendation Viewer details in SAP

SAP DB2_RECOM_REORGTS table summary

Object Name: DB2_RECOM_REORGTS
Dictionary Type: Structure
Description: Structure for REORGTS Recommendation Viewer

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

Details

DB2_RECOM_REORGTS-EXCLUDED table field - c1 flag ▼

Description: c1 flag
Field Name: EXCLUDED
Data Element: DB2FLAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCLUDED

DB2_RECOM_REORGTS-DATE_ANA table field - Date of the last check ▼

Description: Date of the last check
Field Name: DATE_ANA
Data Element: DB2BCKDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_ANA

DB2_RECOM_REORGTS-TIME_ANA table field - Time of the last check ▼

Description: Time of the last check
Field Name: TIME_ANA
Data Element: DB2BCKTIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_ANA

DB2_RECOM_REORGTS-DBNAME table field - Database name ▼

Description: Database name
Field Name: DBNAME
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

DB2_RECOM_REORGTS-TSNAME table field - Name of the tablespace ▼

Description: Name of the tablespace
Field Name: TSNAME
Data Element: DB2TSNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSNAME

DB2_RECOM_REORGTS-PARTI table field - Partition number ▼

Description: Partition number
Field Name: PARTI
Data Element: DB2PARTNRS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTI

DB2_RECOM_REORGTS-CREATOR table field - DB2 creator name ▼

Description: DB2 creator name
Field Name: CREATOR
Data Element: DB2CREATOR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATOR

DB2_RECOM_REORGTS-OBJTYPE table field - DB2 object type: TS for tablespace, IX for indexspace ▼

Description: DB2 object type: TS for tablespace, IX for indexspace
Field Name: OBJTYPE
Data Element: DB2CCOBJT
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJTYPE

DB2_RECOM_REORGTS-OBJSTATUS table field - DB2 object status: NULL, restricted states or orphaned ▼

Description: DB2 object status: NULL, restricted states or orphaned
Field Name: OBJSTATUS
Data Element: DB2CCOBJS
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: CHAR36
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJSTATUS

DB2_RECOM_REORGTS-REORGREC table field - REORG Recommendation: YES or NO ▼

Description: REORG Recommendation: YES or NO
Field Name: REORGREC
Data Element: DB2CCOREC
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REORGREC

DB2_RECOM_REORGTS-EXCTABLE table field - Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) ▼

Description: Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
Field Name: EXCTABLE
Data Element: DB2CCEXCL
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCTABLE

DB2_RECOM_REORGTS-REORGTIME table field - Timestamp of last REORG ▼

Description: Timestamp of last REORG
Field Name: REORGTIME
Data Element: DB2CCOTIME
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: DB2TMSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REORGTIME

DB2_RECOM_REORGTS-RTINSDELUP table field - REORG TS/IX: Changed rows in percent ▼

Description: REORG TS/IX: Changed rows in percent
Field Name: RTINSDELUP
Data Element: DB2CCRCHGS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTINSDELUP

DB2_RECOM_REORGTS-RTINSDELUPABS table field - REO.:Changed rows (insert, delete or update) absolute number ▼

Description: REO.:Changed rows (insert, delete or update) absolute number
Field Name: RTINSDELUPABS
Data Element: DB2CCRCHGA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTINSDELUPABS

DB2_RECOM_REORGTS-RTINSPCT table field - REORG TS: Inserted rows in percent ▼

Description: REORG TS: Inserted rows in percent
Field Name: RTINSPCT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTINSPCT

DB2_RECOM_REORGTS-RTINSABS table field - REORG TS: Inserted rows absolut ▼

Description: REORG TS: Inserted rows absolut
Field Name: RTINSABS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTINSABS

DB2_RECOM_REORGTS-RTDELPCT table field - REORG TS:Deleted rows in percent ▼

Description: REORG TS:Deleted rows in percent
Field Name: RTDELPCT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTDELPCT

DB2_RECOM_REORGTS-RTDELABS table field - REORG TS:Deleted rows absolut ▼

Description: REORG TS:Deleted rows absolut
Field Name: RTDELABS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTDELABS

DB2_RECOM_REORGTS-RTUNCLUST table field - REORG TS: Unclustered inserts in percent ▼

Description: REORG TS: Unclustered inserts in percent
Field Name: RTUNCLUST
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTUNCLUST

DB2_RECOM_REORGTS-RTLOBPCT table field - REORG TS: Disorganized LOBs in percent ▼

Description: REORG TS: Disorganized LOBs in percent
Field Name: RTLOBPCT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTLOBPCT

DB2_RECOM_REORGTS-RTDATASPRAT table field - REORG TS: Ration between RTS SPACE and RTS DATASIZE ▼

Description: REORG TS: Ration between RTS SPACE and RTS DATASIZE
Field Name: RTDATASPRAT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTDATASPRAT

DB2_RECOM_REORGTS-RTMASSDEL table field - REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) ▼

Description: REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
Field Name: RTMASSDEL
Data Element: DB2CCRMASS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTMASSDEL

DB2_RECOM_REORGTS-RTINDREF table field - REORG TS: Indirect references (overflow records) in percent ▼

Description: REORG TS: Indirect references (overflow records) in percent
Field Name: RTINDREF
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTINDREF

DB2_RECOM_REORGTS-RTACTIVEPAGES table field - REORG TS/IX: Number of active pages ▼

Description: REORG TS/IX: Number of active pages
Field Name: RTACTIVEPAGES
Data Element: DB2CCRROWS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTACTIVEPAGES

DB2_RECOM_REORGTS-EXTENT_NO table field - Number of physical extents in TS, IS or partition ▼

Description: Number of physical extents in TS, IS or partition
Field Name: EXTENT_NO
Data Element: DB2CCEXTNO
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENT_NO

View list of all SAP tables(S4H/ECC)

Select data from SAP table