R_INSURPLCYCONTRACTTP

CDS View

Contract under Policy

R_INSURPLCYCONTRACTTP is a CDS View in S/4HANA. Contract under Policy. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_InsurancePolicyContract view_entity projection CONSUMPTION Contract under Policy
A_InsurOpenApplicationContract view_entity projection CONSUMPTION Contract under Policy 
@EndUserText.label: 'Contract under Policy'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   semanticKey: [ 'InsurPlcyInsurContr' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'BPD',
  allowNewDatasources: false,
  dataSources: [ '_Extension' ],
  allowNewCompositions: true,
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}

@ObjectModel.sapObjectNodeType.name: 'InsurancePolicyContract'

define root view entity R_InsurPlcyContractTP
  as select from I_InsurancePolicyContract

  association [1..1] to R_InsurancePolicyTP_2         as _Policy          on  $projection.InsurPlcyUUID = _Policy.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 [0..*] to R_InsurPlcyContrCoverageTP_2  as _Coverage        on  $projection.InsurPlcyUUID       = _Coverage.InsurPlcyUUID
                                                                          and $projection.InsurPlcyInsurContr = _Coverage.InsurPlcyInsurContr

  association [0..*] to R_InsurPlcyContrCvrgPackageTP as _CoveragePackage on  $projection.InsurPlcyUUID       = _CoveragePackage.InsurPlcyUUID
                                                                          and $projection.InsurPlcyInsurContr = _CoveragePackage.InsurPlcyInsurContr

  association [0..*] to R_InsurPlcyAccountingTP_2 as _TransferSettle on $projection.InsurancePolicyContract   = _TransferSettle.InsurPlcyAcctgExtContrNmbr

  composition [0..*] of R_InsurPlcyContrReltdContrTP  as _RelatedContract
  composition [0..*] of R_InsurPlcyContrBeneficiaryTP as _Beneficiary
  composition [0..*] of R_InsurPlcyCBCPayerTP         as _CBCPayer
  composition [0..*] of R_InsurPlcyContractChargeTP   as _Charge
  composition [0..*] of R_InsurPlcyContractCreditorTP as _Creditor
  composition [0..*] of R_InsurPlcyContractDcblTP_2   as _Deductible
  composition [0..*] of R_InsurPlcyContrAdjustmentTP  as _Adjustment
  composition [0..*] of R_InsurPlcyContractLimitTP_2  as _Limit
  composition [0..*] of R_InsurPlcyPremiumPayerTP_2   as _PremiumPayer
  composition [0..*] of R_InsurPlcyContrSuDscTP       as _SurchargeDiscount
  composition [0..*] of R_InsurPlcyContrValDateTP     as _ValueDate
  composition [0..*] of R_InsurPlcyContractPremiumTP  as _Premium
  composition [0..*] of R_InsurPlcyContrClauseTP_2    as _Clause
  composition [0..*] of R_InsurPlcyContractBenefitTP  as _Benefit
  composition [0..*] of R_InsurPlcyProcDpCndTP        as _ProcessDependentCondition
  composition [0..*] of R_InsurPlcyContrInsObTP_2     as _InsuredObject
  composition [0..*] of R_InsurPlcyContrExtRefTP      as _ExternalReference
  composition [0..1] of R_InsurPlcyLifeContractTP     as _LifeContract
  composition [0..1] of R_InsurPlcyGeneralContractTP  as _GeneralContract

