I_InsurApplCoverageLimit

@EndUserText.label: 'Cvrg Limit of Cvrg Pckg in Insur Appl'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyLimitID',
   semanticKey: [ 'InsurPlcyLimitID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IACvrgLmt'
}

define view entity I_InsurApplCoverageLimit
  as select from P_InsurPolicyJournalKeys as PlcyJrnl
    inner join   I_InsurPlcyLimitBasic    as Limit on  PlcyJrnl.InsurPlcyUUID                  =  Limit.InsurPlcyUUID
                                                   and PlcyJrnl.InsurPlcyInsurContr            =  Limit.InsurPlcyInsurContr
                                                   and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Limit.InsurPlcyJrnlNmbr
                                                   and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Limit.InsurPlcyJrnlEndNmbr

  association        to parent I_InsurApplCoverage as _InsurApplCoverage  on  $projection.InsurPlcyUUID                  = _InsurApplCoverage.InsurPlcyUUID
                                                                          and $projection.InsurPlcyInsurContr            = _InsurApplCoverage.InsurPlcyInsurContr
                                                                          and $projection.InsurPlcyCoveragePackageID     = _InsurApplCoverage.InsurPlcyCoveragePackageID
                                                                          and $projection.InsurPlcyCoverageID            = _InsurApplCoverage.InsurPlcyCoverageID
                                                                          and $projection.InsurPlcyContrDataDetnJrnlNmbr = _InsurApplCoverage.InsurPlcyContrDataDetnJrnlNmbr

  association [1..1] to I_Currency                 as _Currency           on  $projection.InsurPlcyLimitCurrency = _Currency.Currency
  association [1..*] to I_InsurPlcyTemplateT       as _InsurPlcyTemplateT on  $projection.InsurPlcyLimitTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

{

  key Limit.InsurPlcyUUID,
  key Limit.InsurPlcyInsurContr,
  key Limit.InsurPlcyCoveragePackageID,
  key Limit.InsurPlcyCoverageID,
  key Limit.InsurPlcySubCvrgID,
  key Limit.InsurPlcyLimitID,
  key cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      Limit.InsurPlcyJrnlNmbr,
      Limit.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Limit.InsurPlcyProductPackageID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      Limit.InsurPlcyLimitTemplate,
      @Semantics.amount.currencyCode: 'InsurPlcyLimitCurrency'
      Limit.InsurPlcyLimitAmount,
      @ObjectModel.foreignKey.association: '_Currency'
      Limit.InsurPlcyLimitCurrency,
      @Semantics.systemDateTime.lastChangedAt: true
      Limit.LastChangeDateTime,

      /* Associations */
      _InsurApplCoverage,
      @Consumption.hidden: true
      _Currency,
      @Consumption.hidden: true
      _InsurPlcyTemplateT

}
where
      Limit.InsurPlcySubCvrgID         =  0
  and Limit.InsurPlcyCoveragePackageID <> 0
  and Limit.InsurPlcyCoverageID        <> 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYLIMITBASIC",
"P_INSURPOLICYJOURNALKEYS"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_INSURAPPLCOVERAGE",
"I_INSURPLCYTEMPLATET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/