I_INSURPLCYBONUSMALUSBASIC
Bonus Malus in Insurance Policy
I_INSURPLCYBONUSMALUSBASIC is a CDS View in S/4HANA. Bonus Malus in Insurance Policy. It contains 52 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsOpApContractBonusMalus | view_entity | from | COMPOSITE | Contract Bonus Malus in InsurOpenAppl |
| I_InsOpApContrCvrgBonusMalus | view_entity | from | COMPOSITE | Crvg Bonus Malus of Contr in InsOpenAppl |
| I_InsOpApCoverageBonusMalus | view_entity | from | COMPOSITE | Cvrg Bn Ml of Cvrg Pckg in InsurOpenAppl |
| I_InsurApplContractBonusMalus | view_entity | inner | COMPOSITE | Contr Bn Ml in Insur Appl |
| I_InsurApplContrCvrgBonusMalus | view_entity | inner | COMPOSITE | Crvg Bn Ml of Contr in Insur Appl |
| I_InsurApplCoverageBonusMalus | view_entity | inner | COMPOSITE | Cvrg Bn Ml of Cvrg Pckg in Insur Appl |
| I_InsurPlcyContractBonusMalus | view_entity | from | COMPOSITE | Contr Bn Ml in Insur Plcy |
| I_InsurPlcyContrCvrgBonusMalus | view_entity | from | COMPOSITE | Crvg Bn Ml of Contr in Insur Plcy |
| I_InsurPlcyCoverageBonusMalus | view_entity | from | COMPOSITE | Cvrg Bn Ml of Cvrg Pckg in Insur Plcy |
| P_InsurOpenApplBonusMalus | view_entity | from | COMPOSITE | Insurance Open Application Bonus/Malus |
| P_InsurOpenApplBonusMalus | view_entity | union | COMPOSITE | Insurance Open Application Bonus/Malus |
Fields (52)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyBonusMalusID | InsurPlcyBonusMalusID | 10 |
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | 10 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 10 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 10 |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 10 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 6 |
| InsuranceBonusMalus | InsuranceBonusMalus | 9 | |
| InsurLicensePlateNumber | InsurLicensePlateNumber | 9 | |
| InsurPlcyAssignmentMode | InsurPlcyAssignmentMode | 9 | |
| InsurPlcyBnMlCertIsReceived | InsurPlcyBnMlCertIsReceived | 9 | |
| InsurPlcyBnMlExtPremiumRate | InsurPlcyBnMlExtPremiumRate | 9 | |
| InsurPlcyBnMlInternalAddition | InsurPlcyBnMlInternalAddition | 9 | |
| InsurPlcyBnMlLifeCycleStatus | InsurPlcyBnMlLifeCycleStatus | 9 | |
| InsurPlcyBnMlPremiumModel | InsurPlcyBnMlPremiumModel | 9 | |
| InsurPlcyBnMlPrevInsrrAddition | InsurPlcyBnMlPrevInsrrAddition | 9 | |
| InsurPlcyBonusMalusCategory | InsurPlcyBonusMalusCategory | 9 | |
| InsurPlcyBonusMalusOrigin | InsurPlcyBonusMalusOrigin | 9 | |
| InsurPlcyBonusMalusPremiumRate | InsurPlcyBonusMalusPremiumRate | 9 | |
| InsurPlcyBonusMalusTemplate | InsurPlcyBonusMalusTemplate | 9 | |
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | 9 | |
| InsurPlcyClassificationReason | InsurPlcyClassificationReason | 9 | |
| InsurPlcyDiffntBnMlOwnerDesc | InsurPlcyDiffntBnMlOwnerDesc | 9 | |
| InsurPlcyDriversLicenseIsChkd | InsurPlcyDriversLicenseIsChkd | 9 | |
| InsurPlcyExtPremiumLevel | InsurPlcyExtPremiumLevel | 9 | |
| InsurPlcyFirstClfnReason | InsurPlcyFirstClfnReason | 9 | |
| InsurPlcyInsrdVehNumberOfSeats | InsurPlcyInsrdVehNumberOfSeats | 9 | |
| InsurPlcyInsuranceType | InsurPlcyInsuranceType | 9 | |
| InsurPlcyIntDiscountBaseYear | InsurPlcyIntDiscountBaseYear | 9 | |
| InsurPlcyIntNumberOfClaims | InsurPlcyIntNumberOfClaims | 9 | |
| InsurPlcyIntNumberOfPauseDays | InsurPlcyIntNumberOfPauseDays | 9 | |
| InsurPlcyIntPremiumLevel | InsurPlcyIntPremiumLevel | 9 | |
| InsurPlcyIntRatingModel | InsurPlcyIntRatingModel | 9 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 9 | |
| InsurPlcyNumberOfClaims | InsurPlcyNumberOfClaims | 9 | |
| InsurPlcyNumberOfPauseDays | InsurPlcyNumberOfPauseDays | 9 | |
| InsurPlcyPeriodBeginDate | InsurPlcyPeriodBeginDate | 9 | |
| InsurPlcyPeriodEndDate | InsurPlcyPeriodEndDate | 9 | |
| InsurPlcyPrevInsrrContrEndDate | InsurPlcyPrevInsrrContrEndDate | 9 | |
| InsurPlcyPrevInsrrDiscBaseYear | InsurPlcyPrevInsrrDiscBaseYear | 9 | |
| InsurPlcyPrevInsrrRatingModel | InsurPlcyPrevInsrrRatingModel | 9 | |
| InsurPlcyPrevInsurerCheckValue | InsurPlcyPrevInsurerCheckValue | 9 | |
| InsurPlcyPrevInsurerCompanyID | InsurPlcyPrevInsurerCompanyID | 9 | |
| InsurPlcyPrevInsurerPolicyID | InsurPlcyPrevInsurerPolicyID | 9 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 9 | |
| InsurPlcyPrvInsBranchOfficeID | InsurPlcyPrvInsBranchOfficeID | 9 | |
| InsurPlcyPrvInsNrOfPauseDays | InsurPlcyPrvInsNrOfPauseDays | 9 | |
| InsurPlcyPrvInsNumberOfClaims | InsurPlcyPrvInsNumberOfClaims | 9 | |
| InsurPlcyRatingPremiumRate | InsurPlcyRatingPremiumRate | 9 | |
| InsurPlcyRefcdBonusMalus | InsurPlcyRefcdBonusMalus | 9 | |
| InsurPlcyTypeOfRelatedContract | InsurPlcyTypeOfRelatedContract | 9 | |
| InsurPlcyValidityBeginDate | InsurPlcyValidityBeginDate | 9 | |
| LastChangeDateTime | LastChangeDateTime | 9 |
@EndUserText.label: 'Bonus Malus in Insurance Policy'
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'InsurPlcyBonusMalusID',
semanticKey: [ 'InsurPlcyBonusMalusID' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XL
},
supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
technicalName: 'IPBnMlBsc'
}
define view entity I_InsurPlcyBonusMalusBasic
as select from /mva/amdabm as BonusMalus
{
key cast( BonusMalus.policy_id as /pm0/vdm_policy_uuid preserving type ) as InsurPlcyUUID,
key BonusMalus.policyproduct_id as InsurPlcyInsurContr,
key BonusMalus.covpac_id as InsurPlcyCoveragePackageID,
key BonusMalus.coverage_id as InsurPlcyCoverageID,
key BonusMalus./mva/bm_id as InsurPlcyBonusMalusID,
key cast( BonusMalus.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
key BonusMalus.journalendno_id as InsurPlcyJrnlEndNmbr,
@Consumption.hidden: true
BonusMalus.ppdpac_id as InsurPlcyProductPackageID,
BonusMalus./mva/bmdata_id as InsuranceBonusMalus,
BonusMalus./mva/premrate_vl as InsurPlcyBonusMalusPremiumRate,
cast( BonusMalus.pm_id as /mva/vdm_bnml_template_code preserving type ) as InsurPlcyBonusMalusTemplate,
BonusMalus./mva/ass_mode_cd as InsurPlcyAssignmentMode,
BonusMalus./mva/frc_id as InsurPlcyFirstClfnReason,
BonusMalus./mva/premstep_id as InsurPlcyIntPremiumLevel,
BonusMalus./mva/prstext_id as InsurPlcyExtPremiumLevel,
BonusMalus./mva/insurer_id as InsurPlcyPrevInsurerCompanyID,
BonusMalus./mva/office_id as InsurPlcyPrvInsBranchOfficeID,
BonusMalus./mva/inscheck_vl as InsurPlcyPrevInsurerCheckValue,
BonusMalus./mva/insur_tp as InsurPlcyInsuranceType,
BonusMalus./mva/bmsource_cd as InsurPlcyBonusMalusOrigin,
BonusMalus./mva/periobeg_dt as InsurPlcyPeriodBeginDate,
BonusMalus./mva/perioend_dt as InsurPlcyPeriodEndDate,
BonusMalus./mva/classrea_cd as InsurPlcyClassificationReason,
BonusMalus./mva/premmod_id as InsurPlcyBnMlPremiumModel,
BonusMalus./mva/tpremrat_vl as InsurPlcyRatingPremiumRate,
BonusMalus./mva/bmtype_cd as InsurPlcyBonusMalusCategory,
BonusMalus./mva/ratext_id as InsurPlcyPrevInsrrRatingModel,
BonusMalus./mva/ratint_id as InsurPlcyIntRatingModel,
BonusMalus./mva/breakint_am as InsurPlcyIntNumberOfPauseDays,
BonusMalus./mva/breakext_am as InsurPlcyPrvInsNrOfPauseDays,
BonusMalus./mva/break_am as InsurPlcyNumberOfPauseDays,
BonusMalus./mva/claimint_am as InsurPlcyIntNumberOfClaims,
BonusMalus./mva/claimext_am as InsurPlcyPrvInsNumberOfClaims,
BonusMalus./mva/claims_am as InsurPlcyNumberOfClaims,
BonusMalus./mva/polend_dt as InsurPlcyPrevInsrrContrEndDate,
BonusMalus./mva/begin_dt as InsurPlcyValidityBeginDate,
BonusMalus./mva/actinact_cd as InsurPlcyBnMlLifeCycleStatus,
BonusMalus./mva/prmrtext_vl as InsurPlcyBnMlExtPremiumRate,
BonusMalus./mva/addonext_id as InsurPlcyBnMlPrevInsrrAddition,
BonusMalus./mva/addonint_id as InsurPlcyBnMlInternalAddition,
cast( BonusMalus./mva/licence as /mva/amd_licence ) as InsurLicensePlateNumber,
BonusMalus./mva/licence_fg as InsurPlcyDriversLicenseIsChkd,
BonusMalus./mva/policy_id as InsurPlcyPrevInsurerPolicyID,
BonusMalus./mva/ref_bm_id as InsurPlcyRefcdBonusMalus,
BonusMalus./mva/seats_vl as InsurPlcyInsrdVehNumberOfSeats,
BonusMalus./mva/yodext_dt as InsurPlcyPrevInsrrDiscBaseYear,
BonusMalus./mva/yodint_dt as InsurPlcyIntDiscountBaseYear,
BonusMalus./mva/diffins_tt as InsurPlcyDiffntBnMlOwnerDesc,
BonusMalus./mva/par5rec_fg as InsurPlcyBnMlCertIsReceived,
BonusMalus./mva/bminsrl_id as InsurPlcyTypeOfRelatedContract,
@Consumption.hidden: true
BonusMalus.bo_cd as InsurPlcyBusinessObject,
@Semantics.systemDateTime.lastChangedAt: true
BonusMalus.change_ts as LastChangeDateTime
}