R_InsuranceContractTP

DDL: R_INSURANCECONTRACTTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API

Contract in Insur Policy - TP

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

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
I_InsuranceContract I_InsuranceContract from

Associations (11)

CardinalityTargetAliasCondition
[1..1] E_InsuranceContract _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[1..1] E_InsurancePolicyPremium _Extension_Prem $projection.InsurPlcyUUID = _Extension_Prem.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension_Prem.InsurPlcyInsurContr and 0 = _Extension_Prem.InsurPlcyCoveragePackageID and 0 = _Extension_Prem.InsurPlcyCoverageID and 0 = _Extension_Prem.InsurPlcyCoverageOptionID and 0 = _Extension_Prem.InsurPlcyInsuredObjectID and $projection.InsurancePolicyPremium = _Extension_Prem.InsurancePolicyPremium and $projection.InsurPlcyPremiumJournalNumber = _Extension_Prem.InsurPlcyJrnlNmbr and $projection.InsurPlcyPremJournalEndNumber = _Extension_Prem.InsurPlcyJrnlEndNmbr
[1..*] R_InsurPolicyContrCoverageTP _InsurancePolicyContrCoverage
[0..*] R_InsurPlcyCoveragePackageTP _InsurPlcyCoveragePackage
[0..*] R_InsurancePolicyContrLimitTP _InsurancePolicyContrLimit
[0..*] R_InsurancePolicyContrClauseTP _InsurancePolicyContrClause
[0..*] R_InsurPlcyContrSurchrgDiscTP _InsurPlcyContrSurchrgDisc
[1..*] R_InsurancePolicyPremPayerTP _InsurancePolicyPremPayer
[0..*] R_InsurPolicyContrDeductibleTP _InsurPolicyContrDeductible
[0..*] R_InsurPlcyContrInsrdObjectTP _InsurPlcyContrInsuredObject
[0..*] R_InsurContrPlndProcessingTP _InsurContrPlndProcg

Annotations (8)

