I_INSURANCEPOLICYPREMIUMBASIC

CDS View

Premium in Insurance Policy

I_INSURANCEPOLICYPREMIUMBASIC is a CDS View in S/4HANA. Premium in Insurance Policy. It contains 20 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 20 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_InsurOpenApplicationPremium view_entity from COMPOSITE Insurance Open Application Regular Premium
P_InsurOpenApplicationPremium view_entity union COMPOSITE Insurance Open Application Regular Premium
P_InsurPlcyPremDevPremChg view_entity from COMPOSITE Insurance Policy Premium History Premium Changes
R_InsurancePolicyPremium view_entity from COMPOSITE Contract Premium in Insurance Policy
R_InsurApplicationPremium view_entity inner COMPOSITE Premium in Insurance Application
R_InsurOpenApplicationPremium view_entity from COMPOSITE Premium in Insur Open Application

Fields (20)

KeyField CDS FieldsUsed in Views
KEY InsurancePolicyPremium InsurancePolicyPremium 4
KEY InsurPlcyCoverageID InsurPlcyCoverageID 4
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 4
KEY InsurPlcyInsurContr InsurPlcyInsurContr 5
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 4
KEY InsurPlcyUUID InsurPlcyUUID 3
InsurPerdPremAftTaxPaytAmt InsurPerdPremAftTaxPaytAmt 3
InsurPerdPremBfrTaxPaytAmt InsurPerdPremBfrTaxPaytAmt 3
InsurPlcyCvrgIsPremiumExempt InsurPlcyCvrgIsPremiumExempt 3
InsurPlcyCvrgPremExmpEndDate InsurPlcyCvrgPremExmpEndDate 3
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 3
InsurPlcyMainDueDayMonth InsurPlcyMainDueDayMonth 3
InsurPlcyPerdPremBfrTxPaytAmt InsurPlcyPerdPremBfrTxPaytAmt 3
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency 4
InsurPlcyPremiumTemplate InsurPlcyPremiumTemplate 3
InsurPlcyProductPackageID InsurPlcyProductPackageID 3
InsurPlcyTotAnnPremAmt InsurPlcyTotAnnPremAmt 4
InsurPremSpecPaytRcrrcFrqcy InsurPremSpecPaytRcrrcFrqcy 3
InsurPremType InsurPremType 3
LastChangeDateTime LastChangeDateTime 3 
@EndUserText.label: 'Premium in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurancePolicyPremium',
   semanticKey: [ 'InsurancePolicyPremium' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
  technicalName: 'IPPremBsc'
}

define view entity I_InsurancePolicyPremiumBasic
  as select from /pm0/abdaprem as Premium

  association [1..1] to I_Currency as _Currency on $projection.InsurPlcyPremiumCurrency = _Currency.Currency

{

  key cast( Premium.policy_id as /pm0/vdm_policy_uuid preserving type )           as InsurPlcyUUID,
  key Premium.policyproduct_id                                                    as InsurPlcyInsurContr,
  key Premium.covpac_id                                                           as InsurPlcyCoveragePackageID,
  key Premium.coverage_id                                                         as InsurPlcyCoverageID,
  key Premium.premium_id                                                          as InsurancePolicyPremium,
  key cast( Premium.journalno_id as /pm0/vdm_journal_number_id preserving type )  as InsurPlcyJrnlNmbr,
  key Premium.journalendno_id                                                     as InsurPlcyJrnlEndNmbr,

      
      Premium.ppdpac_id                                                           as InsurPlcyProductPackageID,
      cast( Premium.payfrq_cd as /pm0/vdm_payment_freq_code preserving type )     as InsurPremSpecPaytRcrrcFrqcy,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.prembeforetax_am                                                    as InsurPerdPremBfrTaxPaytAmt,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.premaftertax_am                                                     as InsurPerdPremAftTaxPaytAmt,
      Premium.prem_cd                                                             as InsurPremType,
      @Semantics.booleanIndicator:true
      Premium.prmxmpt_fg                                                          as InsurPlcyCvrgIsPremiumExempt,
      Premium.prmxmptend_dt                                                       as InsurPlcyCvrgPremExmpEndDate,
      @ObjectModel.foreignKey.association: '_Currency'
      Premium.currency_id                                                         as InsurPlcyPremiumCurrency,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.annpremafttax_am                                                    as InsurPlcyTotAnnPremAmt,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.annprembeftax_am                                                    as InsurPlcyPerdPremBfrTxPaytAmt,
      cast( Premium.mainmaturity_dt as /pm0/vdm_mainmaturity_dt preserving type ) as InsurPlcyMainDueDayMonth,
      @Consumption.hidden: true
      Premium.bo_cd                                                               as InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      Premium.change_ts                                                           as LastChangeDateTime,
      Premium.pm_id                                                               as InsurPlcyPremiumTemplate,

      _Currency

}
where
      Premium.covcp_id   = 0
  and Premium.subject_id = 0

Learn More