SAP Table TICL160

Generation of Benefit Type Tree

TICL160 (Generation of Benefit Type Tree) 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 TICL160 to other SAP tables.

TICL160 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
BENTREE Benefit Type Tree ICL_BENTREE CHAR 8 0
VERSION Generation of Benefit Type Tree ICL_BENTREEG NUMC 5 0
ACTIVE Status ICL_ACTIVE2 CHAR 1 0
A Active
S Suspense
I Inactive
T Transport
L Transport (to generation belonging to version)
D Active deletion entry
CHANGEDBY Generation Created By ICL_CHANGEBYG USR02 CHAR 12 0
CHANGETIME Generation Created: Date + Time ICL_CHANGEUTCG DEC 15 0
INACTIVETIME Generation Deactivated: Date + Time ICL_INACTIUTCG DEC 15 0
EFFFROMTIME Generation Valid From Renewal: Date + Time ICL_EFFROMUTCG DEC 15 0
EFFTOTIME Generation Valid Until Renewal: Date + Time ICL_EFFETOUTCG DEC 15 0
TERMTIME Valid-To Date Set: Date + Time ICL_TERMINUTC DEC 15 0
DELETED Flag: Deletion Entry? ICL_XDELETE CHAR 1 0
X Yes
NULL No
OVERSION Generation of Internal Claim Type in Original System ICL_CLTYPEGO NUMC 5 0
OSYSID Original System of Version ICL_OSYSID CHAR 8 0
OMANDT Client in Original System ICL_OMANDT CLNT 3 0
BVERSION Basis Generation ICL_CLTYPEGB NUMC 5 0
GENERAT_REF Reference Generation ICL_PI_GENERAT_REF CHAR 32 0

TICL160 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TICL160 CHANGEDBY TICL160 CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
TICL160 CHANGEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
TICL160 CLIENT TICL160 CLIENT T000 Clients MANDT