ICSITEM

Claim Item | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
SUBCLAIM FK Subclaim
ITEM Claim Item
CHANGETIME Changed: Date + Time
Column Name Description
💲 Currency of Evaluated Amount (EVCURR):
EVAMTPERUNIT Amount per Unit
EVAMOUNT Evaluated Amount
ACV Actual Cash Value
BENVALUE Benefit Value
TOTALVALUEANNUAL Total Annual Value
PERDAY Amount per Day
Column Name Description
📏 Claim Item: Unit of Measurement (EVQUANUNIT):
EVQUANTITY Claim Item: Number (Days, Visits, Area) for Evaluation
Column Name Description
VALIDFROM Claim Item: Valid From
VALIDTO Claim Item: Valid To
STARTDATE Start Date
ENDDATE End Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
XWAITPERIOD Probationary Periods Ignored Show values
STATUS Status of Claim Item Show values
MODIFIED Modified Show values
PROCURED Ordered Show values
CALCULATED Calculated Show values
XDISCOUNTUSED Discount Amount from Table Applied with Invoice Show values
XDISCOUNTPERCENT Discount Amount Without Reference to Percent Discount Show values
XDISC_2B_APPLIED Indicator: Discount to Be Applied Show values
XGENEROS Flag: Goodwill Payment? Show values
ADDITIONAL_ITEM Additional Claim Item Show values
ADDIT_ITEM_SUM Total of Additional Claim Items Show values
XGENLEDGERTP Internal Clearing Show values
PAYROLLVAR Settlement Variant for Annuity Disbursement Show values
DISBURSETYPE Disbursement Category for Annuity Disbursement Show values
Column Name Description Domain name
RCOVTYPE Benefit Coverage Type ICL_COVTYPE
COVERAGE Coverage ICL_POLM
SCPOSID_INT Internal ID of Benefits Catalog Item SYSUUID_C
SERVCAT ID of a Benefits, Services and Fees Catalog ICL_SERVCATID
SCPOSID_EXT ID of a Benefits Catalog Item ICL_SERVCAT_POSID
DESCRIPTION Claim Item Description TEXT40
DAILY Daily
WEEKLY Weekly
MONTHLY Monthly
TOTAL Total Number of Benefits
DNUMBER Number DEC5
EVALCAT Evaluation Category ICL_EVALCAT
FACTOR Factor ICLH_FACTOR
ACVPERCENT Proportion of Actual Cash Value to Original Cash Value in % ICL_PERCENT
CALCEXPRESSION BRFplus Expression for Calculating Payout Amount BRF_EXPRESSION
DISCOUNTPERCENT Discount on Total Invoice Amount in Percent ICL_PERCENT
GROSNET Flag: Amount Is Net Amount CHAR1
TXCOD Tax Code MWSKZ
SUBCLREF Subclaim to Which a Claim Item Is Assigned ICL_SUBCL
PROCUREMENT ID of Claim Item Grouping ICL_PROCUREMENT
ITEM_REF Claim Item ICL_SCLITEM
ASSIGN_GUID UUID of Entry to be Linked SYSUUID_C
REFNO External Reference Number ICL_SCLITEMREF
PDREF Reference to Purchasing Document ICL_PDREF_DOMAIN
PDPOS Reference to Item Number in Purchasing Document ICL_PDPOS
REF_LOCCAT Reference Location for External Services ICL_EXTSVCS_REFCAT
PTYPE Transaction Type in Procurement Process ICL_PTYPE
REMUN_TYPE Remuneration Category ICL_REMUN_TYPE_D_PE
XCREATEDMAN Manually Created Item ICL_XCREATEDMAN
CREATIONREASON Reason for Manual Creation (ID) ICL_CREATIONREASON
PERIODICITY Time Periods PKEY_VK
ADDDUEDATE Additional Payment Due Date ICL_ADDDUEDATE
Master Data Relations | to Other Relations ↓ Join Conditions
Benefit Type
Changed By
  • ICSITEM.CLIENT == USR02.MANDT
  • ICSITEM.CHANGEDBY == USR02.BNAME
Client ICSITEM.CLIENT == T000.MANDT
Type of Evaluator
  • Type of Evaluator
  • Client
  • ICSITEM.EVALBASE == TICL026.EVALBASE
  • ICSITEM.CLIENT == TICL026.CLIENT
Currency of Evaluated Amount
  • ICSITEM.CLIENT == TCURC.MANDT
  • ICSITEM.EVCURR == TCURC.WAERS
Claim Item Category
Usage Type of Claim Item
Other Relations | to Master Data Relations ↑ Join Conditions
Claim Item Object Type
  • ?
  • ?
  • ?
  • Benefit Type
  • Client
  • Claim Item Object Type
  • ICSITEM.[column in domain "ICL_BENTREEG"] == TICL164.GENERAT
  • ICSITEM.[column in domain "ICL_BENTREEV"] == TICL164.VERSION
  • ICSITEM.[column in domain "ICL_BENTREE"] == TICL164.BENTREE
  • ICSITEM.BENTYPE == TICL164.BENTYPE
  • ICSITEM.CLIENT == TICL164.CLIENT
  • ICSITEM.ITEMTYPE == TICL164.ITEMTYPE
Claim Item Rejection Reason
  • ?
  • Claim Item Rejection Reason
  • ?
  • ?
  • ?
  • ICSITEM.CLIENT == TICL043.CLIENT
  • ICSITEM.[column in domain "ICL_CLTYPEV"] == TICL043.VERSION
  • ICSITEM.REJREASON == TICL043.REJREASON
  • ICSITEM.[column in domain "ICL_CLTYPEG"] == TICL043.GENERAT
  • ICSITEM.[column in domain "ICL_SUBCLTYPE"] == TICL043.SUBCLTYPE
  • ICSITEM.[column in domain "ICL_CLTYPE"] == TICL043.CLTYPE