A_InsurClmSubclmItemGrouping

DDL: A_INSURCLMSUBCLMITEMGROUPING Type: view_entity CONSUMPTION Package: ICL_VDM_CLAIM_API

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 52 fields with key fields InsuranceClaim, InsurClmPaymentSubclaim, InsuranceClaimProcurementID. It is exposed through 1 OData service (API_INSURANCECLAIM). Part of development package ICL_VDM_CLAIM_API.

Data Sources (1)

SourceAliasJoin Type
R_InsurClmSubclmItemGroupingTP R_InsurClmSubclmItemGroupingTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Subclaim Item Grouping 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

OData Services (1)

ServiceBindingVersionContractRelease
API_INSURANCECLAIM API_INSURANCECLAIM V4 C2 C1

Fields (52)

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

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
FROM R_InsurClmSubclmItemGroupingTP
;