C_InsurClmDamagedPrptyInqry

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_InsurClmDamagedPrptyInqry.
-- 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: CICLDAMREINQ

CREATE VIEW C_InsurClmDamagedPrptyInqry AS
SELECT
  I_InsurClmDamagedPrptyDetails.InsuranceClaim AS InsuranceClaim,
  InsurClmDamagedObject,
  I_InsurClmDamagedPrptyDetails.InsurClmDmgdSubObject AS InsurClmDmgdSubObject,
  InsurClmInsuredObjectType,
  _Iobtype._PropTypeText[ Language = $session.system_language].Name AS InsurClmInsuredObjectTypeName,
  InsurClmConstructionYear,
  InsurClmBuildingAddress,
  concat_with_space(_Location.HouseNumber, concat_with_space(_Location.StreetName, concat_with_space(_Location.CityName,_Location.Country,1),1),1) as InsurClmLocationText AS Country111asInsurClmLocationText,
  concat_with_space(_SubClaim.InsurClmSubclm,_SubClaim.InsurClmSubclaimDescription,1) AS InsurClmSubclmDescriptionText,
  InsurClmBuildingTypeDesc,
  InsurClmTotalLoss,
  InsurClmPrimaryMaterialTxt,
  InsurClmScopeOfLossTxt,
  InsurClmPreferredSupplier,
  _Claimant.BusinessPartnerName AS BusinessPartnerName
FROM I_InsurClmDamagedPrptyDetails
LEFT OUTER JOIN I_Address AS _Location ON InsurClmBuildingAddress = _Location.AddressID  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubclaimInquiry AS _SubClaim ON InsuranceClaim = _SubClaim.InsuranceClaim AND InsurClmDmgdSubObject = _SubClaim.InsurClmSubclm  -- association [1..1]
LEFT OUTER JOIN I_InsurClmPrtcpntOccrnc AS _Claimant ON InsuranceClaim = _Claimant.InsuranceClaim AND _Claimant.InsurClmSubobjectCategory = 'S' AND InsurClmDmgdSubObject = _Claimant.InsurClmSubobject AND _Claimant.InsurClmParticipantRole = 'CLAI'  -- association [1..*]
LEFT OUTER JOIN C_InsurClmFactCapture AS _FactsCapture ON InsuranceClaim = _FactsCapture.InsuranceClaim AND _FactsCapture.InsurClmFactCaptureCategory = 'DO' AND InsurClmDamagedObject = _FactsCapture.InsurClmSubobject  -- association [1..*]
LEFT OUTER JOIN I_InsurClmDmgdPrptyType AS _Iobtype ON InsurClmInsuredObjectType = _Iobtype.InsurClmInsuredObjectType  -- association [1..*]
;