SAP Table DM40L

DM Data Model

DM40L (DM Data Model) 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 DM40L to other SAP tables.

DM40L table fields

Field

Data element

Checktable

Datatype

Length

Decimals

DMOID

Data Model Name

UDDMODL

CHAR

AS4LOCAL

Activation Status of a Repository Object

AS4LOCAL

CHAR

Possible values

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

REF_ENTID

Representative

UDREPRES

DM02L

CHAR

REF_OBJECT

Referenced model

UDREFMODEL

DM40L

CHAR

REF_CLUST

Area name

UDCLUS

DM48L

CHAR

FLG_DEF

Flag: documentation object exists

UDFLGDOC

CHAR

Possible values

NULL
X

FLG_COMPL

Flag: application data model

UDFLGAPPLI

CHAR

Possible values

NULL
X

FLG_FRAME

Flag: frame

UDFLGFRAME

CHAR

Possible values

NULL
X

FLG_CUST

Flag: customizing object

UDFLGCUST

CHAR

Possible values

NULL	Is not used in customizing
C	Is only used in customizing
A	Is generally applicable

FLG_BUSINS

Flag: business object

UDFLGBUSIO

CHAR

Possible values

NULL
X

OBJTYP

Type of EDM object

UDOBJTYPE

CHAR

Possible values

DATM	Data model
ENTI	Entity
CLUS	Cluster

COLORTYPE

Type for identifying objects

NETTYPE

CHAR

Possible values

0	Type 0 = default type
1	Type 1
2	Type 2
3	Type 3
4	Type 4
5	Type 5
6	Type 6
7	Type 7
8	Type 8
9	Type 9
A	Type A
B	Type B
C	Type C
D	Type D
E	Type E
F	Type F
G	Type G
H	Type H
I	Type I
J	Type J
K	Type K
L	Type L
M	Type M
N	Type N
O	Type O
P	Type P
Q	Type Q
R	Type R
S	Type S
T	Type T
U	Type U
V	Type V
W	Type W
X	Type X
Y	Type Y
Z	Type Z
a	Type a
b	Type b
c	Type c
d	Type d
e	Type e
f	Type f
g	Type g
h	Type h
i	Type i
j	Type j
k	Type k
l	Type l
m	Type m
n	Type n
o	Type o
p	Type p
q	Type q
r	Type r
s	Type s
t	Type t
u	Type u
v	Type v
w	Type w
x	Type x
y	Type y
z	Type z
"	Extra type
�	Extra type
$	Extra type
%	Extra type
&	Extra type
/	Extra type
(	Extra type
)	Extra type
=	Extra type
?	Extra type
\	Extra type
�	Extra type
`	Extra type
+	Extra type
*	Extra type
~	Extra type
#	Extra type
'	Extra type
@	Extra type
,	Extra type
;	Extra type
.	Extra type
:	Extra type
-	Extra type
^	Extra type
�	Extra type
[	Extra type
]	Extra type
{	Extra type
}	Extra type
�	Extra type
�	Extra type
�	Extra type

FSTUSER

Created by

UDFUSER

CHAR

FSTDATE

Date on which the record was created

UDFDATE

DATS

FSTTIME

Creation Time

UDFTIME

TIMS

LSTUSER

Changed by

UDLUSER

CHAR

LSTDATE

Changed on

UDLDATE

DATS

LSTTIME

Last changed at

UDLTIME

TIMS

LOESCHZ

Deletion Indicator

UDLOEKZ

CHAR

FCTR_ID

Application Component

UFFCTR

DF14L

CHAR

DM40L foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
DM40L	FCTR_ID	DM40L	FCTR_ID	DF14L	Application Components	FCTR_ID
DM40L	FCTR_ID	DM40L	AS4LOCAL	DF14L	Application Components	AS4LOCAL
DM40L	REF_CLUST	DM40L	REF_CLUST	DM48L	DM Area	CLUID
DM40L	REF_CLUST	DM40L	AS4LOCAL	DM48L	DM Area	AS4LOCAL
DM40L	REF_ENTID	DM40L	REF_ENTID	DM02L	DM Entity Type	ENTID
DM40L	REF_ENTID	DM40L	AS4LOCAL	DM02L	DM Entity Type	AS4LOCAL
DM40L	REF_OBJECT	DM40L	REF_OBJECT	DM40L	DM Data Model	DMOID
DM40L	REF_OBJECT	DM40L	AS4LOCAL	DM40L	DM Data Model	AS4LOCAL