I_InsuranceClaimPaymentItem_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_InsuranceClaimPaymentItem_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.

CREATE VIEW I_InsuranceClaimPaymentItem_2 AS
SELECT
  active AS InsurClmActive,
  cast(claim as icl_claim preserving type ) AS InsuranceClaim,
  cast(subclaim as icl_subclp preserving type ) AS InsurClmSubclm,
  cast(payment as icl_payment preserving type ) AS InsurClmPayt,
  cast(paymentitem as icl_paymentitem preserving type ) AS InsurClmPaytItem,
  itemsubcl AS InsurClmItemSubclm,
  cast(bentype as icl_bentype preserving type ) AS InsurBnftType,
  _Payment.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  pampaid AS InsurClmPaytAmt,
  cast(covtype as icl_covtype preserving type ) AS InsurClmCoverageType,
  cast(changedby as icl_changedby preserving type ) AS InsurClmChangedBy,
  cast(changetime as timestamp preserving type) AS InsurClmChangeTime,
  payitemcat AS InsurClmPaytItemCategory,
  cast(pymtype as icl_pymtype preserving type ) AS InsurClmPaytTaxCategory,
  paytypei AS InsurClmPaytItemPaymentType,
  cast(treasonset as icl_payreasonset preserving type ) AS InsurClmPaytReasonGrp,
  cast(treason as icl_payreason preserving type ) AS InsurClmPaytReason,
  gross_net AS InsurClmPaytAmtTaxCategory,
  txcod AS InsurClmPaytTaxCode,
  requested AS InsurClmPaytRequestedAmount,
  cast(item as icl_sclitem preserving type ) AS InsurClmItem,
  validfrom AS InsurClmPaytValidFromDate,
  validto AS InsurClmPaytValidToDate,
  deleted AS InsurClmLineStatus,
  taxcode_id AS InsurClmTaxCodeValue,
  postdatei AS InsuranceClaimPostingDate,
  refno AS InsurClmItemRefNumber,
  cast(payity as icl_payity preserving type ) AS InsuranceClaimPaymentItemType,
  repid AS InsurClmDistrPlnCoinsuranceKey,
  assign_guid AS InsurClmAssignUUID,
  cddocitem AS InsurClmItemNumberPaytPlanDoc,
  requested_orig AS InsurClmPaytOriglReqdAmount,
  dup_pampaid AS InsurClmPaytTotalAmount,
  country AS InsuranceClaimKeyOfTaxCountry,
  region AS InsuranceClaimTaxRegionKey,
  refpayitem AS InsurClmReferencePaymentItem,
  msatz AS InsurClmPaytItemTaxRate,
  ktosl AS InsurClmPaytItemTransactionKey,
  kschl AS InsurClmPaytItemConditionType,
  cast(txjcd as /gsins/txjcd preserving type ) AS InsurClmPaytTaxJurisdiction,
  txbsamt AS InsurClmPaytTaxBaseAmt
FROM iclpayi
LEFT OUTER JOIN I_InsuranceClaimPayment_2 AS _Payment ON InsurClmActive = _Payment.InsurClmActive AND InsuranceClaim = _Payment.InsuranceClaim AND InsurClmSubclm = _Payment.InsurClmSubclm AND InsurClmPayt = _Payment.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsuranceClaim_2 AS _InsuranceClaim ON InsurClmActive = _InsuranceClaim.InsurClmActive AND InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1]
;