R_INSURANCEPOLICYPREMIUM

CDS View

Contract Premium in Insurance Policy

R_INSURANCEPOLICYPREMIUM is a CDS View in S/4HANA. Contract Premium in Insurance Policy. It contains 14 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 14 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InsuranceContract view_entity inner COMPOSITE Contract in Insurance Policy
I_InsurancePolicyContrCoverage view_entity inner COMPOSITE Contract Coverage in Insurance Policy
I_InsurancePolicyCoverage view_entity inner COMPOSITE Coverage of Cvrg Package in Insur Plcy

Fields (14)

KeyField CDS FieldsUsed in Views
InsurancePolicyPremium InsurancePolicyPremium 3
InsurPerdPremAftTaxPaytAmt InsurPerdPremAftTaxPaytAmt 3
InsurPerdPremBfrTaxPaytAmt InsurPerdPremBfrTaxPaytAmt 3
InsurPlcyCvrgIsPremiumExempt InsurContrIsPremExempt,InsurPlcyCvrgIsPremiumExempt 3
InsurPlcyCvrgPremExmpEndDate InsurContrPremExmpEndDte,InsurPlcyCvrgPremExmpEndDate 3
InsurPlcyJrnlEndNmbr InsurPlcyPremJournalEndNumber 3
InsurPlcyJrnlNmbr InsurPlcyPremiumJournalNumber 3
InsurPlcyMainDueDayMonth InsurPlcyMainDueDayMonth 1
InsurPlcyPerdPremBfrTxPaytAmt InsurPlcyPerdPremBfrTxPaytAmt 3
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency 3
InsurPlcyPremiumTemplate InsurPlcyPremiumTemplate 3
InsurPlcyTotAnnPremAmt InsurPlcyTotAnnPremAmt 3
InsurPremSpecPaytRcrrcFrqcy InsurPremSpecPaytRcrrcFrqcy 1
InsurPremType InsurPremType 3 
@EndUserText.label: 'Contract Premium in Insurance Policy'
@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_InsurancePolicyPremium
  as select from I_InsurancePolicyPremiumBasic as Premium

  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,
      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

}
where
      Premium.InsurPlcyJrnlEndNmbr    = 2147483647
  and Premium.InsurPlcyBusinessObject = 'P'

Learn More