TICL161 SAP (Version of Benefit Type Tree) Table details
Dictionary Type: Table
Description: Version of Benefit Type Tree
Description: Version of Benefit Type Tree
Table field list including key, data, relationships and ABAP select examples
TICL161 is a standard SAP Table which is used to store Version of Benefit Type Tree data and is available within R/3 SAP systems depending on the version and release level.
The TICL161 table consists of various fields, each holding specific information or linking keys about Version of Benefit Type Tree data available in SAP. These include BENTREE (Benefit Type Tree), GENERAT (Generation of Benefit Type Tree), VERSION (Version of Benefit Type Tree), ACTIVE (Status).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TICL161T
SAP TICL161 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BENTREE | Benefit Type Tree | ICL_BENTREE | CHAR | 8 | Assigned to domain | ICL_BENTREE | |||
GENERAT | Generation of Benefit Type Tree | ICL_BENTREEG | NUMC | 5 | TICL160 | ICL_BENTREEG | |||
VERSION | Version of Benefit Type Tree | ICL_BENTREEV | NUMC | 5 | ICL_BENTREEV | ||||
ACTIVE | Status | ICL_ACTIVE2 | CHAR | 1 | ICL_ACTIVE2 | ||||
CHANGEDBY | Version Created By (= Object Changed By) | ICL_CHANGEBY | CHAR | 12 | USR02 | XUBNAME | |||
CHANGETIME | Version Created: Date + Time | ICL_CHANGEUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
INACTIVETIME | Version Deactivated: Date + Time | ICL_INACTIUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
EFFFROMTIME | Version Valid From: Date + Time | ICL_EFFROMUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
EFFTOTIME | Version Valid To: Date + Time | ICL_EFFETOUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
TERMTIME | Valid-To Date Set: Date + Time | ICL_TERMINUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
DELETED | Flag: Deletion Entry? | ICL_XDELETE | CHAR | 1 | XFELD | ||||
OVERSION | Version in Original System | ICL_CLTYPEVO | NUMC | 5 | Assigned to domain | ICL_CLTYPEV | |||
OSYSID | Original System of Version | ICL_OSYSID | CHAR | 8 | SYCHAR08 | ||||
OMANDT | Client in Original System | ICL_OMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BVERSION | Basis Version | ICL_CLTYPEVB | NUMC | 5 | Assigned to domain | ICL_CLTYPEV | |||
VERSION_REF | Reference Version | ICL_PI_VERSION_REF | CHAR | 32 | ICL_PI_OBJKEY | ||||
CURR | Currency for All Amount Fields of Benefit Type Tree | ICL_BENTREE01 | CUKY | 5 | TCURC | WAERS | |||
PBENTREE | Higher-Level Benefit Type Tree | ICL_BENTREE02 | CHAR | 8 | TICL160 | ICL_BENTREE | |||
XSUBCLAIM | Benefit Type Tree Only Used for Coverage Types | ICL_XSUBCLBENTREE | CHAR | 1 | XFELD | ||||
BENTREECAT | Category of Benefit Type Tree | ICL_BENTREE_CAT | CHAR | 1 | ICL_BENTREE_CAT | ||||
AWAITPERREJR | Rejection Due to General Probationary Periods | ICL_AWAITPERREJR | CHAR | 2 | TICL022 | ICL_REJREASON | |||
BWAITPERREJR | Rejection Due to Special Probationary Period | ICL_BWAITPERREJR | CHAR | 2 | TICL022 | ICL_REJREASON |
Key field | Non-key field |
How do I retrieve data from SAP table TICL161 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TICL161 to SELECT all data from the tableDATA: WA_TICL161 TYPE TICL161.
SELECT SINGLE *
FROM TICL161
INTO CORRESPONDING FIELDS OF WA_TICL161
WHERE...
How to access SAP table TICL161
Within an ECC or HANA version of SAP you can also view further information about TICL161 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects