A_INS_ClaimItemGrouping

DDL: A_INS_CLAIMITEMGROUPING Type: view_entity CONSUMPTION
76 Fields 1 Data Sources

Claim Item Grouping Header

A_INS_ClaimItemGrouping is a Consumption CDS View that provides data about "Claim Item Grouping Header" in SAP S/4HANA. It reads from 1 data source (R_INS_ClaimItemGroupingTP) and exposes 76 fields with key fields InsurClmActive, InsuranceClaim, InsurClmPaymentSubclaim, InsuranceClaimProcurementID.

Data Sources (1)

SourceAliasJoin Type
R_INS_ClaimItemGroupingTP R_INS_ClaimItemGroupingTP projection

Annotations (14)

NameValueLevelField
EndUserText.label Claim Item Grouping Header view
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
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 INS_ClaimItemGrouping_Type view

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmPaymentSubclaim InsurClmPaymentSubclaim Subclaim
KEY InsuranceClaimProcurementID InsuranceClaimProcurementID ClaimItem Gpng
InsurClmProcmtHandle InsurClmProcmtHandle Clm Item Grpng
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmItemGroupingBnftType InsurClmItemGroupingBnftType Benefit Type
InsurClmItemGroupingCategory InsurClmItemGroupingCategory ClmItemGrpngCat
InsurClmItemGroupingIssueDate InsurClmItemGroupingIssueDate Date Created
InsurClmItmGroupingReceiveDate InsurClmItmGroupingReceiveDate Date Received
InsurClmItmGroupingFromDate InsurClmItmGroupingFromDate Period From
InsurClmItemGroupingFromTime InsurClmItemGroupingFromTime Period From
InsurClmItemGroupingToDate InsurClmItemGroupingToDate To
InsurClmItemGroupingToTime InsurClmItemGroupingToTime To
InsurClmIssuePrescriptionDate InsurClmIssuePrescriptionDate PrescrDate(Inv)
InsurClmAcquisitionDate InsurClmAcquisitionDate Date Entered
InsurClmItemGroupingCurrency InsurClmItemGroupingCurrency Currency
InsurClmItemGroupingAmount InsurClmItemGroupingAmount Amount
InsurClmItmGrpDiscountAmount InsurClmItmGrpDiscountAmount Cash Discount
InsurClmItmGrpDiscPercentAmt InsurClmItmGrpDiscPercentAmt % Cash Discount
InsurClmItemGroupingAccident InsurClmItemGroupingAccident Accident Indic.
InsurClmItmGroupingSubrogation InsurClmItmGroupingSubrogation RecoveryClm Ind
InsurClmItmGroupingDueDate InsurClmItmGroupingDueDate Due Date
InsurClmItmGrpOriginDueDate InsurClmItmGrpOriginDueDate Due Date Origin
InsurClmItemGroupingStatus InsurClmItemGroupingStatus Status
InsurClmStatReason InsurClmStatReason Status Reason
InsurClmItemGroupingReason InsurClmItemGroupingReason Reason
InsurClmItemGroupingCause InsurClmItemGroupingCause Specification
InsurClmItemGrpCategoryType InsurClmItemGrpCategoryType ClmItmGpCatType
InsurClmItemGroupingDataOrigin InsurClmItemGroupingDataOrigin Data Origin
InsurClmItemGrpCompletionDate InsurClmItemGrpCompletionDate Completion Date
InsurClmItmGroupingFeeAmount InsurClmItmGroupingFeeAmount Fee
InsurClmItmGrpMatLabCostAmount InsurClmItmGrpMatLabCostAmount Mat+Lab Costs
InsurClmItmGrpAddCostsAmount InsurClmItmGrpAddCostsAmount Other Costs
InsurClmItmGrpSubsidyPctAmt InsurClmItmGrpSubsidyPctAmt Subsidy %
InsurClmItmGrpSubsidyAmt InsurClmItmGrpSubsidyAmt Subsidy
InsurClmItmGrpStateIsCancelled InsurClmItmGrpStateIsCancelled Cancelled
InsurClmItmGrpStateIsRejected InsurClmItmGrpStateIsRejected Rejected
InsurClmItmGrpStatIsInSuspense InsurClmItmGrpStatIsInSuspense Pending
InsurClmItmGrpStateIsInProcess InsurClmItmGrpStateIsInProcess In Process
InsurClmItmGrpStateIsReleased InsurClmItmGrpStateIsReleased Released
InsurClmItmGrpStateIsFinish InsurClmItmGrpStateIsFinish Complete
InsurClmItmGrpStatIsCommission InsurClmItmGrpStatIsCommission Commissioned
InsurClmItmGrpStatIsReassigned InsurClmItmGrpStatIsReassigned Reassigned
InsurClmItmGrpIsToBeApproved InsurClmItmGrpIsToBeApproved To Be Approved
InsurClmItmGrpIsClinicCard InsurClmItmGrpIsClinicCard Clinic Card
InsurClmItmGrpIsReceivable InsurClmItmGrpIsReceivable Receivable
InsurClmPaytMethod InsurClmPaytMethod Payment Method
InsurClmPaytCheckRcpntAddrNmbr InsurClmPaytCheckRcpntAddrNmbr Address
InsurClmBankID InsurClmBankID Bank Details
InsurClmAssignUUID InsurClmAssignUUID Link UUID
InsClmBndlRefToCollvInvcNmbr InsClmBndlRefToCollvInvcNmbr Ext.Coll.Ref.
InsurClmExtDocumentNumber InsurClmExtDocumentNumber Ext. Doc. No.
InsurClmItemGroupingHospital InsurClmItemGroupingHospital Hosp-Intl ID
InsurClmItemGroupingExtDoc InsurClmItemGroupingExtDoc File Number
InsurClmItemGroupingReference InsurClmItemGroupingReference ClmItmGp Ref.
InsurClmItmGroupingCoPayPct InsurClmItmGroupingCoPayPct Copayment (%)
InsurClmItmGroupingOrgSubclm InsurClmItmGroupingOrgSubclm Original Subclaim Multiple Prescription/Curr.Subclm Appraisl
InsurClmItmGroupingOriginalClm InsurClmItmGroupingOriginalClm Original Claim Item Grouping of Multiple Prescription
InsurClmItmGroupingSetOrderDte InsurClmItmGroupingSetOrderDte Set Order Date
InsurClmItmGrpCatalogItemValue InsurClmItmGrpCatalogItemValue
InsurClmItmGrpSentDateTime InsurClmItmGrpSentDateTime Last Changed At
InsurClmItmGrpIsSentExt InsurClmItmGrpIsSentExt Send Extl Iface
InsurClmItmGrpIsReceivedExt InsurClmItmGrpIsReceivedExt Receipt Extrnl
InsurClmItmGrpRejectionReason InsurClmItmGrpRejectionReason Rejection Reasn
InsurClmItmGrpCompareFromDate InsurClmItmGrpCompareFromDate Period From
InsurClmItmGrpComparisonToDate InsurClmItmGrpComparisonToDate Comp.Period To
InsurClmItmGrpPayoutScenario InsurClmItmGrpPayoutScenario Rept Payt Scen.
InsurClmItmGrpPreliminaryState InsurClmItmGrpPreliminaryState
InsurClmPaymentFrequencyPlan InsurClmPaymentFrequencyPlan Payment Freq.
InsurClmItmGrpgSqnc InsurClmItmGrpgSqnc
InsuranceDataAgingObjectDate InsuranceDataAgingObjectDate Data Aging

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_INS_ClaimItemGrouping.
-- 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_INS_ClaimItemGrouping AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmPaymentSubclaim,
  InsuranceClaimProcurementID,
  InsurClmProcmtHandle,
  ChangedOnDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmItemGroupingBnftType,
  InsurClmItemGroupingCategory,
  InsurClmItemGroupingIssueDate,
  InsurClmItmGroupingReceiveDate,
  InsurClmItmGroupingFromDate,
  InsurClmItemGroupingFromTime,
  InsurClmItemGroupingToDate,
  InsurClmItemGroupingToTime,
  InsurClmIssuePrescriptionDate,
  InsurClmAcquisitionDate,
  InsurClmItemGroupingCurrency,
  InsurClmItemGroupingAmount,
  InsurClmItmGrpDiscountAmount,
  InsurClmItmGrpDiscPercentAmt,
  InsurClmItemGroupingAccident,
  InsurClmItmGroupingSubrogation,
  InsurClmItmGroupingDueDate,
  InsurClmItmGrpOriginDueDate,
  InsurClmItemGroupingStatus,
  InsurClmStatReason,
  InsurClmItemGroupingReason,
  InsurClmItemGroupingCause,
  InsurClmItemGrpCategoryType,
  InsurClmItemGroupingDataOrigin,
  InsurClmItemGrpCompletionDate,
  InsurClmItmGroupingFeeAmount,
  InsurClmItmGrpMatLabCostAmount,
  InsurClmItmGrpAddCostsAmount,
  InsurClmItmGrpSubsidyPctAmt,
  InsurClmItmGrpSubsidyAmt,
  InsurClmItmGrpStateIsCancelled,
  InsurClmItmGrpStateIsRejected,
  InsurClmItmGrpStatIsInSuspense,
  InsurClmItmGrpStateIsInProcess,
  InsurClmItmGrpStateIsReleased,
  InsurClmItmGrpStateIsFinish,
  InsurClmItmGrpStatIsCommission,
  InsurClmItmGrpStatIsReassigned,
  InsurClmItmGrpIsToBeApproved,
  InsurClmItmGrpIsClinicCard,
  InsurClmItmGrpIsReceivable,
  InsurClmPaytMethod,
  InsurClmPaytCheckRcpntAddrNmbr,
  InsurClmBankID,
  InsurClmAssignUUID,
  InsClmBndlRefToCollvInvcNmbr,
  InsurClmExtDocumentNumber,
  InsurClmItemGroupingHospital,
  InsurClmItemGroupingExtDoc,
  InsurClmItemGroupingReference,
  InsurClmItmGroupingCoPayPct,
  InsurClmItmGroupingOrgSubclm,
  InsurClmItmGroupingOriginalClm,
  InsurClmItmGroupingSetOrderDte,
  InsurClmItmGrpCatalogItemValue,
  InsurClmItmGrpSentDateTime,
  InsurClmItmGrpIsSentExt,
  InsurClmItmGrpIsReceivedExt,
  InsurClmItmGrpRejectionReason,
  InsurClmItmGrpCompareFromDate,
  InsurClmItmGrpComparisonToDate,
  InsurClmItmGrpPayoutScenario,
  InsurClmItmGrpPreliminaryState,
  InsurClmPaymentFrequencyPlan,
  InsurClmItmGrpgSqnc,
  InsuranceDataAgingObjectDate
FROM R_INS_ClaimItemGroupingTP
;

Learn More