ICLPAYITDRAFT

Transparent Table Application Table
50 Fields 1 CDS Views

Draft table for entity R_INS_CLAIMPAYMENTITEMTP

ICLPAYITDRAFT is an SAP database table in S/4HANA. Draft table for entity R_INS_CLAIMPAYMENTITEMTP. It contains 50 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_INS_ClaimPaymentItemDraft view_entity from BASIC Payment Item - Draft

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY insurclmactive ICL_ACTIVE Active/Suspense
KEY insuranceclaim ICL_CLAIM Claim Number
KEY insurclmsubclm ICL_SUBCLP Subclaim
KEY insurclmpayt ICL_PAYMENT Payment Number
KEY insurclmpaytitem ICL_PAYMENTITEM Payment Item
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
insurclmitemsubclm ICL_ITEMSUBCLAIM Belongs To
insurbnfttype ICL_BENTYPE Benefit Type
insurclmpaymentcurrency ICL_PAYMENTCUR Currency
insurclmpaytamt ICL_SCLITEMAP Payment Amount
insurclmcoveragetype ICL_COVTYPE Coverage Type
insurclmchangedby ICL_CHANGEDBY Changed By
insurclmchangetime TIMESTAMP Time Stamp
insurclmpaytitemcategory ICL_PAYITEMCAT Item category
insurclmpayttaxcategory ICL_PYMTYPE Tax Category
insurclmpaytitempaymenttype ICL_PAYTYPE Payment Type
insurclmpaytreasongrp ICL_PAYREASONSET Group
insurclmpaytreason ICL_PAYREASON Payment Reason
insurclmpaytamttaxcategory ICL_GROSS_NET Gross/Net
insurclmpayttaxcode ICL_TXCOD Tax Code
insurclmpaytrequestedamount ICL_REQUESTED Amount Requestd
insurclmitem ICL_SCLITEM Claim Item
insurclmpaytvalidfromdate ICL_PAYVALIDFROM Valid From
insurclmpaytvalidtodate ICL_PAYVALIDTO Valid To
insurclmlinestatus ICL_RECSTATUS Status
insurclmtaxcodevalue ICL_TAXCODE_ID_D Tax Code Other Taxes
insuranceclaimpostingdate ICL_POSTDATE Posting Date
insurclmitemrefnumber ICL_SCLITEMREF Reference no.
insuranceclaimpaymentitemtype ICL_PAYITY Payt Item Type
insurclmdistrplncoinsurancekey ICL_REPID Coins. Key
insurclmassignuuid ICL_ASSIGN_GUID Link UUID
insurclmitemnumberpaytplandoc ICL_DOCITEM Item No. Document
insurclmpaytoriglreqdamount ICL_REQUESTED_ORIG Orig.Amt Reqstd
insurclmpayttotalamount ICL_SCLITEMAP Payment Amount
insuranceclaimkeyoftaxcountry ICL_COUNTRYCD_D Country/Region
insuranceclaimtaxregionkey ICL_REGIONCD_D Region
insurclmreferencepaymentitem ICL_PAYMENTITEM Payment Item
insurclmpaytitemtaxrate MSATZ_F05L Tax rate
insurclmpaytitemtransactionkey KTOSL Transaction
insurclmpaytitemconditiontype KSCHL Condition Type
insurclmpayttaxjurisdiction /GSINS/TXJCD Tax Jurisdict.
insurclmpayttaxbaseamt /GSINS/TXBAS Base Amount
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_INS_CLAIMPAYMENTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPAYITDRAFT (
    MANDT,                           -- Client [MANDT]
    INSURCLMACTIVE,                  -- Active/Suspense [ICL_ACTIVE]
    INSURANCECLAIM,                  -- Claim Number [ICL_CLAIM]
    INSURCLMSUBCLM,                  -- Subclaim [ICL_SUBCLP]
    INSURCLMPAYT,                    -- Payment Number [ICL_PAYMENT]
    INSURCLMPAYTITEM,                -- Payment Item [ICL_PAYMENTITEM]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    INSURCLMITEMSUBCLM,              -- Belongs To [ICL_ITEMSUBCLAIM]
    INSURBNFTTYPE,                   -- Benefit Type [ICL_BENTYPE]
    INSURCLMPAYMENTCURRENCY,         -- Currency [ICL_PAYMENTCUR]
    INSURCLMPAYTAMT,                 -- Payment Amount [ICL_SCLITEMAP]
    INSURCLMCOVERAGETYPE,            -- Coverage Type [ICL_COVTYPE]
    INSURCLMCHANGEDBY,               -- Changed By [ICL_CHANGEDBY]
    INSURCLMCHANGETIME,              -- Time Stamp [TIMESTAMP]
    INSURCLMPAYTITEMCATEGORY,        -- Item category [ICL_PAYITEMCAT]
    INSURCLMPAYTTAXCATEGORY,         -- Tax Category [ICL_PYMTYPE]
    INSURCLMPAYTITEMPAYMENTTYPE,     -- Payment Type [ICL_PAYTYPE]
    INSURCLMPAYTREASONGRP,           -- Group [ICL_PAYREASONSET]
    INSURCLMPAYTREASON,              -- Payment Reason [ICL_PAYREASON]
    INSURCLMPAYTAMTTAXCATEGORY,      -- Gross/Net [ICL_GROSS_NET]
    INSURCLMPAYTTAXCODE,             -- Tax Code [ICL_TXCOD]
    INSURCLMPAYTREQUESTEDAMOUNT,     -- Amount Requestd [ICL_REQUESTED]
    INSURCLMITEM,                    -- Claim Item [ICL_SCLITEM]
    INSURCLMPAYTVALIDFROMDATE,       -- Valid From [ICL_PAYVALIDFROM]
    INSURCLMPAYTVALIDTODATE,         -- Valid To [ICL_PAYVALIDTO]
    INSURCLMLINESTATUS,              -- Status [ICL_RECSTATUS]
    INSURCLMTAXCODEVALUE,            -- Tax Code Other Taxes [ICL_TAXCODE_ID_D]
    INSURANCECLAIMPOSTINGDATE,       -- Posting Date [ICL_POSTDATE]
    INSURCLMITEMREFNUMBER,           -- Reference no. [ICL_SCLITEMREF]
    INSURANCECLAIMPAYMENTITEMTYPE,   -- Payt Item Type [ICL_PAYITY]
    INSURCLMDISTRPLNCOINSURANCEKEY,  -- Coins. Key [ICL_REPID]
    INSURCLMASSIGNUUID,              -- Link UUID [ICL_ASSIGN_GUID]
    INSURCLMITEMNUMBERPAYTPLANDOC,   -- Item No. Document [ICL_DOCITEM]
    INSURCLMPAYTORIGLREQDAMOUNT,     -- Orig.Amt Reqstd [ICL_REQUESTED_ORIG]
    INSURCLMPAYTTOTALAMOUNT,         -- Payment Amount [ICL_SCLITEMAP]
    INSURANCECLAIMKEYOFTAXCOUNTRY,   -- Country/Region [ICL_COUNTRYCD_D]
    INSURANCECLAIMTAXREGIONKEY,      -- Region [ICL_REGIONCD_D]
    INSURCLMREFERENCEPAYMENTITEM,    -- Payment Item [ICL_PAYMENTITEM]
    INSURCLMPAYTITEMTAXRATE,         -- Tax rate [MSATZ_F05L]
    INSURCLMPAYTITEMTRANSACTIONKEY,  -- Transaction [KTOSL]
    INSURCLMPAYTITEMCONDITIONTYPE,   -- Condition Type [KSCHL]
    INSURCLMPAYTTAXJURISDICTION,     -- Tax Jurisdict. [/GSINS/TXJCD]
    INSURCLMPAYTTAXBASEAMT,          -- Base Amount [/GSINS/TXBAS]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, INSURCLMACTIVE, INSURANCECLAIM, INSURCLMSUBCLM, INSURCLMPAYT, INSURCLMPAYTITEM, DRAFTUUID)
);

Learn More