I_InsurClmPaymentApp

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_InsurClmPaymentApp.
-- 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_InsurClmPaymentApp AS
SELECT
  I_InsurClmFNOLPayment.InsuranceClaim AS InsuranceClaim,
  I_InsurClmFNOLPayment.InsurClmSubclm AS InsurClmSubclm,
  I_InsurClmFNOLPayment.InsurClmPayt AS InsurClmPayt,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmPaytDraftUUID,
  I_InsurClmFNOLPayment.InsuranceClaim AS InsuranceClaimForEdit,
  I_InsurClmFNOLPayment.InsurClmSubclm AS InsurClmSubclmForEdit,
  I_InsurClmFNOLPayment._CompanyCode.Country AS Country,
  I_InsurClmFNOLPayment.InsurClmPaytCat AS InsurClmPaytCat,
  I_InsurClmFNOLPayment.InsurClmPaymentType AS InsurClmPaymentType,
  I_InsurClmFNOLPayment.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  PaymentSum.InsurClmPaytTotalAmount AS InsurClmPaytTotalAmount,
  PaymentSum.InsurClmPaytRequestedAmount AS InsurClmPaytRequestedAmount,
  I_InsurClmFNOLPayment.InsurClmPaymentDatabaseStatus AS InsurClmPaymentDatabaseStatus,
  I_InsurClmFNOLPayment.InsurClmAssignUUID AS InsurClmAssignUUID,
  I_InsurClmFNOLPayment.InsurClmPaytPostgDte AS InsurClmPaytPostgDte,
  I_InsurClmFNOLPayment.InsurClmPaytMethod AS InsurClmPaytMethod,
  I_InsurClmFNOLPayment.InsurClmPaytCheque AS InsurClmPaytCheque,
  I_InsurClmFNOLPayment.InsurClmBankID AS InsurClmBankID,
  I_InsurClmFNOLPayment.InsurClmPaytDocRefInSubLedger AS InsurClmPaytDocRefInSubLedger,
  I_InsurClmFNOLPayment.InsurClmPaytDueDate AS InsurClmPaytDueDate,
  I_InsurClmFNOLPayment.InsurClmPaytNote AS InsurClmPaytNote,
  I_InsurClmFNOLPayment.InsurClmPaytHasAlreadyPaid AS InsurClmPaytHasAlreadyPaid,
  I_InsurClmFNOLPayment.InsurClmPaytHasAddlPayee AS InsurClmPaytHasAddlPayee,
  I_InsurClmFNOLPayment.InsurClmPaytAddrNmbrForChecks AS InsurClmPaytAddrNmbrForChecks,
  I_InsurClmFNOLPayment.InsurClmPaytCheckRcpntAddrNmbr AS InsurClmPaytCheckRcpntAddrNmbr,
  I_InsurClmFNOLPayment.InsurClmServicePeriodStartDate AS InsurClmServicePeriodStartDate,
  I_InsurClmFNOLPayment.InsurClmServicePeriodEndDate AS InsurClmServicePeriodEndDate,
  I_InsurClmFNOLPayment.InsurClmChangeTime AS InsurClmChangeTime,
  _Payee.InsuranceClaimPayee AS InsuranceClaimPayee,
  _Payer.InsuranceClaimPayer AS InsuranceClaimPayer,
  _AdditionalPayee.InsurClmPaytAdditionalPayee AS InsurClmPaytAdditionalPayee,
  _CheckRecipient.InsurClmPaytCheckRecipient AS InsurClmPaytCheckRecipient,
  _Subclaim.InsurClmSubclmType AS InsurClmSubclmType,
  I_InsurClmFNOLPayment._Claim.InsurClmJurisdictionCountry AS InsurClmJurisdictionCountry,
  I_InsurClmFNOLPayment._Claim._PolicySnapshot.InsurLineOfBus AS InsurLineOfBus,
  I_InsurClmFNOLPayment._Claim.InsurClmType AS InsurClmType,
  I_InsurClmFNOLPayment._Claim.InsurClmTypeGeneration AS InsurClmTypeGeneration,
  I_InsurClmFNOLPayment._Claim.InsurClmTypeVers AS InsurClmTypeVers,
  I_InsurClmFNOLPayment._Claim.InsurClmAuthznGrp AS InsurClmAuthznGrp,
  I_InsurClmFNOLPayment.CompanyCode AS CompanyCode,
  I_InsurClmFNOLPayment._CompanyCode AS _CompanyCode
FROM I_InsurClmFNOLPayment
LEFT OUTER JOIN I_InsurClmPayee AS _Payee ON I_InsurClmFNOLPayment.InsuranceClaim = _Payee.InsuranceClaim AND I_InsurClmFNOLPayment.InsurClmSubclm = _Payee.InsurClmSubclm AND I_InsurClmFNOLPayment.InsurClmPayt = _Payee.InsurClmPayt  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPaytAdditionalPayee AS _AdditionalPayee ON I_InsurClmFNOLPayment.InsuranceClaim = _AdditionalPayee.InsuranceClaim AND I_InsurClmFNOLPayment.InsurClmSubclm = _AdditionalPayee.InsurClmSubclm AND I_InsurClmFNOLPayment.InsurClmPayt = _AdditionalPayee.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmPaytCheckRecipient AS _CheckRecipient ON I_InsurClmFNOLPayment.InsuranceClaim = _CheckRecipient.InsuranceClaim AND I_InsurClmFNOLPayment.InsurClmSubclm = _CheckRecipient.InsurClmSubclm AND I_InsurClmFNOLPayment.InsurClmPayt = _CheckRecipient.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmPaytReqPayer AS _Payer ON I_InsurClmFNOLPayment.InsuranceClaim = _Payer.InsuranceClaim AND I_InsurClmFNOLPayment.InsurClmSubclm = _Payer.InsurClmSubclm AND I_InsurClmFNOLPayment.InsurClmPayt = _Payer.InsurClmPayt  -- association [1]
LEFT OUTER JOIN I_InsurClmSubclaim AS _Subclaim ON InsuranceClaim = _Subclaim.InsuranceClaim AND InsurClmSubclm = _Subclaim.InsurClmSubclm  -- association [1]
LEFT OUTER JOIN I_InsurClmSubclaimTypeText AS _SubclaimTypeText ON insurclmsubclmtype = _SubclaimTypeText.InsurClmSubclmType AND _SubclaimTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InsurIntClmTypeVersion AS _ClmTypeVersion ON insurclmtype = _ClmTypeVersion.InsurClmType AND insurclmtypegeneration = _ClmTypeVersion.InsurClmTypeGeneration AND insurclmtypevers = _ClmTypeVersion.InsurClmTypeVers  -- association [0..1]
;