SAP table DM40L (DM Data Model)

SAP table DM40L has 2 primary key fields being DMOID,AS4LOCAL.

Field Description Data Type Length Decimals Checktable Data Element
DMOID Data Model Name CHAR 26 0 UDDMODL
AS4LOCAL Activation State of Repository Object CHAR 1 0 AS4LOCAL
A Entry was activated or generated in this form
L Lock entry (first N version)
N Entry was edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
REF_ENTID Representative CHAR 26 0 DM02L UDREPRES
REF_OBJECT Referenced model CHAR 26 0 DM40L UDREFMODEL
REF_CLUST Area name CHAR 10 0 DM48L UDCLUS
FLG_DEF Flag: documentation object exists CHAR 1 0 UDFLGDOC
FLG_COMPL Flag: application data model CHAR 1 0 UDFLGAPPLI
FLG_FRAME Flag: frame CHAR 1 0 UDFLGFRAME
FLG_CUST Flag: customizing object CHAR 1 0 UDFLGCUST
Is not used in customizing
A Is generally applicable
C Is only used in customizing
FLG_BUSINS Flag: business object CHAR 1 0 UDFLGBUSIO
OBJTYP Type of EDM object CHAR 4 0 UDOBJTYPE
CLUS Cluster
DATM Data model
ENTI Entity
COLORTYPE Type for identifying objects CHAR 1 0 NETTYPE
" 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
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
: Extra type
; Extra type
= Extra type
? Extra type
@ Extra type
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
ß Extra type
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
FSTUSER Created by CHAR 12 0 UDFUSER
FSTDATE Date on which the record was created DATS 8 0 UDFDATE
FSTTIME Created At TIMS 6 0 UDFTIME
LSTUSER Changed by CHAR 12 0 UDLUSER
LSTDATE Changed on DATS 8 0 UDLDATE
LSTTIME Last Changed At TIMS 6 0 UDLTIME
LOESCHZ Deletion Indicator CHAR 1 0 UDLOEKZ
FCTR_ID Application Component CHAR 20 0 DF14L UFFCTR

DM40L foreign key relationships

Table Field Check Table Check Field
0 DM40L FCTR_ID DF14L Application Components AS4LOCAL
1 DM40L REF_CLUST DM48L DM Area CLUID
1 DM40L REF_CLUST DM48L DM Area AS4LOCAL
0 DM40L REF_ENTID DM02L DM Entity Type AS4LOCAL
1 DM40L REF_OBJECT DM40L DM Data Model AS4LOCAL