TICL007
Insurance Line of Business
TICL007 is an SAP database table in S/4HANA. Insurance Line of Business. It contains 13 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsuranceLineOfBusiness | view_entity | from | BASIC | Insurance Line Of Business |
| I_InsurClmInsurLineOfBusiness | view | from | BASIC | Versicherungssparte |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | plineofbus | ICL_LINEOFBUS | Insurance Line | |||
| polprod | ICL_POLPRODD | Stand. Product | ||||
| notepermit | ICL_NOTEPERMIT | Note Proc.Type | ||||
| no_wf_payment | ICL_NOWFPAYMENT | No Workflow f. Payt | ||||
| prandom | ICL_PRANDOM | PaytApprv | ||||
| wf_claim | ICL_WFCLAIM | ClaimProcessingEvent | ||||
| wf_subcl | ICL_WFSUBCL | SubclaimProc.Event | ||||
| suppress | ICL_SUPPRESS_PLOB | Suppress LOB | ||||
| xwithout_product | ICL_XWITHOUTPRODUCT_D | Without Product | ||||
| xauto_polload | ICL_XAUTO_POLLOAD_D | Autom.PolSnaps.Updte | ||||
| long_text_permit | IGN_LONG_TEXT_PERMISSION_D | Proc.Type LText | ||||
| lock_whole_claim_plob | ICL_LOCK_WHOLE_CLAIM_PLOB | With 'Change Claim' Always Lock Whole Claim |
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.
-- Insurance Line of Business
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TICL007 (
CLIENT, -- Client [MANDT]
PLINEOFBUS, -- Insurance Line [ICL_LINEOFBUS]
POLPROD, -- Stand. Product [ICL_POLPRODD]
NOTEPERMIT, -- Note Proc.Type [ICL_NOTEPERMIT]
NO_WF_PAYMENT, -- No Workflow f. Payt [ICL_NOWFPAYMENT]
PRANDOM, -- PaytApprv [ICL_PRANDOM]
WF_CLAIM, -- ClaimProcessingEvent [ICL_WFCLAIM]
WF_SUBCL, -- SubclaimProc.Event [ICL_WFSUBCL]
SUPPRESS, -- Suppress LOB [ICL_SUPPRESS_PLOB]
XWITHOUT_PRODUCT, -- Without Product [ICL_XWITHOUTPRODUCT_D]
XAUTO_POLLOAD, -- Autom.PolSnaps.Updte [ICL_XAUTO_POLLOAD_D]
LONG_TEXT_PERMIT, -- Proc.Type LText [IGN_LONG_TEXT_PERMISSION_D]
LOCK_WHOLE_CLAIM_PLOB, -- With 'Change Claim' Always Lock Whole Claim [ICL_LOCK_WHOLE_CLAIM_PLOB]
PRIMARY KEY (CLIENT, PLINEOFBUS)
);
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