C_FSAPlanTP

DDL: C_FSAPLANTP Type: view_entity CONSUMPTION
63 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Flexible Spending Account Plan- TP

C_FSAPlanTP is a Consumption CDS View that provides data about "Flexible Spending Account Plan- TP" in SAP S/4HANA. It reads from 1 data source (I_FSAPlanTP) and exposes 63 fields with key fields HCMPersonnelNumber, HCMClaimYearType, HCMBenefitArea, HCMBenefitPlanType, HCMBenefitPlan. It has 1 association to related views. It is exposed through 1 OData service (UI_MYFSACLAIMS). It is used in 1 Fiori application: My FSA Claims (S/4HANA).

Data Sources (1)

SourceAliasJoin Type
I_FSAPlanTP I_FSAPlanTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency _Currency.Currency = $projection.HCMBenefitPlanCurrency

Annotations (9)

NameValueLevelField
EndUserText.label Flexible Spending Account Plan- TP view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.query.implementedBy ABAP:CL_CE_HRFIO_FSA_PLANS view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Feature SW:H4S4_SFWS_SC_01 view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MYFSACLAIMS UI_MYFSACLAIMS V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F7336 My FSA Claims (S/4HANA) Transactional Allows the Employee to manage their FSA Claims

My FSA Claims (S/4HANA)

Business Role: Employee - HR Info

