SAP DBFTYPE table - DB fields with type and type string details in SAP

SAP DBFTYPE table summary

Object Name: DBFTYPE
Dictionary Type: Structure
Description: DB fields with type and type string

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

Details

DBFTYPE-NAME table field - Name of the DB field ▼

Description: Name of the DB field
Field Name: NAME
Data Element: DBFIELDNAM
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: DBFIELDNAM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

DBFTYPE-COLUMN table field - Position of the field in the table ▼

Description: Position of the field in the table
Field Name: COLUMN
Data Element: TABFDPOS
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: AS4POS
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLUMN

DBFTYPE-KEYFLAG table field - Identifies a key field of a table ▼

Description: Identifies a key field of a table
Field Name: KEYFLAG
Data Element: KEYFLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: KEYFLAG
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEYFLAG

DBFTYPE-KEYPOS table field - Position of the index column within the indexes (1,2..) ▼

Description: Position of the index column within the indexes (1,2..)
Field Name: KEYPOS
Data Element: KEYPOS
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: KEYPOS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEYPOS

DBFTYPE-TYPE table field - Database type ▼

Description: Database type
Field Name: TYPE
Data Element: DBTYPE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DBTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

DBFTYPE-LENGTH table field - Length (No. of Characters) ▼

Description: Length (No. of Characters)
Field Name: LENGTH
Data Element: DDLENG
Data Type: NUMC
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DDLENG
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LENGTH

DBFTYPE-DECIMALS table field - Number of Decimal Places ▼

Description: Number of Decimal Places
Field Name: DECIMALS
Data Element: DECIMALS
Data Type: NUMC
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DDLENG
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DECIMALS

DBFTYPE-NULLABLE table field - Null values allowed ▼

Description: Null values allowed
Field Name: NULLABLE
Data Element: NULLABLE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AS4FLAG
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NULLABLE

DBFTYPE-DEFAULTVAL table field - Default value for a DB column ▼

Description: Default value for a DB column
Field Name: DEFAULTVAL
Data Element: DEFAULT_VA
Data Type: CHAR
length (Dec): 75(0)
Check table:
Conversion Routine:
Domain Name: DEFAULT_VA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFAULTVAL

DBFTYPE-DEFAULTPFX table field - Prefix/Suffix for a DB default value ▼

Description: Prefix/Suffix for a DB default value
Field Name: DEFAULTPFX
Data Element: DEFAULTPFX
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: SYCHAR03
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFAULTPFX

DBFTYPE-STRING table field - String for defining a DB type with CREATE TABLE ▼

Description: String for defining a DB type with CREATE TABLE
Field Name: STRING
Data Element: TYPESTR
Data Type: CHAR
length (Dec): 72(0)
Check table:
Conversion Routine:
Domain Name: CHAR72
MemoryID:
AppClass: SDOC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STRING

View list of all SAP tables(S4H/ECC)

Select data from SAP table