I_InsurClmItemTP

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_InsurClmItemTP.
-- 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_InsurClmItemTP AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmItem,
  InsurClmItemEvaluation,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmItemUUID,
  InsuranceClaim AS InsuranceClaimForEdit,
  InsurClmSubclm AS InsurClmSubclmForEdit,
  I_InsurClmItemApp.LastChangeDateTime AS LastChangeDateTime,
  I_InsurClmItemApp.InsurClmItemCat AS InsurClmItemCat,
  I_InsurClmItemApp.InsurClmItemType AS InsurClmItemType,
  I_InsurClmItemApp.InsurClmCoverageType AS InsurClmCoverageType,
  I_InsurClmItemApp.InsurBnftType AS InsurBnftType,
  I_InsurClmItemApp.InsurClmBenefitTypeTree AS InsurClmBenefitTypeTree,
  I_InsurClmItemApp.InsurClmBnftTypeTreeGeneration AS InsurClmBnftTypeTreeGeneration,
  I_InsurClmItemApp.InsurClmBnftTypeTreeVersion AS InsurClmBnftTypeTreeVersion,
  I_InsurClmItemApp.InsurClmItemStatus AS InsurClmItemStatus,
  I_InsurClmItemApp.InsurClmItemRjcnRsn AS InsurClmItemRjcnRsn,
  I_InsurClmItemApp.InsurClmItemDescription AS InsurClmItemDescription,
  I_InsurClmItemApp.InsurClmItemEvalBase AS InsurClmItemEvalBase,
  I_InsurClmItemApp.InsurClmItemEvalQuantity AS InsurClmItemEvalQuantity,
  I_InsurClmItemApp.InsurClmItemEvalQuantityUnit AS InsurClmItemEvalQuantityUnit,
  I_InsurClmItemApp.InsurClmItemEvalPerUnitAmt AS InsurClmItemEvalPerUnitAmt,
  I_InsurClmItemApp.InsurClmItemEvalAmount AS InsurClmItemEvalAmount,
  I_InsurClmItemApp.InsurClmItemEvalCurrency AS InsurClmItemEvalCurrency,
  I_InsurClmItemApp.InsurClmItemEvalFactor AS InsurClmItemEvalFactor,
  I_InsurClmItemApp.InsurClmItmEvalActlCshValAmt AS InsurClmItmEvalActlCshValAmt,
  I_InsurClmItemApp.InsurClmItmEvalActlCshValPct AS InsurClmItmEvalActlCshValPct,
  I_InsurClmItemApp.InsurClmBRFCalcExpression AS InsurClmBRFCalcExpression,
  I_InsurClmItemApp.InsurClmItemTaxCode AS InsurClmItemTaxCode,
  I_InsurClmItemApp.InsurClmItemSubclmRef AS InsurClmItemSubclmRef,
  I_InsurClmItemApp.InsurClmItemRef AS InsurClmItemRef,
  I_InsurClmItemApp.InsurClmDamagedObject AS InsurClmDamagedObject,
  I_InsurClmItemApp.InsurClmItemEvalDate AS InsurClmItemEvalDate,
  I_InsurClmItemApp.InsurClmItemLiabilityRate AS InsurClmItemLiabilityRate,
  I_InsurClmItemApp.InsurClmItemClmdAmount AS InsurClmItemClmdAmount,
  InsurClmItemHasAlreadyPaidOut,
  I_InsurClmItemApp.CompanyCode AS CompanyCode,
  cast('' as icl_bentype17 preserving type ) AS BnftTypeIsSelectForReceivables,
  _CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  InsurClmItemEvalCurrency AS InsurClmDisplayCurrency,
  I_InsurClmItemApp.InsurClmType AS InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmSubclmType,
  I_InsurClmItemApp.InsurBnftType AS InsurClmBenefitType,
  I_InsurClmItemApp._BenefitType AS _BenefitType,
  I_InsurClmItemApp._BenefitTypeTree AS _BenefitTypeTree,
  I_InsurClmItemApp._Claim AS _Claim,
  I_InsurClmItemApp._CompanyCode AS _CompanyCode,
  _CompanyCode.Country AS Country,
  I_InsurClmItemApp._SubClaim AS _SubClaim,
  concat_with_space(I_InsurClmItemApp.InsurBnftType, _BenefitType._BenefitTypeText.InsurBnftTypeName, 1) AS InsurClmBnftTypeCodeName,
  cast ('/sap/bc/ui5_ui5/sap/INS_MNTNCLITMS1/images/ClaimItem.jpg' as mr_url) AS InsurClmImageURL
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON InsurClmItemTaxCode = _TaxCode.TaxCode AND TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_InsurClmItemRjcnRsn AS _RejectionReason ON InsurClmItemRjcnRsn = _RejectionReason.InsurClmItemRjcnRsn  -- association [0..1]
LEFT OUTER JOIN I_InsurClmEvaluatorType AS _EvaluatorType ON InsurClmItemEvalBase = _EvaluatorType.InsurClmItemEvalBase  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON InsurClmItemEvalCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN C_InsurClmPaytCompnCalcHdr AS _PaytCompnCalcHdr ON InsuranceClaim = _PaytCompnCalcHdr.InsuranceClaim AND InsurClmSubclm = _PaytCompnCalcHdr.InsurClmSubclm AND InsurClmItem = _PaytCompnCalcHdr.InsurClmItem AND InsurClmItemEvaluation = _PaytCompnCalcHdr.InsurClmItemEvaluation AND InsurClmItemUUID = _PaytCompnCalcHdr.InsurClmItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InsurClmPaytCompnCalcResult AS _PaytCompnCalcItems ON InsuranceClaim = _PaytCompnCalcItems.InsuranceClaim AND InsurClmSubclm = _PaytCompnCalcItems.InsurClmSubclm AND InsurClmItem = _PaytCompnCalcItems.InsurClmItem AND InsurClmItemEvaluation = _PaytCompnCalcItems.InsurClmItemEvaluation AND InsurClmItemUUID = _PaytCompnCalcItems.InsurClmItemUUID  -- association [1..*]
;