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
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