HRFIO_D_FSA_CLMS

Transparent Table Application Table
42 Fields 1 CDS Views

Table for Fsa claims

HRFIO_D_FSA_CLMS is an SAP database table in S/4HANA. Table for Fsa claims. It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FSAClaim view_entity from BASIC Flexible Spending Account Claim

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pernr pernr_d Personnel No.
KEY year_type hrfio_fsa_year_type Current or Previous year indicator
KEY barea ben_area Benefit area
KEY pltyp ben_type Plan type
KEY bplan ben_plan Benefit plan
KEY seqnr seqnr IT record no.
KEY begda pad_begda Valid From
KEY endda pad_endda Valid To
KEY pybeg ben_pybeg Start plan year
KEY pyend ben_pyend Ende plan year
KEY claimexists char1 Single-Character Flag
aedtm aedat Changed On
uname aenam Changed By
sprps sprps Lock indicator
sprtx sprpstext Lock indicator
itbld itbld Screen control
itxex itxex Text exists
plntx ben_plan_text Benefit Plan
cldat ben_cldat Claim Submis. Date
pendg ben_pendg On hold
codat ben_codat Date cost inc.
cancd ben_cancd Cancellation
fsacl ben_fsacl Receivable
curre ben_curr Currency
curre1 ben_curr Currency
uict_currency boole_d TRUE
agree ben_agree Agreement
clsta ben_clsta Status of claim
clsta_critic int1 INT1
txt_clsta hrfio_fsa_status_text Flexible Spending Account Status Text
txt_year_type hrfio_fsa_year_type_text Flexible Spending Account Year Type Text
year_type_critic abap.int1 Year Type Criticality
rcpty ben_rcpty Receipt type
txt_rcpty text20 Description
recnr ben_recnr Receipt number
provn ben_provn Provider name
fsagl ben_fsacl Receivable
clstaishidden boole_d TRUE
claimcanbechanged boole_d TRUE
claimcanberejected boole_d TRUE
claimcanbedeleted boole_d TRUE

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.

-- Table for Fsa claims
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FSA_CLMS (
    MANDT,               -- Client [mandt]
    PERNR,               -- Personnel No. [pernr_d]
    YEAR_TYPE,           -- Current or Previous year indicator [hrfio_fsa_year_type]
    BAREA,               -- Benefit area [ben_area]
    PLTYP,               -- Plan type [ben_type]
    BPLAN,               -- Benefit plan [ben_plan]
    SEQNR,               -- IT record no. [seqnr]
    BEGDA,               -- Valid From [pad_begda]
    ENDDA,               -- Valid To [pad_endda]
    PYBEG,               -- Start plan year [ben_pybeg]
    PYEND,               -- Ende plan year [ben_pyend]
    CLAIMEXISTS,         -- Single-Character Flag [char1]
    AEDTM,               -- Changed On [aedat]
    UNAME,               -- Changed By [aenam]
    SPRPS,               -- Lock indicator [sprps]
    SPRTX,               -- Lock indicator [sprpstext]
    ITBLD,               -- Screen control [itbld]
    ITXEX,               -- Text exists [itxex]
    PLNTX,               -- Benefit Plan [ben_plan_text]
    CLDAT,               -- Claim Submis. Date [ben_cldat]
    PENDG,               -- On hold [ben_pendg]
    CODAT,               -- Date cost inc. [ben_codat]
    CANCD,               -- Cancellation [ben_cancd]
    FSACL,               -- Receivable [ben_fsacl]
    CURRE,               -- Currency [ben_curr]
    CURRE1,              -- Currency [ben_curr]
    UICT_CURRENCY,       -- TRUE [boole_d]
    AGREE,               -- Agreement [ben_agree]
    CLSTA,               -- Status of claim [ben_clsta]
    CLSTA_CRITIC,        -- INT1 [int1]
    TXT_CLSTA,           -- Flexible Spending Account Status Text [hrfio_fsa_status_text]
    TXT_YEAR_TYPE,       -- Flexible Spending Account Year Type Text [hrfio_fsa_year_type_text]
    YEAR_TYPE_CRITIC,    -- Year Type Criticality [abap.int1]
    RCPTY,               -- Receipt type [ben_rcpty]
    TXT_RCPTY,           -- Description [text20]
    RECNR,               -- Receipt number [ben_recnr]
    PROVN,               -- Provider name [ben_provn]
    FSAGL,               -- Receivable [ben_fsacl]
    CLSTAISHIDDEN,       -- TRUE [boole_d]
    CLAIMCANBECHANGED,   -- TRUE [boole_d]
    CLAIMCANBEREJECTED,  -- TRUE [boole_d]
    CLAIMCANBEDELETED,   -- TRUE [boole_d]
    PRIMARY KEY (MANDT, PERNR, YEAR_TYPE, BAREA, PLTYP, BPLAN, SEQNR, BEGDA, ENDDA, PYBEG, PYEND, CLAIMEXISTS)
);

Learn More