I_InsurClmPaymentTP

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_InsurClmPaymentTP.
-- 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_InsurClmPaymentTP AS
SELECT
  I_InsurClmPaymentApp.InsuranceClaim AS InsuranceClaim,
  I_InsurClmPaymentApp.InsurClmSubclm AS InsurClmSubclm,
  I_InsurClmPaymentApp.InsurClmPayt AS InsurClmPayt,
  InsurClmPaytDraftUUID,
  I_InsurClmPaymentApp.InsuranceClaimForEdit AS InsuranceClaimForEdit,
  I_InsurClmPaymentApp.InsurClmSubclmForEdit AS InsurClmSubclmForEdit,
  I_InsurClmPaymentApp.InsurClmPaytIsForSubclaim AS InsurClmPaytIsForSubclaim,
  I_InsurClmPaymentApp.InsurClmPaytSubobject AS InsurClmPaytSubobject,
  I_InsurClmPaymentApp.InsurClmPaymentIsParked AS InsurClmPaymentIsParked,
  I_InsurClmPaymentApp.InsurClmPaytIsFinalPayment AS InsurClmPaytIsFinalPayment,
  I_InsurClmPaymentApp.InsurClmPaytCat AS InsurClmPaytCat,
  _PaymentCat._Text[1:Language = $session.system_language].InsurClmPaytCatName AS InsurClmPaytCatName,
  I_InsurClmPaymentApp.InsurClmPaymentType AS InsurClmPaymentType,
  I_InsurClmPaymentApp.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  I_InsurClmPaymentApp.InsurClmPaymentCurrency AS InsurClmDisplayCurrency,
  I_InsurClmPaymentApp.InsurClmPaytTotalAmount AS InsurClmPaytTotalAmount,
  I_InsurClmPaymentApp.InsurClmPaytRequestedAmount AS InsurClmPaytRequestedAmount,
  I_InsurClmPaymentApp.InsurClmPaymentDatabaseStatus AS InsurClmPaymentDatabaseStatus,
  _PaymentStatus._Text[1:Language = $session.system_language].InsurClmPaytStatusName AS InsurClmPaytStatusName,
  I_InsurClmPaymentApp.InsurClmAssignUUID AS InsurClmAssignUUID,
  I_InsurClmPaymentApp.InsurClmPaytPostgDte AS InsurClmPaytPostgDte,
  I_InsurClmPaymentApp.InsurClmPaytMethod AS InsurClmPaytMethod,
  I_InsurClmPaymentApp.InsurClmPaytCheque AS InsurClmPaytCheque,
  I_InsurClmPaymentApp.InsurClmBankID AS InsurClmBankID,
  I_InsurClmPaymentApp.InsurClmPaytDocRefInSubLedger AS InsurClmPaytDocRefInSubLedger,
  I_InsurClmPaymentApp.InsurClmPaytDueDate AS InsurClmPaytDueDate,
  I_InsurClmPaymentApp.InsurClmPaytNote AS InsurClmPaytNote,
  I_InsurClmPaymentApp.InsurClmPaytHasAlreadyPaid AS InsurClmPaytHasAlreadyPaid,
  I_InsurClmPaymentApp.InsurClmPaytHasAddlPayee AS InsurClmPaytHasAddlPayee,
  I_InsurClmPaymentApp.InsurClmPaytAddrNmbrForChecks AS InsurClmPaytAddrNmbrForChecks,
  I_InsurClmPaymentApp.InsurClmPaytCheckRcpntAddrNmbr AS InsurClmPaytCheckRcpntAddrNmbr,
  I_InsurClmPaymentApp.InsurClmServicePeriodStartDate AS InsurClmServicePeriodStartDate,
  I_InsurClmPaymentApp.InsurClmServicePeriodEndDate AS InsurClmServicePeriodEndDate,
  I_InsurClmPaymentApp.InsurClmChangeTime AS InsurClmChangeTime,
  I_InsurClmPaymentApp.CompanyCode AS CompanyCode,
  _CompanyCode.Country AS Country,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_InsurClmPaymentApp.InsuranceClaimPayee AS InsuranceClaimPayee,
  I_InsurClmPaymentApp.InsuranceClaimPayer AS InsuranceClaimPayer,
  I_InsurClmPaymentApp.InsurClmPaytAdditionalPayee AS InsurClmPaytAdditionalPayee,
  I_InsurClmPaymentApp.InsurClmPaytCheckRecipient AS InsurClmPaytCheckRecipient,
  I_InsurClmPaymentApp.InsurClmJurisdictionCountry AS InsurClmJurisdictionCountry,
  I_InsurClmPaymentApp.InsurLineOfBus AS InsurLineOfBus,
  cast('' as xbkkt preserving type ) AS BankDetailsOfBPAreRequired,
  cast('' as xstra preserving type ) AS AddressDetailsAreRequired,
  cast('' as xschk_042z preserving type ) AS ChequeIsCreatedWithPaytMeth,
  cast('' as icl_phcodi ) AS InsurClmPaytProcessingCat,
  cast('' as boole_d preserving type ) AS InsurClmPaytCatIsImplmtdInRap,
  cast('X' as boole_d preserving type ) AS InsuranceClaimIsNotDraft,
  cast('X' as icl_xuidisp preserving type ) AS InsurClmPaytProcgCatIsDspdOnUI,
  I_InsurClmPaymentApp.InsurClmType AS InsurClmType,
  I_InsurClmPaymentApp.InsurClmTypeGeneration AS InsurClmTypeGeneration,
  I_InsurClmPaymentApp.InsurClmTypeVers AS InsurClmTypeVers,
  I_InsurClmPaymentApp.InsurClmAuthznGrp AS InsurClmAuthznGrp,
  cast ('/sap/bc/ui5_ui5/sap/INS_MNTNPAYTS1/images/MaintainPayments.jpg' as mr_url) AS InsurClmImageURL,
  cast('' as icl_clmitmtopaytnavgncntxtkey ) AS InsurClmItmToPaytNavgnCntxtKey
