I_InsurApplContractBonusMalus

DDL: I_INSURAPPLCONTRACTBONUSMALUS Type: view_entity COMPOSITE

Contr Bn Ml in Insur Appl

I_InsurApplContractBonusMalus is a Composite CDS View that provides data about "Contr Bn Ml 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_InsurApplContrBonusMalusOwnr _InsurApplContrBonusMalusOwnr
[0..*] I_InsurApplContrBonusMalusCert _InsurApplContrBonusMalusCert

Annotations (11)

NameValueLevelField
EndUserText.label Contr Bn Ml 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 IACoBnMl view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyBonusMalusBasic InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyBonusMalusBasic InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyBonusMalusBasic InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyBonusMalusBasic InsurPlcyCoverageID Coverage Key
KEY InsurPlcyBonusMalusID I_InsurPlcyBonusMalusBasic InsurPlcyBonusMalusID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyBonusMalusBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyBonusMalusBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyBonusMalusBasic InsurPlcyProductPackageID Prod. Pckg. Key
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 Insured Seats
InsurPlcyPrevInsrrDiscBaseYear I_InsurPlcyBonusMalusBasic InsurPlcyPrevInsrrDiscBaseYear
InsurPlcyIntDiscountBaseYear I_InsurPlcyBonusMalusBasic InsurPlcyIntDiscountBaseYear
InsurPlcyDiffntBnMlOwnerDesc I_InsurPlcyBonusMalusBasic InsurPlcyDiffntBnMlOwnerDesc
InsurPlcyBnMlCertIsReceived I_InsurPlcyBonusMalusBasic InsurPlcyBnMlCertIsReceived
InsurPlcyTypeOfRelatedContract I_InsurPlcyBonusMalusBasic InsurPlcyTypeOfRelatedContract
InsurPlcyBusinessObject I_InsurPlcyBonusMalusBasic InsurPlcyBusinessObject Process.Status
LastChangeDateTime I_InsurPlcyBonusMalusBasic LastChangeDateTime Timestamp
_InsurApplContract _InsurApplContract
_InsurPlcyIntPremiumLevelLink _InsurPlcyIntPremiumLevelLink
_InsurPlcyExtPremiumLevelLink _InsurPlcyExtPremiumLevelLink
_InsurPlcyBnMlOriginNameLink _InsurPlcyBnMlOriginNameLink
_InsurPlcyClsfctnRsnNameLink _InsurPlcyClsfctnRsnNameLink
_InsurPlcyBnMlPremModelLink _InsurPlcyBnMlPremModelLink
_InsurPlcyBnMlCategoryLink _InsurPlcyBnMlCategoryLink
_InsurPlcyPrvInsRatgModelLink _InsurPlcyPrvInsRatgModelLink
_InsurPlcyIntRatingModelLink _InsurPlcyIntRatingModelLink
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurApplContrBonusMalusOwnr _InsurApplContrBonusMalusOwnr
_InsurApplContrBonusMalusCert _InsurApplContrBonusMalusCert

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 I_InsurApplContractBonusMalus.
-- 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 I_InsurApplContractBonusMalus AS
SELECT
  BonusMalus.InsurPlcyUUID AS InsurPlcyUUID,
  BonusMalus.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  BonusMalus.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  BonusMalus.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  BonusMalus.InsurPlcyBonusMalusID AS InsurPlcyBonusMalusID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  BonusMalus.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  BonusMalus.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  BonusMalus.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  BonusMalus.InsuranceBonusMalus AS InsuranceBonusMalus,
  BonusMalus.InsurPlcyBonusMalusPremiumRate AS InsurPlcyBonusMalusPremiumRate,
  BonusMalus.InsurPlcyBonusMalusTemplate AS InsurPlcyBonusMalusTemplate,
  BonusMalus.InsurPlcyAssignmentMode AS InsurPlcyAssignmentMode,
  BonusMalus.InsurPlcyFirstClfnReason AS InsurPlcyFirstClfnReason,
  BonusMalus.InsurPlcyIntPremiumLevel AS InsurPlcyIntPremiumLevel,
  BonusMalus.InsurPlcyExtPremiumLevel AS InsurPlcyExtPremiumLevel,
  BonusMalus.InsurPlcyPrevInsurerCompanyID AS InsurPlcyPrevInsurerCompanyID,
  BonusMalus.InsurPlcyPrvInsBranchOfficeID AS InsurPlcyPrvInsBranchOfficeID,
  BonusMalus.InsurPlcyPrevInsurerCheckValue AS InsurPlcyPrevInsurerCheckValue,
  BonusMalus.InsurPlcyInsuranceType AS InsurPlcyInsuranceType,
  BonusMalus.InsurPlcyBonusMalusOrigin AS InsurPlcyBonusMalusOrigin,
  BonusMalus.InsurPlcyPeriodBeginDate AS InsurPlcyPeriodBeginDate,
  BonusMalus.InsurPlcyPeriodEndDate AS InsurPlcyPeriodEndDate,
  BonusMalus.InsurPlcyClassificationReason AS InsurPlcyClassificationReason,
  BonusMalus.InsurPlcyBnMlPremiumModel AS InsurPlcyBnMlPremiumModel,
  BonusMalus.InsurPlcyRatingPremiumRate AS InsurPlcyRatingPremiumRate,
  BonusMalus.InsurPlcyBonusMalusCategory AS InsurPlcyBonusMalusCategory,
  BonusMalus.InsurPlcyPrevInsrrRatingModel AS InsurPlcyPrevInsrrRatingModel,
  BonusMalus.InsurPlcyIntRatingModel AS InsurPlcyIntRatingModel,
  BonusMalus.InsurPlcyIntNumberOfPauseDays AS InsurPlcyIntNumberOfPauseDays,
  BonusMalus.InsurPlcyPrvInsNrOfPauseDays AS InsurPlcyPrvInsNrOfPauseDays,
  BonusMalus.InsurPlcyNumberOfPauseDays AS InsurPlcyNumberOfPauseDays,
  BonusMalus.InsurPlcyIntNumberOfClaims AS InsurPlcyIntNumberOfClaims,
  BonusMalus.InsurPlcyPrvInsNumberOfClaims AS InsurPlcyPrvInsNumberOfClaims,
  BonusMalus.InsurPlcyNumberOfClaims AS InsurPlcyNumberOfClaims,
  BonusMalus.InsurPlcyPrevInsrrContrEndDate AS InsurPlcyPrevInsrrContrEndDate,
  BonusMalus.InsurPlcyValidityBeginDate AS InsurPlcyValidityBeginDate,
  BonusMalus.InsurPlcyBnMlLifeCycleStatus AS InsurPlcyBnMlLifeCycleStatus,
  BonusMalus.InsurPlcyBnMlExtPremiumRate AS InsurPlcyBnMlExtPremiumRate,
  BonusMalus.InsurPlcyBnMlPrevInsrrAddition AS InsurPlcyBnMlPrevInsrrAddition,
  BonusMalus.InsurPlcyBnMlInternalAddition AS InsurPlcyBnMlInternalAddition,
  BonusMalus.InsurLicensePlateNumber AS InsurLicensePlateNumber,
  BonusMalus.InsurPlcyDriversLicenseIsChkd AS InsurPlcyDriversLicenseIsChkd,
  BonusMalus.InsurPlcyPrevInsurerPolicyID AS InsurPlcyPrevInsurerPolicyID,
  BonusMalus.InsurPlcyRefcdBonusMalus AS InsurPlcyRefcdBonusMalus,
  BonusMalus.InsurPlcyInsrdVehNumberOfSeats AS InsurPlcyInsrdVehNumberOfSeats,
  BonusMalus.InsurPlcyPrevInsrrDiscBaseYear AS InsurPlcyPrevInsrrDiscBaseYear,
  BonusMalus.InsurPlcyIntDiscountBaseYear AS InsurPlcyIntDiscountBaseYear,
  BonusMalus.InsurPlcyDiffntBnMlOwnerDesc AS InsurPlcyDiffntBnMlOwnerDesc,
  BonusMalus.InsurPlcyBnMlCertIsReceived AS InsurPlcyBnMlCertIsReceived,
  BonusMalus.InsurPlcyTypeOfRelatedContract AS InsurPlcyTypeOfRelatedContract,
  BonusMalus.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  BonusMalus.LastChangeDateTime AS LastChangeDateTime
