SAP DB2TBDETL table - Detailed Information on a Table from the DB2 Catalog details in SAP


SAP DB2TBDETL table summary

Object Name: DB2TBDETL
Dictionary Type: Structure
Description: Detailed Information on a Table from the DB2 Catalog


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

Details
DB2TBDETL-NAME table field - DB2 table name

Description: DB2 table name
Field Name: NAME
Data Element: DB2TABNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

DB2TBDETL-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

DB2TBDETL-TYPE table field - Type of object

Description: Type of object
Field Name: TYPE
Data Element: DB2TBTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2TBTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

DB2TBDETL-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

DB2TBDETL-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

DB2TBDETL-COLCOUNT table field - Number of columns in the table or view

Description: Number of columns in the table or view
Field Name: COLCOUNT
Data Element: DB2COLCNT
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 COLCOUNT

DB2TBDETL-NPAGES table field - Number of pages on which rows of the table appear

Description: Number of pages on which rows of the table appear
Field Name: NPAGES
Data Element: DB2NPAGES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NPAGES

DB2TBDETL-KEYCOLUMNS table field - Number of columns in the table's primary key

Description: Number of columns in the table's primary key
Field Name: KEYCOLUMNS
Data Element: DB2KEYCOLS
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 KEYCOLUMNS

DB2TBDETL-RECLENGTH table field - Maximum length (in bytes) of any record in the table

Description: Maximum length (in bytes) of any record in the table
Field Name: RECLENGTH
Data Element: DB2RECLENS
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 RECLENGTH

DB2TBDETL-STATUS table field - Status of the table

Description: Status of the table
Field Name: STATUS
Data Element: DB2TBSTATU
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2TBSTATU
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

DB2TBDETL-CREATEDTS table field - Time when the CREATE statement was executed

Description: Time when the CREATE statement was executed
Field Name: CREATEDTS
Data Element: DB2CREADTS
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 CREATEDTS

DB2TBDETL-ALTEREDTS table field - Time of most recent ALTER statement on the object

Description: Time of most recent ALTER statement on the object
Field Name: ALTEREDTS
Data Element: DB2ALTEDTS
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 ALTEREDTS

DB2TBDETL-PCTROWCOMP table field - Percentage of rows compressed within the total no. of rows

Description: Percentage of rows compressed within the total no. of rows
Field Name: PCTROWCOMP
Data Element: DB2PCTRCMP
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 PCTROWCOMP

DB2TBDETL-STATSTIME table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: STATSTIME
Data Element: DB2STATSTM
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 STATSTIME

DB2TBDETL-CARDF table field - Total number of rows in the table

Description: Total number of rows in the table
Field Name: CARDF
Data Element: DB2CARDF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CARDF

DB2TBDETL-SIZE table field - Size of the table in KB

Description: Size of the table in KB
Field Name: SIZE
Data Element: DB2TBSIZE
Data Type: DEC
length (Dec): 13(0)
Check table:
Conversion Routine:
Domain Name: DEC13
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIZE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table