SAP table TFMT (Format attributes in VarChart graphics)
SAP table TFMT has 2 primary key fields being MANDT,NAME.
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
NAME
Name of form definition
CHAR
6
0
NETFMTKEY
LAYOUT_A
Layout definition for positions 1 to 50
CHAR
50
0
VCLAYOUT_1
LAYOUT_B
Layout definition for positions 51 to 100
CHAR
50
0
VCLAYOUT_2
LAYOUT_C
Layout definition for positions 101 to 150
CHAR
50
0
VCLAYOUT_3
LAYOUT_D
Layout definition for positions 151 to 200
CHAR
50
0
VCLAYOUT_4
FRAMESHAPE
Shape of frame
CHAR
16
0
TFRSP
VCFRAMESHP
D3_EFFECT
Flag: 3D effect
CHAR
1
0
VC3DEFFECT
SHADOW
Flag: shadow
CHAR
1
0
VCSHADOW
SHADOW_COL
Frame color
CHAR
11
0
TWCOL
VCSHADCOL
LINE_WIDTH
Frame width
NUMC
4
0
VCLINWIDTH
DOUBLE_FRM
Double frame
CHAR
1
0
VCDOUBLEF
TOP_HOT
Hot area above the object
NUMC
5
0
VCTMARG
LEFT_HOT
Hot area to the left of the object
NUMC
5
0
VCLMARG
RIGHT_HOT
Hot area to the right of the object
NUMC
5
0
VCRMARG
BOTTOM_HOT
Hot area below object
NUMC
5
0
VCBMARG
ALL_HOT
Hot area in the vicinity of the object
NUMC
5
0
VCAMARG
TIME_EGG
Indicator element
CHAR
1
0
VCTIMEEGG
LINE_DIST
Dummy
NUMC
4
0
NETNUMC4
USE_NODE
Flag: use for linking lines diagram area
CHAR
1
0
VCUSENODE
USE_BOX
Flag: use chart title in bar chart
CHAR
1
0
VCUSEBOX
USE_TABBOX
ID: Use for graphic objects in table area
CHAR
1
0
VCUSETABBX
PILES
Flag: stack active
CHAR
1
0
VCPILES
PILESCOUNT
Number of stacks
NUMC
1
0
VCPILESCNT
Possible values
1
One stack
2
Two stacks
3
Three stacks
4
Three stacks
5
Five stacks
6
Six stacks
7
Seven stacks
8
Eight stacks
9
Nine stacks
PILESCOLOR
Stack color
CHAR
11
0
TWCOL
VCPILESCOL
VARTEXTLEN
Variable text length for outer fields
CHAR
1
0
VCVARTXLEN
USE_LAYER
Flag: Use for graphic object/element
CHAR
1
0
VCUSELAYER
USE_RIBBON
Flag: Use for scale
CHAR
1
0
VCUSERIBB
CROSSFIELD
Flag: Outer fields crossed by links
CHAR
1
0
VCCROSSFLD
CNTRLNKTXT
Centered link label
CHAR
1
0
VCCNTLKTXT
TFMT foreign key relationships
Table
Field
Check Table
Check Field
0 TFMT
FRAMESHAPE
TFRSP
Frame Form in VarChart
MANDT
1 TFMT
PILESCOLOR
TWCOL
Possible colors (W lib)
MANDT
0 TFMT
SHADOW_COL
TWCOL
Possible colors (W lib)
MANDT