I_InsurApplContrInsuredObject

DDL: I_INSURAPPLCONTRINSUREDOBJECT Type: view_entity COMPOSITE

Contract Insrd Obj in Insurance Appl

I_InsurApplContrInsuredObject is a Composite CDS View that provides data about "Contract Insrd Obj in Insurance Appl" in SAP S/4HANA. It reads from 2 data sources (P_InsurPolicyJournalKeys, I_InsurPlcyInsuredObjectBasic) and exposes 27 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyInsuredObjectID. It has 11 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_InsurPolicyJournalKeys PlcyJrnl from
I_InsurPlcyInsuredObjectBasic Subject inner

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_InsurApplContrInsrdObjClause _InsurApplContrInsrdObjClause
[0..*] I_InsurApplContrInsrdObjDcbl _InsurApplContrInsrdObjDcbl
[0..*] I_InsurApplContrObjSurchrgDisc _InsurApplContrObjSurchrgDisc
[0..1] I_InsurApplContrInsuredVehicle _InsurApplContrInsuredVehicle
[0..*] I_InsurApplContrNamedDriver _InsurApplContrNamedDriver
[0..*] I_InsurApplContrSpclEquip _InsurApplContrSpclEquip
[0..1] I_InsurApplContrInsrdObjBldng _InsurApplContrInsrdObjBldng

Annotations (11)

NameValueLevelField
EndUserText.label Contract Insrd Obj in Insurance Appl 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 #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IAContrInsrdObj view

Fields (27)

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
KEY InsurPlcyContrDataDetnJrnlNmbr
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
_InsurApplContract _InsurApplContract
_InsurApplContrInsrdObjClause _InsurApplContrInsrdObjClause
_InsurApplContrInsrdObjDcbl _InsurApplContrInsrdObjDcbl
_InsurApplContrObjSurchrgDisc _InsurApplContrObjSurchrgDisc
_InsurApplContrInsuredVehicle _InsurApplContrInsuredVehicle
_InsurApplContrNamedDriver _InsurApplContrNamedDriver
_InsurApplContrSpclEquip _InsurApplContrSpclEquip
_InsurApplContrInsrdObjBldng _InsurApplContrInsrdObjBldng
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurInsrdObjectCategory _InsurInsrdObjectCategory
_InsurInsrdObjSubCategory _InsurInsrdObjSubCategory
_InsurInsurableObject _InsurInsurableObject
@EndUserText.label: 'Contract Insrd Obj in Insurance Appl'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations:  [  '_InsurApplContrInsrdObjClause',
                              '_InsurApplContrInsrdObjDcbl',
                              '_InsurApplContrObjSurchrgDisc',
                              '_InsurApplContrInsuredVehicle',
                              '_InsurApplContrNamedDriver',
                              '_InsurApplContrSpclEquip']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsuredObjectID',
   semanticKey: [ 'InsurPlcyInsrdObjUnqID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #L
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IAContrInsrdObj'
}
define view entity I_InsurApplContrInsuredObject
  as select from P_InsurPolicyJournalKeys      as PlcyJrnl
    inner join   I_InsurPlcyInsuredObjectBasic as Subject on  PlcyJrnl.InsurPlcyUUID                  =  Subject.InsurPlcyUUID
                                                          and PlcyJrnl.InsurPlcyInsurContr            =  Subject.InsurPlcyInsurContr
                                                          and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Subject.InsurPlcyJrnlNmbr
                                                          and PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Subject.InsurPlcyJrnlEndNmbr

  association        to parent I_InsurApplContract     as _InsurApplContract        on  $projection.InsurPlcyUUID                  = _InsurApplContract.InsurPlcyUUID
                                                                                    and $projection.InsurPlcyInsurContr            = _InsurApplContract.InsurPlcyInsurContr
                                                                                    and $projection.InsurPlcyContrDataDetnJrnlNmbr = _InsurApplContract.InsurPlcyContrDataDetnJrnlNmbr

  composition [0..*] of I_InsurApplContrInsrdObjClause as _InsurApplContrInsrdObjClause
  composition [0..*] of I_InsurApplContrInsrdObjDcbl   as _InsurApplContrInsrdObjDcbl
  composition [0..*] of I_InsurApplContrObjSurchrgDisc as _InsurApplContrObjSurchrgDisc
  composition [0..1] of I_InsurApplContrInsuredVehicle as _InsurApplContrInsuredVehicle
  composition [0..*] of I_InsurApplContrNamedDriver    as _InsurApplContrNamedDriver
  composition [0..*] of I_InsurApplContrSpclEquip      as _InsurApplContrSpclEquip
  composition [0..1] of I_InsurApplContrInsrdObjBldng  as _InsurApplContrInsrdObjBldng


  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,
  key cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      Subject.InsurPlcyJrnlNmbr,
      Subject.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Subject.InsurPlcyProductPackageID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      Subject.InsurPlcyInsrdObjectTemplate,
      @ObjectModel.foreignKey.association: '_InsurInsrdObjectCategory'
      Subject.InsurPlcyInsuredObjectCategory,
      @ObjectModel.foreignKey.association: '_InsurInsrdObjSubCategory'
      Subject.InsurPlcyInsrdObjSubCategory,
      @ObjectModel.foreignKey.association: '_InsurInsurableObject'
      Subject.InsurPlcyInsrdObjUnqID,
      Subject.InsurInsrblObjJrnlNmbr,
      @Semantics.systemDateTime.lastChangedAt: true
      Subject.LastChangeDateTime,

      /* Associations */
      _InsurApplContract,
      _InsurApplContrInsrdObjClause,
      _InsurApplContrInsrdObjDcbl,
      _InsurApplContrObjSurchrgDisc,
      _InsurApplContrInsuredVehicle,
      _InsurApplContrNamedDriver,
      _InsurApplContrSpclEquip,
      _InsurApplContrInsrdObjBldng,


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

}
where
      Subject.InsurPlcyCoveragePackageID = 0
  and Subject.InsurPlcyCoverageID        = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYINSUREDOBJECTBASIC",
"P_INSURPOLICYJOURNALKEYS"
],
"ASSOCIATED":
[
"I_INSURAPPLCONTRACT",
"I_INSURAPPLCONTRINSRDOBJBLDNG",
"I_INSURAPPLCONTRINSRDOBJCLAUSE",
"I_INSURAPPLCONTRINSRDOBJDCBL",
"I_INSURAPPLCONTRINSUREDVEHICLE",
"I_INSURAPPLCONTRNAMEDDRIVER",
"I_INSURAPPLCONTROBJSURCHRGDISC",
"I_INSURAPPLCONTRSPCLEQUIP",
"I_INSURINSRDOBJECTCATEGORY",
"I_INSURINSRDOBJSUBCATEGORY",
"I_INSURINSURABLEOBJECT",
"I_INSURPLCYTEMPLATET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/