I_InsurOpenApplCoverageLimit

DDL: I_INSUROPENAPPLCOVERAGELIMIT Type: view_entity COMPOSITE Package: VDM_PM_PLCY_OPEN_APPL_COMMON

Cvrg Limit of Cvrg Pckg in InsurOpenAppl

I_InsurOpenApplCoverageLimit is a Composite CDS View that provides data about "Cvrg Limit of Cvrg Pckg in InsurOpenAppl" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyLimitBasic) and exposes 19 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views. Part of development package VDM_PM_PLCY_OPEN_APPL_COMMON.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyLimitBasic Limit from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.InsurPlcyLimitCurrency = _Currency.Currency
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyLimitTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

Annotations (11)

NameValueLevelField
EndUserText.label Cvrg Limit of Cvrg Pckg in InsurOpenAppl view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyLimitID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IOACvrgLmt view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID OpenApplJrnl InsurPlcyApplUUID
KEY InsuranceApplication
KEY InsurPlcyInsurContr I_InsurPlcyLimitBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyLimitBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyLimitBasic InsurPlcyCoverageID
KEY InsurPlcySubCvrgID I_InsurPlcyLimitBasic InsurPlcySubCvrgID
KEY InsurPlcyLimitID I_InsurPlcyLimitBasic InsurPlcyLimitID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyLimitBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyLimitBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyLimitBasic InsurPlcyProductPackageID
InsurPlcyUUID OpenApplJrnl InsurPlcyUUID
InsurPlcyLimitTemplate I_InsurPlcyLimitBasic InsurPlcyLimitTemplate
InsurPlcyLimitAmount I_InsurPlcyLimitBasic InsurPlcyLimitAmount
InsurPlcyLimitCurrency I_InsurPlcyLimitBasic InsurPlcyLimitCurrency
LastChangeDateTime I_InsurPlcyLimitBasic LastChangeDateTime
_InsurOpenApplCoverage _InsurOpenApplCoverage
_Currency _Currency
_InsurPlcyTemplateT _InsurPlcyTemplateT 
@EndUserText.label: 'Cvrg Limit of Cvrg Pckg in InsurOpenAppl'
@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: 'IOACvrgLmt'
}
define view entity I_InsurOpenApplCoverageLimit
  as select from           I_InsurPlcyLimitBasic      as Limit

    left outer to one join P_InsurOpenApplLimitLatest as OpenApplJrnl on  (
        OpenApplJrnl.InsurPlcyUUID                                                                                    = Limit.InsurPlcyUUID
        or OpenApplJrnl.InsurPlcyApplUUID                                                                             = Limit.InsurPlcyUUID
      )
                                                                      and OpenApplJrnl.InsurPlcyInsurContr            = Limit.InsurPlcyInsurContr
                                                                      and OpenApplJrnl.InsurPlcyCoveragePackageID     = Limit.InsurPlcyCoveragePackageID
                                                                      and OpenApplJrnl.InsurPlcyCoverageID            = Limit.InsurPlcyCoverageID
                                                                      and OpenApplJrnl.InsurPlcySubCvrgID             = Limit.InsurPlcySubCvrgID
                                                                      and OpenApplJrnl.InsurPlcyLimitID               = Limit.InsurPlcyLimitID
                                                                      and OpenApplJrnl.InsurPlcyJrnlNmbr              = Limit.InsurPlcyJrnlNmbr
                                                                      and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr < Limit.InsurPlcyJrnlEndNmbr


  association        to parent I_InsurOpenApplCoverage as _InsurOpenApplCoverage on  $projection.InsurPlcyApplUUID              = _InsurOpenApplCoverage.InsurPlcyApplUUID
                                                                                 and $projection.InsuranceApplication           = _InsurOpenApplCoverage.InsuranceApplication
                                                                                 and $projection.InsurPlcyInsurContr            = _InsurOpenApplCoverage.InsurPlcyInsurContr
                                                                                 and $projection.InsurPlcyCoveragePackageID     = _InsurOpenApplCoverage.InsurPlcyCoveragePackageID
                                                                                 and $projection.InsurPlcyCoverageID            = _InsurOpenApplCoverage.InsurPlcyCoverageID
                                                                                 and $projection.InsurPlcyContrDataDetnJrnlNmbr = _InsurOpenApplCoverage.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 OpenApplJrnl.InsurPlcyApplUUID,
  key cast( OpenApplJrnl.InsuranceApplication as /pm0/vdm_applicationnr_tt preserving type )              as InsuranceApplication,
  key Limit.InsurPlcyInsurContr,
  key Limit.InsurPlcyCoveragePackageID,
  key Limit.InsurPlcyCoverageID,
  key Limit.InsurPlcySubCvrgID,
  key Limit.InsurPlcyLimitID,
  key cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      Limit.InsurPlcyJrnlNmbr,
      Limit.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Limit.InsurPlcyProductPackageID,
      OpenApplJrnl.InsurPlcyUUID,
      @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 */
      _InsurOpenApplCoverage,
      @Consumption.hidden: true
      _Currency,
      @Consumption.hidden: true
      _InsurPlcyTemplateT

}
where
      Limit.InsurPlcySubCvrgID          =  0
  and Limit.InsurPlcyCoveragePackageID  <> 0
  and Limit.InsurPlcyCoverageID         <> 0
  and OpenApplJrnl.InsurPlcyApplUUID    is not initial //Perf. Tuning: Make inner Join out of left outer Join

  and OpenApplJrnl.InsuranceApplication is not initial

Learn More