I_InsurClmDamagedPropertyTP

DDL: I_INSURCLMDAMAGEDPROPERTYTP SQL: IICLDMGDPRPTYTP Type: view COMPOSITE

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
KEY InsurClmDamagedObject InsurClmDamagedObject
InsurClmConstructionYear InsurClmConstructionYear
InsurClmBuildingAddress InsurClmBuildingAddress
InsurClmBuildingTypeDesc InsurClmBuildingTypeDesc
InsurClmTotalLoss InsurClmTotalLoss
InsurClmPreferredSupplier InsurClmPreferredSupplier
InsurClmScopeOfLoss InsurClmScopeOfLoss
InsurClmPrimaryMaterial InsurClmPrimaryMaterial
InsurClmClaimantID _Claimant BusinessPartner
InsurClmClaimantName _Claimant BusinessPartnerName
InsurClmRECityName _REAddress CityName
InsurClmREStreetName _REAddress StreetName
InsurClmREHouseNmbr _REAddress HouseNumber
InsurClmRECountry _REAddress Country
InsurClmRERegion _REAddress Region
InsurClmREPostalCode _REAddress PostalCode
_Claimant _Claimant
_REAddress _REAddress
@AbapCatalog.sqlViewName: 'IICLDMGDPRPTYTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Damaged Property of Claim'

@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #S,
    serviceQuality: #D
}
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_InsurClmDamagedPropertyTP
  as select from I_InsurClmDamagedProperty
  association[1..*] to I_InsurClmPrtcpntOccrnc as _Claimant  on  $projection.InsuranceClaim          = _Claimant.InsuranceClaim
                                                       and $projection.InsurClmDamagedObject   = _Claimant.InsurClmSubobject
                                                       and _Claimant.InsurClmParticipantRole   = 'CLAI'
                                                       and _Claimant.InsurClmSubobjectCategory = 'D'
  association[1..1] to I_Address               as _REAddress on  $projection.InsurClmBuildingAddress = _REAddress.AddressID
{
  key InsuranceClaim,
  key 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,
      _Claimant,
      _REAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_INSURCLMDAMAGEDPROPERTY",
"I_INSURCLMPRTCPNTOCCRNC"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_INSURCLMPRTCPNTOCCRNC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/