I_InsurClmPaymentItemApp

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_InsurClmPaymentItemApp.
-- 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_InsurClmPaymentItemApp AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmPayt,
  InsurClmPaytItem,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmPaytDraftUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmPaytItemDraftUUID,
  InsurClmItemSubclm,
  InsurBnftType,
  InsurClmPaytAmt,
  InsurClmPaytRequestedAmount,
  _Payment.InsurClmPaymentCurrency AS InsurClmPaymentCurrency,
  InsurClmCoverageType,
  InsurClmPaytItemCategory,
  InsurClmPaytReasonGrp,
  InsurClmPaytReason,
  InsurClmPaytTaxCategory,
  InsurClmPaytTaxCode,
  InsurClmPaytAmtTaxCategory,
  InsurClmItem,
  InsurClmPaytValidFromDate,
  InsurClmPaytValidToDate,
  InsurClmChangedBy,
  InsurClmChangeTime,
  _Subclaim.InsurClmSubclmType AS InsurClmSubclmType,
  _Claim.InsurClmType AS InsurClmType,
  _Claim.InsurClmAuthznGrp AS InsurClmAuthznGrp
FROM I_InsurClmPaymentItem
LEFT OUTER JOIN I_InsurClmPaymentApp AS _PaymentApp ON InsuranceClaim = _PaymentApp.InsuranceClaim AND InsurClmSubclm = _PaymentApp.InsurClmSubclm AND InsurClmPayt = _PaymentApp.InsurClmPayt AND InsurClmPaytDraftUUID = _PaymentApp.InsurClmPaytDraftUUID  -- association [1]
LEFT OUTER JOIN I_InsurClmSubclaim AS _Subclaim ON InsuranceClaim = _Subclaim.InsuranceClaim AND InsurClmItemSubclm = _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_InsurClmBnftTypeTreeBnftType AS _BnftTypeTree ON InsurClmBenefitTypeTree = _BnftTypeTree.InsurClmBenefitTypeTree AND InsurClmBnftTypeTreeGeneration = _BnftTypeTree.InsurClmBnftTypeTreeGeneration AND InsurClmBnftTypeTreeVersion = _BnftTypeTree.InsurClmBnftTypeTreeVersion AND InsurBnftType = _BnftTypeTree.InsurBnftType  -- association [1]
LEFT OUTER JOIN I_InsurClmBenefitType AS _BenefitType ON InsurBnftType = _BenefitType.InsurBnftType  -- association [1]
;