R_InsurPlcySubcoverageTP_2

DDL: R_INSURPLCYSUBCOVERAGETP_2 Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API_COMMON

Subcoverage

R_InsurPlcySubcoverageTP_2 is a Transactional CDS View that provides data about "Subcoverage" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcySubCoverageBasic) and exposes 30 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcySubCvrgID. It has 5 associations to related views. Part of development package VDM_PM_PLCY_API_COMMON.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcySubCoverageBasic I_InsurPlcySubCoverageBasic from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicySubCoverage _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcySubCvrgID = _Extension.InsurPlcySubCvrgID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[0..*] R_InsurPlcySbcvrgLimitTP _Limit $projection.InsurPlcyUUID = _Limit.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Limit.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Limit.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Limit.InsurPlcyCoverageID and $projection.InsurPlcySubCvrgID = _Limit.InsurPlcySubCvrgID
[0..*] R_InsurPlcySbcvrgDeductibleTP _Deductible $projection.InsurPlcyUUID = _Deductible.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Deductible.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Deductible.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Deductible.InsurPlcyCoverageID and $projection.InsurPlcySubCvrgID = _Deductible.InsurPlcySubCvrgID
[0..*] R_InsurPlcySbcvrgClauseTP _Clause $projection.InsurPlcyUUID = _Clause.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Clause.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Clause.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Clause.InsurPlcyCoverageID and $projection.InsurPlcySubCvrgID = _Clause.InsurPlcySubCvrgID
[1] R_InsurancePolicyTP_2 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID

Annotations (8)

NameValueLevelField
EndUserText.label Subcoverage view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsurancePolicy view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID InsurPlcyCoverageID
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID
InsrrIDByInsrr _Policy InsrrIDByInsrr
InsurPlcyAuthznSlsProductGroup _Policy InsurPlcyAuthznSlsProductGroup
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID InsurPlcyProductPackageID
InsurPlcyInsuranceSubCoverage InsurPlcyInsuranceSubCoverage
InsurPlcySubCoverageTemplate InsurPlcySubCoverageTemplate
InsurPlcySubCoverageStartDate InsurPlcySubCoverageStartDate
InsurPlcySubCoverageEndDate InsurPlcySubCoverageEndDate
InsurPlcySubCvrgInsrdSumAmount InsurPlcySubCvrgInsrdSumAmount
InsurPlcySubCoverageCurrency InsurPlcySubCoverageCurrency
InsurPlcySubCvrgInsuredSumPct InsurPlcySubCvrgInsuredSumPct
InsurPlcySubCvrgInsrdSumCalc InsurPlcySubCvrgInsrdSumCalc
InsurPlcyBusinessObject InsurPlcyBusinessObject
LastChangeDateTime LastChangeDateTime
InsurPlcySbcvrgIsCanceled InsurPlcySbcvrgIsCanceled
InsurPlcySubcoverageType InsurPlcySubcoverageType
InsurPlcySubcoverageRankValue InsurPlcySubcoverageRankValue
InsurPlcySbcvrgGrssPremBfrAmt InsurPlcySbcvrgGrssPremBfrAmt
InsurPlcySbcvrgPremCrrtnAmt InsurPlcySbcvrgPremCrrtnAmt
InsurPlcySbcvrgSuplmntAmt InsurPlcySbcvrgSuplmntAmt
InsurPlcySubcoverageNmbrValue InsurPlcySubcoverageNmbrValue
_Limit _Limit
_Deductible _Deductible
_Clause _Clause 
@EndUserText.label: 'Subcoverage'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   semanticKey: [ 'InsurPlcyInsuranceSubCoverage' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@ObjectModel.sapObjectNodeType.name: 'InsurancePolicy'
define root view entity R_InsurPlcySubcoverageTP_2
  as select from I_InsurPlcySubCoverageBasic

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

  association [0..*] to R_InsurPlcySbcvrgLimitTP      as _Limit      on  $projection.InsurPlcyUUID              = _Limit.InsurPlcyUUID
                                                                     and $projection.InsurPlcyInsurContr        = _Limit.InsurPlcyInsurContr
                                                                     and $projection.InsurPlcyCoveragePackageID = _Limit.InsurPlcyCoveragePackageID
                                                                     and $projection.InsurPlcyCoverageID        = _Limit.InsurPlcyCoverageID
                                                                     and $projection.InsurPlcySubCvrgID         = _Limit.InsurPlcySubCvrgID

  association [0..*] to R_InsurPlcySbcvrgDeductibleTP as _Deductible on  $projection.InsurPlcyUUID              = _Deductible.InsurPlcyUUID
                                                                     and $projection.InsurPlcyInsurContr        = _Deductible.InsurPlcyInsurContr
                                                                     and $projection.InsurPlcyCoveragePackageID = _Deductible.InsurPlcyCoveragePackageID
                                                                     and $projection.InsurPlcyCoverageID        = _Deductible.InsurPlcyCoverageID
                                                                     and $projection.InsurPlcySubCvrgID         = _Deductible.InsurPlcySubCvrgID

  association [0..*] to R_InsurPlcySbcvrgClauseTP     as _Clause     on  $projection.InsurPlcyUUID              = _Clause.InsurPlcyUUID
                                                                     and $projection.InsurPlcyInsurContr        = _Clause.InsurPlcyInsurContr
                                                                     and $projection.InsurPlcyCoveragePackageID = _Clause.InsurPlcyCoveragePackageID
                                                                     and $projection.InsurPlcyCoverageID        = _Clause.InsurPlcyCoverageID
                                                                     and $projection.InsurPlcySubCvrgID         = _Clause.InsurPlcySubCvrgID

  association [1]    to R_InsurancePolicyTP_2         as _Policy     on  $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID

{
  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
  key InsurPlcyCoveragePackageID,
  key InsurPlcyCoverageID,
  key InsurPlcySubCvrgID,
      _Policy.InsrrIDByInsrr,
      _Policy.InsurPlcyAuthznSlsProductGroup,
      InsurPlcyJrnlNmbr,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyProductPackageID,
      InsurPlcyInsuranceSubCoverage,
      InsurPlcySubCoverageTemplate,
      InsurPlcySubCoverageStartDate,
      InsurPlcySubCoverageEndDate,
      InsurPlcySubCvrgInsrdSumAmount,
      InsurPlcySubCoverageCurrency,
      InsurPlcySubCvrgInsuredSumPct,
      InsurPlcySubCvrgInsrdSumCalc,
      InsurPlcyBusinessObject,
      LastChangeDateTime,
      InsurPlcySbcvrgIsCanceled,
      InsurPlcySubcoverageType,
      InsurPlcySubcoverageRankValue,
      InsurPlcySbcvrgGrssPremBfrAmt,
      InsurPlcySbcvrgPremCrrtnAmt,
      InsurPlcySbcvrgSuplmntAmt,
      InsurPlcySubcoverageNmbrValue,

      /* Associations */
      _Limit,
      _Deductible,
      _Clause

}

Learn More