TICL007

Transparent Table Customizing Table
13 Fields 2 CDS Views

Versicherungssparte

TICL007 is an SAP database table in S/4HANA. Versicherungssparte. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_InsuranceLineOfBusiness view_entity from BASIC Insurance Line Of Business
I_InsurClmInsurLineOfBusiness view from BASIC Versicherungssparte

Fields (13)

KeyField Data ElementDescription DomainTypeLength
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.

-- Versicherungssparte
-- 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