R_INS_ClaimPaymentTP

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 R_INS_ClaimPaymentTP.
-- 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 R_INS_ClaimPaymentTP AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmPayt,
  InsurClmPaytCat,
  InsurClmPaymentType,
  InsurClmPaymentCurrency,
  InsurClmPaymentDatabaseStatus,
  InsurClmAssignUUID,
  _Payee.InsuranceClaimPayee AS InsuranceClaimPayee,
  _Payer.InsuranceClaimPayer AS InsuranceClaimPayer,
  _AdditionalPayee.InsurClmPaytAdditionalPayee AS InsurClmPaytAdditionalPayee,
  _CheckRecipient.InsurClmPaytCheckRecipient AS InsurClmPaytCheckRecipient,
  InsurClmPaytPostgDte,
  InsurClmPaytMethod,
  InsurClmPaytCheque,
  InsurClmBankID,
  InsurClmPaytDocRefInSubLedger,
  InsurClmPaytDueDate,
  InsurClmPaytHasAlreadyPaid,
  InsurClmPaytHasAddlPayee,
  InsurClmPaytAddrNmbrForChecks,
  InsurClmPaytCheckRcpntAddrNmbr,
  InsurClmPaytNote,
  InsurClmServicePeriodStartDate,
  InsurClmServicePeriodEndDate,
  InsurClmChangedBy,
  InsurClmChangeTime,
  InsurClmLineStatus,
  InsurClmCreatedBy,
  InsurClmCreatedDateTime,
  InsurClmPaymentApprovedByName,
  InsurClmPaymentApprovedDteTme,
  InsurClmPaymentTransferDteTme,
  InsurClmPaytDocumentDte,
  InsurClmPaytSubrogtnSalvgNmbr,
  InsurClmPaymentExchangeRate,
  InsuranceClaimInvoiceReference,
  InsurClmPaytClmNmbrRef,
  InsurClmPaymentSubclmRef,
  InsuranceClaimPaymentReference,
  InsuranceClaimPaidAmount,
  InsurClaimPaymentLiabilityRate,
  InsuranceClaimNegotiatedAmount,
  InsurClmSubrogtnOrRcvryLglSts,
  InsuranceClaimTaxRole,
  InsurClmIsReportablePayment,
  InsurClmIsWithholdingTax,
  InsurClmWithholdingTax,
  InsurClmIsManualWithholdingTax,
  InsurClmSalvageFundsRcvdDate,
  InsurClmIsSalvageEndEstimation,
  InsurClmRespOrgCat,
  InsurClmRespOrg,
  InsurClmItmGrpRejectionReason,
  InsurClmRefStatPaymentEntry,
  InsurClmMethodOfSettlement,
  InsurClmPaymentFrequencyPlan,
  InsClmRecrrgPaytEndDte,
  InsClmRecrrgPaytStrtDte,
  InsurClmTypeOfScheduledPayment,
  InsurClmMinimumNmbrOfInvoices,
  InsurClmDamagedObject,
  InsurClmIsMigratedPayment,
  InsurClmReceivableAmountCat,
  InsurClmRptvPayoutScenario,
  InsurClmIsRptvPaymentRecord,
  InsurClmPaytDeductiblesMethod,
  InsurClmCompnCalcDeductionAmt,
  InsurClmAltvPostgTgtVal,
  InsurClmGrossNetPayment,
  InsurClmPaytProcgState
FROM I_InsuranceClaimPayment_2
LEFT OUTER JOIN I_InsurClmPaytReqPayer AS _Payer ON InsuranceClaim = _Payer.InsuranceClaim AND InsurClmSubclm = _Payer.InsurClmSubclm AND InsurClmPayt = _Payer.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmPayee AS _Payee ON InsuranceClaim = _Payee.InsuranceClaim AND InsurClmSubclm = _Payee.InsurClmSubclm AND InsurClmPayt = _Payee.InsurClmPayt  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPaytAdditionalPayee AS _AdditionalPayee ON InsuranceClaim = _AdditionalPayee.InsuranceClaim AND InsurClmSubclm = _AdditionalPayee.InsurClmSubclm AND InsurClmPayt = _AdditionalPayee.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmPaytCheckRecipient AS _CheckRecipient ON InsuranceClaim = _CheckRecipient.InsuranceClaim AND InsurClmSubclm = _CheckRecipient.InsurClmSubclm AND InsurClmPayt = _CheckRecipient.InsurClmPayt  -- association [1]
LEFT OUTER JOIN R_INS_ClaimServicesTP AS _InsuranceClaim ON InsurClmActive = _InsuranceClaim.InsurClmActive AND InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN E_InsuranceClaimPayment AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmSubclm = _Extension.InsurClmSubclm AND InsurClmPayt = _Extension.InsurClmPayt  -- association [1..1]
LEFT OUTER JOIN R_INS_ClaimPaymentItemTP AS _PaymentItem ON /* condition not available in parsed metadata */  -- association [0..*]
;