I_InsurClmItem_2

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_InsurClmItem_2.
-- 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: I_INSURCLMITEM2

CREATE VIEW I_InsurClmItem_2 AS
SELECT
  active AS InsurClmActive,
  claim AS InsuranceClaim,
  subclaim AS InsurClmSubclm,
  item AS InsurClmItem,
  evaluation AS InsurClmItemEvaluation,
  cast( changetime as icl_achangetime_fiori preserving type ) AS LastChangeDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  itemcat AS InsurClmItemCat,
  itemtype AS InsurClmItemType,
  covtype AS InsurClmCoverageType,
  bentype AS InsurBnftType,
  status AS InsurClmItemStatus,
  rejreason AS InsurClmItemRjcnRsn,
  description AS InsurClmItemDescription,
  evalbase AS InsurClmItemEvalBase,
  itemuse AS InsuranceClaimItemUsageType,
  rcovtype AS InsurClmBenefitCoverageType,
  xwaitperiod AS InsurClmIsWaitPerdIgnrd,
  coverage AS InsuranceClaimItemCoverage,
  scposid_int AS InsurClmItemBenefitCatalogUUID,
  servcat AS InsurClmItemIdOfServiceCatalog,
  scposid_ext AS InsurClmItmBnftCatalogItemID,
  modified AS InsurClmIsModified,
  procured AS InsurClmIsProcured,
  calculated AS InsurClmIsCalculated,
  daily AS InsurClmDailyBenefitsValue,
  weekly AS InsurClmWeeklyBenefitsValue,
  monthly AS InsurClmMonthlyBenefitsValue,
  total AS InsurClmTotalBenefitsValue,
  validfrom AS InsurClmItmValidFromDate,
  validto AS InsuranceClaimItemValidToDate,
  startdate AS InsuranceClaimStartDate,
  enddate AS InsuranceClaimEndDate,
  dnumber AS InsurClmItemEvaluationValue,
  evquantity AS InsurClmItemEvalQuantity,
  evquanunit AS InsurClmItemEvalQuantityUnit,
  evamtperunit AS InsurClmItemEvalPerUnitAmt,
  evamount AS InsurClmItemEvalAmount,
  evcurr AS InsurClmItemEvalCurrency,
  evalcat AS InsurClmEvaluationCategory,
  factor AS InsurClmItemEvalFactor,
  acv AS InsurClmItmEvalActlCshValAmt,
  acvpercent AS InsurClmItmEvalActlCshValPct,
  calcexpression AS InsurClmBRFCalcExpression,
  txcod AS InsurClmItemTaxCode,
  perday AS InsuranceClaimItemPerDayAmount,
  discountpercent AS InsurClmItmGrpDiscPercentAmt,
  xdiscountused AS InsurClmIsDiscountUsed,
  xdiscountpercent AS InsurClmIsDiscountPercent,
  xdisc_2b_applied AS InsurClmIsDiscountToBeApplied,
  grosnet AS InsurClmIsNet,
  subclref AS InsurClmItemSubclmRef,
  item_ref AS InsurClmItemRef,
  procurement AS InsuranceClaimProcurementID,
  damagedobj AS InsurClmDamagedObject,
  assign_guid AS InsurClmAssignUUID,
  benvalue AS InsurClmBnftValAmt,
  xcreatedman AS InsurClmManuallyCreatedItem,
  creationreason AS InsuranceClaimCreationReason,
  xgenledgertp AS InsurClmIsInternalClearing,
  periodicity AS InsuranceClaimPeriodicity,
  addduedate AS InsurClmAddlPaytDueDateVal,
  refno AS InsurClmItemRefNumber,
  pdref AS InsurClmPurgDocReference,
  pdpos AS InsurClmPurgDocItemReference,
  ref_loccat AS InsurClmRefLocCat,
  ptype AS InsurClmTransactionType,
  xgeneros AS InsurClmIsGoodwillPayment,
  additional_item AS InsurClmAdditionalItem,
  addit_item_sum AS InsurClmIsAdditionalTotal,
  remun_type AS InsurClmRemunerationCategory,
  totalvalueannual AS InsurClaimTotalAnnualAmount,
  payrollvar AS InsuranceClaimPayrollVariant,
  disbursetype AS InsurClmDisbursementCategory,
  prelim_subcl AS InsurClmPreliminarySubclaim
FROM iclitem AS ClaimItem
;