ICLPROCURE

Transparent Table Application Table
76 Fields 4 CDS Views

Claim Item Groupings

ICLPROCURE is an SAP database table in S/4HANA. Claim Item Groupings. It contains 76 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_InsuranceClaimItemGrouping view_entity from EXTENSION Claim Item Groupings - Extension
E_InsuranceClaimItemGrouping_2 view_entity from EXTENSION Claim Item Groupings - Extension
I_InsuranceClaimItemGrouping view from BASIC Anspruchsposten Gruppierung
I_InsuranceClaimItemGrouping_2 view_entity from BASIC Claim Item Grouping

Fields (76)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY subclaim ICL_SUBCLP Subclaim
KEY procurement ICL_PROCUREMENT ClaimItem Gpng
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
createdby ICL_CREATEDBY Created By
createtime ICL_CREATEUTC Created at
pdoctype ICL_PDOCTYPE Benefit Type
pdoccat ICL_PDOCCAT ClmItemGrpngCat
issuedate ICL_ISSUEDATE1 Date Created
receivedate ICL_RECEIVEDATE Date Received
datefrom ICL_DATEFROM Period From
timefrom ICL_TIMEFROM Period From
dateto ICL_DATETO To
timeto ICL_TIMETO To
issuedate_prescr ICL_ISSUEDATE_PRESCR PrescrDate(Inv)
acquisitiondate ICL_ACQUISITIONDATE Date Entered
amount1 ICL_AMOUNT1 Amount
currency ICL_CURRENCY Currency
externalref ICL_EXTERNALREF Ext. Reference
extdocument ICL_EXTDOCUMENT Ext. Doc. No.
extcaseno ICLH_EXTCASENO Hosp-Intl ID
extfileno ICLH_EXTFILENO File Number
proc_ref ICL_PROC_REF ClmItmGp Ref.
discountamount ICL_DISCOUNTAMOUNT Cash Discount
discountpercent ICL_DISCOUNTPERCENT % Cash Discount
accident ICL_ACCIDENT Accident Indic.
subrogation ICL_SUBROGATION RecoveryClm Ind
duedate ICL_DUEDATE Due Date
duedate_orig ICL_DUEDATE_ORIG Due Date Origin
status ICL_PROCSTATUS Status
statreason ICL_FORMSET Status Reason
owncontrib ICL_OWNCONTRIB Copayment (%)
reason ICL_REASON Reason
cause ICLH_CAUSE Specification
pdoccattype ICL_PDOCCATTYPE ClmItmGpCatType
subcl_orig ICL_SUBCL_ORIG Original Subclaim Multiple Prescription/Curr.Subclm Appraisl
proc_orig ICL_PROC_ORIG Original Claim Item Grouping of Multiple Prescription
datasource ICL_DATASOURCE Data Origin
setorderdate ICL_SETORDERDATE Set Order Date
completiondate ICL_COMPLETIONDATE Completion Date
fee ICLH_FEE Fee
matlabcost ICLH_MATLABCOST Mat+Lab Costs
matlabcostint ICLH_MATLABCOSTINT Mat+Lab Costs
addcost ICLH_ADDCOST Other Costs
valperunit ICL_SERVCAT_POS_VALPERUNIT Value per Unit
subsidypercent ICLH_SUBSIDYPERCENT Subsidy %
subsidyamount ICLH_SUBSIDYAMOUNT Subsidy
sentutc ICL_SENTUTC Date Sent
sent_by_dme ICL_SENT_BY_DME Send Extl Iface
receipt_by_dme ICL_RECEIPT_BY_DME Receipt Extrnl
cancel ICL_STATUS_CANCEL Cancelled
rejected ICL_STATUS_REJECTED Rejected
insuspense ICL_STATUS_INSUSPENSE Pending
inprocess ICL_STATUS_INPROCESS In Process
released ICL_STATUS_RELEASED Released
xfinished ICL_XFINISHED Complete
ordered ICL_STATUS_ORDERED Commissioned
transferred ICL_STATUS_TRANSFERRED Reassigned
tobeapproved ICL_STATUS_TOBEAPPROVED To Be Approved
xcliniccard ICLH_CLINIC_CARD Clinic Card
payfreqplan ICL_PAYFREQPLAN_REP Payment Freq.
assign_guid ICL_ASSIGN_GUID Link UUID
xrequest ICL_XREQUEST Receivable
compper_datefrom ICL_COMPPER_DATEFROM_D_PE Period From
compper_dateto ICL_COMPPER_DATETO_D_PE Comp.Period To
payout_scenario ICL_PAYOUT_SCENARIO_D Rept Payt Scen.
reasonrej ICL_REASONREJ Rejection Reasn
method ICL_PAYMENT01 Payment Method
addrnumber ICL_ADDRNUM Address
bkid ICL_BKID Bank Details
_dataaging DATA_TEMPERATURE Data Aging
dummy_field abap.char

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 Groupings
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPROCURE (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    SUBCLAIM,          -- Subclaim [ICL_SUBCLP]
    PROCUREMENT,       -- ClaimItem Gpng [ICL_PROCUREMENT]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    CREATEDBY,         -- Created By [ICL_CREATEDBY]
    CREATETIME,        -- Created at [ICL_CREATEUTC]
    PDOCTYPE,          -- Benefit Type [ICL_PDOCTYPE]
    PDOCCAT,           -- ClmItemGrpngCat [ICL_PDOCCAT]
    ISSUEDATE,         -- Date Created [ICL_ISSUEDATE1]
    RECEIVEDATE,       -- Date Received [ICL_RECEIVEDATE]
    DATEFROM,          -- Period From [ICL_DATEFROM]
    TIMEFROM,          -- Period From [ICL_TIMEFROM]
    DATETO,            -- To [ICL_DATETO]
    TIMETO,            -- To [ICL_TIMETO]
    ISSUEDATE_PRESCR,  -- PrescrDate(Inv) [ICL_ISSUEDATE_PRESCR]
    ACQUISITIONDATE,   -- Date Entered [ICL_ACQUISITIONDATE]
    AMOUNT1,           -- Amount [ICL_AMOUNT1]
    CURRENCY,          -- Currency [ICL_CURRENCY]
    EXTERNALREF,       -- Ext. Reference [ICL_EXTERNALREF]
    EXTDOCUMENT,       -- Ext. Doc. No. [ICL_EXTDOCUMENT]
    EXTCASENO,         -- Hosp-Intl ID [ICLH_EXTCASENO]
    EXTFILENO,         -- File Number [ICLH_EXTFILENO]
    PROC_REF,          -- ClmItmGp Ref. [ICL_PROC_REF]
    DISCOUNTAMOUNT,    -- Cash Discount [ICL_DISCOUNTAMOUNT]
    DISCOUNTPERCENT,   -- % Cash Discount [ICL_DISCOUNTPERCENT]
    ACCIDENT,          -- Accident Indic. [ICL_ACCIDENT]
    SUBROGATION,       -- RecoveryClm Ind [ICL_SUBROGATION]
    DUEDATE,           -- Due Date [ICL_DUEDATE]
    DUEDATE_ORIG,      -- Due Date Origin [ICL_DUEDATE_ORIG]
    STATUS,            -- Status [ICL_PROCSTATUS]
    STATREASON,        -- Status Reason [ICL_FORMSET]
    OWNCONTRIB,        -- Copayment (%) [ICL_OWNCONTRIB]
    REASON,            -- Reason [ICL_REASON]
    CAUSE,             -- Specification [ICLH_CAUSE]
    PDOCCATTYPE,       -- ClmItmGpCatType [ICL_PDOCCATTYPE]
    SUBCL_ORIG,        -- Original Subclaim Multiple Prescription/Curr.Subclm Appraisl [ICL_SUBCL_ORIG]
    PROC_ORIG,         -- Original Claim Item Grouping of Multiple Prescription [ICL_PROC_ORIG]
    DATASOURCE,        -- Data Origin [ICL_DATASOURCE]
    SETORDERDATE,      -- Set Order Date [ICL_SETORDERDATE]
    COMPLETIONDATE,    -- Completion Date [ICL_COMPLETIONDATE]
    FEE,               -- Fee [ICLH_FEE]
    MATLABCOST,        -- Mat+Lab Costs [ICLH_MATLABCOST]
    MATLABCOSTINT,     -- Mat+Lab Costs [ICLH_MATLABCOSTINT]
    ADDCOST,           -- Other Costs [ICLH_ADDCOST]
    VALPERUNIT,        -- Value per Unit [ICL_SERVCAT_POS_VALPERUNIT]
    SUBSIDYPERCENT,    -- Subsidy % [ICLH_SUBSIDYPERCENT]
    SUBSIDYAMOUNT,     -- Subsidy [ICLH_SUBSIDYAMOUNT]
    SENTUTC,           -- Date Sent [ICL_SENTUTC]
    SENT_BY_DME,       -- Send Extl Iface [ICL_SENT_BY_DME]
    RECEIPT_BY_DME,    -- Receipt Extrnl [ICL_RECEIPT_BY_DME]
    CANCEL,            -- Cancelled [ICL_STATUS_CANCEL]
    REJECTED,          -- Rejected [ICL_STATUS_REJECTED]
    INSUSPENSE,        -- Pending [ICL_STATUS_INSUSPENSE]
    INPROCESS,         -- In Process [ICL_STATUS_INPROCESS]
    RELEASED,          -- Released [ICL_STATUS_RELEASED]
    XFINISHED,         -- Complete [ICL_XFINISHED]
    ORDERED,           -- Commissioned [ICL_STATUS_ORDERED]
    TRANSFERRED,       -- Reassigned [ICL_STATUS_TRANSFERRED]
    TOBEAPPROVED,      -- To Be Approved [ICL_STATUS_TOBEAPPROVED]
    XCLINICCARD,       -- Clinic Card [ICLH_CLINIC_CARD]
    PAYFREQPLAN,       -- Payment Freq. [ICL_PAYFREQPLAN_REP]
    ASSIGN_GUID,       -- Link UUID [ICL_ASSIGN_GUID]
    XREQUEST,          -- Receivable [ICL_XREQUEST]
    COMPPER_DATEFROM,  -- Period From [ICL_COMPPER_DATEFROM_D_PE]
    COMPPER_DATETO,    -- Comp.Period To [ICL_COMPPER_DATETO_D_PE]
    PAYOUT_SCENARIO,   -- Rept Payt Scen. [ICL_PAYOUT_SCENARIO_D]
    REASONREJ,         -- Rejection Reasn [ICL_REASONREJ]
    METHOD,            -- Payment Method [ICL_PAYMENT01]
    ADDRNUMBER,        -- Address [ICL_ADDRNUM]
    BKID,              -- Bank Details [ICL_BKID]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    DUMMY_FIELD,       -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCLAIM, PROCUREMENT)
);

Learn More