I_InsurancePolicyPolicyHolder

DDL: I_INSURANCEPOLICYPOLICYHOLDER Type: view_entity COMPOSITE

Policy Holder in Insurance Policy

I_InsurancePolicyPolicyHolder is a Composite CDS View that provides data about "Policy Holder in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyPolicyHolderBasic) and exposes 12 fields with key fields InsurPlcyUUID, InsurPlcyInsurancePolicyholder. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyPolicyHolderBasic Policyholder from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID
[0..1] I_BusinessPartner _BusinessPartner $projection.InsurancePolicyholder = _BusinessPartner.BusinessPartner

Annotations (11)

NameValueLevelField
EndUserText.label Policy Holder in Insurance Policy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsurancePolicyholder 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 IPPlcyHldr view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyPolicyHolderBasic InsurPlcyUUID
KEY InsurPlcyInsurancePolicyholder I_InsurPlcyPolicyHolderBasic InsurPlcyInsurancePolicyholder
InsurPlcyJrnlNmbr I_InsurPlcyPolicyHolderBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyPolicyHolderBasic InsurPlcyJrnlEndNmbr
InsurancePolicyholder I_InsurPlcyPolicyHolderBasic InsurancePolicyholder
AddressID I_InsurPlcyPolicyHolderBasic AddressID
InsurPlcyHldrIsMainPlcyHolder I_InsurPlcyPolicyHolderBasic InsurPlcyHldrIsMainPlcyHolder
InsurPlcyPolicyHolderTemplate I_InsurPlcyPolicyHolderBasic InsurPlcyPolicyHolderTemplate
LastChangeDateTime I_InsurPlcyPolicyHolderBasic LastChangeDateTime
_InsurancePolicy _InsurancePolicy
_BusinessPartner _BusinessPartner
_Address _Address 
@EndUserText.label: 'Policy Holder in Insurance Policy'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsurancePolicyholder',
   semanticKey: [ 'InsurPlcyInsurancePolicyholder' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPPlcyHldr'
}

define view entity I_InsurancePolicyPolicyHolder
  as select from I_InsurPlcyPolicyHolderBasic as Policyholder
  
  association to parent I_InsurancePolicy as _InsurancePolicy on $projection.InsurPlcyUUID = _InsurancePolicy.InsurPlcyUUID

  association [0..1] to I_Address         as _Address         on $projection.AddressID = _Address.AddressID
  association [0..1] to I_BusinessPartner as _BusinessPartner on $projection.InsurancePolicyholder = _BusinessPartner.BusinessPartner

{

  key Policyholder.InsurPlcyUUID,
  key Policyholder.InsurPlcyInsurancePolicyholder,
      Policyholder.InsurPlcyJrnlNmbr,
      Policyholder.InsurPlcyJrnlEndNmbr,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
      @ObjectModel.sapObjectNodeTypeReference: 'BusinessPartner'
      Policyholder.InsurancePolicyholder,
      @ObjectModel.foreignKey.association: '_Address'
      Policyholder.AddressID,
      @Semantics.booleanIndicator:true
      Policyholder.InsurPlcyHldrIsMainPlcyHolder,
      // @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'

      Policyholder.InsurPlcyPolicyHolderTemplate,
      @Semantics.systemDateTime.lastChangedAt: true
      Policyholder.LastChangeDateTime,     

      /* Associations */
      _InsurancePolicy,
      _BusinessPartner,
      _Address

}
where
      Policyholder.InsurPlcyJrnlEndNmbr    = 2147483647
  and Policyholder.InsurPlcyBusinessObject = 'P'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYPOLICYHOLDERBASIC"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_BUSINESSPARTNER",
"I_INSURANCEPOLICY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More