{
  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
      _Policy.InsrrIDByInsrr,
      _Policy.InsurPlcyAuthznSlsProductGroup,
      InsurPlcyJrnlNmbr,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyProductPackageID,
      InsurPlcyContractIsCanceled,
      InsurancePolicyContract,
      InsurPlcyContrOldContractID,
      InsurPlcyContrNmbrOfCoverage,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyLineOfBusiness'
      InsurPlcyLineOfBusiness,
      //      InsurPlcyContractStartDateTime,

      InsurPlcyContractStartDate,
      InsurancePolicyStartTime,
      InsurancePolicyStartTimeZone,
      //      InsurPlcyContractEndDateTime,

      InsurancePolicyContractEndDate,
      InsurancePolicyEndTime,
      InsurancePolicyEndTimeZone,
      InsurPlcyContrCommentID,
      LongText,
      TextObjectCategory,
      TextObjectKey,
      Language,
      InsurPlcyContractCompanyID,
      InsurPlcyContractPolicyStatus,
      InsurPlcyContractCategory,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyContractStatus'
      InsurPlcyContrLifeCycleStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurContrCancellationReason'
      InsurPlcyContrCanclnRsn,
      //      InsurPlcyContrCanclnDateTime,

      InsurPlcyContrCanclnDte,
      InsurPlcyContractReversalTime,
      InsurPlcyContrReversalTimeZone,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyReversalAcctgVariant'
      InsurPlcyContractAcctVariant,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyPremiumPaymentStatus'
      InsurancePolicyContractStatus,
      InsurPlcyContrSuspensionType,
      //      InsurPlcyContrSuspnStrtDteTme,

      InsurPlcySuspensionBeginDate,
      InsurPlcySuspensionBeginTime,
      InsurPlcySuspnBeginTmeZn,
      //      InsurPlcyBsCvrgSuspnEndDteTime,

      InsurPlcySuspensionEndDate,
      InsurPlcySuspensionEndTime,
      InsurPlcySuspensionEndTimeZone,
      InsurPlcyContrMatlStartDate,
      InsurPlcyContrExtensionVariant,
      InsPlcyContrIsCoPensnSchmPmtd,
      InsurPlcyContrIsAdjustment,
      InsurPlcyContrTariffVariant,
      InsurPlcyContrIsManualRating,
      InsurPlcyContrGenerationDate,
      InsurPlcyContrProRtTmpVariant,
      InsurPlcyProductTemplate,
      InsurPlcyContrExprtnAgeValue,
      InsurPlcyContractRejectionDate,
      InsurPlcyContrRejectionReason,
      InsPlcyContrSrceDocStsDateTime,
      InsurPlcyContrInsurObjectID,
      InsPlcyContrHasPndgCommsnCase,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyCommsnPostingCode'
      InsurPlcyContrCommsnPostgCode,
      InsurPlcyContractIsLifetime,
      InsurPlcyPrvsnlContractNumber,
      InsurPlcyCountry,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyTaxPayerInfo'
      InsurPlcyContrTxblPersnInfo,
      InsurPlcyContractIsGeneration,
      InsurPlcyContractRegion,
      InsurPlcyContrScpOfPremTxn,
      InsurPlcyContrIsAlreadyIncld,
      InsPlcyContrDiffntMttyDayMnth,
      InsurPlcyContrFirstProcessorID,
      InsurPlcyContrSecondProcsrID,
      InsurPlcyContrRefusalRsnText,
      InsurPlcyContrIsCheckPending,
      InsurPlcyContrIsAutomProdChg,
      InsurPlcyContrTransferType,
      InsurPlcyContrConversionType,
      InsurPlcyContrAutomProdChgDate,
      InsurPlcyContrGnrtnDetnDate,
      InsurPlcyContractIsDuplicate,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyShiftMode'
      InsurPlcyContractShiftType,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyFinalRenewalDecision'
      InsurPlcyContrFnlRnwlDcsn,
      InsurPlcyContrRnwlRefusalRsn,
      InsurPlcyContrRenewalDate,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyRenewalDecision'
      InsurPlcyContrRnwlDecision,
      InsurPlcyContrRnwlPrepLastDate,
      InsurPlcyContractCurrency,
      InsurPlcyContrAbsltMnlPMLAmt,
      InsurPlcyContrRltvMnlPMLRate,
      InsurPlcyContrIsMnlPostprocg,
      InsurPlcyContrMnlFldLblAmtText,
      InsurPlcyContrEnhancedLife,
      InsurPlcyContrLoanLimitRate,
      InsPlcyContrAutomPremLoanOptn,
      InsurPlcyContrMaxLoanAmount,
      InsurPlcyContractLocalCurrency,
      InsurPlcyContractRiskCurrency,
      InsurPlcyContrInvoiceCurrency,
      InsurPlcyContrRiskExchRate,
      InsurPlcyContrRiskExchRateDte,
      InsurPlcyContrInvcCrcyExchRate,
      InsurPlcyContrInvcExchRateDte,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyExchangeRateDetn'
      InsurPlcyContrExchRateDetn,
      InsurPlcyContrRskApplExchRate,
      InsPlcyContrRskApplExchRateDte,
      InsurPlcyContrInvcApplExchRate,
      InsurPlcyInvcApplExchRateDate,
      InsurPlcyContrQuotationVariant,
      InsurPlcyBusinessObject,
      LastChangeDateTime,

//      _GeneralContract.InsurPlcyGenContrEndDate,

//      _GeneralContract.InsurPlcyGenContrInsurDurn,

//      _GeneralContract.InsurPlcyGenContrLossAbsltAmt,

//      _GeneralContract.InsurPlcyGenContrMaxLossInPct,

//      _GeneralContract.InsurPlcyGenContrCrcy,

//      _GeneralContract.InsurPlcyGenContrMnlFldLblTxt,

//      _GeneralContract.InsPlcyGenContrPostprocgIsRqd,

//      _LifeContract.InsurPlcyLifeContrEmplJoinDte,

//      _LifeContract.InsurPlcyLifeContrCalcRuleType,

//      _LifeContract.InsurPlcyLifeContrCoPensnSchm,

//      _LifeContract.InsPlcyLifeContrGuaranteedOptn,

//      _LifeContract.InsurPlcyLifeContrSpcfdAddlAmt,

//      _LifeContract.InsurPlcyLifeContrRnstmntSpec,

//      _LifeContract.InsPlcyContrDvdndCrdtIsTrnsfd,

//      _LifeContract.InsurPlcyLifeContrSrrndrValCat,

//      _LifeContract.InsurPlcyLifeContrPrtlSrrndr,

//      _LifeContract.InsurPlcyLifeContrBnftIncrSpec,

//      _LifeContract.InsurPlcyLifeContrPlcyDurnSpec,

//      _LifeContract.InsurPlcyLifeContrAvailPremShr,

//      _LifeContract.InsurPlcyLifeContrPremHasExmpt,

//      _LifeContract.InsurPlcyLifeContrPremExmpRsn,

//      _LifeContract.InsurPlcyLifeContrCurrency,

//      _LifeContract.InsurPlcyContrFreeLookIsExists,

//      _LifeContract.InsurPlcyContrFreeLookEndDte,

//      _LifeContract.InsurPlcyLifeContrEntrFeeAmt,

//      _LifeContract.InsPlcyLifeContrEntrFeeIsPaid,

//      _LifeContract.InsurPlcyLifeContrFreeLookPerd,

//      _LifeContract.InsurPlcyLifeContrModifCatAdd,

//      _LifeContract.InsurPlcyLifeContrModifCatChg,

//      _LifeContract.InsurPlcyLifeContrModifCat,

//      _LifeContract.InsurPlcyLifeContrAdjmtTrifVar,

//      _LifeContract.InsurPlcyLifeContrAddlTrifVar,

//      _LifeContract.InsurPlcyLifeContrIncrTrifVar,


      /*association*/
      _Currency,
      _RelatedContract,
      _Beneficiary,
      _CBCPayer,
      _Charge,
      _Creditor,
      _Deductible,
      _Adjustment,
      _Limit,
      _PremiumPayer,
      _SurchargeDiscount,
      _ValueDate,
      _Premium,
      _Clause,
      _Benefit,
      _ProcessDependentCondition,
      _InsuredObject,
      _Coverage,
      _CoveragePackage,
      _ExternalReference,
      _LifeContract,
      _GeneralContract,
      _TransferSettle
      
}

