TICL055
Leistungsart
TICL055 is an SAP database table in S/4HANA. Leistungsart. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurClmBenefitType | view | from | BASIC | Leistungsart |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | bentype | icl_bentype | Benefit Type | |||
| bentype_ref | icl_pi_bentype_ref | Ref.BenefitType | ||||
| lossexp | icl_lossexp | Losses/Expenses | ||||
| xrecovery | icl_xrecovery | Expectation Res | ||||
| category_id | icl_category_id_ext | Prod. Category | ||||
| product_type | icl_product_type | Product Type | ||||
| xcrossstype | icl_xcrossstype | Cross-Coverage Type | ||||
| extbentype | icl_extbentype | Benefit Type | ||||
| defobjcat | icl_deflt_iobcat | Category | ||||
| defobjtype | icl_deflt_iobtype | Object Type | ||||
| bentypecat | icl_bentypecat | Ben.Type Area | ||||
| disability_class | icl_disability_class | Disability Class | ||||
| xprofile | icl_profile_flag | Profile | ||||
| withdrawtyp | icl_withdrawtype_d | Withdrawal Type | ||||
| def_offsetamount | icl_default_offsetamount_d | Def.Offset Amt | ||||
| xinternal | icl_xgenledgertp_d | Int. Clearing | ||||
| xchangable | icl_xgenitemmod_d | OI Unchangeable | ||||
| xposbeniem | icl_xposbenitem_d | Positive Offset Item | ||||
| xpremwaiv | icl_xpremwaiver_d | Premium Exemption | ||||
| defltpost | icl_defltpost | CD Doc: Std Data |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Leistungsart
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TICL055 (
CLIENT, -- Client [mandt]
BENTYPE, -- Benefit Type [icl_bentype]
BENTYPE_REF, -- Ref.BenefitType [icl_pi_bentype_ref]
LOSSEXP, -- Losses/Expenses [icl_lossexp]
XRECOVERY, -- Expectation Res [icl_xrecovery]
CATEGORY_ID, -- Prod. Category [icl_category_id_ext]
PRODUCT_TYPE, -- Product Type [icl_product_type]
XCROSSSTYPE, -- Cross-Coverage Type [icl_xcrossstype]
EXTBENTYPE, -- Benefit Type [icl_extbentype]
DEFOBJCAT, -- Category [icl_deflt_iobcat]
DEFOBJTYPE, -- Object Type [icl_deflt_iobtype]
BENTYPECAT, -- Ben.Type Area [icl_bentypecat]
DISABILITY_CLASS, -- Disability Class [icl_disability_class]
XPROFILE, -- Profile [icl_profile_flag]
WITHDRAWTYP, -- Withdrawal Type [icl_withdrawtype_d]
DEF_OFFSETAMOUNT, -- Def.Offset Amt [icl_default_offsetamount_d]
XINTERNAL, -- Int. Clearing [icl_xgenledgertp_d]
XCHANGABLE, -- OI Unchangeable [icl_xgenitemmod_d]
XPOSBENIEM, -- Positive Offset Item [icl_xposbenitem_d]
XPREMWAIV, -- Premium Exemption [icl_xpremwaiver_d]
DEFLTPOST, -- CD Doc: Std Data [icl_defltpost]
PRIMARY KEY (CLIENT, BENTYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA