SAP table TCNN (Network/hierarchy graphics: profiles for nodes)
SAP table TCNN has 3 primary key fields being MANDT,PROFILE,TYPE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Node group in Network/Hierarchy Graphics
CHAR
12
0
NETKNOPROF
Type for identifying objects
CHAR
1
0
NETTYPE
Possible values
"
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
FMT
Name of form definition
CHAR
6
0
TFMT
NETFMTKEY
HLT
Name of color definition
CHAR
6
0
THLT
NETHLTKEY
TCNN foreign key relationships
Table
Field
Check Table
Check Field
0 TCNN
FMT
TFMT Format attributes in VarChart graphics
MANDT
0 TCNN
FMT
TFMT Format attributes in VarChart graphics
NAME
1 TCNN
HLT
THLT VarChart Graphics: Color Attributes
MANDT
1 TCNN
HLT
THLT VarChart Graphics: Color Attributes
NAME