I_InsurClmDmgdObjChange

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_InsurClmDmgdObjChange.
-- 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: ICLDMGOBJ

CREATE VIEW I_InsurClmDmgdObjChange 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,
  InsurClmInsuredObject,
  InsurClmDamageSeverity,
  InsurClmProbableLossAmount,
  InsurClmInsuredObjectCategory,
  InsurClmInsuredObjectType,
  InsurClmProbableLossAmountCrcy,
  InsurClmDmgdObjHasLblty,
  _DamVehDets.InsurClmInspectionDate AS InsurClmInspectionDate,
  _DamVehDets.InsurClmDamagedObjectLocation AS InsurClmDamagedObjectLocation,
  _DamVehDets.InsurClmVehicleIdentification AS InsurClmVehicleIdentification,
  _DamVehDets.InsurClmConstructionYear AS InsurClmConstructionYear,
  _DamVehDets.InsurClmVehicleMileage AS InsurClmVehicleMileage,
  _DamVehDets.InsurClmVehicleMileageUnit AS InsurClmVehicleMileageUnit,
  _DamVehDets.InsurClmVehicleValueAmount AS InsurClmVehicleValueAmount,
  _DamVehDets.InsurClmVehObjectValCurrency AS InsurClmVehObjectValCurrency,
  _DamVehDets.InsurClmInsuredObjectMake AS InsurClmInsuredObjectMake,
  _DamVehDets.InsurClmVehiclePlateNumber AS InsurClmVehiclePlateNumber,
  _DamVehDets.InsurClmInsuredObjectModel AS InsurClmInsuredObjectModel,
  _DamVehDets.InsurClmInsuredVehicleCategory AS InsurClmInsuredVehicleCategory,
  _DamVehDets.InsurClmVehicleEngineCapacity AS InsurClmVehicleEngineCapacity,
  _DamVehDets.InsurClmVehicleEngineCapUnit AS InsurClmVehicleEngineCapUnit,
  _DamVehDets.InsurClmSeasnlLicPlateValdFrm AS InsurClmSeasnlLicPlateValdFrm,
  _DamVehDets.InsurClmSeasnlLicPlateValidTo AS InsurClmSeasnlLicPlateValidTo,
  _DamVehDets.InsurClmVehiclePlateCountry AS InsurClmVehiclePlateCountry,
  _DamVehDets.InsurClmVehiclePlateRegion AS InsurClmVehiclePlateRegion,
  _DmgdBodilyInjured.InsurClmRelationship AS InsurClmRelationship,
  _DmgdBodilyInjured.BusinessPartner AS BusinessPartner,
  _DmgdBodilyInjured.InsurClmFatalInjury AS InsurClmFatalInjury,
  _DmgdBodilyInjured.InsurClmImpairmentPercent AS InsurClmImpairmentPercent,
  _DmgdBodilyInjured.InsurClmIntraCompany AS InsurClmIntraCompany,
  _DmgdBodilyInjured.InsurClmParticipantType AS InsurClmParticipantType,
  _DmgdBodilyInjured.InsurClmNoInsurance AS InsurClmNoInsurance,
  _DmgdBodilyInjured.BirthDate AS BirthDate,
  _DmgdBodilyInjured.BusinessPartnerName AS BusinessPartnerName,
  _DmgdBodilyInjured.HouseNumber AS InsurClmInjuredPersnHouseNmbr,
  _DmgdBodilyInjured.StreetName AS InsurClmInjuredPersnStreetName,
  _DmgdBodilyInjured.CityName AS InsurClmInjuredPersnCityName,
  _DmgdBodilyInjured.Country AS InsurClmInjuredPersnCountry,
  _DmgdBodilyInjured._RelshpTypeTxt.InsurClmRelationshipText AS InsurClmRelationshipText,
  _DmgdBodilyInjured.InsurClmInjuredPersnAddrTxt AS InsurClmInjuredPersnAddrTxt,
  _DmgdBodilyInjured.InsurClmInjuryInsurCompanyName AS InsurClmInjuryInsurCompanyName,
  _DmgdProperty.InsurClmBuildingAddress AS InsurClmBuildingAddress,
  _DmgdProperty.InsurClmBuildingTypeDesc AS InsurClmBuildingTypeDesc,
  _DmgdProperty.InsurClmTotalLoss AS InsurClmTotalLoss,
  _DmgdProperty.InsurClmPreferredSupplier AS InsurClmPreferredSupplier,
  _DmgdProperty.InsurClmScopeOfLoss AS InsurClmScopeOfLoss,
  _DmgdProperty.InsurClmPrimaryMaterial AS InsurClmPrimaryMaterial,
  _DmgdProperty.InsurClmConstructionYear AS InsurClmPrptyConstructionYear,
  _DmgdProperty.InsurClmClaimantID AS InsurClmClaimantID,
  _DmgdProperty.InsurClmClaimantName AS InsurClmClaimantName,
  _DmgdProperty.InsurClmRECityName AS InsurClmRECityName,
  _DmgdProperty.InsurClmRECountry AS InsurClmRECountry,
  _DmgdProperty.InsurClmREHouseNmbr AS InsurClmREHouseNmbr,
  _DmgdProperty.InsurClmRERegion AS InsurClmRERegion,
  _DmgdProperty.InsurClmREStreetName AS InsurClmREStreetName,
  _DmgdProperty.InsurClmREPostalCode AS InsurClmREPostalCode,
  _PropertyType.InsurClmInsuredObjectType AS InsurClmDmgdPrptyType,
  _PropertyType._PropTypeText.Name AS InsurClmDmgdPrptyTypeName
