SAP Table TFAT

Field Attributes in VarChart Graphics

TFAT (Field Attributes in VarChart Graphics) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TFAT to other SAP tables.

TFAT table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

FMT_NAME

Name of form definition

NETFMTKEY

TFMT

CHAR

FLD_NAME

Field identification

NETFLDKEY

CHAR

TC_ENTRY

Text index

VCTCENTRY

CHAR

Possible values

0	One-position text index followed by a blank
1	One-position text index followed by a blank
2	One-position text index followed by a blank
3	One-position text index followed by a blank
4	One-position text index followed by a blank
5	One-position text index followed by a blank
6	One-position text index followed by a blank
7	One-position text index followed by a blank
8	One-position text index followed by a blank
9	One-position text index followed by a blank
0	One-position text index with leading blank
1	One-position text index with leading blank
2	One-position text index with leading blank
3	One-position text index with leading blank
4	One-position text index with leading blank
5	One-position text index with leading blank
6	One-position text index with leading blank
7	One-position text index with leading blank
8	One-position text index with leading blank
9	One-position text index with leading blank
00	Two-position text index
10	Two-position text index
20	Two-position text index
30	Two-position text index
40	Two-position text index
50	Two-position text index
60	Two-position text index
70	Two-position text index
80	Two-position text index
90	Two-position text index

FONT_NAME

Font

VCFONTNAME

CHAR

Possible values

HELVETICA	Helvetica
COURIER	Courier
TIMES	Times

FONT_BODY

Font style for text in field

VCFONTBODY

TFTBY

CHAR

FONT_SIZE

Font size for text in field

VCFONTSIZE

NUMC

Possible values

001	Specify in millimeters or pixel

MIN_WIDTH

Minimum field width in 1/100mm

VCMINFWDTH

NUMC

N_OF_LINES

Number of lines in field

VCNOFLINES

NUMC

LINE_SPACE

Line spacing in field

VCLINESPAC

NUMC

FG_COLOR

Color of text in field

VCFGCOL

TWCOL

CHAR

AUTO_WRAP

Automatic line break for blanks

VCAUTOWRAP

CHAR

Possible values

X	Yes
NULL	No

ALL_MRG

Distance between text and field border

VCFAMARG

NUMC

Possible values

00001	Width of the border in 1/100 mm

TOP_MRG

Distance between text and upper border of field

VCFTMARG

NUMC

Possible values

00001	Width of the border in 1/100 mm

LEFT_MRG

Left margin in field

VCFLMARG

NUMC

Possible values

00001	Width of the border in 1/100 mm

RIGHT_MRG

Right margin in field

VCFRMARG

NUMC

Possible values

00001	Width of the border in 1/100 mm

BOTTOM_MRG

Distance between text and lower border of the field

VCFBMARG

NUMC

Possible values

00001	Width of the border in 1/100 mm

HOR_ALIGN

Horizontal alignment of field text

VCHORALIGN

CHAR

Possible values

VC_LEFT	Left
VC_CENTER	Centered
VC_RIGHT	Right

VER_ALIGN

Vertical alignment of field contents

VCVERALIGN

CHAR

Possible values

VC_TOP	Top
VC_CENTER	Centered
VC_BOTTOM	Bottom

GMF_FILE

Name of file for the graphic symbol

VCGMFFILE

TGMF

CHAR

LOGO_WIDTH

Width of symbol

VCLOGOWDTH

NUMC

LOGO_HIGHT

Height of logo

VCLOGOHGHT

NUMC

USE_MARK

Flag: Use as selection column in bar chart

VCUSEMARK

CHAR

Possible values

X	Yes
NULL	No

OVER_BOARD

Flag: Text can exceed field border

VCOVERBORD

CHAR

Possible values

X	Yes
NULL	No

TEXT_SPACE

Spacing of label text

VCTXTSPACE

NUMC

Possible values

0010	Pixel

WRAP_MODE

Text wrap in field

VCWRAPMODE

CHAR

Possible values

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	Foreign key table	Foreign key field	Check table		Check field
TFAT	FG_COLOR	TFAT	MANDT	TWCOL	Possible colors (W lib)	MANDT
TFAT	FG_COLOR	TFAT	FG_COLOR	TWCOL	Possible colors (W lib)	COLOR
TFAT	FMT_NAME	TFAT	FMT_NAME	TFMT	Format attributes in VarChart graphics	NAME
TFAT	FMT_NAME	TFAT	MANDT	TFMT	Format attributes in VarChart graphics	MANDT
TFAT	FONT_BODY	TFAT	MANDT	TFTBY	Font Type in VarChart	MANDT
TFAT	FONT_BODY	TFAT	FONT_BODY	TFTBY	Font Type in VarChart	FONT_BODY
TFAT	GMF_FILE	TFAT	MANDT	TGMF	Files for Inclusion as Symbol	MANDT
TFAT	GMF_FILE	TFAT	GMF_FILE	TGMF	Files for Inclusion as Symbol	GMF_FILE
TFAT	MANDT	TFAT	MANDT	T000	Clients	MANDT