I_InsuranceClaimPayment_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_InsuranceClaimPayment_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_InsuranceClaimPayment_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,
  paycat AS InsurClmPaytCat,
  paytype AS InsurClmPaymentType,
  cast(curr as icl_paymentcur preserving type ) AS InsurClmPaymentCurrency,
  status AS InsurClmPaymentDatabaseStatus,
  assign_guid AS InsurClmAssignUUID,
  postdate AS InsurClmPaytPostgDte,
  cast(method as icl_payment01 preserving type ) AS InsurClmPaytMethod,
  checknumber AS InsurClmPaytCheque,
  cast(bkid as icl_bkid preserving type ) AS InsurClmBankID,
  documentref AS InsurClmPaytDocRefInSubLedger,
  duedate AS InsurClmPaytDueDate,
  xalreadypaid AS InsurClmPaytHasAlreadyPaid,
  xpayee AS InsurClmPaytHasAddlPayee,
  cast(addrnumber as icl_addrnum preserving type ) AS InsurClmPaytAddrNmbrForChecks,
  crecaddr AS InsurClmPaytCheckRcpntAddrNmbr,
  note AS InsurClmPaytNote,
  serv_from AS InsurClmServicePeriodStartDate,
  serv_to AS InsurClmServicePeriodEndDate,
  cast(changedby as icl_changedby preserving type ) AS InsurClmChangedBy,
  cast(changetime as icl_achangetime_fiori preserving type ) AS InsurClmChangeTime,
  deleted AS InsurClmLineStatus,
  cast(createdby as icl_createdby preserving type ) AS InsurClmCreatedBy,
  cast (createtime as icl_achangetime_fiori preserving type ) AS InsurClmCreatedDateTime,
  cast(approvedby as icl_payment13 preserving type ) AS InsurClmPaymentApprovedByName,
  cast (approvedtime as icl_achangetime_fiori preserving type ) AS InsurClmPaymentApprovedDteTme,
  cast (transfertime as icl_achangetime_fiori preserving type ) AS InsurClmPaymentTransferDteTme,
  cast (docdate as icl_date_from preserving type ) AS InsurClmPaytDocumentDte,
  subsal AS InsurClmPaytSubrogtnSalvgNmbr,
  cast (exchrate as fis_exchange_rate preserving type ) AS InsurClmPaymentExchangeRate,
  invoiceref AS InsuranceClaimInvoiceReference,
  cast (refclaim as char17 preserving type ) AS InsurClmPaytClmNmbrRef,
  refsubclaim AS InsurClmPaymentSubclmRef,
  refpayment AS InsuranceClaimPaymentReference,
  amtdone AS InsuranceClaimPaidAmount,
  liabrate AS InsurClaimPaymentLiabilityRate,
  amtneg AS InsuranceClaimNegotiatedAmount,
  subrostatus AS InsurClmSubrogtnOrRcvryLglSts,
  taxrole AS InsuranceClaimTaxRole,
  tax_rpt AS InsurClmIsReportablePayment,
  xtaxrptct AS InsurClmIsWithholdingTax,
  mtaxrptct AS InsurClmWithholdingTax,
  ovrd_taxrptct AS InsurClmIsManualWithholdingTax,
  cast (fundsrecdt as icl_date_from preserving type ) AS InsurClmSalvageFundsRcvdDate,
  xsalvestend AS InsurClmIsSalvageEndEstimation,
  ownertype_grp AS InsurClmRespOrgCat,
  owner_grp AS InsurClmRespOrg,
  cast(reasonrej as icl_reasonrej preserving type ) AS InsurClmItmGrpRejectionReason,
  refextsdoc AS InsurClmRefStatPaymentEntry,
  mos AS InsurClmMethodOfSettlement,
  cast(cl_payfreqplan as icl_payfreqplan preserving type ) AS InsurClmPaymentFrequencyPlan,
  pmtto AS InsClmRecrrgPaytEndDte,
  pmtfr AS InsClmRecrrgPaytStrtDte,
  cast(schedtype as icl_schedule_type preserving type ) AS InsurClmTypeOfScheduledPayment,
  nrofinvreq AS InsurClmMinimumNmbrOfInvoices,
  damagedobj AS InsurClmDamagedObject,
  migration AS InsurClmIsMigratedPayment,
  reqevalcat AS InsurClmReceivableAmountCat,
  payout_scenario AS InsurClmRptvPayoutScenario,
  xreppay AS InsurClmIsRptvPaymentRecord,
  hdeduct AS InsurClmPaytDeductiblesMethod,
  deduction AS InsurClmCompnCalcDeductionAmt,
  altposttarget AS InsurClmAltvPostgTgtVal,
  gross_net_payment AS InsurClmGrossNetPayment,
  hcm_payment_state AS InsurClmPaytProcgState
FROM iclpay
LEFT OUTER JOIN I_InsuranceClaim_2 AS _InsuranceClaim ON InsurClmActive = _InsuranceClaim.InsurClmActive AND InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1]
;