I_InsurApplCoverageBonusMalus

DDL: I_INSURAPPLCOVERAGEBONUSMALUS Type: view_entity COMPOSITE

Cvrg Bn Ml of Cvrg Pckg in Insur Appl

I_InsurApplCoverageBonusMalus is a Composite CDS View that provides data about "Cvrg Bn Ml of Cvrg Pckg in Insur Appl" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyBonusMalusBasic, P_InsurPolicyJournalKeys) and exposes 65 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyBonusMalusID. It has 11 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyBonusMalusBasic BonusMalus inner
P_InsurPolicyJournalKeys PlcyJrnl from

Associations (11)

CardinalityTargetAliasCondition
[1..1] I_InsurPlcyIntPremiumLevelLink _InsurPlcyIntPremiumLevelLink $projection.InsurPlcyIntPremiumLevel = _InsurPlcyIntPremiumLevelLink.InsurPlcyIntPremiumLevel and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyIntPremiumLevelLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyExtPremiumLevelLink _InsurPlcyExtPremiumLevelLink $projection.InsurPlcyExtPremiumLevel = _InsurPlcyExtPremiumLevelLink.InsurPlcyExtPremiumLevel and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyExtPremiumLevelLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyBnMlOriginNameLink _InsurPlcyBnMlOriginNameLink $projection.InsurPlcyBonusMalusOrigin = _InsurPlcyBnMlOriginNameLink.InsurPlcyBonusMalusOrigin and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyBnMlOriginNameLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyClsfctnRsnNameLink _InsurPlcyClsfctnRsnNameLink $projection.InsurPlcyClassificationReason = _InsurPlcyClsfctnRsnNameLink.InsurPlcyClassificationReason and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyClsfctnRsnNameLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyBnMlPremModelLink _InsurPlcyBnMlPremModelLink $projection.InsurPlcyBnMlPremiumModel = _InsurPlcyBnMlPremModelLink.InsurPlcyBnMlPremiumModel and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyBnMlPremModelLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyBnMlCategoryLink _InsurPlcyBnMlCategoryLink $projection.InsurPlcyBonusMalusCategory = _InsurPlcyBnMlCategoryLink.InsurPlcyBonusMalusCategory and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyBnMlCategoryLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyPrvInsRatgModelLink _InsurPlcyPrvInsRatgModelLink $projection.InsurPlcyPrevInsrrRatingModel = _InsurPlcyPrvInsRatgModelLink.InsurPlcyPrevInsrrRatingModel and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyPrvInsRatgModelLink.InsurPlcyBonusMalusTemplate
[1..1] I_InsurPlcyIntRatingModelLink _InsurPlcyIntRatingModelLink $projection.InsurPlcyIntRatingModel = _InsurPlcyIntRatingModelLink.InsurPlcyIntRatingModel and $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyIntRatingModelLink.InsurPlcyBonusMalusTemplate
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[0..*] I_InsurApplCvrgBonusMalusOwner _InsurApplCvrgBonusMalusOwner
[0..*] I_InsurApplCvrgBonusMalusCert _InsurApplCvrgBonusMalusCert

Annotations (11)

