R_INSUROPENAPPLICATIONPREMIUM

CDS View

Premium in Insur Open Application

R_INSUROPENAPPLICATIONPREMIUM is a CDS View in S/4HANA. Premium in Insur Open Application. It contains 12 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 12 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurOpenApplCoverage view_entity inner COMPOSITE Coverage of Cvrg Package in InsOpenAppl

Fields (12)

KeyField CDS FieldsUsed in Views
InsurancePolicyPremium InsurancePolicyPremium 1
InsurPerdPremAftTaxPaytAmt InsurPerdPremAftTaxPaytAmt 1
InsurPerdPremBfrTaxPaytAmt InsurPerdPremBfrTaxPaytAmt 1
InsurPlcyCvrgIsPremiumExempt InsurPlcyCvrgIsPremiumExempt 1
InsurPlcyCvrgPremExmpEndDate InsurPlcyCvrgPremExmpEndDate 1
InsurPlcyJrnlEndNmbr InsurPlcyPremJournalEndNumber 1
InsurPlcyJrnlNmbr InsurPlcyPremiumJournalNumber 1
InsurPlcyPerdPremBfrTxPaytAmt InsurPlcyPerdPremBfrTxPaytAmt 1
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency 1
InsurPlcyPremiumTemplate InsurPlcyPremiumTemplate 1
InsurPlcyTotAnnPremAmt InsurPlcyTotAnnPremAmt 1
InsurPremType InsurPremType 1 
@EndUserText.label: 'Premium in Insur Open 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:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}

define view entity R_InsurOpenApplicationPremium
  as select from           I_InsurancePolicyPremiumBasic  as Premium

    left outer to one join P_InsurOpenApplicationPremLtst as OpenApplJrnl on  (
        OpenApplJrnl.InsurPlcyApplUUID                                                                                    = Premium.InsurPlcyUUID
        or OpenApplJrnl.InsurPlcyUUID                                                                                     = Premium.InsurPlcyUUID
      )
                                                                          and OpenApplJrnl.InsurPlcyInsurContr            = Premium.InsurPlcyInsurContr
                                                                          and OpenApplJrnl.InsurPlcyCoveragePackageID     = Premium.InsurPlcyCoveragePackageID
                                                                          and OpenApplJrnl.InsurPlcyCoverageID            = Premium.InsurPlcyCoverageID
                                                                          and OpenApplJrnl.InsurancePolicyPremium         = Premium.InsurancePolicyPremium
                                                                          and OpenApplJrnl.InsurPlcyJrnlNmbr              = Premium.InsurPlcyJrnlNmbr
                                                                          and OpenApplJrnl.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 OpenApplJrnl.InsurPlcyApplUUID,
  key Premium.InsurPlcyInsurContr,
  key Premium.InsurPlcyCoveragePackageID,
  key Premium.InsurPlcyCoverageID,
  key Premium.InsurancePolicyPremium,
  key cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      Premium.InsurPlcyJrnlNmbr,
      Premium.InsurPlcyJrnlEndNmbr,
      Premium.InsurPlcyUUID,
      @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
      OpenApplJrnl.InsurPlcyApplUUID    is not initial //Perf. Tuning: Make inner Join out of left outer Join

  and OpenApplJrnl.InsuranceApplication is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCEPOLICYPREMIUMBASIC",
"P_INSUROPENAPPLICATIONPREMLTST"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_INSURPLCYTEMPLATET",
"I_INSURPREMPAYTRCRRCFRQCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More