ICL_BENSPPER_ITM

Transparent Table Application Table

Benefit Split Item (Periodic)

ICL_BENSPPER_ITM is an SAP database table in S/4HANA. Benefit Split Item (Periodic). It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmBnftSplitPerdcItem view_entity from EXTENSION Claim Bnft Splt Item Periodic - Extension
I_InsurClmBnftSplitPerdcItmBsc view_entity from BASIC Grundsicht Verteilungsposition(periodisch)

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY benspper_itm_id ICL_SUBOBJECT_UUID_D Object GUID
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
benspper_itm_num ICL_BENSPLIT_ITM_NUM_D Item
benspper_hdr_id ICL_SUBOBJECT_UUID_D Object GUID
prio ICL_PRIO_D Priority
sharepct ICL_SHAREPCT_D Percent Share
benoffset ICL_BENOFFSET_D Offset ID
duedate ICL_DUEDATENET Net Due Date
bkid ICL_BKID Bank Details
method ICL_PAYMENT01 Payment Method
addrnumber ICL_ADDRNUM Address
altposttarget ICL_ALTPOSTTARGET_D Alt.Posting Tgt
note ICL_PAYMENT04 Purpose
validto ICL_BENVALIDTO_D Valid To
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.

-- Benefit Split Item (Periodic)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICL_BENSPPER_ITM (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    BENSPPER_ITM_ID,   -- Object GUID [ICL_SUBOBJECT_UUID_D]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    BENSPPER_ITM_NUM,  -- Item [ICL_BENSPLIT_ITM_NUM_D]
    BENSPPER_HDR_ID,   -- Object GUID [ICL_SUBOBJECT_UUID_D]
    PRIO,              -- Priority [ICL_PRIO_D]
    SHAREPCT,          -- Percent Share [ICL_SHAREPCT_D]
    BENOFFSET,         -- Offset ID [ICL_BENOFFSET_D]
    DUEDATE,           -- Net Due Date [ICL_DUEDATENET]
    BKID,              -- Bank Details [ICL_BKID]
    METHOD,            -- Payment Method [ICL_PAYMENT01]
    ADDRNUMBER,        -- Address [ICL_ADDRNUM]
    ALTPOSTTARGET,     -- Alt.Posting Tgt [ICL_ALTPOSTTARGET_D]
    NOTE,              -- Purpose [ICL_PAYMENT04]
    VALIDTO,           -- Valid To [ICL_BENVALIDTO_D]
    DUMMY_FIELD,       -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, BENSPPER_ITM_ID)
);