HRFIO_D_FSAPLANS

Transparent Table Application Table
71 Fields 1 CDS Views

Table for fsa plans

HRFIO_D_FSAPLANS is an SAP database table in S/4HANA. Table for fsa plans. It contains 71 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FSAPlan view_entity from BASIC Flexible Spending Account Plan

Fields (71)

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 pybeg ben_pybeg Start plan year
KEY pyend ben_pyend Ende plan year
begda ben_crbeg Start ex.record
endda ben_crend End ex. record
bpcat ben_categ Plan category
plnno ben_planno Plan number
elidt ben_elidt Eligible on
pardt ben_partdt Particip.date
enrty ben_enrtyp Type of enrol.
event ben_event Adjust. reason
actin ben_active Active
curre ben_curr Currency
perio ben_period Period
model mode1 Payment model
egrcl ben_egrcl End of grace
egrcl_critic abap.int1 End of Grace Period Criticality
camnt ben_camnt Contribution
eettl ben_eettl EE total contr.
erttl ben_erttl ER total contr.
paytg cob_paytg Payment target
reitg cob_reitg Reimburs.target
cocst cob_cocst COBRA costs
txt_barea ben_areatx BenArea Text
txt_pcateg ben_cattx PlanCateg. text
txt_pltype ben_pltptx Plan type text
txt_plan ben_plantx Plan text
txt_period ben_peritx Period text
txt_model mode1tx Name
url_pltype ben_urltco URL for type
txt_urlpt ben_urlttx Text on URL
url_plan ben_urlpco URL for plan
txt_urlpl ben_urlptx Text on URL
txt_year_type hrfio_fsa_year_type_text Flexible Spending Account Year Type Text
year_type_critic abap.int1 Year Type Criticality
coppa ben_coppa Contr.
copaa ben_copaa Contributions
coypa ben_coypa Contributions
coyaa ben_coyaa Contributions
clppa ben_clppa Claims
clpaa ben_clpaa FSA Claims
clypa ben_clypa Claims
clyaa ben_clyaa Claims
bappa ben_bappa Balance
bapaa ben_bapaa Balance
baypa ben_baypa Balance
bayaa ben_bayaa Balance
curra ben_curr Currency
currp ben_curr Currency
carov ben_carov Carryover
carav ben_copaa Contributions
pegrcl hress_ben_pegrcl End of Grace
iscreateallowed char1 Single-Character Flag
available_prev_amount ben_camnt Contribution
curapa ben_curr Currency
amrpy ben_copaa Contributions
currc ben_curr Currency
pybegishidden char1 Single-Character Flag
begdaishidden char1 Single-Character Flag
benpdateishidden char1 Single-Character Flag
baypaishidden char1 Single-Character Flag
pegrclishidden char1 Single-Character Flag
caravishidden char1 Single-Character Flag
amrpyishidden char1 Single-Character Flag
uict_available_balance_critic abap.int1 Semantic Color Avialble Balance
uict_consumned_bal_pct abap.int1 Consumed Balance Percentage

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 plans
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_FSAPLANS (
    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]
    PYBEG,                          -- Start plan year [ben_pybeg]
    PYEND,                          -- Ende plan year [ben_pyend]
    BEGDA,                          -- Start ex.record [ben_crbeg]
    ENDDA,                          -- End ex. record [ben_crend]
    BPCAT,                          -- Plan category [ben_categ]
    PLNNO,                          -- Plan number [ben_planno]
    ELIDT,                          -- Eligible on [ben_elidt]
    PARDT,                          -- Particip.date [ben_partdt]
    ENRTY,                          -- Type of enrol. [ben_enrtyp]
    EVENT,                          -- Adjust. reason [ben_event]
    ACTIN,                          -- Active [ben_active]
    CURRE,                          -- Currency [ben_curr]
    PERIO,                          -- Period [ben_period]
    MODEL,                          -- Payment model [mode1]
    EGRCL,                          -- End of grace [ben_egrcl]
    EGRCL_CRITIC,                   -- End of Grace Period Criticality [abap.int1]
    CAMNT,                          -- Contribution [ben_camnt]
    EETTL,                          -- EE total contr. [ben_eettl]
    ERTTL,                          -- ER total contr. [ben_erttl]
    PAYTG,                          -- Payment target [cob_paytg]
    REITG,                          -- Reimburs.target [cob_reitg]
    COCST,                          -- COBRA costs [cob_cocst]
    TXT_BAREA,                      -- BenArea Text [ben_areatx]
    TXT_PCATEG,                     -- PlanCateg. text [ben_cattx]
    TXT_PLTYPE,                     -- Plan type text [ben_pltptx]
    TXT_PLAN,                       -- Plan text [ben_plantx]
    TXT_PERIOD,                     -- Period text [ben_peritx]
    TXT_MODEL,                      -- Name [mode1tx]
    URL_PLTYPE,                     -- URL for type [ben_urltco]
    TXT_URLPT,                      -- Text on URL [ben_urlttx]
    URL_PLAN,                       -- URL for plan [ben_urlpco]
    TXT_URLPL,                      -- Text on URL [ben_urlptx]
    TXT_YEAR_TYPE,                  -- Flexible Spending Account Year Type Text [hrfio_fsa_year_type_text]
    YEAR_TYPE_CRITIC,               -- Year Type Criticality [abap.int1]
    COPPA,                          -- Contr. [ben_coppa]
    COPAA,                          -- Contributions [ben_copaa]
    COYPA,                          -- Contributions [ben_coypa]
    COYAA,                          -- Contributions [ben_coyaa]
    CLPPA,                          -- Claims [ben_clppa]
    CLPAA,                          -- FSA Claims [ben_clpaa]
    CLYPA,                          -- Claims [ben_clypa]
    CLYAA,                          -- Claims [ben_clyaa]
    BAPPA,                          -- Balance [ben_bappa]
    BAPAA,                          -- Balance [ben_bapaa]
    BAYPA,                          -- Balance [ben_baypa]
    BAYAA,                          -- Balance [ben_bayaa]
    CURRA,                          -- Currency [ben_curr]
    CURRP,                          -- Currency [ben_curr]
    CAROV,                          -- Carryover [ben_carov]
    CARAV,                          -- Contributions [ben_copaa]
    PEGRCL,                         -- End of Grace [hress_ben_pegrcl]
    ISCREATEALLOWED,                -- Single-Character Flag [char1]
    AVAILABLE_PREV_AMOUNT,          -- Contribution [ben_camnt]
    CURAPA,                         -- Currency [ben_curr]
    AMRPY,                          -- Contributions [ben_copaa]
    CURRC,                          -- Currency [ben_curr]
    PYBEGISHIDDEN,                  -- Single-Character Flag [char1]
    BEGDAISHIDDEN,                  -- Single-Character Flag [char1]
    BENPDATEISHIDDEN,               -- Single-Character Flag [char1]
    BAYPAISHIDDEN,                  -- Single-Character Flag [char1]
    PEGRCLISHIDDEN,                 -- Single-Character Flag [char1]
    CARAVISHIDDEN,                  -- Single-Character Flag [char1]
    AMRPYISHIDDEN,                  -- Single-Character Flag [char1]
    UICT_AVAILABLE_BALANCE_CRITIC,  -- Semantic Color Avialble Balance [abap.int1]
    UICT_CONSUMNED_BAL_PCT,         -- Consumed Balance Percentage [abap.int1]
    PRIMARY KEY (MANDT, PERNR, YEAR_TYPE, BAREA, PLTYP, BPLAN, PYBEG, PYEND)
);

Learn More