R_InsurClaimBundleDraft

DDL: R_INSURCLAIMBUNDLEDRAFT Type: view_entity BASIC
52 Fields 1 Data Sources

Insurance Claim Bundle Draft

R_InsurClaimBundleDraft is a Basic CDS View that provides data about "Insurance Claim Bundle Draft" in SAP S/4HANA. It reads from 1 data source (iclcceventdraft2) and exposes 52 fields with key fields InsurClmActive, InsurClaimBundle.

Data Sources (1)

SourceAliasJoin Type
iclcceventdraft2 iclcceventdraft2 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 Bundle 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 (52)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive insurclmactive Active/Suspense
KEY InsurClaimBundle insurclaimbundle Claim Bundle
ChangedOnDateTime changedondatetime Last Changed At
LastChangedByUser lastchangedbyuser User Name
InsurClmDatabaseLineStatus insurclmdatabaselinestatus Status
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
InsurClaimBundleType insurclaimbundletype Clm Bundle Type
InsurClaimBundleSubtype insurclaimbundlesubtype ClmBndleSubType
InsurClmBndlCrcyType insurclmbndlcrcytype Currency
InsurClmBndlCompnRsrvAmt insurclmbndlcompnrsrvamt Reserve
InsurClmBndlExpnRsrvAmt insurclmbndlexpnrsrvamt Expense Reserve
InsurClmBndlExtNameId insurclmbndlextnameid External Name
InsurClaimBundleName insurclaimbundlename Name
InsurClmBndlRngeFrmDte insurclmbndlrngefrmdte Date From
InsurClmBndlRngeToDte insurclmbndlrngetodte Date To
InsurClmBndlCoordtrPhNmbr insurclmbndlcoordtrphnmbr Phone
InsurClmBndlLocationType insurclmbndllocationtype Location Type
InsurClmBndlStatus insurclmbndlstatus Status
InsurClmBndlCause insurclmbndlcause Bundle Reason
InsurClmBndlOwner insurclmbndlowner Claim Handler
InsurClmBndlExtCollvInvcNmbr insurclmbndlextcollvinvcnmbr Ext CollInvNo.
InsClmBndlRefToCollvInvcNmbr insclmbndlreftocollvinvcnmbr Ext.Coll.Ref.
InsurClmBndlCollvInvcDte insurclmbndlcollvinvcdte Invoice Date
InsClmBndlCollvInvcNetTotAmt insclmbndlcollvinvcnettotamt NetTotal (CI)
InsurClmBndlPaytLvl insurclmbndlpaytlvl Payment Level
InsurClmBndlDtaSrce insurclmbndldtasrce Data Origin
InsurClmBndlReceiveDate insurclmbndlreceivedate Date Received
InsurClmBndlIsClaimInProcess insurclmbndlisclaiminprocess In Process
InsurClmBndlStsIsReld insurclmbndlstsisreld Released
InsurClmBndlStsIsCancelled insurclmbndlstsiscancelled Cancelled
InsurClmBndlStsIsInProc insurclmbndlstsisinproc In Process
InsurClmBndlNmbrOfClmInProcSts insurclmbndlnmbrofclminprocsts Open Claims
InsurClmBndlIsStsHdlr insurclmbndlisstshdlr Procssng Active
InsurClmWorkflowStatus insurclmworkflowstatus WF Status
InsurClmBndlCollvSubrogtnNmbr insurclmbndlcollvsubrogtnnmbr Coll.Subro/Rcvr
InsurClmBndlSubrogtnClmType insurclmbndlsubrogtnclmtype SubroClaim Type
InsClmBndlStsChgRsnOfSubrogtn insclmbndlstschgrsnofsubrogtn Change Reason
InsurClmBndlBillingDate insurclmbndlbillingdate Billing Date
InsurClmBndlResubmsnDte insurclmbndlresubmsndte Resubmission
InsurClmBndlSubrogtnClmRptDte insurclmbndlsubrogtnclmrptdte SubroClm RptdOn
InsurClmWholeClmChgdBy insurclmwholeclmchgdby Last Changed by
InsurClmWholeClmChgDteTme insurclmwholeclmchgdtetme Last Changed At
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_InsurClaimBundleDraft.
-- 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_InsurClaimBundleDraft AS
SELECT
  InsurClmActive,
  InsurClaimBundle,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  CreationDateTime,
  CreatedByUser,
  InsurClaimBundleType,
  InsurClaimBundleSubtype,
  InsurClmBndlCrcyType,
  InsurClmBndlCompnRsrvAmt,
  InsurClmBndlExpnRsrvAmt,
  InsurClmBndlExtNameId,
  InsurClaimBundleName,
  InsurClmBndlRngeFrmDte,
  InsurClmBndlRngeToDte,
  InsurClmBndlCoordtrPhNmbr,
  InsurClmBndlLocationType,
  InsurClmBndlStatus,
  InsurClmBndlCause,
  InsurClmBndlOwner,
  InsurClmBndlExtCollvInvcNmbr,
  InsClmBndlRefToCollvInvcNmbr,
  InsurClmBndlCollvInvcDte,
  InsClmBndlCollvInvcNetTotAmt,
  InsurClmBndlPaytLvl,
  InsurClmBndlDtaSrce,
  InsurClmBndlReceiveDate,
  InsurClmBndlIsClaimInProcess,
  InsurClmBndlStsIsReld,
  InsurClmBndlStsIsCancelled,
  InsurClmBndlStsIsInProc,
  InsurClmBndlNmbrOfClmInProcSts,
  InsurClmBndlIsStsHdlr,
  InsurClmWorkflowStatus,
  InsurClmBndlCollvSubrogtnNmbr,
  InsurClmBndlSubrogtnClmType,
  InsClmBndlStsChgRsnOfSubrogtn,
  InsurClmBndlBillingDate,
  InsurClmBndlResubmsnDte,
  InsurClmBndlSubrogtnClmRptDte,
  InsurClmWholeClmChgdBy,
  InsurClmWholeClmChgDteTme,
  InsurClmArchivingStatus,
  InsurClmArchResubmsnDte,
  InsurClmArchRjcnRsn,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM iclcceventdraft2
;

Learn More