I_INSURPLCYCOVERAGEBASIC
Coverage in Insurance Policy
I_INSURPLCYCOVERAGEBASIC is a CDS View in S/4HANA. Coverage in Insurance Policy. It contains 32 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurancePolicyContrCoverage | view_entity | from | COMPOSITE | Contract Coverage in Insurance Policy |
| I_InsurancePolicyCoverage | view_entity | from | COMPOSITE | Coverage of Cvrg Package in Insur Plcy |
| 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_InsurOpenApplContrCoverage | view_entity | from | COMPOSITE | Contract Coverage in InsurOpenAppl |
| I_InsurOpenApplCoverage | view_entity | from | COMPOSITE | Coverage of Cvrg Package in InsOpenAppl |
| P_InsurOpenApplCoverage | view_entity | from | COMPOSITE | |
| P_InsurOpenApplCoverage | view_entity | union | COMPOSITE |
Fields (32)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | 7 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 7 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 7 |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 7 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 4 |
| InsurContrCanclnRsn | InsurContrCanclnRsn | 6 | |
| InsurPlcyBonusMalusIsNotCeded | InsurPlcyBonusMalusIsNotCeded | 6 | |
| InsurPlcyBonusRestorerType | InsurPlcyBonusRestorerType | 6 | |
| InsurPlcyCoverageCurrency | InsurPlcyCoverageCurrency | 6 | |
| InsurPlcyCoverageEndDateTime | InsurPlcyCoverageEndDateTime | 6 | |
| InsurPlcyCoverageStartDateTime | InsurPlcyCoverageStartDateTime | 6 | |
| InsurPlcyCoverageSuspension | InsurPlcyCoverageSuspension | 6 | |
| InsurPlcyCrteInsurEndMessage | InsurPlcyCrteInsurEndMessage | 6 | |
| InsurPlcyCvrgCanclnDateTime | InsurPlcyCvrgCanclnDateTime | 6 | |
| InsurPlcyCvrgInsrdSumCalcMeth | InsurPlcyCvrgInsrdSumCalcMeth | 6 | |
| InsurPlcyCvrgInsuredSumAmount | InsurPlcyCvrgInsuredSumAmount | 6 | |
| InsurPlcyCvrgInsuredSumPercent | InsurPlcyCvrgInsuredSumPercent | 6 | |
| InsurPlcyCvrgLifeCycleStatus | InsurPlcyCvrgLifeCycleStatus | 6 | |
| InsurPlcyCvrgPremExmpReason | InsurPlcyCvrgPremExmpReason | 6 | |
| InsurPlcyCvrgSuspnEndDateTime | InsurPlcyCvrgSuspnEndDateTime | 6 | |
| InsurPlcyCvrgSuspnStrtDateTime | InsurPlcyCvrgSuspnStrtDateTime | 6 | |
| InsurPlcyDiscProtIsActive | InsurPlcyDiscProtIsActive | 6 | |
| InsurPlcyElementaryProdTmpl | InsurPlcyElementaryProdTmpl | 6 | |
| InsurPlcyInsuranceCoverage | InsurPlcyInsuranceCoverage | 6 | |
| InsurPlcyInsurEndMsgSendDate | InsurPlcyInsurEndMsgSendDate | 6 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 6 | |
| InsurPlcyNrOfVehClaimsRestored | InsurPlcyNrOfVehClaimsRestored | 6 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 6 | |
| InsurPlcySubcoverageVariant | InsurPlcySubcoverageVariant | 6 | |
| InsurPlcyVehDeregistrationDate | InsurPlcyVehDeregistrationDate | 6 | |
| InsurPlcyVehInsurCoverEndDate | InsurPlcyVehInsurCoverEndDate | 6 | |
| LastChangeDateTime | LastChangeDateTime | 6 |
@EndUserText.label: 'Coverage in Insurance Policy'
@VDM: {
viewType: #BASIC
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'InsurPlcyCoverageID',
semanticKey: [ 'InsurPlcyInsuranceCoverage' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XL
},
supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
technicalName: 'IPCvrgBsc'
}
define view entity I_InsurPlcyCoverageBasic
as select from /pm0/abdacov as Coverage
// Join to sibling data - if available
left outer to one join /pm0/apdacov as PC_Coverage on Coverage.policy_id = PC_Coverage.policy_id
and Coverage.ppdpac_id = PC_Coverage.ppdpac_id
and Coverage.policyproduct_id = PC_Coverage.policyproduct_id
and Coverage.journalendno_id = PC_Coverage.journalendno_id
and Coverage.journalno_id = PC_Coverage.journalno_id
and Coverage.covpac_id = PC_Coverage.covpac_id
and Coverage.coverage_id = PC_Coverage.coverage_id
left outer to one join /mva/amdacov as MV_Coverage on Coverage.policy_id = MV_Coverage.policy_id
and Coverage.ppdpac_id = MV_Coverage.ppdpac_id
and Coverage.policyproduct_id = MV_Coverage.policyproduct_id
and Coverage.journalendno_id = MV_Coverage.journalendno_id
and Coverage.journalno_id = MV_Coverage.journalno_id
and Coverage.covpac_id = MV_Coverage.covpac_id
and Coverage.coverage_id = MV_Coverage.coverage_id
association [1..1] to I_Currency as _Currency on $projection.InsurPlcyCoverageCurrency = _Currency.Currency
{
key cast( Coverage.policy_id as /pm0/vdm_policy_uuid preserving type ) as InsurPlcyUUID,
key Coverage.policyproduct_id as InsurPlcyInsurContr,
key Coverage.covpac_id as InsurPlcyCoveragePackageID,
key Coverage.coverage_id as InsurPlcyCoverageID,
key cast( Coverage.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
key Coverage.journalendno_id as InsurPlcyJrnlEndNmbr,
@Consumption.hidden: true
Coverage.ppdpac_id as InsurPlcyProductPackageID,
Coverage.coveragenr_tt as InsurPlcyInsuranceCoverage,
Coverage.pm_id as InsurPlcyElementaryProdTmpl,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Coverage.covbeg_dt,
Coverage.starttime_tm,
Coverage.starttimezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_cov_start_datetime preserving type ) as InsurPlcyCoverageStartDateTime,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Coverage.covend_dt,
Coverage.endtime_tm,
Coverage.endtimezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_cov_end_datetime preserving type ) as InsurPlcyCoverageEndDateTime,
Coverage.covstatus_cd as InsurPlcyCvrgPremExmpReason,
Coverage.actinactst_cd as InsurPlcyCvrgLifeCycleStatus,
Coverage.cancreas_cd as InsurContrCanclnRsn,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Coverage.ccldate_dt,
Coverage.reversal_tm,
Coverage.ccltmezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_cov_cln_datetime preserving type ) as InsurPlcyCvrgCanclnDateTime,
Coverage.susptp_cd as InsurPlcyCoverageSuspension,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Coverage.suspbeg_dt,
Coverage.suspbeg_tm,
Coverage.suspbegtimez_tt,
$session.client,
'NULL' ) as /pm0/vdm_susp_start_datetime preserving type ) as InsurPlcyCvrgSuspnStrtDateTime,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Coverage.suspend_dt,
Coverage.suspend_tm,
Coverage.suspendtimez_tt,
$session.client,
'NULL' ) as /pm0/vdm_susp_end_datetime preserving type ) as InsurPlcyCvrgSuspnEndDateTime,
@Semantics.amount.currencyCode: 'InsurPlcyCoverageCurrency'
case
when PC_Coverage.coverage_id <> 0 then PC_Coverage.insamount_am
when MV_Coverage.coverage_id <> 0 then MV_Coverage./mva/insamount_am
else cast( 0 as /pm0/apd_insamount_am )
end as InsurPlcyCvrgInsuredSumAmount,
PC_Coverage.insamtp_cd as InsurPlcyCvrgInsrdSumCalcMeth,
PC_Coverage.insamount_vl as InsurPlcyCvrgInsuredSumPercent,
@ObjectModel.foreignKey.association: '_Currency'
case
when PC_Coverage.coverage_id <> 0 then PC_Coverage.curr_id
when MV_Coverage.coverage_id <> 0 then MV_Coverage./mva/curr_id
else cast( ' ' as /pm0/abd_currency_id )
end as InsurPlcyCoverageCurrency,
//FS-PM Auto sibling specific fields
MV_Coverage./mva/bmstype_cd as InsurPlcyBonusRestorerType,
MV_Coverage./mva/unsbscrb_dt as InsurPlcyVehDeregistrationDate,
MV_Coverage./mva/prvntbm_fg as InsurPlcyBonusMalusIsNotCeded,
MV_Coverage./mva/deliver_dt as InsurPlcyInsurEndMsgSendDate,
MV_Coverage./mva/covvar_cd as InsurPlcySubcoverageVariant,
MV_Coverage./mva/insend_dt as InsurPlcyVehInsurCoverEndDate,
MV_Coverage./mva/bsclcnt_vl as InsurPlcyNrOfVehClaimsRestored,
MV_Coverage./mva/creaters_id as InsurPlcyCrteInsurEndMessage,
MV_Coverage./mva/ncmdpact_fg as InsurPlcyDiscProtIsActive,
@Consumption.hidden: true
Coverage.bo_cd as InsurPlcyBusinessObject,
@Semantics.systemDateTime.lastChangedAt: true
Coverage.change_ts as LastChangeDateTime,
_Currency
}