NameValueLevelField
EndUserText.label Cvrg Bn Ml of Cvrg Pckg in Insur Appl view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyBonusMalusID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IACvPckgCvBnMl view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyBonusMalusBasic InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyBonusMalusBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyBonusMalusBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyBonusMalusBasic InsurPlcyCoverageID
KEY InsurPlcyBonusMalusID I_InsurPlcyBonusMalusBasic InsurPlcyBonusMalusID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyBonusMalusBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyBonusMalusBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyBonusMalusBasic InsurPlcyProductPackageID
InsuranceBonusMalus I_InsurPlcyBonusMalusBasic InsuranceBonusMalus
InsurPlcyBonusMalusPremiumRate I_InsurPlcyBonusMalusBasic InsurPlcyBonusMalusPremiumRate
InsurPlcyBonusMalusTemplate I_InsurPlcyBonusMalusBasic InsurPlcyBonusMalusTemplate
InsurPlcyAssignmentMode I_InsurPlcyBonusMalusBasic InsurPlcyAssignmentMode
InsurPlcyFirstClfnReason I_InsurPlcyBonusMalusBasic InsurPlcyFirstClfnReason
InsurPlcyIntPremiumLevel I_InsurPlcyBonusMalusBasic InsurPlcyIntPremiumLevel
InsurPlcyExtPremiumLevel I_InsurPlcyBonusMalusBasic InsurPlcyExtPremiumLevel
InsurPlcyPrevInsurerCompanyID I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsurerCompanyID
InsurPlcyPrvInsBranchOfficeID I_InsurPlcyBonusMalusBasic InsurPlcyPrvInsBranchOfficeID
InsurPlcyPrevInsurerCheckValue I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsurerCheckValue
InsurPlcyInsuranceType I_InsurPlcyBonusMalusBasic InsurPlcyInsuranceType
InsurPlcyBonusMalusOrigin I_InsurPlcyBonusMalusBasic InsurPlcyBonusMalusOrigin
InsurPlcyPeriodBeginDate I_InsurPlcyBonusMalusBasic InsurPlcyPeriodBeginDate
InsurPlcyPeriodEndDate I_InsurPlcyBonusMalusBasic InsurPlcyPeriodEndDate
InsurPlcyClassificationReason I_InsurPlcyBonusMalusBasic InsurPlcyClassificationReason
InsurPlcyBnMlPremiumModel I_InsurPlcyBonusMalusBasic InsurPlcyBnMlPremiumModel
InsurPlcyRatingPremiumRate I_InsurPlcyBonusMalusBasic InsurPlcyRatingPremiumRate
InsurPlcyBonusMalusCategory I_InsurPlcyBonusMalusBasic InsurPlcyBonusMalusCategory
InsurPlcyPrevInsrrRatingModel I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsrrRatingModel
InsurPlcyIntRatingModel I_InsurPlcyBonusMalusBasic InsurPlcyIntRatingModel
InsurPlcyIntNumberOfPauseDays I_InsurPlcyBonusMalusBasic InsurPlcyIntNumberOfPauseDays
InsurPlcyPrvInsNrOfPauseDays I_InsurPlcyBonusMalusBasic InsurPlcyPrvInsNrOfPauseDays
InsurPlcyNumberOfPauseDays I_InsurPlcyBonusMalusBasic InsurPlcyNumberOfPauseDays
InsurPlcyIntNumberOfClaims I_InsurPlcyBonusMalusBasic InsurPlcyIntNumberOfClaims
InsurPlcyPrvInsNumberOfClaims I_InsurPlcyBonusMalusBasic InsurPlcyPrvInsNumberOfClaims
InsurPlcyNumberOfClaims I_InsurPlcyBonusMalusBasic InsurPlcyNumberOfClaims
InsurPlcyPrevInsrrContrEndDate I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsrrContrEndDate
InsurPlcyValidityBeginDate I_InsurPlcyBonusMalusBasic InsurPlcyValidityBeginDate
InsurPlcyBnMlLifeCycleStatus I_InsurPlcyBonusMalusBasic InsurPlcyBnMlLifeCycleStatus
InsurPlcyBnMlExtPremiumRate I_InsurPlcyBonusMalusBasic InsurPlcyBnMlExtPremiumRate
InsurPlcyBnMlPrevInsrrAddition I_InsurPlcyBonusMalusBasic InsurPlcyBnMlPrevInsrrAddition
InsurPlcyBnMlInternalAddition I_InsurPlcyBonusMalusBasic InsurPlcyBnMlInternalAddition
InsurLicensePlateNumber I_InsurPlcyBonusMalusBasic InsurLicensePlateNumber
InsurPlcyDriversLicenseIsChkd I_InsurPlcyBonusMalusBasic InsurPlcyDriversLicenseIsChkd
InsurPlcyPrevInsurerPolicyID I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsurerPolicyID
InsurPlcyRefcdBonusMalus I_InsurPlcyBonusMalusBasic InsurPlcyRefcdBonusMalus
InsurPlcyInsrdVehNumberOfSeats I_InsurPlcyBonusMalusBasic InsurPlcyInsrdVehNumberOfSeats
InsurPlcyPrevInsrrDiscBaseYear I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsrrDiscBaseYear
InsurPlcyIntDiscountBaseYear I_InsurPlcyBonusMalusBasic InsurPlcyIntDiscountBaseYear
InsurPlcyDiffntBnMlOwnerDesc I_InsurPlcyBonusMalusBasic InsurPlcyDiffntBnMlOwnerDesc
InsurPlcyBnMlCertIsReceived I_InsurPlcyBonusMalusBasic InsurPlcyBnMlCertIsReceived
InsurPlcyTypeOfRelatedContract I_InsurPlcyBonusMalusBasic InsurPlcyTypeOfRelatedContract
InsurPlcyBusinessObject I_InsurPlcyBonusMalusBasic InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyBonusMalusBasic LastChangeDateTime
_InsurApplContrCoverage _InsurApplContrCoverage
_InsurApplCvrgBonusMalusOwner _InsurApplCvrgBonusMalusOwner
_InsurApplCvrgBonusMalusCert _InsurApplCvrgBonusMalusCert
_InsurPlcyIntPremiumLevelLink _InsurPlcyIntPremiumLevelLink
_InsurPlcyExtPremiumLevelLink _InsurPlcyExtPremiumLevelLink
_InsurPlcyBnMlOriginNameLink _InsurPlcyBnMlOriginNameLink
_InsurPlcyClsfctnRsnNameLink _InsurPlcyClsfctnRsnNameLink
_InsurPlcyBnMlPremModelLink _InsurPlcyBnMlPremModelLink
_InsurPlcyBnMlCategoryLink _InsurPlcyBnMlCategoryLink
_InsurPlcyPrvInsRatgModelLink _InsurPlcyPrvInsRatgModelLink
_InsurPlcyIntRatingModelLink _InsurPlcyIntRatingModelLink
_InsurPlcyTemplateT _InsurPlcyTemplateT
@EndUserText.label: 'Cvrg Bn Ml of Cvrg Pckg in Insur Appl'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking: #('TRANSACTIONAL_DATA'),
privilegedAssociations: [  '_InsurApplCvrgBonusMalusOwner' ]
}
@ObjectModel: {
representativeKey: 'InsurPlcyBonusMalusID',
semanticKey: [ 'InsurPlcyBonusMalusID' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #B,
sizeCategory: #XL
},
supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
allowExtensions:false,
ignorePropagatedAnnotations:false
}
@Analytics: {
technicalName: 'IACvPckgCvBnMl'
}
define view entity I_InsurApplCoverageBonusMalus
  as select from P_InsurPolicyJournalKeys   as PlcyJrnl
    inner join   I_InsurPlcyBonusMalusBasic as BonusMalus on  PlcyJrnl.InsurPlcyUUID                  =  BonusMalus.InsurPlcyUUID
                                                          and PlcyJrnl.InsurPlcyInsurContr            =  BonusMalus.InsurPlcyInsurContr
                                                          and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr >= BonusMalus.InsurPlcyJrnlNmbr
                                                          and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr <  BonusMalus.InsurPlcyJrnlEndNmbr

  association        to parent I_InsurApplCoverage      as _InsurApplContrCoverage       on  $projection.InsurPlcyUUID                  = _InsurApplContrCoverage.InsurPlcyUUID
                                                                                         and $projection.InsurPlcyInsurContr            = _InsurApplContrCoverage.InsurPlcyInsurContr
                                                                                         and $projection.InsurPlcyCoveragePackageID     = _InsurApplContrCoverage.InsurPlcyCoveragePackageID
                                                                                         and $projection.InsurPlcyCoverageID            = _InsurApplContrCoverage.InsurPlcyCoverageID
                                                                                         and $projection.InsurPlcyContrDataDetnJrnlNmbr = _InsurApplContrCoverage.InsurPlcyContrDataDetnJrnlNmbr

  composition [0..*] of I_InsurApplCvrgBonusMalusOwner  as _InsurApplCvrgBonusMalusOwner
  composition [0..*] of I_InsurApplCvrgBonusMalusCert   as _InsurApplCvrgBonusMalusCert
  
  association [1..1] to I_InsurPlcyIntPremiumLevelLink  as _InsurPlcyIntPremiumLevelLink on $projection.InsurPlcyIntPremiumLevel      = _InsurPlcyIntPremiumLevelLink.InsurPlcyIntPremiumLevel
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyIntPremiumLevelLink.InsurPlcyBonusMalusTemplate
  association [1..1] to I_InsurPlcyExtPremiumLevelLink  as _InsurPlcyExtPremiumLevelLink on $projection.InsurPlcyExtPremiumLevel      = _InsurPlcyExtPremiumLevelLink.InsurPlcyExtPremiumLevel
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyExtPremiumLevelLink.InsurPlcyBonusMalusTemplate                                                                                    
  association [1..1] to I_InsurPlcyBnMlOriginNameLink   as _InsurPlcyBnMlOriginNameLink  on $projection.InsurPlcyBonusMalusOrigin     = _InsurPlcyBnMlOriginNameLink.InsurPlcyBonusMalusOrigin
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyBnMlOriginNameLink.InsurPlcyBonusMalusTemplate 
  association [1..1] to I_InsurPlcyClsfctnRsnNameLink   as _InsurPlcyClsfctnRsnNameLink  on $projection.InsurPlcyClassificationReason = _InsurPlcyClsfctnRsnNameLink.InsurPlcyClassificationReason
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyClsfctnRsnNameLink.InsurPlcyBonusMalusTemplate
  association [1..1] to I_InsurPlcyBnMlPremModelLink    as _InsurPlcyBnMlPremModelLink   on $projection.InsurPlcyBnMlPremiumModel     = _InsurPlcyBnMlPremModelLink.InsurPlcyBnMlPremiumModel
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyBnMlPremModelLink.InsurPlcyBonusMalusTemplate
  association [1..1] to I_InsurPlcyBnMlCategoryLink     as _InsurPlcyBnMlCategoryLink    on $projection.InsurPlcyBonusMalusCategory   = _InsurPlcyBnMlCategoryLink.InsurPlcyBonusMalusCategory
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyBnMlCategoryLink.InsurPlcyBonusMalusTemplate                                                                                                                                                                                                                                                                        
  association [1..1] to I_InsurPlcyPrvInsRatgModelLink  as _InsurPlcyPrvInsRatgModelLink on $projection.InsurPlcyPrevInsrrRatingModel = _InsurPlcyPrvInsRatgModelLink.InsurPlcyPrevInsrrRatingModel
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyPrvInsRatgModelLink.InsurPlcyBonusMalusTemplate
  association [1..1] to I_InsurPlcyIntRatingModelLink   as _InsurPlcyIntRatingModelLink  on $projection.InsurPlcyIntRatingModel       = _InsurPlcyIntRatingModelLink.InsurPlcyIntRatingModel
                                                                                         and $projection.InsurPlcyBonusMalusTemplate  = _InsurPlcyIntRatingModelLink.InsurPlcyBonusMalusTemplate

  association [1..*] to I_InsurPlcyTemplateT           as _InsurPlcyTemplateT            on  $projection.InsurPlcyBonusMalusTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

