R_InsClmSrvcsDamagedPropertyTP

DDL: R_INSCLMSRVCSDAMAGEDPROPERTYTP Type: view_entity TRANSACTIONAL

Claim Services For Damaged Property TP

R_InsClmSrvcsDamagedPropertyTP is a Transactional CDS View that provides data about "Claim Services For Damaged Property TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDamagedProperty) and exposes 11 fields with key fields InsuranceClaim, InsurClmDamagedObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDamagedProperty I_InsurClmDamagedProperty from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_InsurClmSrvcsInsurClaimTP _InsuranceClaim $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Claim Services For Damaged Property TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (11)

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
_InsurClmDamagedObj _InsurClmDamagedObj
_InsuranceClaim _InsuranceClaim

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_InsClmSrvcsDamagedPropertyTP.
-- 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_InsClmSrvcsDamagedPropertyTP AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  InsurClmConstructionYear,
  InsurClmBuildingAddress,
  InsurClmBuildingTypeDesc,
  InsurClmTotalLoss,
  InsurClmPreferredSupplier,
  InsurClmScopeOfLoss,
  InsurClmPrimaryMaterial
FROM I_InsurClmDamagedProperty
LEFT OUTER JOIN R_InsurClmSrvcsInsurClaimTP AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
;