R_InsurancePolicyContrLimitTP

DDL: R_INSURANCEPOLICYCONTRLIMITTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API

Contract Limit in Insurance Policy - TP

R_InsurancePolicyContrLimitTP is a Transactional CDS View that provides data about "Contract Limit in Insurance Policy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurancePolicyContrLimit) and exposes 11 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyLimitID. It has 1 association to related views. Part of development package VDM_PM_PLCY_API.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurancePolicyContrLimit Limit from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyLimit _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and 0 = _Extension.InsurPlcyCoveragePackageID and 0 = _Extension.InsurPlcyCoverageID and 0 = _Extension.InsurPlcySubCvrgID and $projection.InsurPlcyLimitID = _Extension.InsurPlcyLimitID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr

Annotations (8)

NameValueLevelField
EndUserText.label Contract Limit in Insurance Policy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurancePolicyContrLimit InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurancePolicyContrLimit InsurPlcyInsurContr
KEY InsurPlcyLimitID I_InsurancePolicyContrLimit InsurPlcyLimitID
InsurPlcyJrnlNmbr I_InsurancePolicyContrLimit InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurancePolicyContrLimit InsurPlcyJrnlEndNmbr
InsurPolicyContractPackageID I_InsurancePolicyContrLimit InsurPlcyProductPackageID
InsurancePolicyLimitControl I_InsurancePolicyContrLimit InsurPlcyLimitTemplate
InsurPlcyLimitAmount I_InsurancePolicyContrLimit InsurPlcyLimitAmount
InsurPlcyLimitCurrency I_InsurancePolicyContrLimit InsurPlcyLimitCurrency
LastChangeDateTime I_InsurancePolicyContrLimit LastChangeDateTime
_InsuranceContract _InsuranceContract 
@EndUserText.label: 'Contract Limit in Insurance Policy - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyLimitID',
   semanticKey: [ 'InsurPlcyLimitID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity R_InsurancePolicyContrLimitTP
  as select from I_InsurancePolicyContrLimit as Limit

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

  association [1..1] to E_InsurancePolicyLimit       as _Extension         on  $projection.InsurPlcyUUID        = _Extension.InsurPlcyUUID
                                                                           and $projection.InsurPlcyInsurContr  = _Extension.InsurPlcyInsurContr
                                                                           and 0                                = _Extension.InsurPlcyCoveragePackageID
                                                                           and 0                                = _Extension.InsurPlcyCoverageID
                                                                           and 0                                = _Extension.InsurPlcySubCvrgID
                                                                           and $projection.InsurPlcyLimitID     = _Extension.InsurPlcyLimitID
                                                                           and $projection.InsurPlcyJrnlNmbr    = _Extension.InsurPlcyJrnlNmbr
                                                                           and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr

{

  key Limit.InsurPlcyUUID,
  key Limit.InsurPlcyInsurContr,
  key Limit.InsurPlcyLimitID,
      Limit.InsurPlcyJrnlNmbr,
      Limit.InsurPlcyJrnlEndNmbr,
      Limit.InsurPlcyProductPackageID as InsurPolicyContractPackageID,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'
      Limit.InsurPlcyLimitTemplate    as InsurancePolicyLimitControl,
      Limit.InsurPlcyLimitAmount,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      Limit.InsurPlcyLimitCurrency,
      Limit.LastChangeDateTime,

      /* Associations */
      _InsuranceContract

}

Learn More