R_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 R_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 R_InsurClmFNOLDamagedObjectTP AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  InsurClmDmgdSubObject,
  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,
  InsurClmInsuredObjectCategory,
  InsurClmREStreetName,
  InsurClmInjuredPersnStreetName,
  InsurClmRECityName,
  InsurClmInjuredPersnCityName,
  InsurClmInjuredPersnAddrTxt,
  InsurClmDmgdObjHasLblty,
  cast( '' as abap.char(1) ) AS InsurClmDmgdObjActionIsChkd,
  cast( '' as abap.char(1) ) AS InsurClmFNOLActionIsChkd,
  InsurClmInsuredObjectType,
  InsurClmProbableLossAmount,
  InsurClmProbableLossAmountCrcy,
  InsurClmInspectionDate,
  InsurClmDamagedObjectLocation,
  InsurClmRelationship,
  InsurClmRelationshipText,
  BusinessPartner,
  InsurClmFatalInjury,
  InsurClmImpairmentPercent,
  InsurClmIntraCompany,
  InsurClmParticipantType,
  InsurClmInjuryInsurCompanyName,
  InsurClmInjuredPersnHouseNmbr,
  InsurClmInjuredPersnCountry,
  InsurClmNoInsurance,
  InsurClmConstructionYear,
  InsurClmVehicleMileage,
  InsurClmVehicleMileageUnit,
  InsurClmVehObjectValCurrency,
  InsurClmVehicleIdentification,
  InsurClmInsuredObjectMake,
  InsurClmInsuredObjectModel,
  InsurClmVehiclePlateNumber,
  _MakeTxt.InsurClmVehicleMfrTxt AS InsurClmVehicleMfrTxt,
  _Make.InsurClmVehicleMakeTxt AS InsurClmVehicleMakeTxt,
  _Model.InsurClmVehicleModelTxt AS InsurClmVehicleModelTxt,
  InsurClmInsuredVehicleCategory,
  InsurClmVehicleEngineCapacity,
  InsurClmVehicleEngineCapUnit,
  InsurClmSeasnlLicPlateValdFrm,
  InsurClmSeasnlLicPlateValidTo,
  InsurClmVehiclePlateCountry,
  InsurClmVehiclePlateRegion,
  BirthDate,
  I_InsurClmDmgdObjChange.BusinessPartnerName AS BusinessPartnerName,
  InsurClmBuildingAddress,
  InsurClmBuildingTypeDesc,
  InsurClmTotalLoss,
  InsurClmPreferredSupplier,
  InsurClmScopeOfLoss,
  InsurClmPrimaryMaterial,
  InsurClmClaimantID,
  InsurClmClaimantName,
  InsurClmRECountry,
  InsurClmREHouseNmbr,
  InsurClmRERegion,
  InsurClmREPostalCode
FROM I_InsurClmDmgdObjChange
LEFT OUTER JOIN R_InsurClmFNOLFactsDmgdVehTP AS _QuestionsDmgdVeh ON InsuranceClaim = _QuestionsDmgdVeh.InsuranceClaim AND InsurClmDamagedObject = _QuestionsDmgdVeh.InsurFactsSubobject  -- association [0..*]
LEFT OUTER JOIN R_InsurClmFNOLDiagnosisTP AS _Diagnosis ON InsuranceClaim = _Diagnosis.InsuranceClaim AND InsurClmDamagedObject = _Diagnosis.InsurClmInjuredPersonNumber  -- association [1..*]
LEFT OUTER JOIN R_InsurClmFNOLInjuredSFCTP AS _QuestionInjured ON InsuranceClaim = _QuestionInjured.InsuranceClaim AND InsurClmDamagedObject = _QuestionInjured.InsurClmSubobject  -- association [1..*]
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]
;