ICLPART

Transparent Table Application Table
34 Fields 3 CDS Views

Participants

ICLPART is an SAP database table in S/4HANA. Participants. It contains 34 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_INS_ClaimParticipant view_entity from EXTENSION Claim Participants – Extension
I_InsuranceClaimParticipant_3 view_entity from BASIC Basic Interface Claim Participant
I_InsurClmParticipant view from BASIC Beteiligtensicht

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY participant ICL_PART Participant
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
mailaddr ICL_PART01 Mail Address
phoneaddr ICL_PART02 Phone Address
phoneid ICL_PART03 Serial Number
reference ICL_REFERENCE Reference No.
reltype ICL_PARTRELTYPE Rel. to PH
text01 ICL_PART_TEXT01 Long Text
file_requested ICL_FILE_REQ File requested
descrip ICL_DESCRIP Participant
assign_guid ICL_ASSIGN_GUID Link UUID
parttype ICL_PARTTYPE Participtn Type
xlawyer ICL_XLAWYER Lawyer?
xsalestax ICL_XSALESTAX No Val.Add Tax
guiltrate ICL_GUILTRATE Liability Rate
xintracompany ICL_INTRACOMPANY Intra-Company
xnoins ICL_XNOINS Not Insured
seat ICL_SEAT Position in Veh
vehicle ICL_VEHICLE Vehicle
wireptype ICL_WIREPTYPE Type
xconfirm ICL_WIREP01 Confirmed
judgement ICL_JUDGM Evaluation
xknown2driver ICL_WIREP02 Knows claimant
xknown2insurd ICL_WIREP03 Knows PH?
age ICL_AGE Age
issuedate ICL_ISSUEDATE Issue date
birthdate BU_BIRTHDT Date of Birth
repr_type ICL_REPR_TYPE Represent. Cat.
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Participants
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPART (
    CLIENT,          -- Client [MANDT]
    ACTIVE,          -- Active/Suspense [ICL_ACTIVE]
    CLAIM,           -- Claim Number [ICL_CLAIM]
    PARTICIPANT,     -- Participant [ICL_PART]
    CHANGETIME,      -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,       -- Changed By [ICL_CHANGEDBY]
    DELETED,         -- Status [ICL_RECSTATUS]
    MAILADDR,        -- Mail Address [ICL_PART01]
    PHONEADDR,       -- Phone Address [ICL_PART02]
    PHONEID,         -- Serial Number [ICL_PART03]
    REFERENCE,       -- Reference No. [ICL_REFERENCE]
    RELTYPE,         -- Rel. to PH [ICL_PARTRELTYPE]
    TEXT01,          -- Long Text [ICL_PART_TEXT01]
    FILE_REQUESTED,  -- File requested [ICL_FILE_REQ]
    DESCRIP,         -- Participant [ICL_DESCRIP]
    ASSIGN_GUID,     -- Link UUID [ICL_ASSIGN_GUID]
    PARTTYPE,        -- Participtn Type [ICL_PARTTYPE]
    XLAWYER,         -- Lawyer? [ICL_XLAWYER]
    XSALESTAX,       -- No Val.Add Tax [ICL_XSALESTAX]
    GUILTRATE,       -- Liability Rate [ICL_GUILTRATE]
    XINTRACOMPANY,   -- Intra-Company [ICL_INTRACOMPANY]
    XNOINS,          -- Not Insured [ICL_XNOINS]
    SEAT,            -- Position in Veh [ICL_SEAT]
    VEHICLE,         -- Vehicle [ICL_VEHICLE]
    WIREPTYPE,       -- Type [ICL_WIREPTYPE]
    XCONFIRM,        -- Confirmed [ICL_WIREP01]
    JUDGEMENT,       -- Evaluation [ICL_JUDGM]
    XKNOWN2DRIVER,   -- Knows claimant [ICL_WIREP02]
    XKNOWN2INSURD,   -- Knows PH? [ICL_WIREP03]
    AGE,             -- Age [ICL_AGE]
    ISSUEDATE,       -- Issue date [ICL_ISSUEDATE]
    BIRTHDATE,       -- Date of Birth [BU_BIRTHDT]
    REPR_TYPE,       -- Represent. Cat. [ICL_REPR_TYPE]
    _DATAAGING,      -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, PARTICIPANT)
);

Learn More