FROM I_InsurClmDamagedObject
LEFT OUTER JOIN I_InsurClmDamagedVeh AS _DamVehDets ON InsuranceClaim = _DamVehDets.InsuranceClaim AND InsurClmDamagedObject = _DamVehDets.InsurClmDamagedObject  -- association [1..*]
LEFT OUTER JOIN I_InsurClmInjuredPersnRltnDets AS _DmgdBodilyInjured ON InsuranceClaim = _DmgdBodilyInjured.InsuranceClaim AND InsurClmDamagedObject = _DmgdBodilyInjured.InsurClmInjuredPersonNumber  -- association [1..1]
LEFT OUTER JOIN I_InsurClmDamagedPropertyTP AS _DmgdProperty ON InsuranceClaim = _DmgdProperty.InsuranceClaim AND InsurClmDamagedObject = _DmgdProperty.InsurClmDamagedObject  -- association [1..1]
LEFT OUTER JOIN I_InsurClmDamageSeverityText AS _DmgdSvrtyTxt ON InsurClmDamageSeverity = _DmgdSvrtyTxt.InsurClmDamageSeverity AND InsurClmDamageCategory = _DmgdSvrtyTxt.InsurClmDamageCategory AND _DmgdSvrtyTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InsurClmDamageAssignment AS _Subclaim ON InsuranceClaim = _Subclaim.InsuranceClaim AND InsurClmDamagedObject = _Subclaim.InsurClmDamagedObject  -- association [1..*]
LEFT OUTER JOIN I_InsurClmPartcipnType AS _PartTxt ON insurclmparticipanttype = _PartTxt.InsurClmParticipantType  -- association [1]
LEFT OUTER JOIN I_InsurClmVehicleMfrTxt AS _MakeTxt ON InsurClmInsuredObjectMake = _MakeTxt.InsurClmVehicleMfr AND InsurClmDamageCategory = _MakeTxt.InsurClmVehicleCat  -- association [1..1]
LEFT OUTER JOIN I_InsurClmDmgdPrptyType AS _PropertyType ON InsurClmDamageCategory = _PropertyType.InsurClmInsuredObjectCategory AND InsurClmInsuredObjectType = _PropertyType.InsurClmInsuredObjectType  -- association [1]
;