You as an employee can use this app to manage your flexible spending accounts (FSAs). FSAs allow employees to set aside pre-tax income to cover anticipated medical or dependent care expenses. Contributions to FSAs are automatically deducted from the employee"s paycheck in accordance with a deduction agreement. When an employee incurs an expense, they register a claim and submit the accompanying receipt, which, if approved, is reimbursed in the employee"s next paycheck. Key Features Display the balance of their flexible spending accounts Display and create claims Change or delete claims that have not yet been approved Register their agreement to the rejection of claims

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber HCMPersonnelNumber Personnel No.
KEY HCMClaimYearType HCMClaimYearType
KEY HCMBenefitArea HCMBenefitArea
KEY HCMBenefitPlanType HCMBenefitPlanType
KEY HCMBenefitPlan HCMBenefitPlan
KEY HCMBenefitPlanYearStartDate HCMBenefitPlanYearStartDate
KEY HCMBenefitPlanYearEndDate HCMBenefitPlanYearEndDate
HCMBenefitPlanStartDate HCMBenefitPlanStartDate
HCMBenefitPlanEndDate HCMBenefitPlanEndDate
HCMBenefitPlanCategory HCMBenefitPlanCategory
HCMBenefitPlanExternalNumber HCMBenefitPlanExternalNumber
HCMBenefitPlanEligibilityDate HCMBenefitPlanEligibilityDate
HCMBenefitPlanParticipationDte HCMBenefitPlanParticipationDte
HCMBenefitEnrollmentType HCMBenefitEnrollmentType
HCMBenefitEvent HCMBenefitEvent
HCMBenefitPlanIsActive HCMBenefitPlanIsActive
HCMBenefitPlanCurrency HCMBenefitPlanCurrency
HCMBenefitPeriod HCMBenefitPeriod
HCMBenefitPaymentModel HCMBenefitPaymentModel
HCMBnftPlnCurYrGrcePerdEndDte HCMBnftPlnCurYrGrcePerdEndDte
HCMBnftPlnGrcePerdDateCritlty HCMBnftPlnGrcePerdDateCritlty
HCMBenefitAreaText HCMBenefitAreaText
HCMBenefitPlanCategoryText HCMBenefitPlanCategoryText
HCMBenefitPlanTypeText HCMBenefitPlanTypeText
HCMBenefitPlanText HCMBenefitPlanText
HCMBenefitPeriodText HCMBenefitPeriodText
HCMBenefitPaymentModelText HCMBenefitPaymentModelText
HCMBenefitPlanTypeDetailURL HCMBenefitPlanTypeDetailURL
HCMBenefitPlanTypeDetailURLTxt HCMBenefitPlanTypeDetailURLTxt
HCMBenefitPlanDetailURL HCMBenefitPlanDetailURL
HCMBenefitPlanDetailURLText HCMBenefitPlanDetailURLText
HCMClaimYearTypeText HCMClaimYearTypeText
HCMClaimYearTypeCriticality HCMClaimYearTypeCriticality
HCMBnftPlnPrevYrPlndContrbnAmt HCMBnftPlnPrevYrPlndContrbnAmt
HCMBnftPlnCurYrPlndContrbnAmt HCMBnftPlnCurYrPlndContrbnAmt
HCMBnftPlnPrevYrContrbnAmt HCMBnftPlnPrevYrContrbnAmt
HCMBnftPlnCurYrContrbnAmt HCMBnftPlnCurYrContrbnAmt
HCMBnftPlnPrevYrPlndClmAmt HCMBnftPlnPrevYrPlndClmAmt
HCMBnftPlnPlndClmCurYrAmt HCMBnftPlnPlndClmCurYrAmt
HCMBnftPlnPrevYTDClmAmt HCMBnftPlnPrevYTDClmAmt
HCMBnftPlnCurYTDClmAmt HCMBnftPlnCurYTDClmAmt
HCMBnftPlnPrevYrPlndBalAmt HCMBnftPlnPrevYrPlndBalAmt
HCMBnftPlnCurYrPlndBalAmt HCMBnftPlnCurYrPlndBalAmt
HCMBnftPlnPrevYrBalAmt HCMBnftPlnPrevYrBalAmt
HCMBnftPlnCurYrBalAmt HCMBnftPlnCurYrBalAmt
HCMBnftPlnCurYrCurrencyKey HCMBnftPlnCurYrCurrencyKey
HCMBnftPlnPrevYrCurrencyKey HCMBnftPlnPrevYrCurrencyKey
HCMBnftPlnIsCarryOvrAllwd HCMBnftPlnIsCarryOvrAllwd
HCMBenefitPlanCarryOverAmount HCMBenefitPlanCarryOverAmount
HCMBnftPlnPrevYrGrcePerdEndDte HCMBnftPlnPrevYrGrcePerdEndDte
HCMBnftPlnIsCreateAllowed HCMBnftPlnIsCreateAllowed
HCMBnftPlnPrevYrAvailBalAmt HCMBnftPlnPrevYrAvailBalAmt
HCMBnftPlnPrevYrReimbursedAmt HCMBnftPlnPrevYrReimbursedAmt
HCMBnftPlnYrStrtDteIsHidn HCMBnftPlnYrStrtDteIsHidn
HCMClaimStartDateIsHidden HCMClaimStartDateIsHidden
HCMBnftPlnYrEndDteIsHidn HCMBnftPlnYrEndDteIsHidn
HCMBnftPlnPrevYrBalAmtIsHidden HCMBnftPlnPrevYrBalAmtIsHidden
HCMBnftPlnPrevYrGrceDteIsHidn HCMBnftPlnPrevYrGrceDteIsHidn
HCMBnftPlnCarryOvrAmtIsHidn HCMBnftPlnCarryOvrAmtIsHidn
HCMBnftPlnPrevYrRmbsdAmtIsHidn HCMBnftPlnPrevYrRmbsdAmtIsHidn
HCMBnftPlnAvailableBalCritlty HCMBnftPlnAvailableBalCritlty
HCMBnftPlnAvailableBalPct HCMBnftPlnAvailableBalPct
_Currency _Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FSAPlanTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_FSAPlanTP AS
SELECT
  HCMPersonnelNumber,
  HCMClaimYearType,
  HCMBenefitArea,
  HCMBenefitPlanType,
  HCMBenefitPlan,
  HCMBenefitPlanYearStartDate,
  HCMBenefitPlanYearEndDate,
  HCMBenefitPlanStartDate,
  HCMBenefitPlanEndDate,
  HCMBenefitPlanCategory,
  HCMBenefitPlanExternalNumber,
  HCMBenefitPlanEligibilityDate,
  HCMBenefitPlanParticipationDte,
  HCMBenefitEnrollmentType,
  HCMBenefitEvent,
  HCMBenefitPlanIsActive,
  HCMBenefitPlanCurrency,
  HCMBenefitPeriod,
  HCMBenefitPaymentModel,
  HCMBnftPlnCurYrGrcePerdEndDte,
  HCMBnftPlnGrcePerdDateCritlty,
  HCMBenefitAreaText,
  HCMBenefitPlanCategoryText,
  HCMBenefitPlanTypeText,
  HCMBenefitPlanText,
  HCMBenefitPeriodText,
  HCMBenefitPaymentModelText,
  HCMBenefitPlanTypeDetailURL,
  HCMBenefitPlanTypeDetailURLTxt,
  HCMBenefitPlanDetailURL,
  HCMBenefitPlanDetailURLText,
  HCMClaimYearTypeText,
  HCMClaimYearTypeCriticality,
  HCMBnftPlnPrevYrPlndContrbnAmt,
  HCMBnftPlnCurYrPlndContrbnAmt,
  HCMBnftPlnPrevYrContrbnAmt,
  HCMBnftPlnCurYrContrbnAmt,
  HCMBnftPlnPrevYrPlndClmAmt,
  HCMBnftPlnPlndClmCurYrAmt,
  HCMBnftPlnPrevYTDClmAmt,
  HCMBnftPlnCurYTDClmAmt,
  HCMBnftPlnPrevYrPlndBalAmt,
  HCMBnftPlnCurYrPlndBalAmt,
  HCMBnftPlnPrevYrBalAmt,
  HCMBnftPlnCurYrBalAmt,
  HCMBnftPlnCurYrCurrencyKey,
  HCMBnftPlnPrevYrCurrencyKey,
  HCMBnftPlnIsCarryOvrAllwd,
  HCMBenefitPlanCarryOverAmount,
  HCMBnftPlnPrevYrGrcePerdEndDte,
  HCMBnftPlnIsCreateAllowed,
  HCMBnftPlnPrevYrAvailBalAmt,
  HCMBnftPlnPrevYrReimbursedAmt,
  HCMBnftPlnYrStrtDteIsHidn,
  HCMClaimStartDateIsHidden,
  HCMBnftPlnYrEndDteIsHidn,
  HCMBnftPlnPrevYrBalAmtIsHidden,
  HCMBnftPlnPrevYrGrceDteIsHidn,
  HCMBnftPlnCarryOvrAmtIsHidn,
  HCMBnftPlnPrevYrRmbsdAmtIsHidn,
  HCMBnftPlnAvailableBalCritlty,
  HCMBnftPlnAvailableBalPct
FROM I_FSAPlanTP
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = HCMBenefitPlanCurrency  -- association [0..1]
;

Learn More