I_InsurClmItemInquiry

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_InsurClmItemInquiry.
-- 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.
-- SQL view name: IICLCLMITEM

CREATE VIEW I_InsurClmItemInquiry AS
SELECT
  ClaimItem.InsuranceClaim AS InsuranceClaim,
  ClaimItem.InsurClmSubclm AS InsurClmSubclm,
  ClaimItem.InsurClmItem AS InsurClmItem,
  ClaimItemEval.InsurClmItemEvaluation AS InsurClmItemEvaluation,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmItemUUID,
  ClaimItem.LastChangeDateTime AS LastChangeDateTime,
  ClaimItem.InsurClmItemCat AS InsurClmItemCat,
  ClaimItem.InsurClmItemType AS InsurClmItemType,
  ClaimItem.InsurClmCoverageType AS InsurClmCoverageType,
  ClaimItem.InsurBnftType AS InsurBnftType,
  ClaimItem.InsurClmItemStatus AS InsurClmItemStatus,
  ClaimItem.InsurClmItemRjcnRsn AS InsurClmItemRjcnRsn,
  ClaimItem.InsurClmItemDescription AS InsurClmItemDescription,
  ClaimItem.InsurClmItemEvalBase AS InsurClmItemEvalBase,
  ClaimItem.InsurClmItemEvalQuantity AS InsurClmItemEvalQuantity,
  ClaimItem.InsurClmItemEvalQuantityUnit AS InsurClmItemEvalQuantityUnit,
  ClaimItem.InsurClmItemEvalPerUnitAmt AS InsurClmItemEvalPerUnitAmt,
  ClaimItem.InsurClmItemEvalAmount AS InsurClmItemEvalAmount,
  ClaimItem.InsurClmItemEvalCurrency AS InsurClmItemEvalCurrency,
  ClaimItem.InsurClmItemEvalFactor AS InsurClmItemEvalFactor,
  ClaimItem.InsurClmItmEvalActlCshValAmt AS InsurClmItmEvalActlCshValAmt,
  ClaimItem.InsurClmItmEvalActlCshValPct AS InsurClmItmEvalActlCshValPct,
  ClaimItem.InsurClmBRFCalcExpression AS InsurClmBRFCalcExpression,
  ClaimItem.InsurClmItemTaxCode AS InsurClmItemTaxCode,
  ClaimItem.InsurClmItemSubclmRef AS InsurClmItemSubclmRef,
  ClaimItem.InsurClmItemRef AS InsurClmItemRef,
  ClaimItem.InsurClmDamagedObject AS InsurClmDamagedObject,
  ClaimItemEval.InsurClmItemEvalDate AS InsurClmItemEvalDate,
  ClaimItemEval.InsurClmItemLiabilityRate AS InsurClmItemLiabilityRate,
  ClaimItemEval.InsurClmItemClmdAmount AS InsurClmItemClmdAmount
FROM I_InsurClmItem AS ClaimItem
INNER JOIN I_InsurClmItemEvaluation AS ClaimItemEval ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurClmBenefitType AS _BenefitType ON InsurBnftType = _BenefitType.InsurBnftType  -- association [1]
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1..1]
;