ICL_WCMPD

Transparent Table Application Table
35 Fields 1 CDS Views

FS-CM: Item Data Workers Compensation

ICL_WCMPD is an SAP database table in S/4HANA. FS-CM: Item Data Workers Compensation. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmWrkrsCompnItm view from BASIC Positionsdaten Berufsunfallversicherung

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY subclaim ICL_SUBCL Subclaim
KEY wcmph_seqnum ICL_WCMP_SEQNUM Seq.No. Hdr Data
KEY wcmpd_seqnum ICL_WCMP_DET_SEQNUM Detail Seq.No.
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
itemcat ICL_WCMP_ITEMCAT WComp Item Cat.
currency ICL_CURRENCY Currency
saww ICL_SAWW_AMT State AWW
min_ben ICL_MIN_AMT Minimum Amount
max_ben ICL_MAX_AMT Maximum Amount
percent ICL_WCMP_PERCENT Percent Benefit
max_period ICL_MAXPRD Max.BenefPeriod
max_total ICL_MAX_PYMNT Max. Payt Amt
payment_amt ICL_WCMP_TOPAY Payout Amount
pay_amt_off ICL_WCMP_PAY_AMT_OFF Amount After Offset
numfullpaym ICL_NUMFULLPAYM No.of FullWeeks
numpartpaym ICL_NUMPARTPAYM Days Remaining
paym_partial ICL_PAYM_PARTIAL Partial Payment
benefit_offset ICL_WCMP_OFFSET Amount Offset
retro_amt ICL_WCMP_RETRO_AMT Retro Payt Amount
pmtfr ICL_PMTFR_REP Valid From
pmtto ICL_PMTTO_REP Valid To
paym_total ICL_PAYM_TOTAL Payment Total Amount
burial_amount ICL_BURIAL_AMT Burial Amount
transportn_max ICL_TRNSPT_MAX MaxAmt Transprt
lump_sum ICL_LUMP_SUM Lump Sum
total_amt ICL_WCMP_SRVR_TOT Payment Total Amount
chld_max_age ICL_CHILD_MAX_AGE Child Max Age
stdnt_max_age ICL_STDNT_MAX_AGE Student Max Age
scheduled_period ICL_WCMP_SCHEDULED_PERIOD Scheduled Weeks
scheduled_unit ICL_WCMP_SCH_COMP_UNIT Compensation Unit

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.

-- FS-CM: Item Data Workers Compensation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICL_WCMPD (
    MANDT,             -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    SUBCLAIM,          -- Subclaim [ICL_SUBCL]
    WCMPH_SEQNUM,      -- Seq.No. Hdr Data [ICL_WCMP_SEQNUM]
    WCMPD_SEQNUM,      -- Detail Seq.No. [ICL_WCMP_DET_SEQNUM]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    ITEMCAT,           -- WComp Item Cat. [ICL_WCMP_ITEMCAT]
    CURRENCY,          -- Currency [ICL_CURRENCY]
    SAWW,              -- State AWW [ICL_SAWW_AMT]
    MIN_BEN,           -- Minimum Amount [ICL_MIN_AMT]
    MAX_BEN,           -- Maximum Amount [ICL_MAX_AMT]
    PERCENT,           -- Percent Benefit [ICL_WCMP_PERCENT]
    MAX_PERIOD,        -- Max.BenefPeriod [ICL_MAXPRD]
    MAX_TOTAL,         -- Max. Payt Amt [ICL_MAX_PYMNT]
    PAYMENT_AMT,       -- Payout Amount [ICL_WCMP_TOPAY]
    PAY_AMT_OFF,       -- Amount After Offset [ICL_WCMP_PAY_AMT_OFF]
    NUMFULLPAYM,       -- No.of FullWeeks [ICL_NUMFULLPAYM]
    NUMPARTPAYM,       -- Days Remaining [ICL_NUMPARTPAYM]
    PAYM_PARTIAL,      -- Partial Payment [ICL_PAYM_PARTIAL]
    BENEFIT_OFFSET,    -- Amount Offset [ICL_WCMP_OFFSET]
    RETRO_AMT,         -- Retro Payt Amount [ICL_WCMP_RETRO_AMT]
    PMTFR,             -- Valid From [ICL_PMTFR_REP]
    PMTTO,             -- Valid To [ICL_PMTTO_REP]
    PAYM_TOTAL,        -- Payment Total Amount [ICL_PAYM_TOTAL]
    BURIAL_AMOUNT,     -- Burial Amount [ICL_BURIAL_AMT]
    TRANSPORTN_MAX,    -- MaxAmt Transprt [ICL_TRNSPT_MAX]
    LUMP_SUM,          -- Lump Sum [ICL_LUMP_SUM]
    TOTAL_AMT,         -- Payment Total Amount [ICL_WCMP_SRVR_TOT]
    CHLD_MAX_AGE,      -- Child Max Age [ICL_CHILD_MAX_AGE]
    STDNT_MAX_AGE,     -- Student Max Age [ICL_STDNT_MAX_AGE]
    SCHEDULED_PERIOD,  -- Scheduled Weeks [ICL_WCMP_SCHEDULED_PERIOD]
    SCHEDULED_UNIT,    -- Compensation Unit [ICL_WCMP_SCH_COMP_UNIT]
    PRIMARY KEY (MANDT, ACTIVE, CLAIM, SUBCLAIM, WCMPH_SEQNUM, WCMPD_SEQNUM)
);

Learn More