- Home
- Resources
- SAP Tables
- DM40L - DM Data Model
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.
Source: DM40L (DM Data Model)
DM40L table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
DMOID |
Data Model Name |
UDDMODL |
|
CHAR |
|
26 |
0 |
|
AS4LOCAL |
Activation Status of a Repository Object |
AS4LOCAL |
|
CHAR |
|
1 |
0 |
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 |
|
26 |
0 |
|
REF_OBJECT |
Referenced model |
UDREFMODEL |
DM40L
|
CHAR |
|
26 |
0 |
|
REF_CLUST |
Area name |
UDCLUS |
DM48L
|
CHAR |
|
10 |
0 |
|
FLG_DEF |
Flag: documentation object exists |
UDFLGDOC |
|
CHAR |
|
1 |
0 |
Possible values
|
FLG_COMPL |
Flag: application data model |
UDFLGAPPLI |
|
CHAR |
|
1 |
0 |
Possible values
|
FLG_FRAME |
Flag: frame |
UDFLGFRAME |
|
CHAR |
|
1 |
0 |
Possible values
|
FLG_CUST |
Flag: customizing object |
UDFLGCUST |
|
CHAR |
|
1 |
0 |
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 |
|
1 |
0 |
Possible values
|
OBJTYP |
Type of EDM object |
UDOBJTYPE |
|
CHAR |
|
4 |
0 |
Possible values
DATM |
Data model |
ENTI |
Entity |
CLUS |
Cluster |
|
COLORTYPE |
Type for identifying objects |
NETTYPE |
|
CHAR |
|
1 |
0 |
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 |
|
12 |
0 |
|
FSTDATE |
Date on which the record was created |
UDFDATE |
|
DATS |
|
8 |
0 |
|
FSTTIME |
Creation Time |
UDFTIME |
|
TIMS |
|
6 |
0 |
|
LSTUSER |
Changed by |
UDLUSER |
|
CHAR |
|
12 |
0 |
|
LSTDATE |
Changed on |
UDLDATE |
|
DATS |
|
8 |
0 |
|
LSTTIME |
Last changed at |
UDLTIME |
|
TIMS |
|
6 |
0 |
|
LOESCHZ |
Deletion Indicator |
UDLOEKZ |
|
CHAR |
|
1 |
0 |
|
FCTR_ID |
Application Component |
UFFCTR |
DF14L
|
CHAR |
|
20 |
0 |
|
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 |