A_InsuranceClaimShadow_2

DDL: A_INSURANCECLAIMSHADOW_2 Type: view_entity CONSUMPTION

Insurance Claim Shadow Table_2

A_InsuranceClaimShadow_2 is a Consumption CDS View that provides data about "Insurance Claim Shadow Table_2" in SAP S/4HANA. It reads from 1 data source (R_InsuranceClaimShadow2TP) and exposes 92 fields with key fields InsuranceClaim, InsurClmChangeDate, InsurClmChangedTime.

Data Sources (1)

SourceAliasJoin Type
R_InsuranceClaimShadow2TP R_InsuranceClaimShadow2TP projection

Annotations (9)

NameValueLevelField
EndUserText.label Insurance Claim Shadow Table_2 view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name InsuranceClaimShadow2_Type view

Fields (92)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmChangeDate InsurClmChangeDate
KEY InsurClmChangedTime InsurClmChangedTime
LastChangeDateTime LastChangeDateTime Timestamp
InsuranceContract InsuranceContract Contract
InsuranceClaimContractControl InsuranceClaimContractControl 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
InsurClmLossDateTime InsurClmLossDateTime
InsurClmCauseOfLoss InsurClmCauseOfLoss Cause
InsurClmLossLocAddressID InsurClmLossLocAddressID Loss Location
InsurClmTypeGeneration InsurClmTypeGeneration Generation
InsurClmTypeVers InsurClmTypeVers Clm Type Versn
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
InsurClmStatutoryPensionType InsurClmStatutoryPensionType Statut. Pension
InsurClmBndlWithdrawAmt InsurClmBndlWithdrawAmt
InsurClmBndlWithdrawCrcy InsurClmBndlWithdrawCrcy
InsurClmBndlWthdrwlSqnc InsurClmBndlWthdrwlSqnc
InsuranceClaimAlternateBenefit InsuranceClaimAlternateBenefit Alt.Ben.Values
InsuranceClaimSpecialRiskNotif InsuranceClaimSpecialRiskNotif Spec.Risk Notif
InsuranceClaimNotifReason InsuranceClaimNotifReason SpecRisk NotifR
InsuranceClaimAutoResubmission InsuranceClaimAutoResubmission Autom.Resubmssn
InsClmAutoResubmsnDte InsClmAutoResubmsnDte
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

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 A_InsuranceClaimShadow_2.
-- 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 A_InsuranceClaimShadow_2 AS
SELECT
  InsuranceClaim,
  InsurClmChangeDate,
  InsurClmChangedTime,
  LastChangeDateTime,
  InsuranceContract,
  InsuranceClaimContractControl,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmLifeCycSts,
  InsurClmStatReason,
  InsurClmType,
  InsurClmAuthznGrp,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmIncdntType,
  InsurClmLossDateTime,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  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 R_InsuranceClaimShadow2TP
;