I_InsurancePolicyInsuredObject

DDL: I_INSURANCEPOLICYINSUREDOBJECT Type: view_entity COMPOSITE

Cvrg InsOb of Cvrg Pckg in Insur Plcy

I_InsurancePolicyInsuredObject is a Composite CDS View that provides data about "Cvrg InsOb of Cvrg Pckg in Insur Plcy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyInsuredObjectBasic) and exposes 26 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyInsuredObjectID. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyInsuredObjectBasic Subject from

Associations (11)

CardinalityTargetAliasCondition
[1..1] I_InsurInsrdObjectCategory _InsurInsrdObjectCategory $projection.InsurPlcyInsuredObjectCategory = _InsurInsrdObjectCategory.InsurPlcyInsuredObjectCategory
[1..1] I_InsurInsrdObjSubCategory _InsurInsrdObjSubCategory $projection.InsurPlcyInsrdObjSubCategory = _InsurInsrdObjSubCategory.InsurPlcyInsrdObjSubCategory
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyInsrdObjectTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[1..1] I_InsurInsurableObject _InsurInsurableObject $projection.InsurPlcyInsrdObjUnqID = _InsurInsurableObject.InsurInsrblObj and $projection.InsurInsrblObjJrnlNmbr = _InsurInsurableObject.InsurInsrblObjJrnlNmbr
[0..*] I_InsurPlcyCvrgInsrdObjClause _InsurPlcyCvrgInsrdObjClause
[0..*] I_InsurPlcyCvrgInsrdObjDcbl _InsurPlcyCvrgInsrdObjDcbl
[0..*] I_InsurPlcyCvrgObjSurchrgDisc _InsurPlcyCvrgObjSurchrgDisc
[0..1] I_InsurPolicyInsuredVehicle _InsurPolicyInsuredVehicle
[0..*] I_InsurPolicyInsrdObjNmdDrvr _InsurPolicyInsrdObjNmdDrvr
[0..*] I_InsurPolicyInsrdObjSpclEquip _InsurPolicyInsrdObjSpclEquip
[0..1] I_InsurPlcyCvrgPckgCvrgBldng _InsurPlcyCvrgPckgCvrgBldng

Annotations (11)

NameValueLevelField
EndUserText.label Cvrg InsOb of Cvrg Pckg in Insur Plcy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsuredObjectID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IPPlcyInsrdObj view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyInsuredObjectBasic InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyInsuredObjectBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyInsuredObjectBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyInsuredObjectBasic InsurPlcyCoverageID
KEY InsurPlcyInsuredObjectID I_InsurPlcyInsuredObjectBasic InsurPlcyInsuredObjectID
InsurPlcyJrnlNmbr I_InsurPlcyInsuredObjectBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyInsuredObjectBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyInsuredObjectBasic InsurPlcyProductPackageID
InsurPlcyInsrdObjectTemplate I_InsurPlcyInsuredObjectBasic InsurPlcyInsrdObjectTemplate
InsurPlcyInsuredObjectCategory I_InsurPlcyInsuredObjectBasic InsurPlcyInsuredObjectCategory
InsurPlcyInsrdObjSubCategory I_InsurPlcyInsuredObjectBasic InsurPlcyInsrdObjSubCategory
InsurPlcyInsrdObjUnqID I_InsurPlcyInsuredObjectBasic InsurPlcyInsrdObjUnqID
InsurInsrblObjJrnlNmbr I_InsurPlcyInsuredObjectBasic InsurInsrblObjJrnlNmbr
LastChangeDateTime I_InsurPlcyInsuredObjectBasic LastChangeDateTime
_InsurancePolicyCoverage _InsurancePolicyCoverage
_InsurPlcyCvrgInsrdObjClause _InsurPlcyCvrgInsrdObjClause
_InsurPlcyCvrgInsrdObjDcbl _InsurPlcyCvrgInsrdObjDcbl
_InsurPlcyCvrgObjSurchrgDisc _InsurPlcyCvrgObjSurchrgDisc
_InsurPolicyInsuredVehicle _InsurPolicyInsuredVehicle
_InsurPolicyInsrdObjNmdDrvr _InsurPolicyInsrdObjNmdDrvr
_InsurPolicyInsrdObjSpclEquip _InsurPolicyInsrdObjSpclEquip
_InsurPlcyCvrgPckgCvrgBldng _InsurPlcyCvrgPckgCvrgBldng
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurInsrdObjectCategory _InsurInsrdObjectCategory
_InsurInsrdObjSubCategory _InsurInsrdObjSubCategory
_InsurInsurableObject _InsurInsurableObject
@EndUserText.label: 'Cvrg InsOb of Cvrg Pckg in Insur Plcy'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations:  [  '_InsurPlcyCvrgInsrdObjClause',
                              '_InsurPlcyCvrgInsrdObjDcbl',
                              '_InsurPlcyCvrgObjSurchrgDisc',
                              '_InsurPolicyInsuredVehicle',
                              '_InsurPolicyInsrdObjNmdDrvr',
                              '_InsurPolicyInsrdObjSpclEquip',
                              '_InsurPlcyCvrgPckgCvrgBldng']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsuredObjectID',
   semanticKey: [ 'InsurPlcyInsrdObjUnqID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPPlcyInsrdObj'
}

