C_InsurClmSubclaimInquiry

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 C_InsurClmSubclaimInquiry.
-- 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: CICLSUBCLMINQ

CREATE VIEW C_InsurClmSubclaimInquiry AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmSubclaimDescription,
  InsurClmSubclmTypeName,
  concat_with_space ('Subclaim ', InsurClmSubclm, 1) AS InsurClmSubclaimTypeText,
  InsurClmLifeCycSts,
  InsurClmSubclmStatusText,
  InsurClmSubclaimLbltyText,
  InsurClmSubclmPaytTotText,
  InsurClmSubclmTotRsrvText,
  concat_with_space(InsurClmSubclm, InsurClmSubclaimDescription,1) AS InsurClmSubclmDescriptionText,
  InsurClmClaimantID,
  InsurClmClaimantName,
  InsurClmCoverageText,
  InsurClmCvrgConfirmedText,
  InsurClmFraudFlagText,
  InsurClmSubrogtnPotentialText,
  InsurClmSalvageFlagText,
  InsurClmLitigationFlagText,
  InsurClmNegotiationFlagText,
  InsurClmStatReasonText
FROM I_InsurClmSubclaimInquiry
LEFT OUTER JOIN C_InsurClmDamagedVehicleInqry AS _DamVehicle ON InsuranceClaim = _DamVehicle.InsuranceClaim AND InsurClmSubclm = _DamVehicle.InsurClmDmgdSubObject  -- association [0..*]
LEFT OUTER JOIN C_InsurClmInjuredPerson AS _InjuredPerson ON InsuranceClaim = _InjuredPerson.InsuranceClaim AND InsurClmSubclm = _InjuredPerson.InsurClmSubclm  -- association [0..*]
LEFT OUTER JOIN C_InsurClmDamagedPrptyInqry AS _DamagePrpty ON InsuranceClaim = _DamagePrpty.InsuranceClaim AND InsurClmSubclm = _DamagePrpty.InsurClmDmgdSubObject  -- association [0..*]
LEFT OUTER JOIN C_InsurClmSubclmFinInqry AS _SubFinOvw ON InsuranceClaim = _SubFinOvw.InsuranceClaim AND InsurClmSubclm = _SubFinOvw.InsurClmSubclm  -- association [1..*]
LEFT OUTER JOIN C_InsurClmSubclaimRsrvInqry AS _SubReserve ON InsuranceClaim = _SubReserve.InsuranceClaim AND InsurClmSubclm = _SubReserve.InsurClmSubclm  -- association [1..*]
LEFT OUTER JOIN C_InsurClmSubclaimPaytInqry AS _SubPay ON InsuranceClaim = _SubPay.InsuranceClaim AND InsurClmSubclm = _SubPay.InsurClmSubclm  -- association [1..*]
LEFT OUTER JOIN C_InsurClmBPQuickView AS _BPDetails ON InsurClmClaimantID = _BPDetails.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_InsurClmPerformer AS _Performer ON InsuranceClaim = _Performer.InsuranceClaim AND InsurClmSubclm = _Performer.InsurClmSubclm  -- association [0..*]
LEFT OUTER JOIN C_InsurClmItemInquiry AS _ClaimItem ON InsuranceClaim = _ClaimItem.InsuranceClaim AND InsurClmSubclm = _ClaimItem.InsurClmSubclm  -- association [0..*]
;