NameValueLevelField
EndUserText.label Contract in Insur Policy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsurContr view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr
InsurPolicyContractPackageID InsurPlcyProductPackageID
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr
InsuranceContract InsuranceContract
InsuranceContractControl InsurPlcyProductTemplate
InsurPlcyLineOfBusiness InsurPlcyLineOfBusiness
InsurPlcyContractStartDateTime InsurPlcyContractStartDateTime
InsurPlcyContractEndDateTime InsurPlcyContractEndDateTime
InsrrIDByInsrr InsrrIDByInsrr
InsurContrLifeCycSts InsurContrLifeCycSts
InsurContrTrifVar InsurContrTrifVar
InsurCollDisbmtInsurObj InsurCollDisbmtInsurObj
InsurContrRnwlType InsurContrRnwlType
InsurContrCanclnRsn InsurContrCanclnRsn
InsurPlcyContrCanclnDateTime InsurPlcyContrCanclnDateTime
InsurApplRjcnRsn InsurApplRjcnRsn
InsurApplLifeCycSts InsurApplLifeCycSts
InsurPlcyCountry InsurPlcyCountry
InsurancePolicyPremium InsurancePolicyPremium
InsurPlcyPremiumJournalNumber InsurPlcyPremiumJournalNumber
InsurPlcyPremJournalEndNumber InsurPlcyPremJournalEndNumber
InsurPremSpecPaytRcrrcFrqcy InsurPremSpecPaytRcrrcFrqcy
InsurPerdPremBfrTaxPaytAmt InsurPerdPremBfrTaxPaytAmt
InsurPerdPremAftTaxPaytAmt InsurPerdPremAftTaxPaytAmt
InsurPremType InsurPremType
InsurContrIsPremExempt InsurContrIsPremExempt
InsurContrPremExmpEndDte InsurContrPremExmpEndDte
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency
InsurPlcyTotAnnPremAmt InsurPlcyTotAnnPremAmt
InsurPlcyPerdPremBfrTxPaytAmt InsurPlcyPerdPremBfrTxPaytAmt
InsurPlcyMainDueDayMonth InsurPlcyMainDueDayMonth
InsurancePolicyPremiumControl InsurPlcyPremiumTemplate
LastChangeDateTime LastChangeDateTime
_InsurancePolicy _InsurancePolicy
_InsurPlcyCoveragePackage _InsurPlcyCoveragePackage
_InsurancePolicyPremPayer _InsurancePolicyPremPayer
_InsurancePolicyContrLimit _InsurancePolicyContrLimit
_InsurancePolicyContrClause _InsurancePolicyContrClause
_InsurPlcyContrSurchrgDisc _InsurPlcyContrSurchrgDisc
_InsurPolicyContrDeductible _InsurPolicyContrDeductible
_InsurPlcyContrInsuredObject _InsurPlcyContrInsuredObject
_InsurancePolicyContrCoverage _InsurancePolicyContrCoverage
_InsurContrPlndProcg _InsurContrPlndProcg 
@EndUserText.label: 'Contract in Insur Policy - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [  '_InsurPlcyCoveragePackage',
                             '_InsurancePolicyPremPayer',
                             '_InsurancePolicyContrLimit',
                             '_InsurancePolicyContrClause',
                             '_InsurPlcyContrSurchrgDisc',
                             '_InsurPolicyContrDeductible',
                             '_InsurPlcyContrInsuredObject',
                             '_InsurancePolicyContrCoverage',
                             '_InsurContrPlndProcg']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsurContr',
   semanticKey: [ 'InsuranceContract' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity R_InsuranceContractTP
  as select from I_InsuranceContract

  composition [1..*] of R_InsurPolicyContrCoverageTP   as _InsurancePolicyContrCoverage
  composition [0..*] of R_InsurPlcyCoveragePackageTP   as _InsurPlcyCoveragePackage
  composition [0..*] of R_InsurancePolicyContrLimitTP  as _InsurancePolicyContrLimit
  composition [0..*] of R_InsurancePolicyContrClauseTP as _InsurancePolicyContrClause
  composition [0..*] of R_InsurPlcyContrSurchrgDiscTP  as _InsurPlcyContrSurchrgDisc
  composition [1..*] of R_InsurancePolicyPremPayerTP   as _InsurancePolicyPremPayer
  composition [0..*] of R_InsurPolicyContrDeductibleTP as _InsurPolicyContrDeductible
  composition [0..*] of R_InsurPlcyContrInsrdObjectTP  as _InsurPlcyContrInsuredObject
  composition [0..*] of R_InsurContrPlndProcessingTP   as _InsurContrPlndProcg

  association        to parent R_InsurancePolicyTP            as _InsurancePolicy on  $projection.InsurPlcyUUID = _InsurancePolicy.InsurPlcyUUID

  association [1..1] to E_InsuranceContract            as _Extension              on  $projection.InsurPlcyUUID        = _Extension.InsurPlcyUUID
                                                                                  and $projection.InsurPlcyInsurContr  = _Extension.InsurPlcyInsurContr
                                                                                  and $projection.InsurPlcyJrnlNmbr    = _Extension.InsurPlcyJrnlNmbr
                                                                                  and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr

  association [1..1] to E_InsurancePolicyPremium       as _Extension_Prem         on  $projection.InsurPlcyUUID                 = _Extension_Prem.InsurPlcyUUID
                                                                                  and $projection.InsurPlcyInsurContr           = _Extension_Prem.InsurPlcyInsurContr
                                                                                  and 0                                         = _Extension_Prem.InsurPlcyCoveragePackageID
                                                                                  and 0                                         = _Extension_Prem.InsurPlcyCoverageID
                                                                                  and 0                                         = _Extension_Prem.InsurPlcyCoverageOptionID
                                                                                  and 0                                         = _Extension_Prem.InsurPlcyInsuredObjectID
                                                                                  //and 0                                         = _Extension_Prem.InsurPlcyPremSubjectID

                                                                                  and $projection.InsurancePolicyPremium        = _Extension_Prem.InsurancePolicyPremium
                                                                                  and $projection.InsurPlcyPremiumJournalNumber = _Extension_Prem.InsurPlcyJrnlNmbr
                                                                                  and $projection.InsurPlcyPremJournalEndNumber = _Extension_Prem.InsurPlcyJrnlEndNmbr

{

  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
      InsurPlcyProductPackageID as InsurPolicyContractPackageID,
      InsurPlcyJrnlNmbr,
      InsurPlcyJrnlEndNmbr,
      InsuranceContract,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'
      InsurPlcyProductTemplate  as InsuranceContractControl,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyLineOfBusiness'
      InsurPlcyLineOfBusiness,
      InsurPlcyContractStartDateTime,
      InsurPlcyContractEndDateTime,
      @ObjectModel.sapObjectNodeTypeReference: 'Insurer'
      InsrrIDByInsrr,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurContractLifeCycleStatus'
      InsurContrLifeCycSts,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceContractTariffVariant'
      InsurContrTrifVar,
      InsurCollDisbmtInsurObj,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceContractRenewalType'
      InsurContrRnwlType,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurContrCancellationReason'
      InsurContrCanclnRsn,
      InsurPlcyContrCanclnDateTime,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceApplRejectionReason'
      InsurApplRjcnRsn,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurApplLifeCycleStatus'
      InsurApplLifeCycSts,
      InsurPlcyCountry,
      InsurancePolicyPremium,
      InsurPlcyPremiumJournalNumber,
      InsurPlcyPremJournalEndNumber,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPremSpecPaytRcrrcFrqcy'
      InsurPremSpecPaytRcrrcFrqcy,
      InsurPerdPremBfrTaxPaytAmt,
      InsurPerdPremAftTaxPaytAmt,
      InsurPremType,
      InsurContrIsPremExempt,
      InsurContrPremExmpEndDte,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      InsurPlcyPremiumCurrency,
      InsurPlcyTotAnnPremAmt,
      InsurPlcyPerdPremBfrTxPaytAmt,
      InsurPlcyMainDueDayMonth,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'
      InsurPlcyPremiumTemplate  as InsurancePolicyPremiumControl,
      LastChangeDateTime,

      /* Associations */
      _InsurancePolicy,
      _InsurPlcyCoveragePackage,
      _InsurancePolicyPremPayer,
      _InsurancePolicyContrLimit,
      _InsurancePolicyContrClause,
      _InsurPlcyContrSurchrgDisc,
      _InsurPolicyContrDeductible,
      _InsurPlcyContrInsuredObject,
      _InsurancePolicyContrCoverage,
      _InsurContrPlndProcg

}

Learn More