I_InsurancePolicy
Insurance Policy
I_InsurancePolicy is a Composite CDS View that provides data about "Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyBasic) and exposes 24 fields with key field InsurPlcyUUID. It has 11 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InsurPlcyBasic | Policy | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_InsurPlcyDistrChnl | _InsurPlcyDistrChnl | $projection.InsurPlcyDistrChnl = _InsurPlcyDistrChnl.InsurPlcyDistrChnl |
| [1..1] | I_InsurPlcyAcquisitionType | _InsurPlcyAcqnType | $projection.InsurPlcyAcqnType = _InsurPlcyAcqnType.InsurPlcyAcqnType |
| [1..1] | I_InsurPlcyInsurer | _InsurPlcyInsurer | $projection.InsrrIDByInsrr = _InsurPlcyInsurer.InsrrIDByInsrr |
| [1..*] | I_InsurPlcyTemplateT | _InsurPlcyTemplateT | $projection.InsurPlcySalesProductTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate |
| [1..1] | I_InsurApplLifeCycleStatus | _InsurApplLifeCycleStatus | $projection.InsurApplLifeCycSts = _InsurApplLifeCycleStatus.InsurApplLifeCycSts |
| [1..*] | I_InsurPlcyCashFlowHeader | _InsurPlcyCashFlowHeader | $projection.InsurancePolicy = _InsurPlcyCashFlowHeader.InsurancePolicy |
| [1..1] | E_InsurancePolicy | _Extension | $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr |
| [1..*] | I_InsurancePolicyPolicyHolder | _InsurancePolicyholder | |
| [1..*] | I_InsuranceContract | _InsuranceContract | |
| [1..*] | I_InsurPlcyContrJrnl | _InsurPlcyContrJrnl | |
| [0..*] | I_InsurPolicyPlannedProcessing | _InsurPlcyPlndProcg | |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Insurance Policy | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | InsurPlcyUUID | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.allowExtensions | false | view | |
| Metadata.ignorePropagatedAnnotations | false | view | |
| Analytics.technicalName | IPPlcy | view |
Fields (24)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InsurPlcyUUID | I_InsurPlcyBasic | InsurPlcyUUID | |
| InsurPlcyJrnlNmbr | I_InsurPlcyBasic | InsurPlcyJrnlNmbr | ||
| InsurPlcyJrnlEndNmbr | I_InsurPlcyBasic | InsurPlcyJrnlEndNmbr | ||
| InsurancePolicy | I_InsurPlcyBasic | InsurancePolicy | ||
| InsurPlcyAuthznSlsProductGroup | I_InsurPlcyBasic | InsurPlcyAuthznSlsProductGroup | ||
| InsurPlcyStartDateTime | I_InsurPlcyBasic | InsurPlcyStartDateTime | ||
| InsurApplLifeCycSts | I_InsurPlcyBasic | InsurApplLifeCycSts | ||
| InsurPlcyDistrChnl | I_InsurPlcyBasic | InsurPlcyDistrChnl | ||
| InsrrIDByInsrr | I_InsurPlcyBasic | InsrrIDByInsrr | ||
| InsurPlcySalesProductTemplate | I_InsurPlcyBasic | InsurPlcySalesProductTemplate | ||
| InsurPlcyAcqnType | I_InsurPlcyBasic | InsurPlcyAcqnType | ||
| PrdcssrInsurancePolicy | I_InsurPlcyBasic | PrdcssrInsurancePolicy | ||
| LastChangeDateTime | I_InsurPlcyBasic | LastChangeDateTime | ||
| InsurPolicyCancellationStatus | I_InsurPlcyBasic | InsurPolicyCancellationStatus | ||
| _InsuranceContract | _InsuranceContract | |||
| _InsurancePolicyholder | _InsurancePolicyholder | |||
| _InsurPlcyCashFlowHeader | _InsurPlcyCashFlowHeader | |||
| _InsurPlcyContrJrnl | _InsurPlcyContrJrnl | |||
| _InsurPlcyPlndProcg | _InsurPlcyPlndProcg | |||
| _InsurPlcyDistrChnl | _InsurPlcyDistrChnl | |||
| _InsurPlcyAcqnType | _InsurPlcyAcqnType | |||
| _InsurPlcyTemplateT | _InsurPlcyTemplateT | |||
| _InsurPlcyInsurer | _InsurPlcyInsurer | |||
| _InsurApplLifeCycleStatus | _InsurApplLifeCycleStatus |
@EndUserText.label: 'Insurance Policy'
@VDM: {
viewType:#COMPOSITE,
lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA'),
privilegedAssociations: [ '_InsuranceContract',
'_InsurancePolicyholder',
'_InsurPlcyContrJrnl']
}
@ObjectModel: {
representativeKey: 'InsurPlcyUUID',
semanticKey: [ 'InsurancePolicy' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
},
supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
allowExtensions:false,
ignorePropagatedAnnotations:false
}
@Analytics: {
technicalName: 'IPPlcy'
}
define root view entity I_InsurancePolicy
as select from I_InsurPlcyBasic as Policy
composition [1..*] of I_InsurancePolicyPolicyHolder as _InsurancePolicyholder
composition [1..*] of I_InsuranceContract as _InsuranceContract
composition [1..*] of I_InsurPlcyContrJrnl as _InsurPlcyContrJrnl
composition [0..*] of I_InsurPolicyPlannedProcessing as _InsurPlcyPlndProcg
association [1..1] to I_InsurPlcyDistrChnl as _InsurPlcyDistrChnl on $projection.InsurPlcyDistrChnl = _InsurPlcyDistrChnl.InsurPlcyDistrChnl
association [1..1] to I_InsurPlcyAcquisitionType as _InsurPlcyAcqnType on $projection.InsurPlcyAcqnType = _InsurPlcyAcqnType.InsurPlcyAcqnType
association [1..1] to I_InsurPlcyInsurer as _InsurPlcyInsurer on $projection.InsrrIDByInsrr = _InsurPlcyInsurer.InsrrIDByInsrr
association [1..*] to I_InsurPlcyTemplateT as _InsurPlcyTemplateT on $projection.InsurPlcySalesProductTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
association [1..1] to I_InsurApplLifeCycleStatus as _InsurApplLifeCycleStatus on $projection.InsurApplLifeCycSts = _InsurApplLifeCycleStatus.InsurApplLifeCycSts
association [1..*] to I_InsurPlcyCashFlowHeader as _InsurPlcyCashFlowHeader on $projection.InsurancePolicy = _InsurPlcyCashFlowHeader.InsurancePolicy
association [1..1] to E_InsurancePolicy as _Extension on $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID
and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr
and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
{
key Policy.InsurPlcyUUID,
Policy.InsurPlcyJrnlNmbr,
Policy.InsurPlcyJrnlEndNmbr,
Policy.InsurancePolicy,
@Consumption.hidden: true
Policy.InsurPlcyAuthznSlsProductGroup,
@Semantics.dateTime:true
Policy.InsurPlcyStartDateTime,
@ObjectModel.foreignKey.association: '_InsurApplLifeCycleStatus'
@ObjectModel.sapObjectNodeTypeReference: 'InsurApplLifeCycleStatus'
Policy.InsurApplLifeCycSts,
@ObjectModel.foreignKey.association: '_InsurPlcyDistrChnl'
@ObjectModel.sapObjectNodeTypeReference: 'InsurPolicyDistributionChannel'
Policy.InsurPlcyDistrChnl,
@ObjectModel.foreignKey.association: '_InsurPlcyInsurer'
@ObjectModel.sapObjectNodeTypeReference: 'Insurer'
Policy.InsrrIDByInsrr,
@ObjectModel.text.association: '_InsurPlcyTemplateT'
Policy.InsurPlcySalesProductTemplate,
@ObjectModel.foreignKey.association: '_InsurPlcyAcqnType'
@ObjectModel.sapObjectNodeTypeReference: 'InsurPolicyAcquisitionType'
Policy.InsurPlcyAcqnType,
Policy.PrdcssrInsurancePolicy,
@Semantics.systemDateTime.lastChangedAt: true
Policy.LastChangeDateTime,
Policy.InsurPolicyCancellationStatus,
_InsuranceContract,
_InsurancePolicyholder,
_InsurPlcyCashFlowHeader,
_InsurPlcyContrJrnl,
_InsurPlcyPlndProcg,
@Consumption.hidden: true
_InsurPlcyDistrChnl,
@Consumption.hidden: true
_InsurPlcyAcqnType,
@Consumption.hidden: true
_InsurPlcyTemplateT,
@Consumption.hidden: true
_InsurPlcyInsurer,
@Consumption.hidden: true
_InsurApplLifeCycleStatus
}
where
Policy.InsurPlcyJrnlEndNmbr = 2147483647
and Policy.InsurPlcyBusinessObject = 'P'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYBASIC"
],
"ASSOCIATED":
[
"I_INSURANCECONTRACT",
"I_INSURANCEPOLICYPOLICYHOLDER",
"I_INSURAPPLLIFECYCLESTATUS",
"I_INSURPLCYACQUISITIONTYPE",
"I_INSURPLCYCASHFLOWHEADER",
"I_INSURPLCYCONTRJRNL",
"I_INSURPLCYDISTRCHNL",
"I_INSURPLCYINSURER",
"I_INSURPLCYTEMPLATET",
"I_INSURPOLICYPLANNEDPROCESSING"
],
"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