R_InsuranceClaimShadow2TP

DDL: R_INSURANCECLAIMSHADOW2TP Type: view_entity TRANSACTIONAL
100 Fields 1 Data Sources 8 Associations

Insurance Claim Shadow2 - TP

R_InsuranceClaimShadow2TP is a Transactional CDS View that provides data about "Insurance Claim Shadow2 - TP" in SAP S/4HANA. It reads from 1 data source (I_InsuranceClaimShadowBasic) and exposes 100 fields with key fields InsuranceClaim, InsurClmChangeDate, InsurClmChangedTime. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsuranceClaimShadowBasic I_InsuranceClaimShadowBasic from

Associations (8)

CardinalityTargetAliasCondition
[0..*] R_InsurClmSubclaimShadow2TP _InsuranceSubclaimShadow $projection.InsuranceClaim = _InsuranceSubclaimShadow.InsuranceClaim
[0..*] R_InsuranceClaimItemShadow2TP _InsuranceClaimItem $projection.InsuranceClaim = _InsuranceClaimItem.InsuranceClaim
[0..*] R_InsuranceClaimTaskShadow2TP _InsuranceClmTask $projection.InsuranceClaim = _InsuranceClmTask.InsuranceClaim
[0..*] R_InsurClmPrtcpntShadow2TP _InsuranceClmParticipant $projection.InsuranceClaim = _InsuranceClmParticipant.InsuranceClaim
[0..*] R_InsurClmPaymentShadow2TP _InsuranceClaimPayment $projection.InsuranceClaim = _InsuranceClaimPayment.InsuranceClaim
[0..*] R_InsurClmReserveShadow2TP _InsuranceClaimReserve $projection.InsuranceClaim = _InsuranceClaimReserve.InsuranceClaim
[0..*] R_InsurClmPerformerShadow2TP _InsuranceClaimPerformer $projection.InsuranceClaim = _InsuranceClaimPerformer.InsuranceClaim
[0..*] R_InsurClmDmgdObjectShadow2TP _InsuranceClaimDamagedObject $projection.InsuranceClaim = _InsuranceClaimDamagedObject.InsuranceClaim

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Insurance Claim Shadow2 - 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 (100)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmChangeDate InsurClmChangeDate
KEY InsurClmChangedTime InsurClmChangedTime
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
InsurClmWholeClmChgdBy InsurClmWholeClmChgdBy Last Changed by
InsurClmWholeClmChgDteTme InsurClmWholeClmChgDteTme Last Changed At
InsurClmExternalNumberCategory InsurClmExternalNumberCategory External No.Category
InsurClmSubclmStsChgdOnDteTime InsurClmSubclmStsChgdOnDteTime
InsuranceClaimIsStatusHandler InsuranceClaimIsStatusHandler ClmHandlngActve
InsuranceClaimIsNoClaimMade InsuranceClaimIsNoClaimMade No Claim Made
InsuranceClaimIsStatusClosed InsuranceClaimIsStatusClosed Closed
InsuranceClaimBundleLossEvent InsuranceClaimBundleLossEvent CumulativeEvent
InsuranceClaimReinsurancePeril InsuranceClaimReinsurancePeril Peril
InsuranceClaimIsDateEstimate InsuranceClaimIsDateEstimate Date Estimated
InsuranceClaimDateChangeReason InsuranceClaimDateChangeReason Reason f.Change
InsurClmIsRptdToAuth InsurClmIsRptdToAuth Reported
InsurClmActyAssgmtSts InsurClmActyAssgmtSts Assgmt Status
InsuranceClaimOwnerType InsuranceClaimOwnerType CH Obj.Type
InsuranceClaimOwner InsuranceClaimOwner Clm Hndlr ID
InsuranceClaimOwnerTypeGroup InsuranceClaimOwnerTypeGroup CH Obj.Type
InsuranceClaimOwnerGroup InsuranceClaimOwnerGroup CH Group
InsuranceClaimIsCumulative InsuranceClaimIsCumulative Claim Assigned to an Aggregate
InsuranceClaimViewFault InsuranceClaimViewFault Fault
InsurClmVwFaultPlcyHldr InsurClmVwFaultPlcyHldr PH View ofFault
InsurClmIsThirdPartyKnown InsurClmIsThirdPartyKnown 3rd party known
InsurClmIsEntrInPaytAmtAuthzns InsurClmIsEntrInPaytAmtAuthzns EntryClaimB
InsuranceClaimIsNoNotif InsuranceClaimIsNoNotif Not Notif. Mode
InsuranceClaimIsReserve InsuranceClaimIsReserve Reserve Exists
InsurClmWrkflwExecDteTme InsurClmWrkflwExecDteTme Last Renewal
InsurClmWorkflowStatus InsurClmWorkflowStatus WF Status
InsuranceClaimMaxItemNumber InsuranceClaimMaxItemNumber Highest ClmItNo
InsurClmSecondInjuryFundStatus InsurClmSecondInjuryFundStatus SIF Status
InsurClmIncdntInvstgnSts InsurClmIncdntInvstgnSts Match Status
InsuranceClaimEffectiveDate InsuranceClaimEffectiveDate Validity Date
InsuranceClaimLossRepDate InsuranceClaimLossRepDate Date on Request
InsuranceClaimLumpSum InsuranceClaimLumpSum Option Exercisd
InsurClmStatutoryPensionType InsurClmStatutoryPensionType Statut. Pension
InsurClmBndlWithdrawAmt InsurClmBndlWithdrawAmt Withdrawal Amt
InsurClmBndlWithdrawCrcy InsurClmBndlWithdrawCrcy Currency
InsurClmBndlWthdrwlSqnc InsurClmBndlWthdrwlSqnc Withdrawal Seq.
InsuranceClaimAlternateBenefit InsuranceClaimAlternateBenefit Alt.Ben.Values
InsuranceClaimSpecialRiskNotif InsuranceClaimSpecialRiskNotif Spec.Risk Notif
InsuranceClaimNotifReason InsuranceClaimNotifReason SpecRisk NotifR
InsuranceClaimAutoResubmission InsuranceClaimAutoResubmission Autom.Resubmssn
InsClmAutoResubmsnDte InsClmAutoResubmsnDte Resubmissn Date
InsuranceClaimProcessingDate InsuranceClaimProcessingDate Processing On
InsuranceClaimStatusObjectNmbr InsuranceClaimStatusObjectNmbr Object number
InsuranceClaimDunningStatus InsuranceClaimDunningStatus Dunning Status
InsuranceClaimClearDate InsuranceClaimClearDate Paid Up To
InsurClmPremiumBalanceAmount InsurClmPremiumBalanceAmount Premium Balance
InsurClmPremiumBalanceCurrency InsurClmPremiumBalanceCurrency Currency
InsuranceClaimWithdrawalType InsuranceClaimWithdrawalType Withdrawal Type
InsuranceClaimReactDate InsuranceClaimReactDate Reactivation
InsurClmSpecialRiskMsgDateTime InsurClmSpecialRiskMsgDateTime Last Renewal
InsurClmIncrrtBnftCalcDateTime InsurClmIncrrtBnftCalcDateTime Last Renewal
InsuranceClaimPolicySystem InsuranceClaimPolicySystem Policy System
InsurClmArchivingStatus InsurClmArchivingStatus Archiving Status
InsurClmArchResubmsnDte InsurClmArchResubmsnDte Resubmission Date
InsurClmArchRjcnRsn InsurClmArchRjcnRsn Rejection Reason
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
_InsuranceSubclaimShadow _InsuranceSubclaimShadow
_InsuranceClaimItem _InsuranceClaimItem
_InsuranceClmTask _InsuranceClmTask
_InsuranceClmParticipant _InsuranceClmParticipant
_InsuranceClaimPayment _InsuranceClaimPayment
_InsuranceClaimReserve _InsuranceClaimReserve
_InsuranceClaimPerformer _InsuranceClaimPerformer
_InsuranceClaimDamagedObject _InsuranceClaimDamagedObject

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_InsuranceClaimShadow2TP.
-- 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_InsuranceClaimShadow2TP AS
SELECT
  InsuranceClaim,
  InsurClmChangeDate,
  InsurClmChangedTime,
  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,
  InsurClmWholeClmChgdBy,
  InsurClmWholeClmChgDteTme,
  InsurClmExternalNumberCategory,
  InsurClmSubclmStsChgdOnDteTime,
  InsuranceClaimIsStatusHandler,
  InsuranceClaimIsNoClaimMade,
  InsuranceClaimIsStatusClosed,
  InsuranceClaimBundleLossEvent,
  InsuranceClaimReinsurancePeril,
  InsuranceClaimIsDateEstimate,
  InsuranceClaimDateChangeReason,
  InsurClmIsRptdToAuth,
  InsurClmActyAssgmtSts,
  InsuranceClaimOwnerType,
  InsuranceClaimOwner,
  InsuranceClaimOwnerTypeGroup,
  InsuranceClaimOwnerGroup,
  InsuranceClaimIsCumulative,
  InsuranceClaimViewFault,
  InsurClmVwFaultPlcyHldr,
  InsurClmIsThirdPartyKnown,
  InsurClmIsEntrInPaytAmtAuthzns,
  InsuranceClaimIsNoNotif,
  InsuranceClaimIsReserve,
  InsurClmWrkflwExecDteTme,
  InsurClmWorkflowStatus,
  InsuranceClaimMaxItemNumber,
  InsurClmSecondInjuryFundStatus,
  InsurClmIncdntInvstgnSts,
  InsuranceClaimEffectiveDate,
  InsuranceClaimLossRepDate,
  InsuranceClaimLumpSum,
  InsurClmStatutoryPensionType,
  InsurClmBndlWithdrawAmt,
  InsurClmBndlWithdrawCrcy,
  InsurClmBndlWthdrwlSqnc,
  InsuranceClaimAlternateBenefit,
  InsuranceClaimSpecialRiskNotif,
  InsuranceClaimNotifReason,
  InsuranceClaimAutoResubmission,
  InsClmAutoResubmsnDte,
  InsuranceClaimProcessingDate,
  InsuranceClaimStatusObjectNmbr,
  InsuranceClaimDunningStatus,
  InsuranceClaimClearDate,
  InsurClmPremiumBalanceAmount,
  InsurClmPremiumBalanceCurrency,
  InsuranceClaimWithdrawalType,
  InsuranceClaimReactDate,
  InsurClmSpecialRiskMsgDateTime,
  InsurClmIncrrtBnftCalcDateTime,
  InsuranceClaimPolicySystem,
  InsurClmArchivingStatus,
  InsurClmArchResubmsnDte,
  InsurClmArchRjcnRsn,
  InsurClmDatabaseLineStatus
FROM I_InsuranceClaimShadowBasic
LEFT OUTER JOIN R_InsurClmSubclaimShadow2TP AS _InsuranceSubclaimShadow ON InsuranceClaim = _InsuranceSubclaimShadow.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimItemShadow2TP AS _InsuranceClaimItem ON InsuranceClaim = _InsuranceClaimItem.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsuranceClaimTaskShadow2TP AS _InsuranceClmTask ON InsuranceClaim = _InsuranceClmTask.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmPrtcpntShadow2TP AS _InsuranceClmParticipant ON InsuranceClaim = _InsuranceClmParticipant.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmPaymentShadow2TP AS _InsuranceClaimPayment ON InsuranceClaim = _InsuranceClaimPayment.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmReserveShadow2TP AS _InsuranceClaimReserve ON InsuranceClaim = _InsuranceClaimReserve.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmPerformerShadow2TP AS _InsuranceClaimPerformer ON InsuranceClaim = _InsuranceClaimPerformer.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN R_InsurClmDmgdObjectShadow2TP AS _InsuranceClaimDamagedObject ON InsuranceClaim = _InsuranceClaimDamagedObject.InsuranceClaim  -- association [0..*]
;

Learn More