SAP table TFAT (Field Attributes in VarChart Graphics)

SAP table TFAT has 3 primary key fields being MANDT,FMT_NAME,FLD_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
FMT_NAME Name of form definition CHAR 6 0 TFMT NETFMTKEY
FLD_NAME Field identification CHAR 1 0 NETFLDKEY
TC_ENTRY Text index CHAR 2 0 VCTCENTRY
0 One-position text index followed by a blank
0 One-position text index with leading blank
00 Two-position text index
1 One-position text index followed by a blank
1 One-position text index with leading blank
10 Two-position text index
2 One-position text index followed by a blank
2 One-position text index with leading blank
20 Two-position text index
3 One-position text index followed by a blank
3 One-position text index with leading blank
30 Two-position text index
4 One-position text index followed by a blank
4 One-position text index with leading blank
40 Two-position text index
5 One-position text index followed by a blank
5 One-position text index with leading blank
50 Two-position text index
6 One-position text index followed by a blank
6 One-position text index with leading blank
60 Two-position text index
7 One-position text index followed by a blank
7 One-position text index with leading blank
70 Two-position text index
8 One-position text index followed by a blank
8 One-position text index with leading blank
80 Two-position text index
9 One-position text index followed by a blank
9 One-position text index with leading blank
90 Two-position text index
FONT_NAME Font CHAR 9 0 VCFONTNAME
COURIER Courier
HELVETICA Helvetica
TIMES Times
FONT_BODY Font style for text in field CHAR 14 0 TFTBY VCFONTBODY
FONT_SIZE Font size for text in field NUMC 3 0 VCFONTSIZE
001 Specify in millimeters or pixel
MIN_WIDTH Minimum field width in 1/100mm NUMC 5 0 VCMINFWDTH
N_OF_LINES Number of lines in field NUMC 2 0 VCNOFLINES
LINE_SPACE Line spacing in field NUMC 3 0 VCLINESPAC
FG_COLOR Color of text in field CHAR 11 0 TWCOL VCFGCOL
AUTO_WRAP Automatic line break for blanks CHAR 1 0 VCAUTOWRAP
ALL_MRG Distance between text and field border NUMC 5 0 VCFAMARG
TOP_MRG Distance between text and upper border of field NUMC 5 0 VCFTMARG
LEFT_MRG Left margin in field NUMC 5 0 VCFLMARG
RIGHT_MRG Right margin in field NUMC 5 0 VCFRMARG
BOTTOM_MRG Distance between text and lower border of the field NUMC 5 0 VCFBMARG
HOR_ALIGN Horizontal alignment of field text CHAR 9 0 VCHORALIGN
VC_CENTER Centered
VC_LEFT Left
VC_RIGHT Right
VER_ALIGN Vertical alignment of field contents CHAR 9 0 VCVERALIGN
VC_BOTTOM Bottom
VC_CENTER Centered
VC_TOP Top
GMF_FILE Name of file for the graphic symbol CHAR 12 0 TGMF VCGMFFILE
LOGO_WIDTH Width of symbol NUMC 4 0 VCLOGOWDTH
LOGO_HIGHT Height of logo NUMC 4 0 VCLOGOHGHT
USE_MARK Flag: Use as selection column in bar chart CHAR 1 0 VCUSEMARK
OVER_BOARD Flag: Text can exceed field border CHAR 1 0 VCOVERBORD
TEXT_SPACE Spacing of label text NUMC 4 0 VCTXTSPACE
0010 Pixel
WRAP_MODE Text wrap in field CHAR 1 0 VCWRAPMODE
0 Words can be split (default)
1 Line always starts with a new word; cutoff possible
2 Line always starts with a new word; words exceed field

TFAT foreign key relationships

Table Field Check Table Check Field
0 TFAT FG_COLOR TWCOL Possible colors (W lib) MANDT
1 TFAT FMT_NAME TFMT Format attributes in VarChart graphics MANDT
1 TFAT FMT_NAME TFMT Format attributes in VarChart graphics NAME
0 TFAT FONT_BODY TFTBY Font Type in VarChart MANDT
1 TFAT GMF_FILE TGMF Files for Inclusion as Symbol MANDT
1 TFAT GMF_FILE TGMF Files for Inclusion as Symbol GMF_FILE