R_InsurPlcyCoveragePackageTP

DDL: R_INSURPLCYCOVERAGEPACKAGETP Type: view_entity TRANSACTIONAL

Cvrg Package in Insurance Policy - TP

R_InsurPlcyCoveragePackageTP is a Transactional CDS View that provides data about "Cvrg Package in Insurance Policy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCoveragePackage) and exposes 16 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCoveragePackage CoveragePackage from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_InsurancePolicyCoverageTP _InsurancePolicyCoverage
[0..*] R_InsurPlcyCvrgPckgClauseTP _InsurPlcyCvrgPckgClause
[0..*] R_InsurPlcyCvrgPckgInsrdObjTP _InsurPlcyCvrgPckgInsrdObject
[0..*] R_InsurPlcyCvrgPckgSuDscTP _InsurPlcyCvrgPckgSurchrgDisc
[0..*] R_InsurPlcyCvrgPckgPlndProcgTP _InsurPlcyCvrgPckgPlndProcg

Annotations (8)

NameValueLevelField
EndUserText.label Cvrg Package in Insurance Policy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyCoveragePackageID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyCoveragePackage InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyCoveragePackage InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyCoveragePackage InsurPlcyCoveragePackageID
InsurPlcyJrnlNmbr I_InsurPlcyCoveragePackage InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyCoveragePackage InsurPlcyJrnlEndNmbr
InsurPlcyCvrgPackageControl I_InsurPlcyCoveragePackage InsurPlcyCvrgPackageTemplate
InsurPolicyContractPackageID I_InsurPlcyCoveragePackage InsurPlcyProductPackageID
InsurPlcyCvrgPckgCanclnReason I_InsurPlcyCoveragePackage InsurPlcyCvrgPckgCanclnReason
InsurPlcyCvrgPckgCanclnDteTime I_InsurPlcyCoveragePackage InsurPlcyCvrgPckgCanclnDteTime
LastChangeDateTime I_InsurPlcyCoveragePackage LastChangeDateTime
_InsuranceContract _InsuranceContract
_InsurancePolicyCoverage _InsurancePolicyCoverage
_InsurPlcyCvrgPckgClause _InsurPlcyCvrgPckgClause
_InsurPlcyCvrgPckgInsrdObject _InsurPlcyCvrgPckgInsrdObject
_InsurPlcyCvrgPckgSurchrgDisc _InsurPlcyCvrgPckgSurchrgDisc
_InsurPlcyCvrgPckgPlndProcg _InsurPlcyCvrgPckgPlndProcg
@EndUserText.label: 'Cvrg Package in Insurance Policy - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_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:   #XL
   }
}

define view entity R_InsurPlcyCoveragePackageTP
  as select from I_InsurPlcyCoveragePackage as CoveragePackage

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

  composition [1..*] of R_InsurancePolicyCoverageTP    as _InsurancePolicyCoverage
  composition [0..*] of R_InsurPlcyCvrgPckgClauseTP    as _InsurPlcyCvrgPckgClause
  composition [0..*] of R_InsurPlcyCvrgPckgInsrdObjTP  as _InsurPlcyCvrgPckgInsrdObject
  composition [0..*] of R_InsurPlcyCvrgPckgSuDscTP     as _InsurPlcyCvrgPckgSurchrgDisc
  composition [0..*] of R_InsurPlcyCvrgPckgPlndProcgTP as _InsurPlcyCvrgPckgPlndProcg

{

  key CoveragePackage.InsurPlcyUUID,
  key CoveragePackage.InsurPlcyInsurContr,
  key CoveragePackage.InsurPlcyCoveragePackageID,
      CoveragePackage.InsurPlcyJrnlNmbr,
      CoveragePackage.InsurPlcyJrnlEndNmbr,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'
      CoveragePackage.InsurPlcyCvrgPackageTemplate as InsurPlcyCvrgPackageControl,
      CoveragePackage.InsurPlcyProductPackageID    as InsurPolicyContractPackageID,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurContrCancellationReason'
      CoveragePackage.InsurPlcyCvrgPckgCanclnReason,
      CoveragePackage.InsurPlcyCvrgPckgCanclnDteTime,
      CoveragePackage.LastChangeDateTime,

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYCOVERAGEPACKAGE"
],
"ASSOCIATED":
[
"R_INSURANCECONTRACTTP",
"R_INSURANCEPOLICYCOVERAGETP",
"R_INSURPLCYCVRGPCKGCLAUSETP",
"R_INSURPLCYCVRGPCKGINSRDOBJTP",
"R_INSURPLCYCVRGPCKGPLNDPROCGTP",
"R_INSURPLCYCVRGPCKGSUDSCTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/