SAP table TCNNT (Network/Hierarchy Graphics: Texts for Node Profiles)
SAP table TCNNT has 4 primary key fields being MANDT,SPRAS,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
Language Key
LANG
1
0
T002
SPRAS
Node group in Network/Hierarchy Graphics
CHAR
12
0
TCNN
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
KTEXT
Text, 40 Characters Long
CHAR
40
0
TEXT40
TCNNT foreign key relationships
Table
Field
Check Table
Check Field
0 TCNNT
PROFILE
TCNN Network/hierarchy graphics: profiles for nodes
MANDT
0 TCNNT
PROFILE
TCNN Network/hierarchy graphics: profiles for nodes
PROFILE
0 TCNNT
PROFILE
TCNN Network/hierarchy graphics: profiles for nodes
TYPE
1 TCNNT
SPRAS
T002 Language Keys (Component BC-I18)
SPRAS