SAP TICL321 Policy Product Version Table data and field list

TICL321 is a standard SAP Table which is used to store Policy Product Version data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TICL321 table consists of various fields, each holding specific information or linking keys about Policy Product Version data available in SAP. These include POLPROD (Policy Product), GENERAT (Policy Product Generation), VERSION (Policy Product Version), 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. .

TICL321 table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TICL321T


SAP TICL321 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TICL321 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
POLPRODPolicy Product ICL_POLPRODCHAR6TICL320ICL_POLPROD
GENERATPolicy Product Generation ICL_GENERATNUMC5TICL320ICL_GENERAT
VERSIONPolicy Product Version ICL_POLPRODVNUMC5ICL_CUST_VERSION
ACTIVEStatus ICL_ACTIVE2CHAR1ICL_ACTIVE2
CHANGEDBYVersion Created By (= Object Changed By) ICL_CHANGEBYCHAR12USR02XUBNAME
CHANGETIMEVersion Created: Date + Time ICL_CHANGEUTCDEC15TSTAMICL_TIMESTAMP
INACTIVETIMEVersion Deactivated: Date + Time ICL_INACTIUTCDEC15TSTAMICL_TIMESTAMP
EFFFROMTIMEVersion Valid From: Date + Time ICL_EFFROMUTCDEC15TSTAMICL_TIMESTAMP
EFFTOTIMEVersion Valid To: Date + Time ICL_EFFETOUTCDEC15TSTAMICL_TIMESTAMP
TERMTIMEValid-To Date Set: Date + Time ICL_TERMINUTCDEC15TSTAMICL_TIMESTAMP
DELETEDFlag: Deletion Entry? ICL_XDELETECHAR1XFELD
OVERSIONVersion in Original System ICL_CLTYPEVONUMC5Assigned to domainICL_CLTYPEV
OSYSIDOriginal System of Version ICL_OSYSIDCHAR8SYCHAR08
OMANDTClient in Original System ICL_OMANDTCLNT3Assigned to domainMANDT
BVERSIONBasis Version ICL_CLTYPEVBNUMC5Assigned to domainICL_CLTYPEV
VERSION_REFReference Version ICL_PI_VERSION_REFCHAR32ICL_PI_OBJKEY
PLINEOFBUSInsurance Line of Business ICL_LINEOFBUSCHAR3TICL007ICL_LINEOFBUS
COMPANYCODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
CURRCurrency for All reserves, Limits and Deductibles ICL_POLPROD04CUKY5TCURCWAERS
CDSPECSpecification for FS-CD Posting ICL_CDSPECCHAR4TICL326CHAR4
XADDRDETAdditional Address Fields Displayed ICL_XADDRDETCHAR1XFELD
CDUSAGEIntegration with Collections/Disbursements ICL_CDUSAGECHAR1ICL_CDUSAGE
BENTREEBenefit Type Tree at Policy Product Level ICL_PBENTREECHAR8TICL160ICL_BENTREE
PPOLPRODHigher-Level Policy Product (Not Supported) ICL_PPOLPRODCHAR6TICL319ICL_POLPROD
MULT_INS_RISKS_FLAGUse Multiple Insured Objects ICL_MIR_FLAG_DCHAR1ICL_MIR_FLAG

Key field Non-key field



How do I retrieve data from SAP table TICL321 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TICL321 to SELECT all data from the table
DATA: WA_TICL321 TYPE TICL321.

SELECT SINGLE *
FROM TICL321
INTO CORRESPONDING FIELDS OF WA_TICL321
WHERE...

How to access SAP table TICL321

Within an ECC or HANA version of SAP you can also view further information about TICL321 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to TICL321

    ICLCLAIM - Claim
        ICLSUBCL - Subclaim
            TICL321 - Policy Product Version
            ICLPAY - Claim Payment
            ICLRESERVE - Case Reserve