I_InsurClaimBundleTP

DDL: I_INSURCLAIMBUNDLETP Type: view_entity TRANSACTIONAL
46 Fields 1 Data Sources

Insurance Claim Bundle - TP

I_InsurClaimBundleTP is a Transactional CDS View that provides data about "Insurance Claim Bundle - TP" in SAP S/4HANA. It reads from 1 data source (R_InsurClaimBundleTP) and exposes 46 fields with key fields InsurClmActive, InsurClaimBundle.

Data Sources (1)

SourceAliasJoin Type
R_InsurClaimBundleTP R_InsurClaimBundleTP projection

Annotations (15)

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 - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.sapObjectNodeType.name InsuranceClaimBundle view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (46)

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

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 I_InsurClaimBundleTP.
-- 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 I_InsurClaimBundleTP 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
FROM R_InsurClaimBundleTP
;

Learn More