R_INSURANCECONTRACTTP

CDS View

Contract in Insur Policy - TP

R_INSURANCECONTRACTTP is a CDS View in S/4HANA. Contract in Insur Policy - TP. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_InsuranceContract view_entity projection CONSUMPTION Insurance Contract 
@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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCECONTRACT"
],
"ASSOCIATED":
[
"R_INSURANCEPOLICYCONTRCLAUSETP",
"R_INSURANCEPOLICYCONTRLIMITTP",
"R_INSURANCEPOLICYPREMPAYERTP",
"R_INSURANCEPOLICYTP",
"R_INSURCONTRPLNDPROCESSINGTP",
"R_INSURPLCYCONTRINSRDOBJECTTP",
"R_INSURPLCYCONTRSURCHRGDISCTP",
"R_INSURPLCYCOVERAGEPACKAGETP",
"R_INSURPOLICYCONTRCOVERAGETP",
"R_INSURPOLICYCONTRDEDUCTIBLETP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More