SAP Table TICL321
Policy Product Version
TICL321 (Policy Product Version) 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 TICL321 to other SAP tables.
TICL321 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| POLPROD | Policy Product | ICL_POLPROD | TICL320 | CHAR | 6 | 0 | ||||||||||||||
| GENERAT | Policy Product Generation | ICL_GENERAT | TICL320 | NUMC | 5 | 0 | ||||||||||||||
| VERSION | Policy Product Version | ICL_POLPRODV | NUMC | 5 | 0 | |||||||||||||||
| ACTIVE | Status | ICL_ACTIVE2 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| CHANGEDBY | Version Created By (= Object Changed By) | ICL_CHANGEBY | USR02 | CHAR | 12 | 0 | ||||||||||||||
| CHANGETIME | Version Created: Date + Time | ICL_CHANGEUTC | DEC | 15 | 0 | |||||||||||||||
| INACTIVETIME | Version Deactivated: Date + Time | ICL_INACTIUTC | DEC | 15 | 0 | |||||||||||||||
| EFFFROMTIME | Version Valid From: Date + Time | ICL_EFFROMUTC | DEC | 15 | 0 | |||||||||||||||
| EFFTOTIME | Version Valid To: Date + Time | ICL_EFFETOUTC | DEC | 15 | 0 | |||||||||||||||
| TERMTIME | Valid-To Date Set: Date + Time | ICL_TERMINUTC | DEC | 15 | 0 | |||||||||||||||
| DELETED | Flag: Deletion Entry? | ICL_XDELETE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| OVERSION | Version in Original System | ICL_CLTYPEVO | 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 Version | ICL_CLTYPEVB | NUMC | 5 | 0 | |||||||||||||||
| VERSION_REF | Reference Version | ICL_PI_VERSION_REF | CHAR | 32 | 0 | |||||||||||||||
| PLINEOFBUS | Insurance Line of Business | ICL_LINEOFBUS | TICL007 | CHAR | 3 | 0 | ||||||||||||||
| COMPANYCODE | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||
| CURR | Currency for All reserves, Limits and Deductibles | ICL_POLPROD04 | TCURC | CUKY | 5 | 0 | ||||||||||||||
| CDSPEC | Specification for FS-CD Posting | ICL_CDSPEC | TICL326 | CHAR | 4 | 0 | ||||||||||||||
| XADDRDET | Additional Address Fields Displayed | ICL_XADDRDET | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| CDUSAGE | Integration with Collections/Disbursements | ICL_CDUSAGE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BENTREE | Benefit Type Tree at Policy Product Level | ICL_PBENTREE | TICL160 | CHAR | 8 | 0 | ||||||||||||||
| PPOLPROD | Higher-Level Policy Product (Not Supported) | ICL_PPOLPROD | TICL319 | CHAR | 6 | 0 | ||||||||||||||
| MULT_INS_RISKS_FLAG | Use Multiple Insured Objects | ICL_MIR_FLAG_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
TICL321 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TICL321 | BENTREE | TICL321 | CLIENT | TICL160 | Generation of Benefit Type Tree | CLIENT |
| TICL321 | BENTREE | TICL321 | BENTREE | TICL160 | Generation of Benefit Type Tree | BENTREE |
| TICL321 | BENTREE | * | TICL160 | Generation of Benefit Type Tree | VERSION | |
| TICL321 | CDSPEC | TICL321 | CLIENT | TICL326 | Standard Attributes for FS-CD Insurance Object in Contract | CLIENT |
| TICL321 | CDSPEC | TICL321 | CDSPEC | TICL326 | Standard Attributes for FS-CD Insurance Object in Contract | CDSPEC |
| TICL321 | CHANGEDBY | TICL321 | CLIENT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| TICL321 | CHANGEDBY | TICL321 | CHANGEDBY | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| TICL321 | CLIENT | TICL321 | CLIENT | T000 | Clients | MANDT |
| TICL321 | COMPANYCODE | TICL321 | CLIENT | T001 | Company Codes | MANDT |
| TICL321 | COMPANYCODE | TICL321 | COMPANYCODE | T001 | Company Codes | BUKRS |
| TICL321 | CURR | TICL321 | CLIENT | TCURC | Currency Codes | MANDT |
| TICL321 | CURR | TICL321 | CURR | TCURC | Currency Codes | WAERS |
| TICL321 | GENERAT | TICL321 | CLIENT | TICL320 | Policy Product Generation | CLIENT |
| TICL321 | GENERAT | TICL321 | POLPROD | TICL320 | Policy Product Generation | POLPROD |
| TICL321 | GENERAT | TICL321 | GENERAT | TICL320 | Policy Product Generation | VERSION |
| TICL321 | PLINEOFBUS | TICL321 | PLINEOFBUS | TICL007 | Insurance Line of Business | PLINEOFBUS |
| TICL321 | PLINEOFBUS | TICL321 | CLIENT | TICL007 | Insurance Line of Business | CLIENT |
| TICL321 | POLPROD | * | TICL320 | Policy Product Generation | VERSION | |
| TICL321 | POLPROD | TICL321 | CLIENT | TICL320 | Policy Product Generation | CLIENT |
| TICL321 | POLPROD | TICL321 | POLPROD | TICL320 | Policy Product Generation | POLPROD |
| TICL321 | PPOLPROD | TICL321 | CLIENT | TICL319 | Policy Product (Time-Independent Properties) | CLIENT |
| TICL321 | PPOLPROD | TICL321 | PPOLPROD | TICL319 | Policy Product (Time-Independent Properties) | POLPROD |
