SAP table TBCL (Layer types in bar chart)

SAP table TBCL has 3 primary key fields being MANDT,PROFILE,TYPE.

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
PROFILE Graphic element group CHAR 6 0 BCLAYPROF
TYPE Graphic element type CHAR 2 0 BCLAYTYP
HLT Color of the graphic element CHAR 6 0 THLT BCLAYCOLOR
LAYER_TYPE Type of graphic element CHAR 1 0 BCLAYERTYP
L Line
R Rectangle
S Symbol
FIRSTDATE Index for first date in the graphic element INT4 10 0 BCLAYFIRST
SECONDDATE Index for second date in graphic element INT4 10 0 BCLAYSECND
HEIGHT Height of graphic element INT4 10 0 BCLAYHGHT
OFFSET Vertical offset of the graphic element INT4 10 0 BCLAYOFFST
SYMBOLTYPE Predefined symbol NUMC 2 0 BCLAYSYTYP
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 CHAR 6 0 TFMT BCLAYFMT
LAYPRIO Drawing level for graphic element NUMC 3 0 BCLAYPRIO
000 Drawing level for graphic element
GAPTYPE Representation of break for the graphic element CHAR 1 0 BCGAPTYPE
0 Invisible
1 Rectangle
2 Line (default)
GAPHLT Background color for the break in the graphic element CHAR 6 0 THLT BCGAPHLT
BMP_FILE Name of file for the graphic symbol CHAR 12 0 TGMF VCGMFFILE
NOT_MOVE Fix the graphic element CHAR 1 0 BCLAYMOMVE
HOR_OFFSET Horizontal offset of chart symbols (percentage) INT4 10 0 BCHOROFFST
NULL_SHOW Display graphic element without duration CHAR 1 0 BCNULLLENS

TBCL foreign key relationships

Table Field Check Table Check Field
0 TBCL BMP_FILE TGMF Files for Inclusion as Symbol MANDT
0 TBCL BMP_FILE TGMF Files for Inclusion as Symbol GMF_FILE
1 TBCL FMT TFMT Format attributes in VarChart graphics MANDT
1 TBCL FMT TFMT Format attributes in VarChart graphics NAME
0 TBCL GAPHLT THLT VarChart Graphics: Color Attributes MANDT
0 TBCL GAPHLT THLT VarChart Graphics: Color Attributes NAME
1 TBCL HLT THLT VarChart Graphics: Color Attributes MANDT
1 TBCL HLT THLT VarChart Graphics: Color Attributes NAME