I_INSURPLCYPREMIUMCOMPRNBASIC

CDS View

Premium Comparison in Insurance Policy

I_INSURPLCYPREMIUMCOMPRNBASIC is a CDS View in S/4HANA. Premium Comparison in Insurance Policy. It contains 23 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 23 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_InsOpApContrCvrgPremComprn view_entity from COMPOSITE Cvrg Prem Comprn of Contr in InsurOpAp
I_InsOpApCvrgPremComparison view_entity from COMPOSITE Cvrg Prem Comprn of Cvrg Pckg in InsOpAp
I_InsurApplContrCvrgPremComprn view_entity inner COMPOSITE Cvrg Prem Comprn of Contr in Insur Appl
I_InsurApplCvrgPremComparison view_entity inner COMPOSITE Cv Prem Comprn of Cv Pckg in Insur Appl
I_InsurPlcyContrCvrgPremComprn view_entity from COMPOSITE Cvrg Prem Comprn of Contr in Insur Plcy
I_InsurPlcyCvrgPremComparison view_entity from COMPOSITE Cv Prem Comprn of Cv Pckg in Insur Plcy
P_InsurOpenApplPremComparison view_entity from COMPOSITE
P_InsurOpenApplPremComparison view_entity union COMPOSITE

Fields (23)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 7
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 7
KEY InsurPlcyInsurContr InsurPlcyInsurContr 7
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 7
KEY InsurPlcyPremiumComparisonID InsurPlcyPremiumComparisonID 7
KEY InsurPlcyUUID InsurPlcyUUID 4
InsurPlcyComprnAnnPremAmount InsurPlcyComprnAnnPremAmount 6
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 6
InsurPlcyNewAnnPremiumAmount InsurPlcyNewAnnPremiumAmount 6
InsurPlcyNewIntPremiumLevel InsurPlcyNewIntPremiumLevel 6
InsurPlcyNewIntPremiumRate InsurPlcyNewIntPremiumRate 6
InsurPlcyNewRegionalClass InsurPlcyNewRegionalClass 6
InsurPlcyNewTypeClass InsurPlcyNewTypeClass 6
InsurPlcyPremComprnTemplate InsurPlcyPremComprnTemplate 6
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency 6
InsurPlcyPremiumIsIncreased InsurPlcyPremiumIsIncreased 6
InsurPlcyPrevAnnPremiumAmount InsurPlcyPrevAnnPremiumAmount 6
InsurPlcyPrevIntPremiumLevel InsurPlcyPrevIntPremiumLevel 6
InsurPlcyPrevIntPremiumRate InsurPlcyPrevIntPremiumRate 6
InsurPlcyPreviousRegionalClass InsurPlcyPreviousRegionalClass 6
InsurPlcyPreviousTypeClass InsurPlcyPreviousTypeClass 6
InsurPlcyProductPackageID InsurPlcyProductPackageID 6
LastChangeDateTime LastChangeDateTime 6 
@EndUserText.label: 'Premium Comparison in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyPremiumComparisonID',
   semanticKey: [ 'InsurPlcyPremiumComparisonID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
  technicalName: 'IPPremComprnBsc'
}

define view entity I_InsurPlcyPremiumComprnBasic
  as select from /mva/amdapcmp as PremComprn

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

{

  key cast( PremComprn.policy_id as /pm0/vdm_policy_uuid preserving type )          as InsurPlcyUUID,
  key PremComprn.policyproduct_id                                                   as InsurPlcyInsurContr,
  key PremComprn.covpac_id                                                          as InsurPlcyCoveragePackageID,
  key PremComprn.coverage_id                                                        as InsurPlcyCoverageID,
  key PremComprn./mva/prmcmp_id                                                     as InsurPlcyPremiumComparisonID,
  key cast( PremComprn.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key PremComprn.journalendno_id                                                    as InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      PremComprn.ppdpac_id                                                          as InsurPlcyProductPackageID,
      cast( PremComprn.pm_id as /mva/vdm_pcmp_template_code preserving type )       as InsurPlcyPremComprnTemplate,
      PremComprn./mva/opstep_id                                                     as InsurPlcyPrevIntPremiumLevel,
      PremComprn./mva/npstep_id                                                     as InsurPlcyNewIntPremiumLevel,
      PremComprn./mva/oprate_vl                                                     as InsurPlcyPrevIntPremiumRate,
      PremComprn./mva/nprate_vl                                                     as InsurPlcyNewIntPremiumRate,
      PremComprn./mva/oregcl_cd                                                     as InsurPlcyPreviousRegionalClass,
      PremComprn./mva/nregcl_cd                                                     as InsurPlcyNewRegionalClass,
      PremComprn./mva/ocatcl_tt                                                     as InsurPlcyPreviousTypeClass,
      PremComprn./mva/ncatcl_tt                                                     as InsurPlcyNewTypeClass,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      PremComprn./mva/oannprm_am                                                    as InsurPlcyPrevAnnPremiumAmount,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      PremComprn./mva/nannprm_am                                                    as InsurPlcyNewAnnPremiumAmount,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      PremComprn./mva/cannprm_am                                                    as InsurPlcyComprnAnnPremAmount,
      @ObjectModel.foreignKey.association: '_Currency'
      PremComprn.currency_id                                                        as InsurPlcyPremiumCurrency,
      PremComprn./mva/premrai_fg                                                    as InsurPlcyPremiumIsIncreased,
      @Consumption.hidden: true
      PremComprn.bo_cd                                                              as InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      PremComprn.change_ts                                                          as LastChangeDateTime,
      
      _Currency
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/MVA/AMDAPCMP"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More