I_FSAPlanTP

DDL: I_FSAPLANTP Type: view_entity TRANSACTIONAL
64 Fields 1 Data Sources 2 Associations

Flexible Spending Account Plan - TP

I_FSAPlanTP is a Transactional CDS View that provides data about "Flexible Spending Account Plan - TP" in SAP S/4HANA. It reads from 1 data source (I_FSAPlan) and exposes 64 fields with key fields HCMPersonnelNumber, HCMClaimYearType, HCMBenefitArea, HCMBenefitPlanType, HCMBenefitPlan. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FSAPlan I_FSAPlan from

Associations (2)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Flexible Spending Account Plan - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber HCMPersonnelNumber Personnel No.
KEY HCMClaimYearType HCMClaimYearType Current or Previous year indicator
KEY HCMBenefitArea HCMBenefitArea Benefit area
KEY HCMBenefitPlanType HCMBenefitPlanType Price List Tp.
KEY HCMBenefitPlan HCMBenefitPlan Benefit plan
KEY HCMBenefitPlanYearStartDate HCMBenefitPlanYearStartDate Start plan year
KEY HCMBenefitPlanYearEndDate HCMBenefitPlanYearEndDate Ende plan year
HCMBenefitPlanStartDate HCMBenefitPlanStartDate Valid From
HCMBenefitPlanEndDate HCMBenefitPlanEndDate Valid To
HCMBenefitPlanCategory HCMBenefitPlanCategory Plan category
HCMBenefitPlanExternalNumber HCMBenefitPlanExternalNumber Plan number
HCMBenefitPlanEligibilityDate HCMBenefitPlanEligibilityDate Eligible on
HCMBenefitPlanParticipationDte HCMBenefitPlanParticipationDte Particip.date
HCMBenefitEnrollmentType HCMBenefitEnrollmentType Type of enrol.
HCMBenefitEvent HCMBenefitEvent Time
HCMBenefitPlanIsActive HCMBenefitPlanIsActive Active
HCMBenefitPlanCurrency HCMBenefitPlanCurrency Currency
HCMBenefitPeriod HCMBenefitPeriod Time unit
HCMBenefitPaymentModel HCMBenefitPaymentModel Vehicle Model
HCMBnftPlnCurYrGrcePerdEndDte HCMBnftPlnCurYrGrcePerdEndDte End of grace
HCMBnftPlnGrcePerdDateCritlty HCMBnftPlnGrcePerdDateCritlty
HCMBenefitAreaText HCMBenefitAreaText BenArea Text
HCMBenefitPlanCategoryText HCMBenefitPlanCategoryText PlanCateg. text
HCMBenefitPlanTypeText HCMBenefitPlanTypeText Plan type text
HCMBenefitPlanText HCMBenefitPlanText Plan text
HCMBenefitPeriodText HCMBenefitPeriodText Period text
HCMBenefitPaymentModelText HCMBenefitPaymentModelText Name
HCMBenefitPlanTypeDetailURL HCMBenefitPlanTypeDetailURL URL for type
HCMBenefitPlanTypeDetailURLTxt HCMBenefitPlanTypeDetailURLTxt Text on URL
HCMBenefitPlanDetailURL HCMBenefitPlanDetailURL URL for plan
HCMBenefitPlanDetailURLText HCMBenefitPlanDetailURLText Text on URL
HCMClaimYearTypeText HCMClaimYearTypeText Flexible Spending Account Year Type Text
HCMClaimYearTypeCriticality HCMClaimYearTypeCriticality
HCMBnftPlnPrevYrPlndContrbnAmt HCMBnftPlnPrevYrPlndContrbnAmt Contr.
HCMBnftPlnCurYrPlndContrbnAmt HCMBnftPlnCurYrPlndContrbnAmt Contributions
HCMBnftPlnPrevYrContrbnAmt HCMBnftPlnPrevYrContrbnAmt Contributions
HCMBnftPlnCurYrContrbnAmt HCMBnftPlnCurYrContrbnAmt Contributions
HCMBnftPlnPrevYrPlndClmAmt HCMBnftPlnPrevYrPlndClmAmt Claims
HCMBnftPlnPlndClmCurYrAmt HCMBnftPlnPlndClmCurYrAmt FSA Claims
HCMBnftPlnPrevYTDClmAmt HCMBnftPlnPrevYTDClmAmt Claims
HCMBnftPlnCurYTDClmAmt HCMBnftPlnCurYTDClmAmt Claims
HCMBnftPlnPrevYrPlndBalAmt HCMBnftPlnPrevYrPlndBalAmt Balance
HCMBnftPlnCurYrPlndBalAmt HCMBnftPlnCurYrPlndBalAmt Balance
HCMBnftPlnPrevYrBalAmt HCMBnftPlnPrevYrBalAmt Balance
HCMBnftPlnCurYrBalAmt HCMBnftPlnCurYrBalAmt Balance
HCMBnftPlnCurYrCurrencyKey HCMBnftPlnCurYrCurrencyKey Currency
HCMBnftPlnPrevYrCurrencyKey HCMBnftPlnPrevYrCurrencyKey Currency
HCMBnftPlnIsCarryOvrAllwd HCMBnftPlnIsCarryOvrAllwd Carryover
HCMBenefitPlanCarryOverAmount HCMBenefitPlanCarryOverAmount Contributions
HCMBnftPlnPrevYrGrcePerdEndDte HCMBnftPlnPrevYrGrcePerdEndDte End of Grace
HCMBnftPlnIsCreateAllowed HCMBnftPlnIsCreateAllowed Single-Character Flag
HCMBnftPlnPrevYrAvailBalAmt HCMBnftPlnPrevYrAvailBalAmt Contribution
HCMBnftPlnPrevYrReimbursedAmt HCMBnftPlnPrevYrReimbursedAmt Contributions
HCMBnftPlnYrStrtDteIsHidn HCMBnftPlnYrStrtDteIsHidn Single-Character Flag
HCMClaimStartDateIsHidden HCMClaimStartDateIsHidden Single-Character Flag
HCMBnftPlnYrEndDteIsHidn HCMBnftPlnYrEndDteIsHidn Single-Character Flag
HCMBnftPlnPrevYrBalAmtIsHidden HCMBnftPlnPrevYrBalAmtIsHidden Single-Character Flag
HCMBnftPlnPrevYrGrceDteIsHidn HCMBnftPlnPrevYrGrceDteIsHidn Single-Character Flag
HCMBnftPlnCarryOvrAmtIsHidn HCMBnftPlnCarryOvrAmtIsHidn Single-Character Flag
HCMBnftPlnPrevYrRmbsdAmtIsHidn HCMBnftPlnPrevYrRmbsdAmtIsHidn Single-Character Flag
HCMBnftPlnAvailableBalCritlty HCMBnftPlnAvailableBalCritlty
HCMBnftPlnAvailableBalPct HCMBnftPlnAvailableBalPct
_FSAClaim _FSAClaim
_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 I_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 I_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_FSAPlan
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = HCMBenefitPlanCurrency  -- association [0..1]
LEFT OUTER JOIN I_FSAClaimTP AS _FSAClaim ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More