I_InsurPlcyContrInsuredObject

DDL: I_INSURPLCYCONTRINSUREDOBJECT Type: view_entity COMPOSITE

Contract Insrd Obj in Insurance Policy

I_InsurPlcyContrInsuredObject is a Composite CDS View that provides data about "Contract Insrd Obj in Insurance Policy" 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_InsurPlcyContrInsrdObjClause _InsurPlcyContrInsrdObjClause
[0..*] I_InsurPlcyContrInsrdObjDcbl _InsurPlcyContrInsrdObjDcbl
[0..*] I_InsurPlcyContrObjSurchrgDisc _InsurPlcyContrObjSurchrgDisc
[0..1] I_InsurPlcyContrInsuredVehicle _InsurPlcyContrInsuredVehicle
[0..*] I_InsurPlcyContrObjNmdDrvr _InsurPlcyContrObjNmdDrvr
[0..*] I_InsurPlcyContrObjSpclEquip _InsurPlcyContrObjSpclEquip
[0..1] I_InsurPlcyContrInsuredBldng _InsurPlcyContrInsuredBldng

Annotations (11)

NameValueLevelField
EndUserText.label Contract Insrd Obj in Insurance Policy 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 IPCoInsObj 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
_InsuranceContract _InsuranceContract
_InsurPlcyContrInsrdObjClause _InsurPlcyContrInsrdObjClause
_InsurPlcyContrInsrdObjDcbl _InsurPlcyContrInsrdObjDcbl
_InsurPlcyContrObjSurchrgDisc _InsurPlcyContrObjSurchrgDisc
_InsurPlcyContrInsuredVehicle _InsurPlcyContrInsuredVehicle
_InsurPlcyContrObjNmdDrvr _InsurPlcyContrObjNmdDrvr
_InsurPlcyContrObjSpclEquip _InsurPlcyContrObjSpclEquip
_InsurPlcyContrInsuredBldng _InsurPlcyContrInsuredBldng
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurInsrdObjectCategory _InsurInsrdObjectCategory
_InsurInsrdObjSubCategory _InsurInsrdObjSubCategory
_InsurInsurableObject _InsurInsurableObject
@EndUserText.label: 'Contract Insrd Obj in Insurance Policy'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations:  [  '_InsurPlcyContrInsrdObjClause',
                              '_InsurPlcyContrInsrdObjDcbl',
                              '_InsurPlcyContrObjSurchrgDisc',
                              '_InsurPlcyContrInsuredVehicle',
                              '_InsurPlcyContrObjNmdDrvr',
                              '_InsurPlcyContrObjSpclEquip',
                              '_InsurPlcyContrInsuredBldng']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsuredObjectID',
   semanticKey: [ 'InsurPlcyInsrdObjUnqID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPCoInsObj'
}
define view entity I_InsurPlcyContrInsuredObject
  as select from I_InsurPlcyInsuredObjectBasic as Subject

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

  composition [0..*] of I_InsurPlcyContrInsrdObjClause as _InsurPlcyContrInsrdObjClause
  composition [0..*] of I_InsurPlcyContrInsrdObjDcbl   as _InsurPlcyContrInsrdObjDcbl
  composition [0..*] of I_InsurPlcyContrObjSurchrgDisc as _InsurPlcyContrObjSurchrgDisc
  composition [0..1] of I_InsurPlcyContrInsuredVehicle as _InsurPlcyContrInsuredVehicle
  composition [0..*] of I_InsurPlcyContrObjNmdDrvr     as _InsurPlcyContrObjNmdDrvr
  composition [0..*] of I_InsurPlcyContrObjSpclEquip   as _InsurPlcyContrObjSpclEquip
  composition [0..1] of I_InsurPlcyContrInsuredBldng   as _InsurPlcyContrInsuredBldng

  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 */
      _InsuranceContract,
      _InsurPlcyContrInsrdObjClause,
      _InsurPlcyContrInsrdObjDcbl,
      _InsurPlcyContrObjSurchrgDisc,
      _InsurPlcyContrInsuredVehicle,
      _InsurPlcyContrObjNmdDrvr,
      _InsurPlcyContrObjSpclEquip,
      _InsurPlcyContrInsuredBldng,

      @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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYINSUREDOBJECTBASIC"
],
"ASSOCIATED":
[
"I_INSURANCECONTRACT",
"I_INSURINSRDOBJECTCATEGORY",
"I_INSURINSRDOBJSUBCATEGORY",
"I_INSURINSURABLEOBJECT",
"I_INSURPLCYCONTRINSRDOBJCLAUSE",
"I_INSURPLCYCONTRINSRDOBJDCBL",
"I_INSURPLCYCONTRINSUREDBLDNG",
"I_INSURPLCYCONTRINSUREDVEHICLE",
"I_INSURPLCYCONTROBJNMDDRVR",
"I_INSURPLCYCONTROBJSPCLEQUIP",
"I_INSURPLCYCONTROBJSURCHRGDISC",
"I_INSURPLCYTEMPLATET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/