A_InsurClmSubclmItemGrouping

DDL: A_INSURCLMSUBCLMITEMGROUPING Type: view_entity CONSUMPTION
69 Fields 1 Data Sources

Subclaim Item Grouping

A_InsurClmSubclmItemGrouping is a Consumption CDS View that provides data about "Subclaim Item Grouping" in SAP S/4HANA. It reads from 1 data source (R_InsurClmSubclmItemGroupingTP) and exposes 69 fields with key fields InsuranceClaim, InsurClmPaymentSubclaim, InsuranceClaimProcurementID.

Data Sources (1)

SourceAliasJoin Type
R_InsurClmSubclmItemGroupingTP R_InsurClmSubclmItemGroupingTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Subclaim Item Grouping view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 1000 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 InsurClmSubclmItemGrouping_Type view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmPaymentSubclaim InsurClmPaymentSubclaim Subclaim
KEY InsuranceClaimProcurementID InsuranceClaimProcurementID ClaimItem Gpng
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
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.

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_InsurClmSubclmItemGrouping.
-- 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_InsurClmSubclmItemGrouping AS
SELECT
  InsuranceClaim,
  InsurClmPaymentSubclaim,
  InsuranceClaimProcurementID,
  ChangedOnDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  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
FROM R_InsurClmSubclmItemGroupingTP
;

Learn More