I_InsurPlcyCoveragePackage

DDL: I_INSURPLCYCOVERAGEPACKAGE Type: view_entity COMPOSITE Package: VDM_PM_PLCY_COMMON

Coverage Package in Insurance Policy

I_InsurPlcyCoveragePackage is a Composite CDS View that provides data about "Coverage Package in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCvrgPackageBasic) and exposes 18 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID. It has 7 associations to related views. Part of development package VDM_PM_PLCY_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCvrgPackageBasic CoveragePackage from

Associations (7)

CardinalityTargetAliasCondition
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyCvrgPackageTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[1..1] I_InsurContrCanclnReason _InsurContrCanclnReason $projection.InsurPlcyCvrgPckgCanclnReason = _InsurContrCanclnReason.InsurContrCanclnRsn
[1..*] I_InsurancePolicyCoverage _InsurancePolicyCoverage
[0..*] I_InsurPlcyCvrgPckgClause _InsurPlcyCvrgPckgClause
[0..*] I_InsurPlcyCvrgPckgInsrdObject _InsurPlcyCvrgPckgInsrdObject
[0..*] I_InsurPlcyCvrgPckgSurchrgDisc _InsurPlcyCvrgPckgSurchrgDisc
[0..*] I_InsurPlcyCvrgPckgPlndProcg _InsurPlcyCvrgPckgPlndProcg

Annotations (11)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyCvrgPackageBasic InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyCvrgPackageBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyCvrgPackageBasic InsurPlcyCoveragePackageID
InsurPlcyJrnlNmbr I_InsurPlcyCvrgPackageBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyCvrgPackageBasic InsurPlcyJrnlEndNmbr
InsurPlcyCvrgPackageTemplate I_InsurPlcyCvrgPackageBasic InsurPlcyCvrgPackageTemplate
InsurPlcyProductPackageID I_InsurPlcyCvrgPackageBasic InsurPlcyProductPackageID
InsurPlcyCvrgPckgCanclnReason I_InsurPlcyCvrgPackageBasic InsurPlcyCvrgPckgCanclnReason
InsurPlcyCvrgPckgCanclnDteTime I_InsurPlcyCvrgPackageBasic InsurPlcyCvrgPckgCanclnDteTime
LastChangeDateTime I_InsurPlcyCvrgPackageBasic LastChangeDateTime
_InsuranceContract _InsuranceContract
_InsurancePolicyCoverage _InsurancePolicyCoverage
_InsurPlcyCvrgPckgClause _InsurPlcyCvrgPckgClause
_InsurPlcyCvrgPckgInsrdObject _InsurPlcyCvrgPckgInsrdObject
_InsurPlcyCvrgPckgSurchrgDisc _InsurPlcyCvrgPckgSurchrgDisc
_InsurPlcyCvrgPckgPlndProcg _InsurPlcyCvrgPckgPlndProcg
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurContrCanclnReason _InsurContrCanclnReason
@EndUserText.label: 'Coverage Package in Insurance Policy'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations:  [  '_InsurancePolicyCoverage',
                              '_InsurPlcyCvrgPckgClause',
                              '_InsurPlcyCvrgPckgSurchrgDisc',
                              '_InsurPlcyCvrgPckgInsrdObject',
                              '_InsurPlcyCvrgPckgPlndProcg']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyCoveragePackageID',
   semanticKey: [ 'InsurPlcyCoveragePackageID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPPlcyCvrgPckg'
}

define view entity I_InsurPlcyCoveragePackage
  as select from I_InsurPlcyCvrgPackageBasic as CoveragePackage

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

  composition [1..*] of I_InsurancePolicyCoverage      as _InsurancePolicyCoverage
  composition [0..*] of I_InsurPlcyCvrgPckgClause      as _InsurPlcyCvrgPckgClause
  composition [0..*] of I_InsurPlcyCvrgPckgInsrdObject as _InsurPlcyCvrgPckgInsrdObject
  composition [0..*] of I_InsurPlcyCvrgPckgSurchrgDisc as _InsurPlcyCvrgPckgSurchrgDisc
  composition [0..*] of I_InsurPlcyCvrgPckgPlndProcg   as _InsurPlcyCvrgPckgPlndProcg 

  association [1..*] to I_InsurPlcyTemplateT           as _InsurPlcyTemplateT     on  $projection.InsurPlcyCvrgPackageTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
  association [1..1] to I_InsurContrCanclnReason       as _InsurContrCanclnReason on  $projection.InsurPlcyCvrgPckgCanclnReason = _InsurContrCanclnReason.InsurContrCanclnRsn

{

  key CoveragePackage.InsurPlcyUUID,
  key CoveragePackage.InsurPlcyInsurContr,
  key CoveragePackage.InsurPlcyCoveragePackageID,
      CoveragePackage.InsurPlcyJrnlNmbr,
      CoveragePackage.InsurPlcyJrnlEndNmbr,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      // @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'

      CoveragePackage.InsurPlcyCvrgPackageTemplate,
      CoveragePackage.InsurPlcyProductPackageID,
      @ObjectModel.foreignKey.association: '_InsurContrCanclnReason'
      @ObjectModel.sapObjectNodeTypeReference: 'InsurContrCancellationReason'
      CoveragePackage.InsurPlcyCvrgPckgCanclnReason,
      @Semantics.dateTime:true
      CoveragePackage.InsurPlcyCvrgPckgCanclnDteTime,
      @Semantics.systemDateTime.lastChangedAt: true
      CoveragePackage.LastChangeDateTime,

      /* Associations */
      _InsuranceContract,
      _InsurancePolicyCoverage,
      _InsurPlcyCvrgPckgClause,
      _InsurPlcyCvrgPckgInsrdObject,
      _InsurPlcyCvrgPckgSurchrgDisc,
      _InsurPlcyCvrgPckgPlndProcg,

      @Consumption.hidden: true
      _InsurPlcyTemplateT,
      @Consumption.hidden: true
      _InsurContrCanclnReason

}
where
      CoveragePackage.InsurPlcyJrnlEndNmbr    = 2147483647
  and CoveragePackage.InsurPlcyBusinessObject = 'P'