SAP table TCNO (Network/hierarchy graphics: options profile)

SAP table TCNO has 2 primary key fields being MANDT,PROFILE.

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
MANDT Client CLNT 3 0 T000 MANDT
PROFILE Name of the options profile CHAR 12 0 NETOPTPROF
AUTOADJUST Flag for activation of automatic alignment CHAR 1 0 NETAUTOADJ
BUTTONPOS Toolbox position CHAR 1 0 NETBUTPOS
0 Vertical
1 Horizontal
2 No toolbox
DISPBG Background color for display area CHAR 11 0 TWCOL NETDISPBG
DUPMODE Mode for copying nodes CHAR 1 0 NETDUPMODE
0 First predecessor
1 Last predecessor
2 Left brother
3 Right brother
4 First successor
5 Last successor
HEIGHT Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
HOFFSET Offset for horizontal scrolling NUMC 3 0 NETHOFFSET
IGNOREUSER Flag: ingnore user entries CHAR 1 0 NETIGNORE
INODESIZE Initial size of nodes in "insertable nodes" area NUMC 5 0 NETINODESZ
INSMODE Mode when inserting nodes CHAR 1 0 NETINSMODE
0 First predecessor
1 Last predecessor
2 Left brother
3 Right brother
4 First successor
5 Last successor
LAYBG Background color in partitioning window CHAR 11 0 TWCOL NETLAYBG
LAYFG Line color in partitioning window CHAR 11 0 TWCOL NETLAYFG
LAYORDER Sequence of the display, node and navigation areas CHAR 1 0 NETLAYORD
0 Relationship type 0
1 Relationship type 1
2 Relationship type 2
3 Order type 3
4 Order type 4
5 Order type 5
6 Order type 6
LAYSTYLE Area division CHAR 1 0 NETLAYSTL
0 Style type 0
1 Style type 1
2 Style type 2
3 Style type 3
4 Style type 4
5 Style type 5
6 Style type 6
LBUTTBG Background color for symbols in partitioning window CHAR 11 0 TWCOL NETLBUTTBG
LBUTTFG Line color in partitioning symbols CHAR 11 0 TWCOL NETLBUTTFG
MARKNODE Node/frame marking type CHAR 1 0 NETMARKND
0 Frame
1 inverted
2 with pickmarks
MODMODE Change Mode CHAR 1 0 NETMODMODE
0 Color
1 Form
2 Contents
NAVBG Background color for navigation area CHAR 11 0 TWCOL NETNAVBG
NAVFRMCOL Color of frame in navigation area CHAR 11 0 TWCOL NETNAVFRM
NODEBG Background color of node area CHAR 11 0 TWCOL NETNODEBG
NODESIZE Initial node size in display area NUMC 5 0 NETNODESZ
00500 Initial node size
OBUTTBG Background color of symbols in ordering window CHAR 11 0 TWCOL NETOBUTTBG
OBUTTFG Line color for ordering symbols CHAR 11 0 TWCOL NETOBUTTFG
ORDBG Background Color in Order Window CHAR 11 0 TWCOL NETORDBG
ORDFG Foreground Color in Order Window CHAR 11 0 TWCOL NETORDFG
SELLINECOL Color for link selection CHAR 11 0 TWCOL NETSELLINC
SELOBJMODE Selection mode for object type CHAR 1 0 NETSELOMOD
0 Links
1 Nodes
2 Nodes and links
3 Boxes
4 Frames
5 Boxes and frames
6 All
SELTYPMODE Mode for selection type CHAR 1 0 NETSELTMOD
0 Individual selection
1 Selection of an object with direct successor
2 Selection of an object with all successors
STATBG Background color for status line (is no longer used) CHAR 11 0 TWCOL NETSTATBG
STATFG Status line foreground color (no longer used) CHAR 11 0 TWCOL NETSTATFG
TRCKFRMCOL Color frame track CHAR 11 0 TWCOL NETTRCKFRM
USESAVE Flag: for activating symbol for saving CHAR 1 0 NETUSESAVE
VIEW1BG Background color for view 1 CHAR 11 0 TWCOL NETVIEW1BG
VIEW2BG Background color for view 2 CHAR 11 0 TWCOL NETVIEW2BG
VIEW3BG Background color for view 3 CHAR 11 0 TWCOL NETVIEW3BG
VOFFSET Vertical offset for scrolling NUMC 3 0 NETVOFFSET
WIDTH Dummy NUMC 4 0 NETNUMC4
XPERCENT Vertical window division in percent NUMC 3 0 NETXPERCNT
XPOS Dummy NUMC 4 0 NETNUMC4
YPERCENT Horizontal division of are in percent NUMC 3 0 NETYPERCNT
YPOS Dummy NUMC 4 0 NETNUMC4
ZOOMFAC Initial zoom factor NUMC 5 0 NETZOOMFAC
00005 Zoom factor
MARKLINK Link marking type CHAR 1 0 NETMRKLINK
CONMODE Mode when Connecting Nodes CHAR 1 0 NETCONMODE
0 First successor
1 Last successor
CUSMODE Flag: activate saving of options profile CHAR 1 0 NETCUSMODE
TIMER Time Interval for Passing Control to Calling Program NUMC 6 0 NETTIMER
000000 Time interval
DBLCLICK Flag: support double-click CHAR 1 0 NETDBCLICK
AUTOPORT Mode for unbundling edges CHAR 1 0 NETAUTOPRT
0 Do not unbundle edges
1 Unbundle edges entering a node
2 Unbundle edges leaving a node
3 Unbundle all edges of a node
UDM Mode for layout CHAR 1 0 NETUDMMODE
ROUNDED Flag: Use rounded corners in graphics CHAR 1 0 NETROUNDED
XPOSITION Initial horizontal position of the graphics window NUMC 3 0 NETXPOSIT
YPOSITION Initial vertical position of the graphics window NUMC 3 0 NETYPOSIT
XSIZE Width of graphics window NUMC 3 0 NETXSIZE
YSIZE Height of graphics window NUMC 3 0 NETYSIZE
TRACKOPT Path optimization in network graphics CHAR 1 0 NETTRACKOP
0 Not optimized
1 Optimized display
2 Always optimize
CLROWS Number of Rows in the Cluster Editor NUMC 3 0 NETCLROWS
CLCOLS Number of columns in cluster editor NUMC 3 0 NETCLCOLS
001 Number of Columns
CLRASTER Flag: Display grid in frame editor CHAR 1 0 NETRASTER
CLCOLWD Width of columns in cluster editor NUMC 5 0 NETCLCOLWD
01000 Column width
MASTERVIEW Drawing mode for the navigation window CHAR 1 0 NETMASTERV
0 Nodes without content, no marking, no links
1 Nodes with content, no marking, no links
2 Nodes without content, marking, no links
3 Nodes with content, marking, no links
4 Nodes without content, no marking, links
5 Nodes with content, no marking, no links
6 Nodes without content, marking, links
7 Nodes with content, marking, links
LEGEND Position of the legend in the network CHAR 1 0 NETLEGEND
0 Legend to the left
1 Legend to the right
2 Legend below
3 Legend not visible
SUBCHART Indicator: Area restriction active CHAR 1 0 NETSUBCHRT
SUBINDEX Text index for area restriction NUMC 2 0 NETSUBINDX
INFOTEXTS Show/hide info text CHAR 1 0 BCINFOTEXT
CONFIRM Flag: activate CONFIRM mode CHAR 1 0 NETCONFIRM
TITLEBOX Print/display header CHAR 1 0 NETTITLBOX
0 Title is visible and is printed
1 Title is not visible, but is printed
2 Title is not visible and is not printed
PORTSIZE Link symbol size in 1/100 mm NUMC 4 0 NETPORTSIZ
0000 Size in 1/100 mm
AUTO_CLUST Mode for positioning frames during alignment CHAR 1 0 NETAUTOCLS
0 Frames positioned by the application
1 Frames positioned automatically
2 Frames ignored (only nodes significant)
RANG Rank for network layout calculation CHAR 1 0 NETRANG
LAYOUT Mode for aligning graph in network CHAR 1 0 NETLAYOUT
0 Horizontal Alignment (standard values)
1 Vertical Alignment
CLDELS Space between columns in frame editor NUMC 4 0 NETCLDELS
0001 Column spacing
TBXZOOM Zoom with arrow keys CHAR 1 0 NETTBXZOOM
BREAKCON Deactivate link mode after executing once CHAR 1 0 NETBRKCON
ALIVE Interval for graphic to respond NUMC 4 0 NETALIVE
0000 Length of interval in seconds
NODELMSG Time interval for status text display NUMC 2 0 NETNODELMS
00 Seconds
INFOTXTNUM Text index for info text CHAR 2 0 NETINFONUM
AMODAL Flag: activate amodal processing CHAR 1 0 NETAMODAL
STGAUGE Activate scroll bar display CHAR 1 0 BCSTGAUGE
SHORTLINK Flag: move nodes together as close as possible CHAR 1 0 NETSHORTLK
USRPOPS Flag: activate object-sensitive popup CHAR 1 0 NETUSERPOP
LINKINCLUS Flag: Links within a frame CHAR 1 0 NETLINKINC
NOWARN Flag: Ignore warnings CHAR 1 0 NETNOWARN
NODELPOP Flag: Suppress confirmation for deletion CHAR 1 0 NETNODELPO
NODUPMOVE Indicator: Position boxes/nodes overlapping CHAR 1 0 NETNODUPMV
INNERPICKM Indicator: Inner pickmarks at frame CHAR 1 0 NETINPICKM
NOBOXMOVE Flag: Do not allow box movement CHAR 1 0 NETNOBOXMV
COMPACTNOD Mode for Positioning Isolated Nodes CHAR 1 0 NETCOMPACT
COMPCTINOD Flag: Align in area "insertable nodes" CHAR 1 0 NETCOMPIND
OWNLEGEND Flag: Font field CHAR 1 0 NETOWNLGND
PILEMODE Flag: Automatic scrolling through stack CHAR 1 0 NETPILEMOD
LINKOPTIM Flag: Link optimization in Network Graphics CHAR 1 0 NETLINKOPT
CUSTOMIZE Flag: Activate customizing mode CHAR 1 0 BCCUSTOMIZ
TOOLTIP Flag: Activate Tooltip CHAR 1 0 BCTOOLTIP
ROWPOSONLY Positioning only with Y coordinates CHAR 1 0 NETRPONLY
0 Positioning with X and Y coordinates
1 Rows are only set in clusters (UDM)
2 Rows observed everywhere
INSNODEPOS Flag: Give node positions when inserting CHAR 1 0 NETINSNDPO
BMPDISPAR Name of the graphic symbol for the display area CHAR 12 0 TGMF NETBMPDISP
BMPNODEAR Name of the graphic symbol file for the node area CHAR 12 0 TGMF NETBMPNOD
BMPNAVAR Name of the graphic symbol file for the navigation area CHAR 12 0 TGMF NETBMPNAV
UNQLNKSYMS Positioning link symbols NUMC 1 0 NETUNQLKSY
0 On node (default value)
1 Start on last clear edge piece (end on node)
2 Start on node (end on last clear edge piece)
3 On last clear edge piece
MOVEBTMPS Movement of bitmaps CHAR 1 0 NETMVBTMPS
BREAKLGND Wrap in legend CHAR 1 0 NETBRKLGND
DIAGLINES Diagonal links in network CHAR 1 0 NETDIAGLIN
INSATLINK Return link ID when inserting nodes CHAR 1 0 NETINSATLK
NOADJCONF Suppress dialog box when aligning CHAR 1 0 NETADJCONF
MENUMARK Selection of graphic objects with right mouse button CHAR 1 0 BCMENUMRK
NOSELWARN Suppress object reference dialog box CHAR 1 0 NETNOSLWRN
PHANTBAND Movement response of phantoms in network CHAR 1 0 NETPHNTBND
0 By pixel
1 By layer
2 Between layers
ENJOYLEVEL Enjoy level CHAR 1 0 BCENJOY
0 No Enjoy
1 Update the background of the charts
2 Update chart, table title, and background

