I_FSAClaim

DDL: I_FSACLAIM Type: view_entity BASIC
41 Fields 1 Data Sources

Flexible Spending Account Claim

I_FSAClaim is a Basic CDS View that provides data about "Flexible Spending Account Claim" in SAP S/4HANA. It reads from 1 data source (hrfio_d_fsa_clms) and exposes 41 fields with key fields HCMPersonnelNumber, HCMClaimYearType, HCMBenefitArea, HCMBenefitPlanType, HCMBenefitPlan.

Data Sources (1)

SourceAliasJoin Type
hrfio_d_fsa_clms hrfio_d_fsa_clms from

Annotations (7)

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

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber pernr Personnel no.
KEY HCMClaimYearType year_type Current or Previous year indicator
KEY HCMBenefitArea barea Benefit area
KEY HCMBenefitPlanType pltyp Price List Tp.
KEY HCMBenefitPlan bplan Benefit plan
KEY HCMClaimSequenceNumber seqnr Tank ID
KEY HCMClaimStartDate begda Valid From
KEY HCMClaimEndDate endda Valid To
KEY HCMBenefitPlanYearStartDate pybeg Start plan year
KEY HCMBenefitPlanYearEndDate pyend Ende plan year
KEY HCMClaimIsExisting claimexists Single-Character Flag
HCMClaimChangedOnDate aedtm Changed On
HCMClaimChangedBy uname User Name
HCMClaimIsLocked sprps Single-Character Flag
HCMClaimLockReasonText sprtx Lock indicator
HCMClaimScreenControl itbld Screen control
HCMClaimHasText itxex Text exists
HCMBenefitPlanText plntx Benefit Plan
HCMClaimSubmissionDate cldat Closed On
HCMClaimIsPendingForApproval pendg On hold
HCMClaimCostIncurredDate codat Date cost inc.
HCMClaimIsCancelled cancd Cancellation
HCMClaimAmount fsacl Receivable
HCMClaimCurrencyKey curre Currency
HCMClaimCurrencyKeyDisplay curre1 Currency
HCMClmCurrencyKeyDisplayIsHidn uict_currency TRUE
HCMClaimIsAgreed agree Agreement
HCMClaimStatus clsta Status of claim
HCMClaimStatusText txt_clsta Flexible Spending Account Status Text
HCMClaimStatusCriticality clsta_critic INT1
HCMClaimYearTypeText txt_year_type Flexible Spending Account Year Type Text
HCMClaimYearTypeCriticality year_type_critic
HCMClaimReceiptType rcpty Receipt type
HCMClaimReceiptTypeText txt_rcpty Description
HCMClaimReceiptNumber recnr Receipt number
HCMClaimProvider provn Provider name
HCMClaimReceivableAmount fsagl Receivable
HCMClaimStatusIsHidden clstaishidden TRUE
HCMClaimChangeIsAllowed claimcanbechanged TRUE
HCMClaimRejectIsAllowed claimcanberejected TRUE
HCMClaimDeleteIsAllowed claimcanbedeleted TRUE

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_FSAClaim.
-- 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_FSAClaim AS
SELECT
  pernr AS HCMPersonnelNumber,
  year_type AS HCMClaimYearType,
  barea AS HCMBenefitArea,
  pltyp AS HCMBenefitPlanType,
  bplan AS HCMBenefitPlan,
  seqnr AS HCMClaimSequenceNumber,
  begda AS HCMClaimStartDate,
  endda AS HCMClaimEndDate,
  pybeg AS HCMBenefitPlanYearStartDate,
  pyend AS HCMBenefitPlanYearEndDate,
  claimexists AS HCMClaimIsExisting,
  aedtm AS HCMClaimChangedOnDate,
  uname AS HCMClaimChangedBy,
  sprps AS HCMClaimIsLocked,
  sprtx AS HCMClaimLockReasonText,
  itbld AS HCMClaimScreenControl,
  itxex AS HCMClaimHasText,
  plntx AS HCMBenefitPlanText,
  cldat AS HCMClaimSubmissionDate,
  pendg AS HCMClaimIsPendingForApproval,
  codat AS HCMClaimCostIncurredDate,
  cancd AS HCMClaimIsCancelled,
  fsacl AS HCMClaimAmount,
  curre AS HCMClaimCurrencyKey,
  curre1 AS HCMClaimCurrencyKeyDisplay,
  uict_currency AS HCMClmCurrencyKeyDisplayIsHidn,
  agree AS HCMClaimIsAgreed,
  clsta AS HCMClaimStatus,
  txt_clsta AS HCMClaimStatusText,
  clsta_critic AS HCMClaimStatusCriticality,
  txt_year_type AS HCMClaimYearTypeText,
  year_type_critic AS HCMClaimYearTypeCriticality,
  rcpty AS HCMClaimReceiptType,
  txt_rcpty AS HCMClaimReceiptTypeText,
  recnr AS HCMClaimReceiptNumber,
  provn AS HCMClaimProvider,
  fsagl AS HCMClaimReceivableAmount,
  clstaishidden AS HCMClaimStatusIsHidden,
  claimcanbechanged AS HCMClaimChangeIsAllowed,
  claimcanberejected AS HCMClaimRejectIsAllowed,
  claimcanbedeleted AS HCMClaimDeleteIsAllowed
FROM hrfio_d_fsa_clms
;

Learn More