I_InsuranceClaimItemGrouping

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_InsuranceClaimItemGrouping.
-- 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: ITEMGROUPING

CREATE VIEW I_InsuranceClaimItemGrouping AS
SELECT
  claim AS InsuranceClaim,
  subclaim AS InsurClmPaymentSubclaim,
  procurement AS InsuranceClaimProcurementID,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  cast( createtime as icl_createutc_fiori preserving type ) AS CreationDateTime,
  createdby AS CreatedByUser,
  pdoctype AS InsurClmItemGroupingBnftType,
  pdoccat AS InsurClmItemGroupingCategory,
  issuedate AS InsurClmItemGroupingIssueDate,
  receivedate AS InsurClmItmGroupingReceiveDate,
  datefrom AS InsurClmItmGroupingFromDate,
  timefrom AS InsurClmItemGroupingFromTime,
  dateto AS InsurClmItemGroupingToDate,
  timeto AS InsurClmItemGroupingToTime,
  issuedate_prescr AS InsurClmIssuePrescriptionDate,
  acquisitiondate AS InsurClmAcquisitionDate,
  currency AS InsurClmItemGroupingCurrency,
  amount1 AS InsurClmItemGroupingAmount,
  discountamount AS InsurClmItmGrpDiscountAmount,
  discountpercent AS InsurClmItmGrpDiscPercentAmt,
  accident AS InsurClmItemGroupingAccident,
  subrogation AS InsurClmItmGroupingSubrogation,
  duedate AS InsurClmItmGroupingDueDate,
  duedate_orig AS InsurClmItmGrpOriginDueDate,
  status AS InsurClmItemGroupingStatus,
  statreason AS InsurClmStatReason,
  reason AS InsurClmItemGroupingReason,
  cause AS InsurClmItemGroupingCause,
  pdoccattype AS InsurClmItemGrpCategoryType,
  datasource AS InsurClmItemGroupingDataOrigin,
  completiondate AS InsurClmItemGrpCompletionDate,
  fee AS InsurClmItmGroupingFeeAmount,
  matlabcost AS InsurClmItmGrpMatLabCostAmount,
  addcost AS InsurClmItmGrpAddCostsAmount,
  subsidypercent AS InsurClmItmGrpSubsidyPctAmt,
  subsidyamount AS InsurClmItmGrpSubsidyAmt,
  cancel AS InsurClmItmGrpStateIsCancelled,
  rejected AS InsurClmItmGrpStateIsRejected,
  insuspense AS InsurClmItmGrpStatIsInSuspense,
  inprocess AS InsurClmItmGrpStateIsInProcess,
  released AS InsurClmItmGrpStateIsReleased,
  xfinished AS InsurClmItmGrpStateIsFinish,
  ordered AS InsurClmItmGrpStatIsCommission,
  transferred AS InsurClmItmGrpStatIsReassigned,
  tobeapproved AS InsurClmItmGrpIsToBeApproved,
  xcliniccard AS InsurClmItmGrpIsClinicCard,
  xrequest AS InsurClmItmGrpIsReceivable,
  method AS InsurClmPaytMethod,
  addrnumber AS InsurClmPaytCheckRcpntAddrNmbr,
  bkid AS InsurClmBankID,
  assign_guid AS InsurClmAssignUUID,
  externalref AS InsClmBndlRefToCollvInvcNmbr,
  extdocument AS InsurClmExtDocumentNumber,
  extcaseno AS InsurClmItemGroupingHospital,
  extfileno AS InsurClmItemGroupingExtDoc,
  proc_ref AS InsurClmItemGroupingReference,
  owncontrib AS InsurClmItmGroupingCoPayPct,
  subcl_orig AS InsurClmItmGroupingOrgSubclm,
  proc_orig AS InsurClmItmGroupingOriginalClm,
  setorderdate AS InsurClmItmGroupingSetOrderDte,
  cast (valperunit as abap.dec( 24, 12 )) AS InsurClmItmGrpCatalogItemValue,
  cast (sentutc as tzntstmps preserving type) AS InsurClmItmGrpSentDateTime,
  sent_by_dme AS InsurClmItmGrpIsSentExt,
  receipt_by_dme AS InsurClmItmGrpIsReceivedExt,
  reasonrej AS InsurClmItmGrpRejectionReason,
  compper_datefrom AS InsurClmItmGrpCompareFromDate,
  compper_dateto AS InsurClmItmGrpComparisonToDate,
  payout_scenario AS InsurClmItmGrpPayoutScenario
FROM iclprocure
LEFT OUTER JOIN I_InsuranceClaim AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
;