Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table DD40L

Table types (internal tables defined in DD)

DD40L (Table types (internal tables defined in DD)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DD40L to other SAP tables.

DD40L table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

TYPENAME

Name of table type

TTYPENAME

CHAR

AS4LOCAL

Activation Status of a Repository Object

AS4LOCAL

CHAR

Value	Description
A	Entry activated or generated in this form
L	Lock entry (first N version)
N	Entry edited, but not activated
S	Previously active entry, backup copy
T	Temporary version when editing

ACTFLAG

Actions to be executed for a dependent DD object

DEPACTION

CHAR

ROWTYPE

Name of row type for table types

TTROWTYPE

DDTYPES

CHAR

ROWKIND

Category of Dictionary Type

TYPEKIND

CHAR

Value	Description
E	Elementary Type
S	Structured Type
L	Table Type
NULL	Direct Type Entry
R	Reference Type
D	Domain

DATATYPE

Data Type in ABAP Dictionary

DATATYPE_D

CHAR

Value	Description
ACCP	Posting period YYYYMM
CHAR	Character String
CLNT	Client
CUKY	Currency key, referenced by CURR fields
CURR	Currency field, stored as DEC
D16D	Decimal Floating Point, 16 Digits, DEC on Database
D16R	Decimal Floating Point, 16 Digits, RAW on Database
D16S	Decimal Floating Point. 16 Digits, with Scale Field
D34D	Decimal Floating Point, 34 Digits, DEC on Database
D34R	Decimal Floating Point, 34 Digits, RAW on Database
D34S	Decimal Floating Point, 34 Digits, with Scale Field
DATS	Date field (YYYYMMDD) stored as char(8)
DEC	Counter or amount field with comma and sign
FLTP	Floating point number, accurate to 8 bytes
INT1	1-byte integer, integer number <= 255
INT2	2-byte integer, only for length field before LCHR or LRAW
INT4	4-byte integer, integer number with sign
LANG	Language key
LCHR	Long character string, requires preceding INT2 field
LRAW	Long byte string, requires preceding INT2 field
NUMC	Character string with only digits
PREC	Obsolete data type, do not use
QUAN	Quantity field, points to a unit field with format UNIT
RAW	Uninterpreted sequence of bytes
RSTR	Byte String of Variable Length
SSTR	Short Character String of Variable Length
STRG	Character String of Variable Length
TIMS	Time field (hhmmss), stored as char(6)
UNIT	Unit key for QUAN fields
VARC	Long character string, no longer supported from Rel. 3.0

LENG

Length (No. of Characters)

DDLENG

NUMC

DECIMALS

Number of Decimal Places

DECIMALS

NUMC

ACCESSMODE

Access modes for table types

ACCESSMODE

CHAR

Value	Description
A	Not Specified
I	Index Table
T	Standard Table
S	Sorted Table
H	Hashed Table

KEYDEF

Key definition for table types

TTYPKEYDEF

CHAR

Value	Description
D	Standard key
T	Row Type
G	Not specified
K	Key components

KEYKIND

Key category for table types

KEYKIND

CHAR

Value	Description
U	Unique
N	Non-unique
G	Not specified

KEYFDCOUNT

Number of key fields of a table type

KEYFDCNT

NUMC

GENERIC

Generic table type

TYPGENERIC

CHAR

Value	Description
NULL	FALSE
X	TRUE

TYPELEN

Length (No. of Characters)

DDLENG

NUMC

AS4USER

Last Changed by

AS4USER

CHAR

AS4DATE

Date of Last Change

AS4DATE

DATS

AS4TIME

Last changed at

AS4TIME

TIMS

TTYPKIND

Category of table type (range or general table type)

TTYPKIND

CHAR

Value	Description
NULL	General table type
R	Ranges table type

RANGE_CTYP

Elem. type of LOW and HIGH components of a Ranges type

RANGE_CTYP

CHAR

REFTYPE

Type of Object Referenced

DDREFTYPE

CHAR

Value	Description
NULL	No Information
A	ANY
O	Object
D	DATA
B	Built-In Dictionary Type
E	Data Element
S	Structured Type
L	Table Type
C	Class
I	Interface

OCCURS

Initial Line Number for Table Types

DDOCCURS

NUMC

PROXYTYPE

DD: Is a generated proxy object

DDPROXYTY

CHAR

Value	Description
X	Is a generated proxy object
NULL	Is not proxy-generated

ALIAS

Alias for Primary Key of a Table Type (Optional)

TT_PRIMARY_KEY_ALIAS

CHAR

FURTHERSECKEY

Additional Secondary Keys of a Table Type

TT_FURTHER_SECKEYS

CHAR

Value	Description
W	Allowed (Addition WITH FURTHER SECONDARY KEYS)
O	Not allowed (Addition WITHOUT FURTHER SECONDARY KEYS0
NULL	Not specified (none of these specifications)

DD40L foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
DD40L	ROWTYPE	DD40L	ROWTYPE	DDTYPES Table of all Dictionary types and classes	TYPENAME