R_InsurPlcySubcoverageTP_2

DDL: R_INSURPLCYSUBCOVERAGETP_2 Type: view_entity TRANSACTIONAL

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.

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
[1..1] R_InsurancePolicyTP_2 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID
[0..*] R_InsurPlcySbcvrgLimitTP _Limit
[0..*] R_InsurPlcySbcvrgDeductibleTP _Deductible
[0..*] R_InsurPlcySbcvrgClauseTP _Clause

Annotations (14)

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
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SBC view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 2500 view
ObjectModel.sapObjectNodeType.name InsuranceSubcoverage 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
   }
}

@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'SBC',
  allowNewDatasources: false,
  dataSources: [ '_Extension' ],
  allowNewCompositions: true,
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}
@ObjectModel.sapObjectNodeType.name: 'InsuranceSubcoverage'

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

  composition [0..*] of R_InsurPlcySbcvrgLimitTP      as _Limit
  composition [0..*] of R_InsurPlcySbcvrgDeductibleTP as _Deductible
  composition [0..*] of R_InsurPlcySbcvrgClauseTP     as _Clause
  association [1..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

}