I_INSURPLCYDEDUCTIBLEBASIC

@EndUserText.label: 'Deductible in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyDeductibleID',
   semanticKey: [ 'InsurPlcyDeductibleID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
//@Metadata.allowExtensions: true

@Analytics: {
  technicalName: 'IPDcblBsc'
}

define view entity I_InsurPlcyDeductibleBasic
  as select from /pm0/abdadedctbl as Deductible

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

{

  key cast( Deductible.policy_id as /pm0/vdm_policy_uuid preserving type )          as InsurPlcyUUID,
  key Deductible.policyproduct_id                                                   as InsurPlcyInsurContr,
  key Deductible.covpac_id                                                          as InsurPlcyCoveragePackageID,
  key Deductible.coverage_id                                                        as InsurPlcyCoverageID,
  key Deductible.subject_id                                                         as InsurPlcyInsuredObjectID,
  key Deductible.covcpco_id                                                         as InsurPlcySubCvrgID,
  key Deductible.dedctbl_id                                                         as InsurPlcyDeductibleID,
  key cast( Deductible.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key Deductible.journalendno_id                                                    as InsurPlcyJrnlEndNmbr,      
      Deductible.ppdpac_id                                                          as InsurPlcyProductPackageID,
      Deductible.deductible_cd                                                      as InsurPlcyDeductibleCategory,
      @Semantics.amount.currencyCode: 'InsurPlcyDeductibleCurrency'
      Deductible.dedctbl_am                                                         as InsurPlcyDeductibleAmount,
      cast( Deductible.ddtbegin_dt as /pm0/vdm_dcbl_start_date preserving type )    as InsurPlcyDeductibleStartDate,
      cast( Deductible.ddtend_dt   as /pm0/vdm_dcbl_end_date   preserving type )    as InsurPlcyDeductibleEndDate,
      cast( Deductible.pm_id as /pm0/vdm_dcbl_template_code preserving type )       as InsurPlcyDeductibleTemplate,
      @ObjectModel.foreignKey.association: '_Currency'
      Deductible.currency_id                                                        as InsurPlcyDeductibleCurrency,
      Deductible.deductibletyp_cd                                                   as InsurPlcyDeductibleAmountUnit,
      Deductible.dedctbl_vl                                                         as InsurPlcyDeductibleValue,
      @Consumption.hidden: true
      Deductible.bo_cd                                                              as InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      Deductible.change_ts                                                          as LastChangeDateTime,

      _Currency

}
where
      Deductible.covcp_id = 0
  and Deductible.uwdcn_id = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PM0/ABDADEDCTBL"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/