R_InsurClmDamagedObjectTP

DDL: R_INSURCLMDAMAGEDOBJECTTP Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 8 Associations

Insurance Claim Damaged Object - TP

R_InsurClmDamagedObjectTP is a Transactional CDS View that provides data about "Insurance Claim Damaged Object - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDamagedObject) and exposes 25 fields with key fields InsuranceClaim, InsurClmDamagedObject. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDamagedObject ClmDmgObject from

Associations (8)

CardinalityTargetAliasCondition
[1..*] R_InsurClmShadowDmgdObjectTP _InsurClmDamagedObjectShadow $projection.InsuranceClaim = _InsurClmDamagedObjectShadow.InsuranceClaim
[0..*] R_InsurClmDamagedVehicleTP _DamagedVehicle
[0..*] R_InsurClmInjuredPersonTP _InjuredPerson
[0..*] R_InsurClmDamagedPropertyTP _DamagedProperty
[0..*] R_InsurClmSubclmDmgdObjTP _InsurClmSubClmDmgdObj
[0..*] R_InsurClmInjuryDetailTP _InsurClmInjuryDetail
[0..*] R_InsurClmDamagedItemTP _InsurClmDamagedItem
[0..*] R_InsurClmDamagedObjDentalTP _InsurClmDamagedObjDental

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Insurance Claim Damaged Object - 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 (25)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmDamagedObject InsuranceClaim Claim Number
KEY InsurClmDamagedObject I_InsurClmDamagedObject InsurClmDamagedObject Damaged Object
ChangedOnDateTime I_InsurClmDamagedObject ChangedOnDateTime Last Changed At
LastChangedByUser I_InsurClmDamagedObject LastChangedByUser User Name
CreationDateTime I_InsurClmDamagedObject CreationDateTime Timestamp
CreatedByUser I_InsurClmDamagedObject CreatedByUser User Name
InsurClmDamageCategory I_InsurClmDamagedObject InsurClmDamageCategory Damage category
InsurClmDamageSeverity I_InsurClmDamagedObject InsurClmDamageSeverity Severity
InsurClmProbableLossAmount I_InsurClmDamagedObject InsurClmProbableLossAmount Amount of Loss
InsurClmInsuredObject I_InsurClmDamagedObject InsurClmInsuredObject Insured Object
InsurClmInsuredObjectCategory I_InsurClmDamagedObject InsurClmInsuredObjectCategory Category
InsurClmInsuredObjectType I_InsurClmDamagedObject InsurClmInsuredObjectType Object Type
InsurClmProbableLossAmountCrcy I_InsurClmDamagedObject InsurClmProbableLossAmountCrcy Currency
InsurClmDmgdObjHasLblty I_InsurClmDamagedObject InsurClmDmgdObjHasLblty Liability
InsuranceClaimInsurableObject I_InsurClmDamagedObject InsuranceClaimInsurableObject TrgtObjPrprty
InsurClmDamageDescription I_InsurClmDamagedObject InsurClmDamageDescription Damage Descriptn
_InsuranceClaim _InsuranceClaim
_DamagedVehicle _DamagedVehicle
_InjuredPerson _InjuredPerson
_DamagedProperty _DamagedProperty
_InsurClmSubClmDmgdObj _InsurClmSubClmDmgdObj
_InsurClmInjuryDetail _InsurClmInjuryDetail
_InsurClmDamagedItem _InsurClmDamagedItem
_InsurClmDamagedObjDental _InsurClmDamagedObjDental
_InsurClmDamagedObjectShadow _InsurClmDamagedObjectShadow

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_InsurClmDamagedObjectTP.
-- 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_InsurClmDamagedObjectTP AS
SELECT
  ClmDmgObject.InsuranceClaim AS InsuranceClaim,
  ClmDmgObject.InsurClmDamagedObject AS InsurClmDamagedObject,
  ClmDmgObject.ChangedOnDateTime AS ChangedOnDateTime,
  ClmDmgObject.LastChangedByUser AS LastChangedByUser,
  ClmDmgObject.CreationDateTime AS CreationDateTime,
  ClmDmgObject.CreatedByUser AS CreatedByUser,
  ClmDmgObject.InsurClmDamageCategory AS InsurClmDamageCategory,
  ClmDmgObject.InsurClmDamageSeverity AS InsurClmDamageSeverity,
  ClmDmgObject.InsurClmProbableLossAmount AS InsurClmProbableLossAmount,
  ClmDmgObject.InsurClmInsuredObject AS InsurClmInsuredObject,
  ClmDmgObject.InsurClmInsuredObjectCategory AS InsurClmInsuredObjectCategory,
  ClmDmgObject.InsurClmInsuredObjectType AS InsurClmInsuredObjectType,
  ClmDmgObject.InsurClmProbableLossAmountCrcy AS InsurClmProbableLossAmountCrcy,
  ClmDmgObject.InsurClmDmgdObjHasLblty AS InsurClmDmgdObjHasLblty,
  ClmDmgObject.InsuranceClaimInsurableObject AS InsuranceClaimInsurableObject,
  ClmDmgObject.InsurClmDamageDescription AS InsurClmDamageDescription
FROM I_InsurClmDamagedObject AS ClmDmgObject
LEFT OUTER JOIN R_InsurClmShadowDmgdObjectTP AS _InsurClmDamagedObjectShadow ON InsuranceClaim = _InsurClmDamagedObjectShadow.InsuranceClaim  -- association [1..*]
LEFT OUTER JOIN R_InsurClmDamagedVehicleTP AS _DamagedVehicle ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmInjuredPersonTP AS _InjuredPerson ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmDamagedPropertyTP AS _DamagedProperty ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmSubclmDmgdObjTP AS _InsurClmSubClmDmgdObj ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmInjuryDetailTP AS _InsurClmInjuryDetail ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmDamagedItemTP AS _InsurClmDamagedItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmDamagedObjDentalTP AS _InsurClmDamagedObjDental ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More