I_PRAStateInterestOption

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_PRAStateInterestOption.
-- 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.
-- SQL view name: ISTINTOPT

CREATE VIEW I_PRAStateInterestOption AS
SELECT
  land1 AS Country,
  pri_geo_loc AS PrimaryGeogrlLocation,
  int_opt AS PRAInterestOption,
  eff_from_dt AS PRAStateIntrstOptnEffctvFrmDte,
  eff_to_dt AS PRAStateIntrstOptnEffctvToDate,
  frml_no AS PRAInterestFormulaNumber,
  int_opt_desc AS PRAInterestOptionDesc,
  int_rt_dt_sel AS PRAInterestRateDateSelection,
  int_type AS PRAInterestCalculationType,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime
FROM /pra/int_st_opt
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CountryVH AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON Country = _PrimaryGeogrlLocation.Country AND PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation  -- association [0..1]
LEFT OUTER JOIN I_PRAInterestFormulaNumberVH AS _PRAInterestFormulaNumberVH ON PRAInterestFormulaNumber = _PRAInterestFormulaNumberVH.PRAInterestFormulaNumber  -- association [0..1]
LEFT OUTER JOIN I_PRAInterestRateDateSel AS _PRAInterestRateDateSel ON PRAInterestRateDateSelection = _PRAInterestRateDateSel.PRAInterestRateDateSelection  -- association [0..1]
LEFT OUTER JOIN I_PRAInterestCalcType AS _PRAInterestCalcType ON PRAInterestCalculationType = _PRAInterestCalcType.PRAInterestCalculationType  -- association [0..1]
;