I_InsurApplCoverageBonusMalus

Q: Which tables does I_InsurApplCoverageBonusMalus use?

I_InsurApplCoverageBonusMalus reads from 2 data source(s): I_InsurPlcyBonusMalusBasic, P_InsurPolicyJournalKeys.

Q: How many fields does I_InsurApplCoverageBonusMalus have?

I_InsurApplCoverageBonusMalus has 65 fields. Key fields: InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyBonusMalusID.

DDL: I_INSURAPPLCOVERAGEBONUSMALUS Type: view_entity COMPOSITE Package: VDM_PMA_PLCY_APPL_COMMON

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. Part of development package VDM_PMA_PLCY_APPL_COMMON.

Data Sources (2)

Source	Alias	Join Type
I_InsurPlcyBonusMalusBasic	BonusMalus	inner
P_InsurPolicyJournalKeys	PlcyJrnl	from

Associations (11)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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

Depth:

I_InsurApplCoverageBonusMalus view_entity

P_InsurPolicyJournalKeys view_entity
I_InsurPlcyBonusMalusBasic view_entity