I_INSURPLCYSUBCOVERAGEBASIC

CDS View

SubCoverage in Insurance Policy

I_INSURPLCYSUBCOVERAGEBASIC is a CDS View in S/4HANA. SubCoverage in Insurance Policy. It contains 17 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 17 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_InsOpApContrCvrgSubCoverage view_entity from COMPOSITE Cvrg SubCoverage of Contr in InsOpenAppl
I_InsurApplContrCvrgSubCvrg view_entity inner COMPOSITE Cvrg SubCoverage of Contr in Insur Appl
I_InsurApplSubCoverage view_entity inner COMPOSITE Cvrg SubCoverage of CvPcg in Insur Appl
I_InsurOpenApplSubCoverage view_entity from COMPOSITE Cvrg SubCoverage of CvPcg in InsOpenAppl
I_InsurPlcyContrCvrgSubCvrg view_entity from COMPOSITE Cvrg SubCoverage of Contr in Insur Plcy
I_InsurPlcySubCoverage view_entity from COMPOSITE Cvrg SubCoverage of CvPcg in Insur Plcy
P_InsurOpenApplSubCoverage view_entity from COMPOSITE Insurance Open Application SubCoverage
P_InsurOpenApplSubCoverage view_entity union COMPOSITE Insurance Open Application SubCoverage
R_InsurPlcySubcoverageTP_2 view_entity from TRANSACTIONAL Subcoverage

Fields (17)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 7
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 7
KEY InsurPlcyInsurContr InsurPlcyInsurContr 7
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 7
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID 7
KEY InsurPlcyUUID InsurPlcyUUID 4
InsurPlcyInsuranceSubCoverage InsurPlcyInsuranceSubCoverage 6
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 6
InsurPlcyProductPackageID InsurPlcyProductPackageID 6
InsurPlcySubCoverageCurrency InsurPlcySubCoverageCurrency 6
InsurPlcySubCoverageEndDate InsurPlcySubCoverageEndDate 6
InsurPlcySubCoverageStartDate InsurPlcySubCoverageStartDate 6
InsurPlcySubCoverageTemplate InsurPlcySubCoverageTemplate 6
InsurPlcySubCvrgInsrdSumAmount InsurPlcySubCvrgInsrdSumAmount 6
InsurPlcySubCvrgInsrdSumCalc InsurPlcySubCvrgInsrdSumCalc 6
InsurPlcySubCvrgInsuredSumPct InsurPlcySubCvrgInsuredSumPct 6
LastChangeDateTime LastChangeDateTime 6 
@EndUserText.label: 'SubCoverage in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcySubCvrgID',
   semanticKey: [ 'InsurPlcyInsuranceSubCoverage' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Analytics: {
  technicalName: 'IPSubCvrgBsc'
}

define view entity I_InsurPlcySubCoverageBasic
  as select from /pm0/abdacovcpco as SubCoverage

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

{

  key cast( SubCoverage.policy_id         as /pm0/vdm_policy_uuid preserving type )  as InsurPlcyUUID,
  key SubCoverage.policyproduct_id                                                   as InsurPlcyInsurContr,
  key SubCoverage.covpac_id                                                          as InsurPlcyCoveragePackageID,
  key SubCoverage.coverage_id                                                        as InsurPlcyCoverageID,
  key SubCoverage.covcpco_id                                                         as InsurPlcySubCvrgID,
  key cast( SubCoverage.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key SubCoverage.journalendno_id                                                    as InsurPlcyJrnlEndNmbr,
      //@Consumption.hidden: true

      SubCoverage.ppdpac_id                                                          as InsurPlcyProductPackageID,
      SubCoverage.covcpconr_tt                                                       as InsurPlcyInsuranceSubCoverage,
      SubCoverage.pm_id                                                              as InsurPlcySubCoverageTemplate,
      @Semantics.businessDate.from: true
      SubCoverage.begin_dt                                                           as InsurPlcySubCoverageStartDate,
      @Semantics.businessDate.to: true 
      cast( SubCoverage.end_dt as /pm0/vdm_covcpco_end_date preserving type )        as InsurPlcySubCoverageEndDate,
      @Semantics.amount.currencyCode: 'InsurPlcySubCoverageCurrency'
      SubCoverage.insamount_am                                                       as InsurPlcySubCvrgInsrdSumAmount,
      @ObjectModel.foreignKey.association: '_Currency'
      SubCoverage.currency_id                                                        as InsurPlcySubCoverageCurrency,
      SubCoverage.insamount_vl                                                       as InsurPlcySubCvrgInsuredSumPct,
      SubCoverage.insamtp_cd                                                         as InsurPlcySubCvrgInsrdSumCalc,
      @Consumption.hidden: true
      SubCoverage.bo_cd                                                              as InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      SubCoverage.change_ts                                                          as LastChangeDateTime,

      @Semantics.booleanIndicator:true
      SubCoverage.cancel_fg                                                          as InsurPlcySbcvrgIsCanceled,
      SubCoverage.covcpcotp_cd                                                       as InsurPlcySubcoverageType,
      SubCoverage.rank_vl                                                            as InsurPlcySubcoverageRankValue,
      @Semantics.amount.currencyCode: 'InsurPlcySubCoverageCurrency'
      SubCoverage.grosspremiumb_am                                                   as InsurPlcySbcvrgGrssPremBfrAmt,
      @Semantics.amount.currencyCode: 'InsurPlcySubCoverageCurrency'
      SubCoverage.premtrunccorb_am                                                   as InsurPlcySbcvrgPremCrrtnAmt,
      @Semantics.amount.currencyCode: 'InsurPlcySubCoverageCurrency'
      SubCoverage.ratesuppb_am                                                       as InsurPlcySbcvrgSuplmntAmt,
      SubCoverage.covcpconum_vl                                                      as InsurPlcySubcoverageNmbrValue,


      _Currency

}

Learn More