R_INS_ClaimServicesDraft

DDL: R_INS_CLAIMSERVICESDRAFT Type: view_entity BASIC

Insurance Claim - Draft

R_INS_ClaimServicesDraft is a Basic CDS View that provides data about "Insurance Claim - Draft" in SAP S/4HANA. It reads from 1 data source (iclclaimdraft1) and exposes 103 fields with key fields InsurClmActive, InsuranceClaim, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
iclclaimdraft1 iclclaimdraft1 from

Annotations (13)

NameValueLevelField
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 500 view
AbapCatalog.extensibility.quota.maximumBytes 5000 view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Insurance Claim - Draft view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC 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 (103)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive insurclmactive Active/Suspense
KEY InsuranceClaim insuranceclaim Claim Number
KEY DraftUUID draftuuid UUID
ChangedOnDateTime changedondatetime Last Changed At
LastChangedByUser lastchangedbyuser User Name
InsurClmDatabaseLineStatus insurclmdatabaselinestatus Status
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
InsurClmWholeClmChgdBy insurclmwholeclmchgdby Last Changed by
InsurClmWholeClmChgDteTme insurclmwholeclmchgdtetme Last Changed At
InsurClmExternalNumberCategory insurclmexternalnumbercategory External No.Category
InsuranceClaimExternalNumber insuranceclaimexternalnumber External Number
InsurClmLifeCycSts insurclmlifecycsts Status
InsurClmStsChgdOnDteTime insurclmstschgdondtetime Last Changed At
InsuranceClaimIsStatusHandler insuranceclaimisstatushandler ClmHandlngActve
InsuranceClaimIsNoClaimMade insuranceclaimisnoclaimmade No Claim Made
InsuranceClaimIsStatusClosed insuranceclaimisstatusclosed Closed
InsurClmStatReason insurclmstatreason Status Reason
InsurClmIncdntType insurclmincdnttype Incident Type
InsurClmType insurclmtype Claim Type
InsurClmTypeGeneration insurclmtypegeneration Generation
InsurClmTypeVers insurclmtypevers Clm Type Versn
InsuranceClaimBundleLossEvent insuranceclaimbundlelossevent CumulativeEvent
InsurClmPolicyProduct insurclmpolicyproduct Policy Product
InsurClmPolicyProdGeneration insurclmpolicyprodgeneration Generation
InsurClmPolicyProductVersion insurclmpolicyproductversion Version
InsurClmContractLastRenewal insurclmcontractlastrenewal Last Renewal
InsuranceContract insurancecontract Contract
InsurClmCauseOfLoss insurclmcauseofloss Cause
InsuranceClaimReinsurancePeril insuranceclaimreinsuranceperil Peril
InsurClmDateOfLoss insurclmdateofloss Date of Loss
InsurClmTimeOfLoss insurclmtimeofloss Time
InsurClmTimeZoneOfLoss insurclmtimezoneofloss Time Zone
InsuranceClaimIsDateEstimate insuranceclaimisdateestimate Date Estimated
InsuranceClaimDateChangeReason insuranceclaimdatechangereason Reason f.Change
InsurClmReportedDate insurclmreporteddate Repd to Insurer
InsurClmAgentReportedDate insurclmagentreporteddate Reptd to Agent
InsurClmLossLocAddressID insurclmlosslocaddressid Loss Location
InsurClmIsRptdToAuth insurclmisrptdtoauth Reported
InsurClmSensitiveClaim insurclmsensitiveclaim Sensitive Claim
InsurClmComplexity insurclmcomplexity Complexity
InsurClmJurisdictionCountry insurclmjurisdictioncountry C/R Juris.
InsurClmJurisdictionRegion insurclmjurisdictionregion Jurisd. Region
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
InsurClmCovered insurclmcovered Compensable
InsurClmAuthznGrp insurclmauthzngrp AuthGroup (VIP)
InsurClmIsEntrInPaytAmtAuthzns insurclmisentrinpaytamtauthzns EntryClaimB
InsuranceClaimIsNoNotif insuranceclaimisnonotif Not Notif. Mode
InsuranceClaimIsReserve insuranceclaimisreserve Reserve Exists
InsurClmBenefitTypeTree insurclmbenefittypetree Ben. Type Tree
InsurClmBnftTypeTreeGeneration insurclmbnfttypetreegeneration Generation
InsurClmBnftTypeTreeVersion insurclmbnfttypetreeversion Version
InsurClmWrkflwExecDteTme insurclmwrkflwexecdtetme Last Renewal
InsurClmWorkflowStatus insurclmworkflowstatus WF Status
InsurClmIsDummyClaim insurclmisdummyclaim Dummy Claim
InsurClmVersionChangeTime insurclmversionchangetime Read Time
InsurClmOpenDate insurclmopendate Opened On
InsurClmIsWithoutProduct insurclmiswithoutproduct Without Product
InsuranceClaimMaxItemNumber insuranceclaimmaxitemnumber Highest ClmItNo
InsurClmAssignUUID insurclmassignuuid Link UUID
InsurClmSecondInjuryFundStatus insurclmsecondinjuryfundstatus SIF Status
InsurClmIncdntInvstgnSts insurclmincdntinvstgnsts Match Status
InsuranceClaimEffectiveDate insuranceclaimeffectivedate Validity Date
InsuranceClaimLossRepDate insuranceclaimlossrepdate Date on Request
InsuranceClaimIsLumpSumOption insuranceclaimislumpsumoption Option Exercisd
InsurClmStatutoryPensionType insurclmstatutorypensiontype Statut. Pension
InsurClmWithdrawAmt insurclmwithdrawamt Withdrawal Amt
InsurClmWithdrawCrcy insurclmwithdrawcrcy Currency
InsurClmWthdrwlSqnc insurclmwthdrwlsqnc Withdrawal Seq.
InsuranceClaimAlternateBenefit insuranceclaimalternatebenefit Alt.Ben.Values
InsuranceClaimSpecialRiskNotif insuranceclaimspecialrisknotif Spec.Risk Notif
InsuranceClaimNotifReason insuranceclaimnotifreason SpecRisk NotifR
InsuranceClaimAutoResubmission insuranceclaimautoresubmission Autom.Resubmssn
InsuranceClaimFollowUpDate insuranceclaimfollowupdate 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
InsuranceClaimDraftIdentifier insuranceclaimdraftidentifier Claim Number
InsurClmArchivingStatus insurclmarchivingstatus Archiving Status
InsurClmArchResubmsnDte insurclmarchresubmsndte Resubmission Date
InsurClmArchRjcnRsn insurclmarchrjcnrsn Rejection Reason
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_INS_ClaimServicesDraft.
-- 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_INS_ClaimServicesDraft AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  DraftUUID,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  CreatedByUser,
  CreationDateTime,
  InsurClmWholeClmChgdBy,
  InsurClmWholeClmChgDteTme,
  InsurClmExternalNumberCategory,
  InsuranceClaimExternalNumber,
  InsurClmLifeCycSts,
  InsurClmStsChgdOnDteTime,
  InsuranceClaimIsStatusHandler,
  InsuranceClaimIsNoClaimMade,
  InsuranceClaimIsStatusClosed,
  InsurClmStatReason,
  InsurClmIncdntType,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsuranceClaimBundleLossEvent,
  InsurClmPolicyProduct,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmContractLastRenewal,
  InsuranceContract,
  InsurClmCauseOfLoss,
  InsuranceClaimReinsurancePeril,
  InsurClmDateOfLoss,
  InsurClmTimeOfLoss,
  InsurClmTimeZoneOfLoss,
  InsuranceClaimIsDateEstimate,
  InsuranceClaimDateChangeReason,
  InsurClmReportedDate,
  InsurClmAgentReportedDate,
  InsurClmLossLocAddressID,
  InsurClmIsRptdToAuth,
  InsurClmSensitiveClaim,
  InsurClmComplexity,
  InsurClmJurisdictionCountry,
  InsurClmJurisdictionRegion,
  InsurClmActyAssgmtSts,
  InsuranceClaimOwnerType,
  InsuranceClaimOwner,
  InsuranceClaimOwnerTypeGroup,
  InsuranceClaimOwnerGroup,
  InsuranceClaimIsCumulative,
  InsuranceClaimViewFault,
  InsurClmVwFaultPlcyHldr,
  InsurClmIsThirdPartyKnown,
  InsurClmCovered,
  InsurClmAuthznGrp,
  InsurClmIsEntrInPaytAmtAuthzns,
  InsuranceClaimIsNoNotif,
  InsuranceClaimIsReserve,
  InsurClmBenefitTypeTree,
  InsurClmBnftTypeTreeGeneration,
  InsurClmBnftTypeTreeVersion,
  InsurClmWrkflwExecDteTme,
  InsurClmWorkflowStatus,
  InsurClmIsDummyClaim,
  InsurClmVersionChangeTime,
  InsurClmOpenDate,
  InsurClmIsWithoutProduct,
  InsuranceClaimMaxItemNumber,
  InsurClmAssignUUID,
  InsurClmSecondInjuryFundStatus,
  InsurClmIncdntInvstgnSts,
  InsuranceClaimEffectiveDate,
  InsuranceClaimLossRepDate,
  InsuranceClaimIsLumpSumOption,
  InsurClmStatutoryPensionType,
  InsurClmWithdrawAmt,
  InsurClmWithdrawCrcy,
  InsurClmWthdrwlSqnc,
  InsuranceClaimAlternateBenefit,
  InsuranceClaimSpecialRiskNotif,
  InsuranceClaimNotifReason,
  InsuranceClaimAutoResubmission,
  InsuranceClaimFollowUpDate,
  InsuranceClaimProcessingDate,
  InsuranceClaimStatusObjectNmbr,
  InsuranceClaimDunningStatus,
  InsuranceClaimClearDate,
  InsurClmPremiumBalanceAmount,
  InsurClmPremiumBalanceCurrency,
  InsuranceClaimWithdrawalType,
  InsuranceClaimReactDate,
  InsurClmSpecialRiskMsgDateTime,
  InsurClmIncrrtBnftCalcDateTime,
  InsuranceClaimPolicySystem,
  InsuranceClaimDraftIdentifier,
  InsurClmArchivingStatus,
  InsurClmArchResubmsnDte,
  InsurClmArchRjcnRsn,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM iclclaimdraft1
;