I_InsurClmFNOLDamagedObjectTP

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_InsurClmFNOLDamagedObjectTP.
-- 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_InsurClmFNOLDamagedObjectTP AS
SELECT
  InsuranceClaim,
  I_InsurClmDmgdObjChange.InsurClmDamagedObject AS InsurClmDamagedObject,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClaimUUID,
  InsurClmDmgdObjUUID,
  InsuranceClaim AS InsuranceClaimForEdit,
  ChangedOnDateTime,
  InsurClmInsuredObject,
  InsurClmDamageCategory,
  InsurClmDamageCategory AS InsurClmDmgdCategoryForLineItm,
  cast('' as abap.char( 4 )) AS InsurClmType,
  cast('' as abap.numc(5)) AS InsurClmTypeGeneration,
  cast('' as abap.numc( 5 )) AS InsurClmTypeVers,
  InsurClmDamageSeverity,
  InsurClmProbableLossAmount,
  InsurClmInsuredObjectCategory,
  InsurClmREStreetName,
  InsurClmInjuredPersnStreetName,
  InsurClmRECityName,
  InsurClmInjuredPersnCityName,
  InsurClmInjuredPersnAddrTxt,
  InsurClmDmgdObjHasLblty,
  cast( '' as abap.char(1) ) AS InsurClmDmgdObjActionIsChkd,
  cast( '' as abap.char(1) ) AS InsurClmFNOLActionIsChkd,
  InsurClmInsuredObjectType,
  InsurClmProbableLossAmountCrcy,
  InsurClmInspectionDate,
  InsurClmDamagedObjectLocation,
  InsurClmRelationship,
  InsurClmRelationshipText,
  BusinessPartner,
  InsurClmFatalInjury,
  InsurClmImpairmentPercent,
  InsurClmIntraCompany,
  InsurClmParticipantType,
  InsurClmInjuryInsurCompanyName,
  InsurClmInjuredPersnHouseNmbr,
  InsurClmInjuredPersnCountry,
  InsurClmNoInsurance,
  InsurClmConstructionYear,
  InsurClmVehicleMileage,
  InsurClmVehicleMileageUnit,
  InsurClmVehicleValueAmount,
  InsurClmVehObjectValCurrency,
  InsurClmVehicleIdentification,
  InsurClmInsuredObjectMake,
  InsurClmInsuredObjectModel,
  InsurClmVehiclePlateNumber,
  _MakeTxt.InsurClmVehicleMfrTxt AS InsurClmVehicleMfrTxt,
  _Make.InsurClmVehicleMakeTxt AS InsurClmVehicleMakeTxt,
  _Model.InsurClmVehicleModelTxt AS InsurClmVehicleModelTxt,
  BirthDate,
  I_InsurClmDmgdObjChange.BusinessPartnerName AS BusinessPartnerName,
  _DamObjCatText[1: Language = $session.system_language ].Name AS InsurClmDamageCategoryTxt,
  _InspectionLocAddress.HouseNumber AS HouseNumber,
  _InspectionLocAddress.StreetName AS StreetName,
  _InspectionLocAddress.CityName AS CityName,
  _InspectionLocAddress.Region AS Region,
  _InspectionLocAddress.PostalCode AS PostalCode,
  _InspectionLocAddress.Country AS Country,
  InsurClmBuildingAddress,
  InsurClmBuildingTypeDesc,
  InsurClmTotalLoss,
  InsurClmPreferredSupplier,
  InsurClmScopeOfLoss,
  InsurClmPrimaryMaterial,
  InsurClmDmgdSubObject,
  InsurClmClaimantID,
  InsurClmClaimantName,
  InsurClmRECountry,
  InsurClmREHouseNmbr,
  InsurClmRERegion,
  InsurClmREPostalCode
FROM I_InsurClmDmgdObjChange
LEFT OUTER JOIN I_Address AS _InspectionLocAddress ON InsurClmDamagedObjectLocation = _InspectionLocAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_InsurClmDmgdCatTxt AS _DamObjCatText ON InsurClmDamageCategory = _DamObjCatText.InsurClmDamageCategory  -- association [0..*]
LEFT OUTER JOIN I_InsurClmFNOLDmgdObjCatVH AS _DamagedCategory ON InsurClmDamageCategory = _DamagedCategory.InsurClmDamageCategory AND InsurClmType = _DamagedCategory.InsurClmType AND InsurClmTypeGeneration = _DamagedCategory.InsurClmTypeGeneration AND InsurClmTypeVers = _DamagedCategory.InsurClmTypeVers  -- association [0..*]
LEFT OUTER JOIN I_InsurClmDmgdVehMake AS _Make ON InsurClmInsuredObjectCategory = _Make.InsurClmInsuredObjectCategory AND InsurClmInsuredObjectMake = _Make.InsurClmInsuredObjectMake  -- association [0..1]
LEFT OUTER JOIN I_InsurClmDmgdVehModel AS _Model ON InsurClmInsuredObjectCategory = _Model.InsurClmInsuredObjectCategory AND InsurClmInsuredObjectMake = _Model.InsurClmInsuredObjectMake AND InsurClmInsuredObjectModel = _Model.InsurClmInsuredObjectModel  -- association [0..1]
LEFT OUTER JOIN I_InsurClmFNOLFactsDmgdVehTP AS _SFCDMG ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurClmFNOLDiagnosisTP AS _diagnosis ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurClmFNOLClmntTP AS _Clmnt ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurClmFNOLSrvcPrvdrTP AS _SrvsPrvdr ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurClmFNOLInjuredSFCTP AS _injusfc ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurClmFNOLVehDriverTP AS _driver ON /* condition not available in parsed metadata */  -- association [1..*]
;