I_InsurClmBnftSplitItemBasic

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_InsurClmBnftSplitItemBasic.
-- 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_InsurClmBnftSplitItemBasic AS
SELECT
  active AS InsurClmActive,
  claim AS InsuranceClaim,
  bensplit_itm_id AS InsurClmBnftSpltItmUUID,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  bensplit_itm_num AS InsurClmBnftSplitItemNumber,
  bensplit_hdr_id AS InsurClmBnftSpltItmHdrUUID,
  prio AS InsurClmPrioOfBnftSpltValue,
  sharepct AS InsurClmCalcBaseShrPct,
  grossamount AS InsurClmBnftSpltItmGrossAmt,
  netamount AS InsurClmBnftSpltItmNetAmt,
  benamountfixed AS InsurClmBnftSpltAmtFxdValue,
  amtdone AS InsurClmBnftSpltItmPaidAmt,
  calcbase AS InsurClmBnftSpltItmCalcBaseAmt,
  benoffset AS InsurClmBnftSpltOffsetKey,
  duedate AS InsurClmBnftSpltNetPaytDueDate,
  bkid AS InsurClmBankDetailsId,
  method AS InsurClmPaytMethod,
  addrnumber AS InsurClmPaytAddrNmbrForChecks,
  cast ( addrnumber as icl_validtoid_api preserving type ) AS InsurClmBnftSpltItmValidToID,
  altposttarget AS InsurClmAltvPostgTgtVal,
  note AS InsurClmPaytNote,
  splitcurr AS InsurClmBnftSplitCurrency,
  validto AS InsurClmBnftSpltItmValidToDate,
  netamoutofdate AS InsurClmNetAmtValidValue,
  subclaim AS InsurClmBnftSpltItmSubclaim,
  offsetsubclaim AS InsurClmIsOffstAmtAssgdSubclm
FROM icl_bensplit_itm
LEFT OUTER JOIN I_Currency AS _Currency ON InsurClmBnftSplitCurrency = _Currency.Currency  -- association [1..1]
;