FROM P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyBonusMalusBasic AS BonusMalus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurPlcyIntPremiumLevelLink AS _InsurPlcyIntPremiumLevelLink ON InsurPlcyIntPremiumLevel = _InsurPlcyIntPremiumLevelLink.InsurPlcyIntPremiumLevel AND InsurPlcyBonusMalusTemplate = _InsurPlcyIntPremiumLevelLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyExtPremiumLevelLink AS _InsurPlcyExtPremiumLevelLink ON InsurPlcyExtPremiumLevel = _InsurPlcyExtPremiumLevelLink.InsurPlcyExtPremiumLevel AND InsurPlcyBonusMalusTemplate = _InsurPlcyExtPremiumLevelLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyBnMlOriginNameLink AS _InsurPlcyBnMlOriginNameLink ON InsurPlcyBonusMalusOrigin = _InsurPlcyBnMlOriginNameLink.InsurPlcyBonusMalusOrigin AND InsurPlcyBonusMalusTemplate = _InsurPlcyBnMlOriginNameLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyClsfctnRsnNameLink AS _InsurPlcyClsfctnRsnNameLink ON InsurPlcyClassificationReason = _InsurPlcyClsfctnRsnNameLink.InsurPlcyClassificationReason AND InsurPlcyBonusMalusTemplate = _InsurPlcyClsfctnRsnNameLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyBnMlPremModelLink AS _InsurPlcyBnMlPremModelLink ON InsurPlcyBnMlPremiumModel = _InsurPlcyBnMlPremModelLink.InsurPlcyBnMlPremiumModel AND InsurPlcyBonusMalusTemplate = _InsurPlcyBnMlPremModelLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyBnMlCategoryLink AS _InsurPlcyBnMlCategoryLink ON InsurPlcyBonusMalusCategory = _InsurPlcyBnMlCategoryLink.InsurPlcyBonusMalusCategory AND InsurPlcyBonusMalusTemplate = _InsurPlcyBnMlCategoryLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyPrvInsRatgModelLink AS _InsurPlcyPrvInsRatgModelLink ON InsurPlcyPrevInsrrRatingModel = _InsurPlcyPrvInsRatgModelLink.InsurPlcyPrevInsrrRatingModel AND InsurPlcyBonusMalusTemplate = _InsurPlcyPrvInsRatgModelLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyIntRatingModelLink AS _InsurPlcyIntRatingModelLink ON InsurPlcyIntRatingModel = _InsurPlcyIntRatingModelLink.InsurPlcyIntRatingModel AND InsurPlcyBonusMalusTemplate = _InsurPlcyIntRatingModelLink.InsurPlcyBonusMalusTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyBonusMalusTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurApplContrBonusMalusOwnr AS _InsurApplContrBonusMalusOwnr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrBonusMalusCert AS _InsurApplContrBonusMalusCert ON /* condition not available in parsed metadata */  -- association [0..*]
;