ICL_FUND_HDR

Transparent Table Application Table
35 Fields 2 CDS Views

Fund

ICL_FUND_HDR is an SAP database table in S/4HANA. Fund. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InsurClmFundHeader view_entity from EXTENSION Claim Fund - Extension
I_InsurClmFundHeaderBasic view_entity from BASIC Grundsicht für Fonds

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY active ICL_ACTIVE Active/Suspense
KEY claim ICL_CLAIM Claim Number
KEY fund_hdr_id ICL_SUBOBJECT_UUID_D Object GUID
changetime ICL_CHANGEUTC1 Changed On
changedby ICL_CHANGEDBY Changed By
deleted ICL_RECSTATUS Status
fund_hdr_num ICL_FUND_HDR_NUM_D Fund Calc. No.
totalfundvalue ICL_TOTALFUNDVALUE_D Total Fund Val.
totsurrendvalue ICL_TOTSURRENDVALUE_D Surr.Value Fund
valuesettingbase ICL_VALUESETTINGBASE_D Value Date Base
valuesettbase_dt ICL_VALUESETTBASE_DT_D Value Date
valuedate ICL_VALUEDATE_D Value Date
calcbasedondistr ICL_CALCBASEDONDISTR_D Calc.B.onDistrb
totgrossdrawam ICL_TOTGROSSDRAWAM_D Gross Withdrawl
totgrossdrawpct ICL_TOTGROSSDRAWPCT_D Gr.Withdrawal %
tottranscharge ICL_TOTTRANSCHARGE_D Totl Trans.Chrg
transchargerate ICL_TRANSCHARGERATE_D Charge Rate %
totalfundcharge ICL_TOTALFUNDCHARGE_D Fund Charges
totalrevdeduct ICL_TOTALREVDEDUCT_D Reversal Dedctn
totnetwithdrawam ICL_TOTNETWITHDRAWAM_D Net Withdrawal
withdrawampretax ICL_WITHDRAWAMPRETAX_D WthdrAmt BefTax
withdrawvariance ICL_WITHDRAWVARIANCE_D Withdrawal Var.
transchargemin ICL_TRANSCHARGEMIN_D Min.Trans.Chrge
transchargemax ICL_TRANSCHARGEMAX_D Max.TrnsactChrg
fundcurr ICL_FUNDCURR_D Currency
ordergenid ICL_ORDERGENID_D ID Fund Order
fundvalueavail ICL_FUNDVALUEAVAILABLE_D Prices Availabl
chargecat ICL_CHARGECAT_D Charge Type
valuesetbase_pm ICL_VALUESETTINGBASE_D Value Date Base
valsetbase_dt_pm ICL_VALUESETTBASE_DT_D Value Date
ttranscharge_pm ICL_TOTTRANSCHARGE_D Totl Trans.Chrg
tchargerate_pm ICL_TRANSCHARGERATE_D Charge Rate %
fundval_modified ICL_MOD_MANUAL Changed Manually
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.

-- Fund
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICL_FUND_HDR (
    CLIENT,            -- Client [MANDT]
    ACTIVE,            -- Active/Suspense [ICL_ACTIVE]
    CLAIM,             -- Claim Number [ICL_CLAIM]
    FUND_HDR_ID,       -- Object GUID [ICL_SUBOBJECT_UUID_D]
    CHANGETIME,        -- Changed On [ICL_CHANGEUTC1]
    CHANGEDBY,         -- Changed By [ICL_CHANGEDBY]
    DELETED,           -- Status [ICL_RECSTATUS]
    FUND_HDR_NUM,      -- Fund Calc. No. [ICL_FUND_HDR_NUM_D]
    TOTALFUNDVALUE,    -- Total Fund Val. [ICL_TOTALFUNDVALUE_D]
    TOTSURRENDVALUE,   -- Surr.Value Fund [ICL_TOTSURRENDVALUE_D]
    VALUESETTINGBASE,  -- Value Date Base [ICL_VALUESETTINGBASE_D]
    VALUESETTBASE_DT,  -- Value Date [ICL_VALUESETTBASE_DT_D]
    VALUEDATE,         -- Value Date [ICL_VALUEDATE_D]
    CALCBASEDONDISTR,  -- Calc.B.onDistrb [ICL_CALCBASEDONDISTR_D]
    TOTGROSSDRAWAM,    -- Gross Withdrawl [ICL_TOTGROSSDRAWAM_D]
    TOTGROSSDRAWPCT,   -- Gr.Withdrawal % [ICL_TOTGROSSDRAWPCT_D]
    TOTTRANSCHARGE,    -- Totl Trans.Chrg [ICL_TOTTRANSCHARGE_D]
    TRANSCHARGERATE,   -- Charge Rate % [ICL_TRANSCHARGERATE_D]
    TOTALFUNDCHARGE,   -- Fund Charges [ICL_TOTALFUNDCHARGE_D]
    TOTALREVDEDUCT,    -- Reversal Dedctn [ICL_TOTALREVDEDUCT_D]
    TOTNETWITHDRAWAM,  -- Net Withdrawal [ICL_TOTNETWITHDRAWAM_D]
    WITHDRAWAMPRETAX,  -- WthdrAmt BefTax [ICL_WITHDRAWAMPRETAX_D]
    WITHDRAWVARIANCE,  -- Withdrawal Var. [ICL_WITHDRAWVARIANCE_D]
    TRANSCHARGEMIN,    -- Min.Trans.Chrge [ICL_TRANSCHARGEMIN_D]
    TRANSCHARGEMAX,    -- Max.TrnsactChrg [ICL_TRANSCHARGEMAX_D]
    FUNDCURR,          -- Currency [ICL_FUNDCURR_D]
    ORDERGENID,        -- ID Fund Order [ICL_ORDERGENID_D]
    FUNDVALUEAVAIL,    -- Prices Availabl [ICL_FUNDVALUEAVAILABLE_D]
    CHARGECAT,         -- Charge Type [ICL_CHARGECAT_D]
    VALUESETBASE_PM,   -- Value Date Base [ICL_VALUESETTINGBASE_D]
    VALSETBASE_DT_PM,  -- Value Date [ICL_VALUESETTBASE_DT_D]
    TTRANSCHARGE_PM,   -- Totl Trans.Chrg [ICL_TOTTRANSCHARGE_D]
    TCHARGERATE_PM,    -- Charge Rate % [ICL_TRANSCHARGERATE_D]
    FUNDVAL_MODIFIED,  -- Changed Manually [ICL_MOD_MANUAL]
    DUMMY_FIELD,       -- abap.char
    PRIMARY KEY (CLIENT, ACTIVE, CLAIM, FUND_HDR_ID)
);

Learn More