Deprecated SAP_INTERNAL_API
This CDS view is deprecated in S/4HANA. Use R_InsuranceClaimShadow2TP instead. View all deprecated CDS views →

R_InsuranceClaimShadowTP

DDL: R_INSURANCECLAIMSHADOWTP Type: view_entity TRANSACTIONAL
42 Fields 1 Data Sources 8 Associations

TP View for Insurance Claim Shadow Table

R_InsuranceClaimShadowTP is a Transactional CDS View that provides data about "TP View for Insurance Claim Shadow Table" in SAP S/4HANA. It reads from 1 data source (I_InsuranceClaimShadowBasic) and exposes 42 fields with key field InsuranceClaim. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsuranceClaimShadowBasic I_InsuranceClaimShadowBasic from

Associations (8)

CardinalityTargetAliasCondition
[0..*] R_InsurClmSubclaimShadowTP _InsuranceSubclaimShadow
[0..*] R_InsuranceClaimShadowItemTP _InsuranceClaimItem
[0..*] R_InsuranceClaimShadowTaskTP _InsuranceClmTask
[0..*] R_InsurClmShadowParticipantTP _InsuranceClmParticipant
[0..*] R_InsurClmShadowPaymentTP _InsuranceClaimPayment
[0..*] R_InsurClmReserveShadowTP _InsuranceClaimReserve
[0..*] R_InsurClmShadowDmgdObjectTP _InsuranceClaimDamagedObject
[0..*] R_InsurClmShadowPerformerTP _InsuranceClaimPerformer

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label TP View for Insurance Claim Shadow Table view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor R_InsuranceClaimShadow2TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
LastChangeDateTime ChangedOnDateTime Last Changed At
InsuranceContract InsuranceContract Contract
InsuranceClaimContractControl InsurClmPolicyProduct Policy Product
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
InsurClmLifeCycSts InsurClmLifeCycSts Status
InsurClmStatReason InsurClmStatReason Status Reason
InsurClmType InsurClmType Claim Type
InsurClmAuthznGrp InsurClmAuthznGrp AuthGroup (VIP)
InsurClmPolicyProdGeneration InsurClmPolicyProdGeneration Generation
InsurClmPolicyProductVersion InsurClmPolicyProductVersion Version
InsurClmIncdntType InsurClmIncdntType Incident Type
InsurClmCauseOfLoss InsurClmCauseOfLoss Cause
InsurClmLossLocAddressID InsurClmLossLocAddressID Loss Location
InsurClmTypeGeneration InsurClmTypeGeneration Generation
InsurClmTypeVers InsurClmTypeVers Clm Type Versn
clientNULLasInsurClmLossDateTime
InsurClmContractLastRenewal InsurClmContractLastRenewal Last Renewal
InsurClmVersionChangeTime InsurClmVersionChangeTime Read Time
InsurClmAssignUUID InsurClmAssignUUID Link UUID
InsurClmComplexity InsurClmComplexity Complexity
InsurClmJurisdictionCountry InsurClmJurisdictionCountry C/R Juris.
InsurClmJurisdictionRegion InsurClmJurisdictionRegion Jurisd. Region
InsurClmCovered InsurClmCovered Compensable
InsurClmBenefitTypeTree InsurClmBenefitTypeTree Ben. Type Tree
InsurClmBnftTypeTreeGeneration InsurClmBnftTypeTreeGeneration Generation
InsurClmBnftTypeTreeVersion InsurClmBnftTypeTreeVersion Version
InsurClmIsWithoutProduct InsurClmIsWithoutProduct Without Product
InsurClmIsDummyClaim InsurClmIsDummyClaim Dummy Claim
InsurClmReportedDate InsurClmReportedDate Repd to Insurer
InsurClmAgentReportedDate InsurClmAgentReportedDate Reptd to Agent
InsurClmSensitiveClaim InsurClmSensitiveClaim Sensitive Claim
_InsuranceSubclaimShadow _InsuranceSubclaimShadow
_InsuranceClaimItem _InsuranceClaimItem
_InsuranceClmTask _InsuranceClmTask
_InsuranceClmParticipant _InsuranceClmParticipant
_InsuranceClaimPayment _InsuranceClaimPayment
_InsuranceClaimReserve _InsuranceClaimReserve
_InsuranceClaimDamagedObject _InsuranceClaimDamagedObject
_InsuranceClaimPerformer _InsuranceClaimPerformer

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_InsuranceClaimShadowTP.
-- 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_InsuranceClaimShadowTP AS
SELECT
  InsuranceClaim,
  ChangedOnDateTime AS LastChangeDateTime,
  InsuranceContract,
  InsurClmPolicyProduct AS InsuranceClaimContractControl,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmLifeCycSts,
  InsurClmStatReason,
  InsurClmType,
  InsurClmAuthznGrp,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmIncdntType,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  dats_tims_to_tstmp (InsurClmDateOfLoss, InsurClmTimeOfLoss, InsurClmTimeZoneOfLoss, $session.client,'NULL' ) as InsurClmLossDateTime AS clientNULLasInsurClmLossDateTime,
  InsurClmContractLastRenewal,
  InsurClmVersionChangeTime,
  InsurClmAssignUUID,
  InsurClmComplexity,
  InsurClmJurisdictionCountry,
  InsurClmJurisdictionRegion,
  InsurClmCovered,
  InsurClmBenefitTypeTree,
  InsurClmBnftTypeTreeGeneration,
  InsurClmBnftTypeTreeVersion,
  InsurClmIsWithoutProduct,
  InsurClmIsDummyClaim,
  InsurClmReportedDate,
  InsurClmAgentReportedDate,
  InsurClmSensitiveClaim
FROM I_InsuranceClaimShadowBasic
LEFT OUTER JOIN R_InsurClmSubclaimShadowTP AS _InsuranceSubclaimShadow ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimShadowItemTP AS _InsuranceClaimItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimShadowTaskTP AS _InsuranceClmTask ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmShadowParticipantTP AS _InsuranceClmParticipant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmShadowPaymentTP AS _InsuranceClaimPayment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmReserveShadowTP AS _InsuranceClaimReserve ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmShadowDmgdObjectTP AS _InsuranceClaimDamagedObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurClmShadowPerformerTP AS _InsuranceClaimPerformer ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More