I_InsurClmDamagedPropertyTP

DDL: I_INSURCLMDAMAGEDPROPERTYTP SQL: IICLDMGDPRPTYTP Type: view COMPOSITE
19 Fields 1 Data Sources

Damaged Property of Claim

I_InsurClmDamagedPropertyTP is a Composite CDS View that provides data about "Damaged Property of Claim" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDamagedProperty) and exposes 19 fields with key fields InsuranceClaim, InsurClmDamagedObject.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDamagedProperty I_InsurClmDamagedProperty from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IICLDMGDPRPTYTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Damaged Property of Claim view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmDamagedObject InsurClmDamagedObject Damaged Object
InsurClmConstructionYear InsurClmConstructionYear Constructn Year
InsurClmBuildingAddress InsurClmBuildingAddress Subscription address
InsurClmBuildingTypeDesc InsurClmBuildingTypeDesc Description
InsurClmTotalLoss InsurClmTotalLoss Total Loss
InsurClmPreferredSupplier InsurClmPreferredSupplier Vendor Role
InsurClmScopeOfLoss InsurClmScopeOfLoss Scope of Loss
InsurClmPrimaryMaterial InsurClmPrimaryMaterial Prim. material
InsurClmClaimantID _Claimant BusinessPartner Issuing Authority
InsurClmClaimantName _Claimant BusinessPartnerName Extracted Customer Name
InsurClmRECityName _REAddress CityName Name
InsurClmREStreetName _REAddress StreetName Text
InsurClmREHouseNmbr _REAddress HouseNumber House Number
InsurClmRECountry _REAddress Country Venue: Ctry/Reg
InsurClmRERegion _REAddress Region Venue Region
InsurClmREPostalCode _REAddress PostalCode Postal Code
_Claimant _Claimant
_REAddress _REAddress

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_InsurClmDamagedPropertyTP.
-- 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: IICLDMGDPRPTYTP

CREATE VIEW I_InsurClmDamagedPropertyTP AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  InsurClmConstructionYear,
  InsurClmBuildingAddress,
  InsurClmBuildingTypeDesc,
  InsurClmTotalLoss,
  InsurClmPreferredSupplier,
  InsurClmScopeOfLoss,
  InsurClmPrimaryMaterial,
  _Claimant.BusinessPartner AS InsurClmClaimantID,
  _Claimant.BusinessPartnerName AS InsurClmClaimantName,
  _REAddress.CityName AS InsurClmRECityName,
  _REAddress.StreetName AS InsurClmREStreetName,
  _REAddress.HouseNumber AS InsurClmREHouseNmbr,
  _REAddress.Country AS InsurClmRECountry,
  _REAddress.Region AS InsurClmRERegion,
  _REAddress.PostalCode AS InsurClmREPostalCode
FROM I_InsurClmDamagedProperty
;

Learn More