I_INSURANCECLAIMITEMGROUPING

CDS View

Anspruchsposten Gruppierung

I_INSURANCECLAIMITEMGROUPING is a CDS View in S/4HANA. Anspruchsposten Gruppierung. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_InsuranceClaimItemGroupingTP view_entity from TRANSACTIONAL Insurance Claim Item Grouping - TP
R_InsurClmSubclmItemGroupingTP view_entity from TRANSACTIONAL Insurance Claim Sub Claim Item Grouping - TP
@AbapCatalog.sqlViewName: 'ITEMGROUPING'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Anspruchsposten Gruppierung'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view I_InsuranceClaimItemGrouping
  as select from iclprocure
  
  association [1..1] to I_InsuranceClaim as _InsuranceClaim on  $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim

{
  key claim                                                       as InsuranceClaim,
  key subclaim                                                    as InsurClmPaymentSubclaim,
  key procurement                                                 as InsuranceClaimProcurementID,
      cast( changetime as icl_achangetime_fiori preserving type ) as ChangedOnDateTime,
      changedby                                                   as LastChangedByUser,
      cast( createtime as icl_createutc_fiori   preserving type ) as CreationDateTime,
      createdby                                                   as CreatedByUser,
      pdoctype                                                    as InsurClmItemGroupingBnftType,
      pdoccat                                                     as InsurClmItemGroupingCategory,
      issuedate                                                   as InsurClmItemGroupingIssueDate,
      receivedate                                                 as InsurClmItmGroupingReceiveDate,
      datefrom                                                    as InsurClmItmGroupingFromDate,
      timefrom                                                    as InsurClmItemGroupingFromTime,
      dateto                                                      as InsurClmItemGroupingToDate,
      timeto                                                      as InsurClmItemGroupingToTime,
      issuedate_prescr                                            as InsurClmIssuePrescriptionDate,
      acquisitiondate                                             as InsurClmAcquisitionDate,
      currency                                                    as InsurClmItemGroupingCurrency,
      amount1                                                     as InsurClmItemGroupingAmount,
      discountamount                                              as InsurClmItmGrpDiscountAmount,
      discountpercent                                             as InsurClmItmGrpDiscPercentAmt,
      accident                                                    as InsurClmItemGroupingAccident,
      subrogation                                                 as InsurClmItmGroupingSubrogation,
      duedate                                                     as InsurClmItmGroupingDueDate,
      duedate_orig                                                as InsurClmItmGrpOriginDueDate,
      status                                                      as InsurClmItemGroupingStatus,
      statreason                                                  as InsurClmStatReason,
      reason                                                      as InsurClmItemGroupingReason,
      cause                                                       as InsurClmItemGroupingCause,
      pdoccattype                                                 as InsurClmItemGrpCategoryType,
      datasource                                                  as InsurClmItemGroupingDataOrigin,
      completiondate                                              as InsurClmItemGrpCompletionDate,
      fee                                                         as InsurClmItmGroupingFeeAmount,
      matlabcost                                                  as InsurClmItmGrpMatLabCostAmount,
      addcost                                                     as InsurClmItmGrpAddCostsAmount,
      subsidypercent                                              as InsurClmItmGrpSubsidyPctAmt,
      subsidyamount                                               as InsurClmItmGrpSubsidyAmt,
      cancel                                                      as InsurClmItmGrpStateIsCancelled,
      rejected                                                    as InsurClmItmGrpStateIsRejected,
      insuspense                                                  as InsurClmItmGrpStatIsInSuspense,
      inprocess                                                   as InsurClmItmGrpStateIsInProcess,
      released                                                    as InsurClmItmGrpStateIsReleased,
      xfinished                                                   as InsurClmItmGrpStateIsFinish,
      ordered                                                     as InsurClmItmGrpStatIsCommission,
      transferred                                                 as InsurClmItmGrpStatIsReassigned,
      tobeapproved                                                as InsurClmItmGrpIsToBeApproved,
      xcliniccard                                                 as InsurClmItmGrpIsClinicCard,
      xrequest                                                    as InsurClmItmGrpIsReceivable,
      method                                                      as InsurClmPaytMethod,
      addrnumber                                                  as InsurClmPaytCheckRcpntAddrNmbr,
      bkid                                                        as InsurClmBankID,
      assign_guid                                                 as InsurClmAssignUUID,
      
      //Associations

      _InsuranceClaim
}

where
      deleted <> #boole.'X'