R_InsurApplicationPremium

@EndUserText.label: 'Premium in Insurance Application'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XXL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
define view entity R_InsurApplicationPremium
  as select from P_InsurPolicyJournalKeys      as PlcyJrnl
    inner join   I_InsurancePolicyPremiumBasic as Premium on  PlcyJrnl.InsurPlcyUUID                  =  Premium.InsurPlcyUUID
                                                          and PlcyJrnl.InsurPlcyInsurContr            =  Premium.InsurPlcyInsurContr
                                                          and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Premium.InsurPlcyJrnlNmbr
                                                          and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Premium.InsurPlcyJrnlEndNmbr

  association [1..1] to I_Currency                as _Currency                on $projection.InsurPlcyPremiumCurrency = _Currency.Currency
  association [1..1] to I_InsurPremPaytRcrrcFrqcy as _InsurPremPaytRcrrcFrqcy on $projection.InsurPremSpecPaytRcrrcFrqcy = _InsurPremPaytRcrrcFrqcy.InsurPremSpecPaytRcrrcFrqcy
  association [1..*] to I_InsurPlcyTemplateT      as _InsurPlcyTemplateT      on $projection.InsurPlcyPremiumTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

{
  key Premium.InsurPlcyUUID,
  key Premium.InsurPlcyInsurContr,
  key Premium.InsurPlcyCoveragePackageID,
  key Premium.InsurPlcyCoverageID,
  key Premium.InsurancePolicyPremium,
  key cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      Premium.InsurPlcyJrnlNmbr,
      Premium.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Premium.InsurPlcyProductPackageID,
      @ObjectModel.foreignKey.association: '_InsurPremPaytRcrrcFrqcy'
      Premium.InsurPremSpecPaytRcrrcFrqcy,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.InsurPerdPremBfrTaxPaytAmt,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.InsurPerdPremAftTaxPaytAmt,
      Premium.InsurPremType,
      @Semantics.booleanIndicator:true
      Premium.InsurPlcyCvrgIsPremiumExempt,
      Premium.InsurPlcyCvrgPremExmpEndDate,
      @ObjectModel.foreignKey.association: '_Currency'
      Premium.InsurPlcyPremiumCurrency,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.InsurPlcyTotAnnPremAmt,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.InsurPlcyPerdPremBfrTxPaytAmt,
      Premium.InsurPlcyMainDueDayMonth,
      @Semantics.systemDateTime.lastChangedAt: true
      Premium.LastChangeDateTime,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      Premium.InsurPlcyPremiumTemplate,

      @Consumption.hidden: true
      _Currency,
      @Consumption.hidden: true
      _InsurPremPaytRcrrcFrqcy,
      @Consumption.hidden: true
      _InsurPlcyTemplateT

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCEPOLICYPREMIUMBASIC",
"P_INSURPOLICYJOURNALKEYS"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_INSURPLCYTEMPLATET",
"I_INSURPREMPAYTRCRRCFRQCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/