I_InsurApplContrInsuredObject
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)
| Source | Alias | Join Type |
|---|---|---|
| P_InsurPolicyJournalKeys | PlcyJrnl | from |
| I_InsurPlcyInsuredObjectBasic | Subject | inner |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA