I_InsurClmFundHeaderBasic

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_InsurClmFundHeaderBasic.
-- 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_InsurClmFundHeaderBasic AS
SELECT
  active AS InsurClmActive,
  claim AS InsuranceClaim,
  fund_hdr_id AS InsurClmFundHdrUUID,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  fund_hdr_num AS InsuranceClaimFundHeaderNumber,
  totalfundvalue AS InsurClmFundHdrTotFundValAmt,
  totsurrendvalue AS InsurClmFundHdrTotSrrndrValAmt,
  valuesettingbase AS InsurClmFundHdrValSetBaseKey,
  valuesettbase_dt AS InsurClmFundHdrValueDate,
  valuedate AS InsurClmBeneficiaryValueDate,
  calcbasedondistr AS InsurClmFundHdrCalcBsdOnDistr,
  totgrossdrawam AS InsurClmFundHdrTotGrssDrawAmt,
  totgrossdrawpct AS InsurClmFundHdrTotGrssDrawPct,
  tottranscharge AS InsurClmFundHdrTotTransChrgAmt,
  transchargerate AS InsurClmFundHdrTransChargeRate,
  totalfundcharge AS InsurClmFundHdrTotFundChrgAmt,
  totalrevdeduct AS InsurClmTotRvslDeductionAmount,
  totnetwithdrawam AS InsurClmTotNetWthdrwlAmt,
  withdrawampretax AS InsurClmTotWthdrwlPreTaxAmount,
  withdrawvariance AS InsurClmWthdrwlVarianceAmount,
  transchargemin AS InsurClmMinTransChargeAmount,
  transchargemax AS InsurClmMaxTransChargeAmount,
  fundcurr AS InsuranceClaimFundCurrency,
  ordergenid AS InsurClmFundHdrOrderGenID,
  fundvalueavail AS InsurClmAllFundPrIsAvailable,
  chargecat AS InsurClmFundHdrChrgCategory,
  valuesetbase_pm AS InsurClmPlcyMgmtValSetBaseKey,
  valsetbase_dt_pm AS InsurClmPlcyMgmtValueDate,
  ttranscharge_pm AS InsurClmPlcyMgmtTransChrgAmt,
  tchargerate_pm AS InsurClmPlcyMgmtTransChrgRate,
  fundval_modified AS InsurClmFundHdrIsChgdManually
FROM icl_fund_hdr
LEFT OUTER JOIN I_Currency AS _Currency ON InsuranceClaimFundCurrency = _Currency.Currency  -- association [1..1]
;