I_FSAPlan

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_FSAPlan.
-- 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_FSAPlan AS
SELECT
  pernr AS HCMPersonnelNumber,
  year_type AS HCMClaimYearType,
  barea AS HCMBenefitArea,
  pltyp AS HCMBenefitPlanType,
  bplan AS HCMBenefitPlan,
  pybeg AS HCMBenefitPlanYearStartDate,
  pyend AS HCMBenefitPlanYearEndDate,
  begda AS HCMBenefitPlanStartDate,
  endda AS HCMBenefitPlanEndDate,
  bpcat AS HCMBenefitPlanCategory,
  plnno AS HCMBenefitPlanExternalNumber,
  elidt AS HCMBenefitPlanEligibilityDate,
  pardt AS HCMBenefitPlanParticipationDte,
  enrty AS HCMBenefitEnrollmentType,
  event AS HCMBenefitEvent,
  actin AS HCMBenefitPlanIsActive,
  curre AS HCMBenefitPlanCurrency,
  perio AS HCMBenefitPeriod,
  model AS HCMBenefitPaymentModel,
  egrcl AS HCMBnftPlnCurYrGrcePerdEndDte,
  egrcl_critic AS HCMBnftPlnGrcePerdDateCritlty,
  txt_barea AS HCMBenefitAreaText,
  txt_pcateg AS HCMBenefitPlanCategoryText,
  txt_pltype AS HCMBenefitPlanTypeText,
  txt_plan AS HCMBenefitPlanText,
  txt_period AS HCMBenefitPeriodText,
  txt_model AS HCMBenefitPaymentModelText,
  url_pltype AS HCMBenefitPlanTypeDetailURL,
  txt_urlpt AS HCMBenefitPlanTypeDetailURLTxt,
  url_plan AS HCMBenefitPlanDetailURL,
  txt_urlpl AS HCMBenefitPlanDetailURLText,
  txt_year_type AS HCMClaimYearTypeText,
  year_type_critic AS HCMClaimYearTypeCriticality,
  coppa AS HCMBnftPlnPrevYrPlndContrbnAmt,
  copaa AS HCMBnftPlnCurYrPlndContrbnAmt,
  coypa AS HCMBnftPlnPrevYrContrbnAmt,
  coyaa AS HCMBnftPlnCurYrContrbnAmt,
  clppa AS HCMBnftPlnPrevYrPlndClmAmt,
  clpaa AS HCMBnftPlnPlndClmCurYrAmt,
  clypa AS HCMBnftPlnPrevYTDClmAmt,
  clyaa AS HCMBnftPlnCurYTDClmAmt,
  bappa AS HCMBnftPlnPrevYrPlndBalAmt,
  bapaa AS HCMBnftPlnCurYrPlndBalAmt,
  baypa AS HCMBnftPlnPrevYrBalAmt,
  bayaa AS HCMBnftPlnCurYrBalAmt,
  curra AS HCMBnftPlnCurYrCurrencyKey,
  currp AS HCMBnftPlnPrevYrCurrencyKey,
  carov AS HCMBnftPlnIsCarryOvrAllwd,
  carav AS HCMBenefitPlanCarryOverAmount,
  pegrcl AS HCMBnftPlnPrevYrGrcePerdEndDte,
  iscreateallowed AS HCMBnftPlnIsCreateAllowed,
  available_prev_amount AS HCMBnftPlnPrevYrAvailBalAmt,
  amrpy AS HCMBnftPlnPrevYrReimbursedAmt,
  pybegishidden AS HCMBnftPlnYrStrtDteIsHidn,
  begdaishidden AS HCMClaimStartDateIsHidden,
  benpdateishidden AS HCMBnftPlnYrEndDteIsHidn,
  baypaishidden AS HCMBnftPlnPrevYrBalAmtIsHidden,
  pegrclishidden AS HCMBnftPlnPrevYrGrceDteIsHidn,
  caravishidden AS HCMBnftPlnCarryOvrAmtIsHidn,
  amrpyishidden AS HCMBnftPlnPrevYrRmbsdAmtIsHidn,
  uict_available_balance_critic AS HCMBnftPlnAvailableBalCritlty,
  uict_consumned_bal_pct AS HCMBnftPlnAvailableBalPct
FROM hrfio_d_fsaplans
;