where
  InsurPlcyProductPackageID = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCEPOLICYCONTRACT",
"R_INSURANCEPOLICYTP_2"
],
"ASSOCIATED":
[
"I_CURRENCY",
"R_INSURPLCYACCOUNTINGTP_2",
"R_INSURPLCYCBCPAYERTP",
"R_INSURPLCYCONTRACTBENEFITTP",
"R_INSURPLCYCONTRACTCHARGETP",
"R_INSURPLCYCONTRACTCREDITORTP",
"R_INSURPLCYCONTRACTDCBLTP_2",
"R_INSURPLCYCONTRACTLIMITTP_2",
"R_INSURPLCYCONTRACTPREMIUMTP",
"R_INSURPLCYCONTRADJUSTMENTTP",
"R_INSURPLCYCONTRBENEFICIARYTP",
"R_INSURPLCYCONTRCLAUSETP_2",
"R_INSURPLCYCONTRCOVERAGETP_2",
"R_INSURPLCYCONTRCVRGPACKAGETP",
"R_INSURPLCYCONTREXTREFTP",
"R_INSURPLCYCONTRINSOBTP_2",
"R_INSURPLCYCONTRRELTDCONTRTP",
"R_INSURPLCYCONTRSUDSCTP",
"R_INSURPLCYCONTRVALDATETP",
"R_INSURPLCYGENERALCONTRACTTP",
"R_INSURPLCYLIFECONTRACTTP",
"R_INSURPLCYPREMIUMPAYERTP_2",
"R_INSURPLCYPROCDPCNDTP"
],
"BASE":
[
"I_INSURANCEPOLICYCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More