FROM I_InsurClmPaymentApp
LEFT OUTER JOIN I_InsurClmPaymentStatus AS _PaymentStatus ON InsurClmPaymentDatabaseStatus = _PaymentStatus.InsurClmPaymentDatabaseStatus  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _Payee ON InsuranceClaimPayee = _Payee.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _Payer ON InsuranceClaimPayer = _Payer.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _AdditionalPayee ON InsurClmPaytAdditionalPayee = _AdditionalPayee.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _CheckRecipient ON InsurClmPaytCheckRecipient = _CheckRecipient.BusinessPartner  -- association [1]
LEFT OUTER JOIN C_InsurClmPaytCompnCalcHdr AS _PaytCompnCalcHdr ON I_InsurClmPaymentApp.InsuranceClaim = _PaytCompnCalcHdr.InsuranceClaim AND I_InsurClmPaymentApp.InsurClmSubclm = _PaytCompnCalcHdr.InsurClmSubclm AND I_InsurClmPaymentApp.InsurClmPayt = _PaytCompnCalcHdr.InsurClmPayt AND I_InsurClmPaymentApp.InsurClmPaytDraftUUID = _PaytCompnCalcHdr.InsurClmPaytDraftUUID  -- association [0..*]
LEFT OUTER JOIN C_InsurClmPaytCompnCalcResult AS _PaytCompnCalcItems ON I_InsurClmPaymentApp.InsuranceClaim = _PaytCompnCalcItems.InsuranceClaim AND I_InsurClmPaymentApp.InsurClmSubclm = _PaytCompnCalcItems.InsurClmSubclm AND I_InsurClmPaymentApp.InsurClmPayt = _PaytCompnCalcItems.InsurClmPayt AND I_InsurClmPaymentApp.InsurClmPaytDraftUUID = _PaytCompnCalcItems.InsurClmPaytDraftUUID  -- association [0..*]
LEFT OUTER JOIN I_InsurClmPaymentCategory AS _PaymentCat ON InsurClmPaytCat = _PaymentCat.InsurClmPaytCat  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentMethod AS _PaytMethod ON InsurClmPaytMethod = _PaytMethod.CAPaymentMethod AND country = _PaytMethod.Country  -- association [1]
LEFT OUTER JOIN I_Currency AS _Currency ON InsurClmPaymentCurrency = _Currency.Currency  -- association [1]
LEFT OUTER JOIN I_InsurClmPaymentItemTP AS _PaymentItems ON /* condition not available in parsed metadata */  -- association [0..*]
;