SAP table GB90 (Boolean Formula Header for Rules and Boolean Functions)

SAP table GB90 has 2 primary key fields being MANDT,BOOLID.

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
BOOLID Boolean Rule Name CHAR 11 0 BOOL_ID
BOOLTYPE Boolean Function Type CHAR 1 0 BOOLTYPE
A Subrule
C Prerequisite for a substitution
E Prerequisite for a validation
F Check for a validation
G General prerequisite
CLASSID Boolean Class. Which Fields Can Be Used. CHAR 3 0 GB02 BOOLCLASS
AUTHGR Authorization Group CHAR 4 0 TBRG BRGRU
GBOPCREATE User Who Created Boolean Object CHAR 12 0 GBOPCREATE
GBDTCREATE Created On DATS 8 0 GBDTCREATE
GBTMCREATE Time When the Boolean Object Was Created TIMS 6 0 GBTMCREATE
GBOPCHANGE Last Changed By CHAR 12 0 GBOPCHANGE
GBDTCHANGE Last Changed On DATS 8 0 GBDTCHANGE
GBTMCHANGE Time of Last Change TIMS 6 0 GBTMCHANGE
INITEXIT Initialization Exit for Validations/Substitutions/Rules CHAR 5 0 EXITIBOOL
MULTILINE Indicator: Complex Structure/Mathematical Contents CHAR 1 0 MULTIMATHS
A Single-line / No mathematical operation
B Single-line / Simple mathematical operation
C Single-line / Complex mathematical operation
D Multi-line / No mathematical operation
E Multi-line / Simple mathematical operation
F Multi-line / Complex mathematical operation

GB90 foreign key relationships

Table Field Check Table Check Field
0 GB90 AUTHGR TBRG Authorization groups MANDT
0 GB90 AUTHGR TBRG Authorization groups BRGRU
1 GB90 MANDT T000 Clients MANDT