I_InsurClmSrvcsPaymentBase

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_InsurClmSrvcsPaymentBase.
-- 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_InsurClmSrvcsPaymentBase AS
SELECT
  I_InsurClmPayment.InsuranceClaim AS InsuranceClaim,
  I_InsurClmPayment.InsurClmSubclm AS InsurClmSubclm,
  I_InsurClmPayment.InsurClmPayt AS InsurClmPayt,
  I_InsurClmPayment.InsurClmPaytCat AS InsurClmPaytCat,
  I_InsurClmPayment.InsurClmPaymentType AS InsurClmPaymentType,
  I_InsurClmPayment.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  I_InsurClmPayment.InsurClmPaymentDatabaseStatus AS InsurClmPaymentDatabaseStatus,
  _Payee.InsuranceClaimPayee AS InsuranceClaimPayee,
  _Payer.InsuranceClaimPayer AS InsuranceClaimPayer,
  _AdditionalPayee.InsurClmPaytAdditionalPayee AS InsurClmPaytAdditionalPayee,
  _CheckRecipient.InsurClmPaytCheckRecipient AS InsurClmPaytCheckRecipient,
  I_InsurClmPayment.InsurClmAssignUUID AS InsurClmAssignUUID,
  I_InsurClmPayment.InsurClmPaytPostgDte AS InsurClmPaytPostgDte,
  I_InsurClmPayment.InsurClmPaytMethod AS InsurClmPaytMethod,
  I_InsurClmPayment.InsurClmPaytCheque AS InsurClmPaytCheque,
  I_InsurClmPayment.InsurClmBankID AS InsurClmBankID,
  I_InsurClmPayment.InsurClmPaytDocRefInSubLedger AS InsurClmPaytDocRefInSubLedger,
  I_InsurClmPayment.InsurClmPaytDueDate AS InsurClmPaytDueDate,
  I_InsurClmPayment.InsurClmPaytHasAlreadyPaid AS InsurClmPaytHasAlreadyPaid,
  I_InsurClmPayment.InsurClmPaytHasAddlPayee AS InsurClmPaytHasAddlPayee,
  I_InsurClmPayment.InsurClmPaytAddrNmbrForChecks AS InsurClmPaytAddrNmbrForChecks,
  I_InsurClmPayment.InsurClmPaytCheckRcpntAddrNmbr AS InsurClmPaytCheckRcpntAddrNmbr,
  I_InsurClmPayment.InsurClmPaytNote AS InsurClmPaytNote,
  I_InsurClmPayment.InsurClmServicePeriodStartDate AS InsurClmServicePeriodStartDate,
  I_InsurClmPayment.InsurClmServicePeriodEndDate AS InsurClmServicePeriodEndDate,
  I_InsurClmPayment.InsurClmChangedBy AS InsurClmChangedBy,
  I_InsurClmPayment.InsurClmChangeTime AS InsurClmChangeTime,
  cast('' as bu_aktyp ) AS InsuranceClaimActivityCategory
FROM I_InsurClmPayment
LEFT OUTER JOIN I_InsurClmPaytReqPayer AS _Payer ON I_InsurClmPayment.InsuranceClaim = _Payer.InsuranceClaim AND I_InsurClmPayment.InsurClmSubclm = _Payer.InsurClmSubclm AND I_InsurClmPayment.InsurClmPayt = _Payer.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmPayee AS _Payee ON I_InsurClmPayment.InsuranceClaim = _Payee.InsuranceClaim AND I_InsurClmPayment.InsurClmSubclm = _Payee.InsurClmSubclm AND I_InsurClmPayment.InsurClmPayt = _Payee.InsurClmPayt  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPaytAdditionalPayee AS _AdditionalPayee ON I_InsurClmPayment.InsuranceClaim = _AdditionalPayee.InsuranceClaim AND I_InsurClmPayment.InsurClmSubclm = _AdditionalPayee.InsurClmSubclm AND I_InsurClmPayment.InsurClmPayt = _AdditionalPayee.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmPaytCheckRecipient AS _CheckRecipient ON I_InsurClmPayment.InsuranceClaim = _CheckRecipient.InsuranceClaim AND I_InsurClmPayment.InsurClmSubclm = _CheckRecipient.InsurClmSubclm AND I_InsurClmPayment.InsurClmPayt = _CheckRecipient.InsurClmPayt  -- association [1]
LEFT OUTER JOIN R_InsurClmSrvcsInsurClaimTP AS _InsuranceClaim ON 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]
;