R_InsurPlcyContrInsrdObjectTP

DDL: R_INSURPLCYCONTRINSRDOBJECTTP Type: view_entity TRANSACTIONAL

Contr Insrd Obj in Insurance Policy - TP

R_InsurPlcyContrInsrdObjectTP is a Transactional CDS View that provides data about "Contr Insrd Obj in Insurance Policy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyContrInsuredObject) and exposes 17 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyInsuredObjectID. It has 5 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyContrInsuredObject Subject from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyInsuredObject _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and 0 = _Extension.InsurPlcyCoveragePackageID and 0 = _Extension.InsurPlcyCoverageID and 0 = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[0..*] R_InsurPlcyContrObjClauseTP _InsurPlcyContrInsrdObjClause
[0..*] R_InsurPlcyContrInsrdObjDcblTP _InsurPlcyContrInsrdObjDcbl
[0..*] R_InsurPlcyContrObjSuDscTP _InsurPlcyContrObjSurchrgDisc
[0..1] R_InsurPlcyContrInsuredBldngTP _InsurPlcyContrInsuredBldng

Annotations (8)

NameValueLevelField
EndUserText.label Contr Insrd Obj in Insurance Policy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsuredObjectID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyContrInsuredObject InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyContrInsuredObject InsurPlcyInsurContr
KEY InsurPlcyInsuredObjectID I_InsurPlcyContrInsuredObject InsurPlcyInsuredObjectID
InsurPlcyJrnlNmbr I_InsurPlcyContrInsuredObject InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyContrInsuredObject InsurPlcyJrnlEndNmbr
InsurPolicyContractPackageID I_InsurPlcyContrInsuredObject InsurPlcyProductPackageID
InsurPlcyInsuredObjectControl I_InsurPlcyContrInsuredObject InsurPlcyInsrdObjectTemplate
InsurPlcyInsuredObjectCategory I_InsurPlcyContrInsuredObject InsurPlcyInsuredObjectCategory
InsurPlcyInsrdObjSubCategory I_InsurPlcyContrInsuredObject InsurPlcyInsrdObjSubCategory
InsurPlcyInsrdObjUnqID I_InsurPlcyContrInsuredObject InsurPlcyInsrdObjUnqID
InsurInsrblObjJrnlNmbr I_InsurPlcyContrInsuredObject InsurInsrblObjJrnlNmbr
LastChangeDateTime I_InsurPlcyContrInsuredObject LastChangeDateTime
_InsuranceContract _InsuranceContract
_InsurPlcyContrInsrdObjClause _InsurPlcyContrInsrdObjClause
_InsurPlcyContrInsrdObjDcbl _InsurPlcyContrInsrdObjDcbl
_InsurPlcyContrObjSurchrgDisc _InsurPlcyContrObjSurchrgDisc
_InsurPlcyContrInsuredBldng _InsurPlcyContrInsuredBldng 
@EndUserText.label: 'Contr Insrd Obj in Insurance Policy - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations:  [  '_InsurPlcyContrInsrdObjClause',
                              '_InsurPlcyContrInsrdObjDcbl',
                              '_InsurPlcyContrObjSurchrgDisc',
                              '_InsurPlcyContrInsuredBldng']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsuredObjectID',
   semanticKey: [ 'InsurPlcyInsrdObjUnqID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity R_InsurPlcyContrInsrdObjectTP
  as select from I_InsurPlcyContrInsuredObject as Subject

  association        to parent R_InsuranceContractTP   as _InsuranceContract on  $projection.InsurPlcyUUID       = _InsuranceContract.InsurPlcyUUID
                                                                             and $projection.InsurPlcyInsurContr = _InsuranceContract.InsurPlcyInsurContr

  composition [0..*] of R_InsurPlcyContrObjClauseTP    as _InsurPlcyContrInsrdObjClause
  composition [0..*] of R_InsurPlcyContrInsrdObjDcblTP as _InsurPlcyContrInsrdObjDcbl
  composition [0..*] of R_InsurPlcyContrObjSuDscTP     as _InsurPlcyContrObjSurchrgDisc
  composition [0..1] of R_InsurPlcyContrInsuredBldngTP as _InsurPlcyContrInsuredBldng

  association [1..1] to E_InsurancePolicyInsuredObject as _Extension         on  $projection.InsurPlcyUUID            = _Extension.InsurPlcyUUID
                                                                             and $projection.InsurPlcyInsurContr      = _Extension.InsurPlcyInsurContr
                                                                             and 0                                    = _Extension.InsurPlcyCoveragePackageID
                                                                             and 0                                    = _Extension.InsurPlcyCoverageID
                                                                             and 0                                    = _Extension.InsurPlcyCoverageOptionID
                                                                             and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID
                                                                             and $projection.InsurPlcyJrnlNmbr        = _Extension.InsurPlcyJrnlNmbr
                                                                             and $projection.InsurPlcyJrnlEndNmbr     = _Extension.InsurPlcyJrnlEndNmbr

{

  key Subject.InsurPlcyUUID,
  key Subject.InsurPlcyInsurContr,
  key Subject.InsurPlcyInsuredObjectID,
      Subject.InsurPlcyJrnlNmbr,
      Subject.InsurPlcyJrnlEndNmbr,
      Subject.InsurPlcyProductPackageID    as InsurPolicyContractPackageID,
      Subject.InsurPlcyInsrdObjectTemplate as InsurPlcyInsuredObjectControl,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyInsuredObjectCategory'
      Subject.InsurPlcyInsuredObjectCategory,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyInsrdObjSubCategory'
      Subject.InsurPlcyInsrdObjSubCategory,
      Subject.InsurPlcyInsrdObjUnqID,
      Subject.InsurInsrblObjJrnlNmbr,
      Subject.LastChangeDateTime,


      /* Associations */
      _InsuranceContract,
      _InsurPlcyContrInsrdObjClause,
      _InsurPlcyContrInsrdObjDcbl,
      _InsurPlcyContrObjSurchrgDisc,
      _InsurPlcyContrInsuredBldng

}

Learn More