I_INSURPLCYREGPREMCONFIG

CDS View

Regular Premium Confign in Insur Policy

I_INSURPLCYREGPREMCONFIG is a CDS View in S/4HANA. Regular Premium Confign in Insur Policy. 8 CDS views read from this table.

CDS Views using this table (8)

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
I_InsurApplContract view_entity inner COMPOSITE Contract in Insurance Appl
I_InsurApplContrCoverage view_entity inner COMPOSITE Contract Coverage in Insurance Appl
I_InsurApplCoverage view_entity inner COMPOSITE Coverage of Cvrg Package in Insur Appl
I_InsurOpenApplCoverage view_entity inner COMPOSITE Coverage of Cvrg Package in InsOpenAppl
P_InsurPlcyPremDevContract view_entity inner COMPOSITE
@EndUserText.label: 'Regular Premium Confign in Insur Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyProductTemplate',
   semanticKey: [ 'InsurPlcyProductTemplate' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #S
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
  technicalName: 'IPRegPremConfBsc'
}

define view entity I_InsurPlcyRegPremConfig
  as select from /pm0/abucibcattr as IFBCAttribute // IFBC attributes


    inner join   /pm0/abuuprggp   as ProductGroup  // Product group

    on IFBCAttribute.attribvalue = ProductGroup.pbstyp_tt

    inner join   /pm0/abuaprem    as PremiumConfig // Premium Customizing

    on ProductGroup.prelgr_id = PremiumConfig.prelgr_id

{

  key IFBCAttribute.template_id as InsurPlcyProductTemplate,
  key PremiumConfig.prem_cd     as InsurPremType

}
where
      IFBCAttribute.application_id  = 'POLICY'
  and IFBCAttribute.markname        = 'PRODUCT_MODULE_ID'
  and IFBCAttribute.attr_is_used_fg = 'X'
  and IFBCAttribute.state_cd        = '3' // Released

  and

      ProductGroup.grpdim_id        = 'ASSMOD'
  and ProductGroup.prdmod_id        = 'PRODUKT'
  and

      PremiumConfig.premtype_cd     = '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PM0/ABUAPREM",
"/PM0/ABUCIBCATTR",
"/PM0/ABUUPRGGP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/