TCNO foreign key relationships

Table Field Check Table Check Field
0 TCNO BMPDISPAR TGMF Files for Inclusion as Symbol MANDT
0 TCNO BMPDISPAR TGMF Files for Inclusion as Symbol GMF_FILE
1 TCNO BMPNAVAR TGMF Files for Inclusion as Symbol MANDT
1 TCNO BMPNAVAR TGMF Files for Inclusion as Symbol GMF_FILE
0 TCNO BMPNODEAR TGMF Files for Inclusion as Symbol MANDT
0 TCNO BMPNODEAR TGMF Files for Inclusion as Symbol GMF_FILE
1 TCNO DISPBG TWCOL Possible colors (W lib) MANDT
0 TCNO LAYBG TWCOL Possible colors (W lib) MANDT
1 TCNO LAYFG TWCOL Possible colors (W lib) MANDT
0 TCNO LBUTTBG TWCOL Possible colors (W lib) MANDT
1 TCNO LBUTTFG TWCOL Possible colors (W lib) MANDT
0 TCNO NAVBG TWCOL Possible colors (W lib) MANDT
1 TCNO NAVFRMCOL TWCOL Possible colors (W lib) MANDT
0 TCNO NODEBG TWCOL Possible colors (W lib) MANDT
1 TCNO OBUTTBG TWCOL Possible colors (W lib) MANDT
0 TCNO OBUTTFG TWCOL Possible colors (W lib) MANDT
1 TCNO ORDBG TWCOL Possible colors (W lib) MANDT
0 TCNO ORDFG TWCOL Possible colors (W lib) MANDT
1 TCNO SELLINECOL TWCOL Possible colors (W lib) MANDT
0 TCNO STATBG TWCOL Possible colors (W lib) MANDT
1 TCNO STATFG TWCOL Possible colors (W lib) MANDT
0 TCNO TRCKFRMCOL TWCOL Possible colors (W lib) MANDT
1 TCNO VIEW1BG TWCOL Possible colors (W lib) MANDT
0 TCNO VIEW2BG TWCOL Possible colors (W lib) MANDT
1 TCNO VIEW3BG TWCOL Possible colors (W lib) MANDT