{
  key BonusMalus.InsurPlcyUUID,
  key BonusMalus.InsurPlcyInsurContr,
  key BonusMalus.InsurPlcyCoveragePackageID,
  key BonusMalus.InsurPlcyCoverageID,
  key BonusMalus.InsurPlcyBonusMalusID,
  key cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      BonusMalus.InsurPlcyJrnlNmbr,
      BonusMalus.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      BonusMalus.InsurPlcyProductPackageID,
      BonusMalus.InsuranceBonusMalus,
      BonusMalus.InsurPlcyBonusMalusPremiumRate,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      BonusMalus.InsurPlcyBonusMalusTemplate,
      BonusMalus.InsurPlcyAssignmentMode,
      BonusMalus.InsurPlcyFirstClfnReason,
      @ObjectModel.foreignKey.association: '_InsurPlcyIntPremiumLevelLink'
      BonusMalus.InsurPlcyIntPremiumLevel,
      @ObjectModel.foreignKey.association: '_InsurPlcyExtPremiumLevelLink'
      BonusMalus.InsurPlcyExtPremiumLevel,
      BonusMalus.InsurPlcyPrevInsurerCompanyID,
      BonusMalus.InsurPlcyPrvInsBranchOfficeID,
      BonusMalus.InsurPlcyPrevInsurerCheckValue,
      BonusMalus.InsurPlcyInsuranceType,
      @ObjectModel.foreignKey.association: '_InsurPlcyBnMlOriginNameLink'
      BonusMalus.InsurPlcyBonusMalusOrigin,
      BonusMalus.InsurPlcyPeriodBeginDate,
      BonusMalus.InsurPlcyPeriodEndDate,
      @ObjectModel.foreignKey.association: '_InsurPlcyClsfctnRsnNameLink'
      BonusMalus.InsurPlcyClassificationReason,
      @ObjectModel.foreignKey.association: '_InsurPlcyBnMlPremModelLink'
      BonusMalus.InsurPlcyBnMlPremiumModel,
      BonusMalus.InsurPlcyRatingPremiumRate,
      @ObjectModel.foreignKey.association: '_InsurPlcyBnMlCategoryLink'
      BonusMalus.InsurPlcyBonusMalusCategory,
      @ObjectModel.foreignKey.association: '_InsurPlcyPrvInsRatgModelLink'
      BonusMalus.InsurPlcyPrevInsrrRatingModel,
      @ObjectModel.foreignKey.association: '_InsurPlcyIntRatingModelLink'
      BonusMalus.InsurPlcyIntRatingModel,
      BonusMalus.InsurPlcyIntNumberOfPauseDays,
      BonusMalus.InsurPlcyPrvInsNrOfPauseDays,
      BonusMalus.InsurPlcyNumberOfPauseDays,
      BonusMalus.InsurPlcyIntNumberOfClaims,
      BonusMalus.InsurPlcyPrvInsNumberOfClaims,
      BonusMalus.InsurPlcyNumberOfClaims,
      BonusMalus.InsurPlcyPrevInsrrContrEndDate,
      BonusMalus.InsurPlcyValidityBeginDate,
      BonusMalus.InsurPlcyBnMlLifeCycleStatus,
      BonusMalus.InsurPlcyBnMlExtPremiumRate,
      BonusMalus.InsurPlcyBnMlPrevInsrrAddition,
      BonusMalus.InsurPlcyBnMlInternalAddition,
      BonusMalus.InsurLicensePlateNumber,
      BonusMalus.InsurPlcyDriversLicenseIsChkd,
      BonusMalus.InsurPlcyPrevInsurerPolicyID,
      BonusMalus.InsurPlcyRefcdBonusMalus,
      BonusMalus.InsurPlcyInsrdVehNumberOfSeats,
      BonusMalus.InsurPlcyPrevInsrrDiscBaseYear,
      BonusMalus.InsurPlcyIntDiscountBaseYear,
      BonusMalus.InsurPlcyDiffntBnMlOwnerDesc,
      BonusMalus.InsurPlcyBnMlCertIsReceived,
      BonusMalus.InsurPlcyTypeOfRelatedContract,
      @Consumption.hidden: true
      BonusMalus.InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      BonusMalus.LastChangeDateTime,

      /* Associations */
      _InsurApplContrCoverage,
      _InsurApplCvrgBonusMalusOwner,
      _InsurApplCvrgBonusMalusCert,
      @Consumption.hidden: true
      _InsurPlcyIntPremiumLevelLink,
      @Consumption.hidden: true
      _InsurPlcyExtPremiumLevelLink,
      @Consumption.hidden: true
      _InsurPlcyBnMlOriginNameLink,
      @Consumption.hidden: true
      _InsurPlcyClsfctnRsnNameLink,
      @Consumption.hidden: true
      _InsurPlcyBnMlPremModelLink,
      @Consumption.hidden: true
      _InsurPlcyBnMlCategoryLink,
      @Consumption.hidden: true
      _InsurPlcyPrvInsRatgModelLink,
      @Consumption.hidden: true
      _InsurPlcyIntRatingModelLink,
      @Consumption.hidden: true
      _InsurPlcyTemplateT

}
where
      BonusMalus.InsurPlcyCoveragePackageID <> 0
  and BonusMalus.InsurPlcyCoverageID        <> 0