SAP Table TBCL

Layer types in bar chart

TBCL (Layer types in bar chart) 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 TBCL to other SAP tables.

TBCL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PROFILE Graphic element group BCLAYPROF CHAR 6 0
TYPE Graphic element type BCLAYTYP CHAR 2 0
HLT Color of the graphic element BCLAYCOLOR THLT CHAR 6 0
LAYER_TYPE Type of graphic element BCLAYERTYP CHAR 1 0
L Line
R Rectangle
S Symbol
FIRSTDATE Index for first date in the graphic element BCLAYFIRST INT4 10 0
SECONDDATE Index for second date in graphic element BCLAYSECND INT4 10 0
HEIGHT Height of graphic element BCLAYHGHT INT4 10 0
OFFSET Vertical offset of the graphic element BCLAYOFFST INT4 10 0
SYMBOLTYPE Predefined symbol BCLAYSYTYP NUMC 2 0
01 Arrow pointing downwards
02 Triangle pointing downwards
03 Arrow pointing to the right (greater than symbol)
04 Narrow triangle pointing upwards
05 Triangle pointing to the right
06 Triangle pointing to the left
07 Rhombus
08 Triangles pointing towards each other (fly/lying hourglass
09 Narrow triangle pointing downwards
10 Square
11 Circle
12 Arrow pointing downwards in circle
13 Triangle pointing downwards in circle
14 Arrow pointing to the right (greater than symb.) in circle
15 Narrow triangle pointing upwards in circle
16 Triangle pointing to the right in circle
17 Triangle pointing to the left in circle
18 Rhombus in circle
19 Triangles pointing towards each other in circle
20 Narrow triangle pointing downwards in the circle
21 Square in circle
FMT Form definition for the graphic elements BCLAYFMT TFMT CHAR 6 0
LAYPRIO Drawing level for graphic element BCLAYPRIO NUMC 3 0
000 Drawing level for graphic element
GAPTYPE Representation of break for the graphic element BCGAPTYPE CHAR 1 0
0 Invisible
1 Rectangle
2 Line (default)
GAPHLT Background color for the break in the graphic element BCGAPHLT THLT CHAR 6 0
BMP_FILE Name of file for the graphic symbol VCGMFFILE TGMF CHAR 12 0
NOT_MOVE Fix the graphic element BCLAYMOMVE CHAR 1 0
X Yes
NULL No
HOR_OFFSET Horizontal offset of chart symbols (percentage) BCHOROFFST INT4 10 0
NULL_SHOW Display graphic element without duration BCNULLLENS CHAR 1 0
X Yes
NULL No

TBCL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TBCL BMP_FILE TBCL MANDT TGMF Files for Inclusion as Symbol MANDT
TBCL BMP_FILE TBCL BMP_FILE TGMF Files for Inclusion as Symbol GMF_FILE
TBCL FMT TBCL MANDT TFMT Format attributes in VarChart graphics MANDT
TBCL FMT TBCL FMT TFMT Format attributes in VarChart graphics NAME
TBCL GAPHLT TBCL MANDT THLT VarChart Graphics: Color Attributes MANDT
TBCL GAPHLT TBCL GAPHLT THLT VarChart Graphics: Color Attributes NAME
TBCL HLT TBCL HLT THLT VarChart Graphics: Color Attributes NAME
TBCL HLT TBCL MANDT THLT VarChart Graphics: Color Attributes MANDT
TBCL MANDT TBCL MANDT T000 Clients MANDT