define view entity I_InsurancePolicyInsuredObject
  as select from I_InsurPlcyInsuredObjectBasic as Subject

  association        to parent I_InsurancePolicyCoverage as _InsurancePolicyCoverage  on  $projection.InsurPlcyUUID              = _InsurancePolicyCoverage.InsurPlcyUUID
                                                                                      and $projection.InsurPlcyInsurContr        = _InsurancePolicyCoverage.InsurPlcyInsurContr
                                                                                      and $projection.InsurPlcyCoveragePackageID = _InsurancePolicyCoverage.InsurPlcyCoveragePackageID
                                                                                      and $projection.InsurPlcyCoverageID        = _InsurancePolicyCoverage.InsurPlcyCoverageID

  composition [0..*] of I_InsurPlcyCvrgInsrdObjClause    as _InsurPlcyCvrgInsrdObjClause
  composition [0..*] of I_InsurPlcyCvrgInsrdObjDcbl      as _InsurPlcyCvrgInsrdObjDcbl
  composition [0..*] of I_InsurPlcyCvrgObjSurchrgDisc    as _InsurPlcyCvrgObjSurchrgDisc
  composition [0..1] of I_InsurPolicyInsuredVehicle      as _InsurPolicyInsuredVehicle
  composition [0..*] of I_InsurPolicyInsrdObjNmdDrvr     as _InsurPolicyInsrdObjNmdDrvr
  composition [0..*] of I_InsurPolicyInsrdObjSpclEquip   as _InsurPolicyInsrdObjSpclEquip
  composition [0..1] of I_InsurPlcyCvrgPckgCvrgBldng     as _InsurPlcyCvrgPckgCvrgBldng

  association [1..1] to I_InsurInsrdObjectCategory       as _InsurInsrdObjectCategory on  $projection.InsurPlcyInsuredObjectCategory = _InsurInsrdObjectCategory.InsurPlcyInsuredObjectCategory
  association [1..1] to I_InsurInsrdObjSubCategory       as _InsurInsrdObjSubCategory on  $projection.InsurPlcyInsrdObjSubCategory = _InsurInsrdObjSubCategory.InsurPlcyInsrdObjSubCategory
  association [1..*] to I_InsurPlcyTemplateT             as _InsurPlcyTemplateT       on  $projection.InsurPlcyInsrdObjectTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
  association [1..1] to I_InsurInsurableObject           as _InsurInsurableObject     on  $projection.InsurPlcyInsrdObjUnqID = _InsurInsurableObject.InsurInsrblObj
                                                                                      and $projection.InsurInsrblObjJrnlNmbr = _InsurInsurableObject.InsurInsrblObjJrnlNmbr

{

  key Subject.InsurPlcyUUID,
  key Subject.InsurPlcyInsurContr,
  key Subject.InsurPlcyCoveragePackageID,
  key Subject.InsurPlcyCoverageID,
  key Subject.InsurPlcyInsuredObjectID,
      Subject.InsurPlcyJrnlNmbr,
      Subject.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Subject.InsurPlcyProductPackageID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      Subject.InsurPlcyInsrdObjectTemplate,
      @ObjectModel.foreignKey.association: '_InsurInsrdObjectCategory'
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyInsuredObjectCategory'
      Subject.InsurPlcyInsuredObjectCategory,
      @ObjectModel.foreignKey.association: '_InsurInsrdObjSubCategory'
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyInsrdObjSubCategory'
      Subject.InsurPlcyInsrdObjSubCategory,
      @ObjectModel.foreignKey.association: '_InsurInsurableObject'
      Subject.InsurPlcyInsrdObjUnqID,
      Subject.InsurInsrblObjJrnlNmbr,
      @Semantics.systemDateTime.lastChangedAt: true
      Subject.LastChangeDateTime,

      /* Associations */
      _InsurancePolicyCoverage,
      _InsurPlcyCvrgInsrdObjClause,
      _InsurPlcyCvrgInsrdObjDcbl,
      _InsurPlcyCvrgObjSurchrgDisc,
      _InsurPolicyInsuredVehicle,
      _InsurPolicyInsrdObjNmdDrvr,
      _InsurPolicyInsrdObjSpclEquip,
      _InsurPlcyCvrgPckgCvrgBldng,

      @Consumption.hidden: true
      _InsurPlcyTemplateT,
      @Consumption.hidden: true
      _InsurInsrdObjectCategory,
      @Consumption.hidden: true
      _InsurInsrdObjSubCategory,
      _InsurInsurableObject

}
where
      Subject.InsurPlcyJrnlEndNmbr       =  2147483647
  and Subject.InsurPlcyBusinessObject    =  'P'
  and Subject.InsurPlcyCoveragePackageID <> 0
  and Subject.InsurPlcyCoverageID        <> 0