ICLPAYI

Transparent Table Application Table
42 Fields 3 CDS Views

Claim Payment Item

ICLPAYI is an SAP database table in S/4HANA. Claim Payment Item. It contains 42 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_InsuranceClaimPaymentItem view_entity from EXTENSION Insurance Claim Payment item - Extension
I_InsuranceClaimPaymentItem_2 view_entity from BASIC Claim Payment Item
I_InsurClmPaymentItem view from BASIC Fallzahlungsposition

Fields (42)

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 payment ICL_PAYMENT Payment Number
KEY paymentitem ICL_PAYMENTITEM Payment Item
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
itemsubcl ICL_ITEMSUBCLAIM Belongs To
payitemcat ICL_PAYITEMCAT Item category
pampaid ICL_SCLITEMAP Payment Amount
bentype ICL_BENTYPE Benefit Type
covtype ICL_COVTYPE Coverage Type
pymtype ICL_PYMTYPE Tax Category
paytypei ICL_PAYTYPE Payment Type
treasonset ICL_PAYREASONSET Group
treason ICL_PAYREASON Payment Reason
gross_net ICL_GROSS_NET Gross/Net
txcod ICL_TXCOD Tax Code
taxcode_id ICL_TAXCODE_ID_D Tax Code Other Taxes
requested ICL_REQUESTED Amount Requestd
postdatei ICL_POSTDATE Posting Date
item ICL_SCLITEM Claim Item
refno ICL_SCLITEMREF Reference no.
payity ICL_PAYITY Payt Item Type
repid ICL_REPID Coins. Key
validfrom ICL_PAYVALIDFROM Valid From
validto ICL_PAYVALIDTO Valid To
assign_guid ICL_ASSIGN_GUID Link UUID
cddocitem ICL_DOCITEM Item No. Document
requested_orig ICL_REQUESTED_ORIG Orig.Amt Reqstd
dup_pampaid ICL_SCLITEMAP Payment Amount
country ICL_COUNTRYCD_D Country/Region
region ICL_REGIONCD_D Region
refpayitem ICL_PAYMENTITEM Payment Item
msatz MSATZ_F05L Tax rate
ktosl KTOSL Transaction
kschl KSCHL Condition Type
_dataaging DATA_TEMPERATURE Data Aging
txjcd /GSINS/TXJCD Tax Jurisdict.
txbsamt /GSINS/TXBAS Base Amount

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 Payment Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPAYI (
    CLIENT,          -- Client [MANDT]
    ACTIVE,          -- Active/Suspense [ICL_ACTIVE]
    CLAIM,           -- Claim Number [ICL_CLAIM]
    SUBCLAIM,        -- Subclaim [ICL_SUBCLP]
    PAYMENT,         -- Payment Number [ICL_PAYMENT]
    PAYMENTITEM,     -- Payment Item [ICL_PAYMENTITEM]
    CHANGETIME,      -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,       -- Changed By [ICL_CHANGEDBY]
    DELETED,         -- Status [ICL_RECSTATUS]
    ITEMSUBCL,       -- Belongs To [ICL_ITEMSUBCLAIM]
    PAYITEMCAT,      -- Item category [ICL_PAYITEMCAT]
    PAMPAID,         -- Payment Amount [ICL_SCLITEMAP]
    BENTYPE,         -- Benefit Type [ICL_BENTYPE]
    COVTYPE,         -- Coverage Type [ICL_COVTYPE]
    PYMTYPE,         -- Tax Category [ICL_PYMTYPE]
    PAYTYPEI,        -- Payment Type [ICL_PAYTYPE]
    TREASONSET,      -- Group [ICL_PAYREASONSET]
    TREASON,         -- Payment Reason [ICL_PAYREASON]
    GROSS_NET,       -- Gross/Net [ICL_GROSS_NET]
    TXCOD,           -- Tax Code [ICL_TXCOD]
    TAXCODE_ID,      -- Tax Code Other Taxes [ICL_TAXCODE_ID_D]
    REQUESTED,       -- Amount Requestd [ICL_REQUESTED]
    POSTDATEI,       -- Posting Date [ICL_POSTDATE]
    ITEM,            -- Claim Item [ICL_SCLITEM]
    REFNO,           -- Reference no. [ICL_SCLITEMREF]
    PAYITY,          -- Payt Item Type [ICL_PAYITY]
    REPID,           -- Coins. Key [ICL_REPID]
    VALIDFROM,       -- Valid From [ICL_PAYVALIDFROM]
    VALIDTO,         -- Valid To [ICL_PAYVALIDTO]
    ASSIGN_GUID,     -- Link UUID [ICL_ASSIGN_GUID]
    CDDOCITEM,       -- Item No. Document [ICL_DOCITEM]
    REQUESTED_ORIG,  -- Orig.Amt Reqstd [ICL_REQUESTED_ORIG]
    DUP_PAMPAID,     -- Payment Amount [ICL_SCLITEMAP]
    COUNTRY,         -- Country/Region [ICL_COUNTRYCD_D]
    REGION,          -- Region [ICL_REGIONCD_D]
    REFPAYITEM,      -- Payment Item [ICL_PAYMENTITEM]
    MSATZ,           -- Tax rate [MSATZ_F05L]
    KTOSL,           -- Transaction [KTOSL]
    KSCHL,           -- Condition Type [KSCHL]
    _DATAAGING,      -- Data Aging [DATA_TEMPERATURE]
    TXJCD,           -- Tax Jurisdict. [/GSINS/TXJCD]
    TXBSAMT,         -- Base Amount [/GSINS/TXBAS]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCLAIM, PAYMENT, PAYMENTITEM)
);

Learn More