ICL_WCMPH

Transparent Table Application Table
26 Fields 1 CDS Views

Workers Comp - Header Data

ICL_WCMPH is an SAP database table in S/4HANA. Workers Comp - Header Data. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmWrkrsCompnHdr view from BASIC Schaden Workers Compensation Kopfdaten

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY client 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
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
country ICL_JURICOUNTRY C/R Juris.
region ICL_JURISREGION Jurisd. Region
disability_class ICL_DISABILITY_CLASS Disability Class
aww ICL_EMP_PREINJURY_AWW Preinjury AWW
post_aww ICL_EMP_POSTINJURY_AWW AWW AfterInjury
lossdate ICL_LOSSDATE Date of Loss
startdate ICL_WCMP_STARTDATE Last Day Worked
expenddate ICL_WCMP_EXPENDDATE End Date
enddate ICL_EMP_INITIALRTW Return To Work
mmi_date ICL_EMP_MMI_DATE MMI Date
num_exempt ICL_EMP_NUMOFENTEXEMPTIONS Entitled Exmpts
numofwhdexemptio ICL_EMP_NUMOFWHDEXEMPTIONS WHD Exemptions
currency ICL_CURRENCY Currency
servcat ICL_SERVCAT_POSID_INT Int. BC Item ID
num_dependants ICL_EMP_NUMOFDEPENDENTS No.ofDependents
marital_status ICL_WCMP_MARITALSTATUS Marital Status
benefit_offset ICL_WCMP_OFFSET Amount Offset
paid_for_doi ICL_WCMP_PAID_FOR_DOI Day of Injury Paid

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.

-- Workers Comp - Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICL_WCMPH (
    CLIENT,            -- 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]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    COUNTRY,           -- C/R Juris. [ICL_JURICOUNTRY]
    REGION,            -- Jurisd. Region [ICL_JURISREGION]
    DISABILITY_CLASS,  -- Disability Class [ICL_DISABILITY_CLASS]
    AWW,               -- Preinjury AWW [ICL_EMP_PREINJURY_AWW]
    POST_AWW,          -- AWW AfterInjury [ICL_EMP_POSTINJURY_AWW]
    LOSSDATE,          -- Date of Loss [ICL_LOSSDATE]
    STARTDATE,         -- Last Day Worked [ICL_WCMP_STARTDATE]
    EXPENDDATE,        -- End Date [ICL_WCMP_EXPENDDATE]
    ENDDATE,           -- Return To Work [ICL_EMP_INITIALRTW]
    MMI_DATE,          -- MMI Date [ICL_EMP_MMI_DATE]
    NUM_EXEMPT,        -- Entitled Exmpts [ICL_EMP_NUMOFENTEXEMPTIONS]
    NUMOFWHDEXEMPTIO,  -- WHD Exemptions [ICL_EMP_NUMOFWHDEXEMPTIONS]
    CURRENCY,          -- Currency [ICL_CURRENCY]
    SERVCAT,           -- Int. BC Item ID [ICL_SERVCAT_POSID_INT]
    NUM_DEPENDANTS,    -- No.ofDependents [ICL_EMP_NUMOFDEPENDENTS]
    MARITAL_STATUS,    -- Marital Status [ICL_WCMP_MARITALSTATUS]
    BENEFIT_OFFSET,    -- Amount Offset [ICL_WCMP_OFFSET]
    PAID_FOR_DOI,      -- Day of Injury Paid [ICL_WCMP_PAID_FOR_DOI]
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBCLAIM, WCMPH_SEQNUM)
);

Learn More