I_InsurancePolicyContrLimit

DDL: I_INSURANCEPOLICYCONTRLIMIT Type: view_entity COMPOSITE

Contract Limit in Insurance Policy

I_InsurancePolicyContrLimit is a Composite CDS View that provides data about "Contract Limit in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyLimitBasic) and exposes 16 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcySubCvrgID. It has 2 associations to related views.

1 data source(s) 16 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 Contract Limit in Insurance Policy 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 #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IPPlcyContrLmt view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyLimitBasic InsurPlcyUUID
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
InsurPlcyJrnlNmbr I_InsurPlcyLimitBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyLimitBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyLimitBasic InsurPlcyProductPackageID
InsurPlcyLimitTemplate I_InsurPlcyLimitBasic InsurPlcyLimitTemplate
InsurPlcyLimitAmount I_InsurPlcyLimitBasic InsurPlcyLimitAmount
InsurPlcyLimitCurrency I_InsurPlcyLimitBasic InsurPlcyLimitCurrency
LastChangeDateTime I_InsurPlcyLimitBasic LastChangeDateTime
_InsuranceContract _InsuranceContract
_Currency _Currency
_InsurPlcyTemplateT _InsurPlcyTemplateT 
@EndUserText.label: 'Contract Limit in Insurance Policy'
@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: #C,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPPlcyContrLmt'
}

define view entity I_InsurancePolicyContrLimit
  as select from I_InsurPlcyLimitBasic as Limit

  association        to parent I_InsuranceContract as _InsuranceContract  on  $projection.InsurPlcyUUID       = _InsuranceContract.InsurPlcyUUID
                                                                          and $projection.InsurPlcyInsurContr = _InsuranceContract.InsurPlcyInsurContr

  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,
      Limit.InsurPlcyJrnlNmbr,
      Limit.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Limit.InsurPlcyProductPackageID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      // @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'

      Limit.InsurPlcyLimitTemplate,
      @Semantics.amount.currencyCode: 'InsurPlcyLimitCurrency'
      Limit.InsurPlcyLimitAmount,
      @ObjectModel.foreignKey.association: '_Currency'
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      Limit.InsurPlcyLimitCurrency,
      @Semantics.systemDateTime.lastChangedAt: true
      Limit.LastChangeDateTime,

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

}
where
      Limit.InsurPlcyJrnlEndNmbr       = 2147483647
  and Limit.InsurPlcyBusinessObject    = 'P'
  and Limit.InsurPlcyCoveragePackageID = 0
  and Limit.InsurPlcyCoverageID        = 0
  and Limit.InsurPlcySubCvrgID         = 0

Learn More