ICSITEM

Transparent Table Application Table
77 Fields 1 CDS Views

Claim Item

ICSITEM is an SAP database table in S/4HANA. Claim Item. It contains 77 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsuranceClaimShadowItem view_entity from BASIC Schattentabelle: Anspruchsposten Schaden

Fields (77)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY subclaim ICL_SUBCL Subclaim
KEY item ICL_SCLITEM Claim Item
KEY changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
itemcat ICL_ITEMCAT Claim Item Cat.
itemtype ICL_ITEMTYPE Object Type
itemuse ICL_ITEMUSE Usage Type
covtype ICL_COVTYPE Coverage Type
bentype ICL_BENTYPE Benefit Type
rcovtype ICL_RCOVTYPE Benefit CovType
xwaitperiod ICL_XWAITPERIOD No ProbatnryPer
coverage ICL_POLM Coverage
scposid_int ICL_SERVCAT_POSID_INT Int. BC Item ID
servcat ICL_SERVCATID Benef.Catalog
scposid_ext ICL_SERVCAT_POSID BenCtlg Item
status ICL_SCLITEMS Status
rejreason ICL_REJREASON Rejection Reasn
modified ICL_MODIFIED Modified
procured ICL_PROCURED Ordered
calculated ICL_CALCULATED Calculated
description ICL_DPDESC Description
daily ICL_DAILY Daily
weekly ICL_WEEKLY Weekly
monthly ICL_MONTHLY Monthly
total ICL_TOTAL Total
validfrom ICL_VALIDFROM Valid From
validto ICL_VALIDTO Valid To
startdate ICL_STARTDATE Start date
enddate ICL_ENDDATE End Date
dnumber ICL_NUMBER Number
evaluation ICL_EVALUATION1 Valid evaluatn
evalcat ICL_EVALCAT Evaluation cat.
evalbase ICL_EVALBASE Evaluation By
evquantity ICL_EVQUANTITY Number
evquanunit ICL_EVQUANUNIT Unit
evamtperunit ICL_EVAMTPERUNIT Amount per Unit
evamount ICL_EVAMOUNT EvaluatedAmount
evcurr ICL_EVCURR Currency
factor ICLH_FACTOR Factor
acv ICL_ACV Act.Cash Value
acvpercent ICL_ACVPER ACV Part
calcexpression ICL_CALC_EXPRESSION Payout Calc.
perday ICL_PERDAY Amount per day
discountpercent ICL_DISCOUNTPERCENT % Cash Discount
xdiscountused ICL_XDISCOUNTUSED Discount Applied
xdiscountpercent ICL_XDISCOUNTPERCENT Valid Discount Amt
xdisc_2b_applied ICL_XDISC_2B_APPLIED To Apply
grosnet ICL_GROSNET Gross/Net
txcod ICL_TXCOD Tax Code
subclref ICL_SUBCLREF Belongs To
procurement ICL_PROCUREMENT ClaimItem Gpng
item_ref ICL_SCLITEM Claim Item
damagedobj ICL_DAMOBJ Damaged Object
assign_guid ICL_ASSIGN_GUID Link UUID
refno ICL_SCLITEMREF Reference no.
pdref ICL_PDREF Purchasing Doc.
pdpos ICL_PDPOS Item Number
ref_loccat ICL_EXTSVCS_REFCAT Ref. Location
ptype ICL_PTYPE Procurem.Trans.
xgeneros ICL_XGENEROS Goodwill Payt
additional_item ICL_ITEM_SPLIT_D Addl Claim Item
addit_item_sum ICL_ITEM_SUM_D Total
remun_type ICL_REMUN_TYPE_D_PE Remun.Cat.
benvalue ICL_BENVALUE_D Benefit Value
xcreatedman ICL_XCREATEDMAN_D Creatd Manually
creationreason ICL_CREATIONREASON_D Creation Reason
xgenledgertp ICL_XGENLEDGERTP_D Int. Clearing
periodicity ICL_PERIODICITY_D Time Periods
addduedate ICL_ADDDUEDATE_D Addl Due Date
totalvalueannual ICL_TOTALVALUEANNUAL_D Tot.Annl Value
payrollvar ICL_PAYROLLVAR_D Variant
disbursetype ICL_DISBURSETYPE_D Disbursemnt 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.

