I_InsurClmTravelComposite

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_InsurClmTravelComposite.
-- 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_InsurClmTravelComposite AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmDmgdObjUUID,
  cast( case when _Subclaim.InsurClmDmgdSubObject is null then '000' else _Subclaim.InsurClmDmgdSubObject end as abap.char(3) ) as InsurClmDmgdSubObject AS char3asInsurClmDmgdSubObject,
  cast( case when _Subclaim.InsurClmSubobjectCategory is null then 'C' else _Subclaim.InsurClmSubobjectCategory end as abap.char(2) ) as InsurClmSubobjectCategory AS char2asInsurClmSubobjectCategory,
  InsurClmDamageCategory,
  CreationDateTime,
  CreatedByUser,
  ChangedOnDateTime,
  InsurClmProbableLossAmount,
  InsurClmProbableLossAmountCrcy,
  InsurClmDamageDescription,
  _Travel.InsurClmDatabaseLineStatus AS InsurClmDatabaseLineStatus,
  _Travel.InsurClmTrvlStartDate AS InsurClmTrvlStartDate,
  _Travel.InsurClmTrvlToDate AS InsurClmTrvlToDate,
  _Travel.InsurClmTrvlBkgDate AS InsurClmTrvlBkgDate,
  _Travel.InsurClmTrvlAccdtDate AS InsurClmTrvlAccdtDate,
  _Travel.InsurClmTrvlPurposeCode AS InsurClmTrvlPurposeCode,
  _Travel.InsurClmTripIsWithFamily AS InsurClmTripIsWithFamily,
  _Travel.InsurClmTrvlDiagnosisCode AS InsurClmTrvlDiagnosisCode,
  _Travel.InsurClmPrepaidIsAffected AS InsurClmPrepaidIsAffected,
  _Travel.InsurClmOriglTranspNumber AS InsurClmOriglTranspNumber,
  _Travel.InsurClmRvrtTranspNumber AS InsurClmRvrtTranspNumber,
  _Travel.InsurClmOriglArrvlDateTime AS InsurClmOriglArrvlDateTime,
  _Travel.InsurClmActlArrvlDateTime AS InsurClmActlArrvlDateTime,
  _Travel.InsurClmCauseOfIssue AS InsurClmCauseOfIssue
FROM I_InsurClmDamagedObject
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_InsurClmTravel AS _Travel ON InsuranceClaim = _Travel.InsuranceClaim AND InsurClmDamagedObject = _Travel.InsurClmDamagedObject  -- association [1..1]
LEFT OUTER JOIN I_InsurClmDamageAssignment AS _Subclaim ON InsuranceClaim = _Subclaim.InsuranceClaim AND InsurClmDamagedObject = _Subclaim.InsurClmDamagedObject  -- association [1..*]
LEFT OUTER JOIN I_InsurClmTrvlIssueCause AS _IssueCause ON insurclmcauseofissue = _IssueCause.InsurClmCauseOfIssue  -- association [1..*]
LEFT OUTER JOIN I_InsurClmTrvlMedlDiagnosis AS _Diagnosis ON insurclmtrvldiagnosiscode = _Diagnosis.InsurClmTrvlDiagnosisCode  -- association [1..*]
;