-- Claim Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICSITEM (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    SUBCLAIM,          -- Subclaim [ICL_SUBCL]
    ITEM,              -- Claim Item [ICL_SCLITEM]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    ITEMCAT,           -- Claim Item Cat. [ICL_ITEMCAT]
    ITEMTYPE,          -- Object Type [ICL_ITEMTYPE]
    ITEMUSE,           -- Usage Type [ICL_ITEMUSE]
    COVTYPE,           -- Coverage Type [ICL_COVTYPE]
    BENTYPE,           -- Benefit Type [ICL_BENTYPE]
    RCOVTYPE,          -- Benefit CovType [ICL_RCOVTYPE]
    XWAITPERIOD,       -- No ProbatnryPer [ICL_XWAITPERIOD]
    COVERAGE,          -- Coverage [ICL_POLM]
    SCPOSID_INT,       -- Int. BC Item ID [ICL_SERVCAT_POSID_INT]
    SERVCAT,           -- Benef.Catalog [ICL_SERVCATID]
    SCPOSID_EXT,       -- BenCtlg Item [ICL_SERVCAT_POSID]
    STATUS,            -- Status [ICL_SCLITEMS]
    REJREASON,         -- Rejection Reasn [ICL_REJREASON]
    MODIFIED,          -- Modified [ICL_MODIFIED]
    PROCURED,          -- Ordered [ICL_PROCURED]
    CALCULATED,        -- Calculated [ICL_CALCULATED]
    DESCRIPTION,       -- Description [ICL_DPDESC]
    DAILY,             -- Daily [ICL_DAILY]
    WEEKLY,            -- Weekly [ICL_WEEKLY]
    MONTHLY,           -- Monthly [ICL_MONTHLY]
    TOTAL,             -- Total [ICL_TOTAL]
    VALIDFROM,         -- Valid From [ICL_VALIDFROM]
    VALIDTO,           -- Valid To [ICL_VALIDTO]
    STARTDATE,         -- Start date [ICL_STARTDATE]
    ENDDATE,           -- End Date [ICL_ENDDATE]
    DNUMBER,           -- Number [ICL_NUMBER]
    EVALUATION,        -- Valid evaluatn [ICL_EVALUATION1]
    EVALCAT,           -- Evaluation cat. [ICL_EVALCAT]
    EVALBASE,          -- Evaluation By [ICL_EVALBASE]
    EVQUANTITY,        -- Number [ICL_EVQUANTITY]
    EVQUANUNIT,        -- Unit [ICL_EVQUANUNIT]
    EVAMTPERUNIT,      -- Amount per Unit [ICL_EVAMTPERUNIT]
    EVAMOUNT,          -- EvaluatedAmount [ICL_EVAMOUNT]
    EVCURR,            -- Currency [ICL_EVCURR]
    FACTOR,            -- Factor [ICLH_FACTOR]
    ACV,               -- Act.Cash Value [ICL_ACV]
    ACVPERCENT,        -- ACV Part [ICL_ACVPER]
    CALCEXPRESSION,    -- Payout Calc. [ICL_CALC_EXPRESSION]
    PERDAY,            -- Amount per day [ICL_PERDAY]
    DISCOUNTPERCENT,   -- % Cash Discount [ICL_DISCOUNTPERCENT]
    XDISCOUNTUSED,     -- Discount Applied [ICL_XDISCOUNTUSED]
    XDISCOUNTPERCENT,  -- Valid Discount Amt [ICL_XDISCOUNTPERCENT]
    XDISC_2B_APPLIED,  -- To Apply [ICL_XDISC_2B_APPLIED]
    GROSNET,           -- Gross/Net [ICL_GROSNET]
    TXCOD,             -- Tax Code [ICL_TXCOD]
    SUBCLREF,          -- Belongs To [ICL_SUBCLREF]
    PROCUREMENT,       -- ClaimItem Gpng [ICL_PROCUREMENT]
    ITEM_REF,          -- Claim Item [ICL_SCLITEM]
    DAMAGEDOBJ,        -- Damaged Object [ICL_DAMOBJ]
    ASSIGN_GUID,       -- Link UUID [ICL_ASSIGN_GUID]
    REFNO,             -- Reference no. [ICL_SCLITEMREF]
    PDREF,             -- Purchasing Doc. [ICL_PDREF]
    PDPOS,             -- Item Number [ICL_PDPOS]
    REF_LOCCAT,        -- Ref. Location [ICL_EXTSVCS_REFCAT]
    PTYPE,             -- Procurem.Trans. [ICL_PTYPE]
    XGENEROS,          -- Goodwill Payt [ICL_XGENEROS]
    ADDITIONAL_ITEM,   -- Addl Claim Item [ICL_ITEM_SPLIT_D]
    ADDIT_ITEM_SUM,    -- Total [ICL_ITEM_SUM_D]
    REMUN_TYPE,        -- Remun.Cat. [ICL_REMUN_TYPE_D_PE]
    BENVALUE,          -- Benefit Value [ICL_BENVALUE_D]
    XCREATEDMAN,       -- Creatd Manually [ICL_XCREATEDMAN_D]
    CREATIONREASON,    -- Creation Reason [ICL_CREATIONREASON_D]
    XGENLEDGERTP,      -- Int. Clearing [ICL_XGENLEDGERTP_D]
    PERIODICITY,       -- Time Periods [ICL_PERIODICITY_D]
    ADDDUEDATE,        -- Addl Due Date [ICL_ADDDUEDATE_D]
    TOTALVALUEANNUAL,  -- Tot.Annl Value [ICL_TOTALVALUEANNUAL_D]
    PAYROLLVAR,        -- Variant [ICL_PAYROLLVAR_D]
    DISBURSETYPE,      -- Disbursemnt Cat [ICL_DISBURSETYPE_D]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCLAIM, ITEM, CHANGETIME)
);

Learn More