R_InsurPlcyCvrgExtRefTP

DDL: R_INSURPLCYCVRGEXTREFTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API_COMMON

External Reference under Coverage

R_InsurPlcyCvrgExtRefTP is a Transactional CDS View that provides data about "External Reference under Coverage" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyExtReferenceBasic) and exposes 17 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyCoverageOptionID. It has 1 association to related views. Part of development package VDM_PM_PLCY_API_COMMON.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyExtReferenceBasic I_InsurPlcyExtReferenceBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurPlcyExtRef _Extension $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcyExternalReferenceID = _Extension.InsurPlcyExternalReferenceID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID

Annotations (8)

NameValueLevelField
EndUserText.label External Reference under Coverage view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsurancePolicy view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID InsurPlcyCoverageID
KEY InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID
KEY InsurPlcyExternalReferenceID InsurPlcyExternalReferenceID
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr
InsurPlcyProductPackageID InsurPlcyProductPackageID
InsurPlcyExtRefIsCancelled InsurPlcyExtRefIsCancelled
InsurPlcyExtRefCompany InsurPlcyExtRefCompany
InsurPlcyExtRefReferenceNumber InsurPlcyExtRefReferenceNumber
InsurPlcyExtRefReferenceType InsurPlcyExtRefReferenceType
InsurPlcyExtRefTemplate InsurPlcyExtRefTemplate
InsurPlcyBusinessObject InsurPlcyBusinessObject
LastChangeDateTime LastChangeDateTime 
@EndUserText.label: 'External Reference under Coverage'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   semanticKey: [ 'InsurPlcyExternalReferenceID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@ObjectModel.sapObjectNodeType.name: 'InsurancePolicy'
define root view entity R_InsurPlcyCvrgExtRefTP
  as select from I_InsurPlcyExtReferenceBasic
  association [1..1] to E_InsurPlcyExtRef as _Extension on  $projection.InsurPlcyInsurContr          = _Extension.InsurPlcyInsurContr
                                                        and $projection.InsurPlcyCoverageID          = _Extension.InsurPlcyCoverageID
                                                        and $projection.InsurPlcyJrnlEndNmbr         = _Extension.InsurPlcyJrnlEndNmbr
                                                        and $projection.InsurPlcyInsuredObjectID     = _Extension.InsurPlcyInsuredObjectID
                                                        and $projection.InsurPlcyExternalReferenceID = _Extension.InsurPlcyExternalReferenceID
                                                        and $projection.InsurPlcyJrnlNmbr            = _Extension.InsurPlcyJrnlNmbr
                                                        and $projection.InsurPlcyCoveragePackageID   = _Extension.InsurPlcyCoveragePackageID
                                                        and $projection.InsurPlcyCoverageOptionID    = _Extension.InsurPlcyCoverageOptionID
                                                        and $projection.InsurPlcyUUID                = _Extension.InsurPlcyUUID
{

  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
  key InsurPlcyCoveragePackageID,
  key InsurPlcyCoverageID,
  key InsurPlcyCoverageOptionID,
  key InsurPlcyInsuredObjectID,
  key InsurPlcyExternalReferenceID,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyJrnlNmbr,
      InsurPlcyProductPackageID,
      InsurPlcyExtRefIsCancelled,
      InsurPlcyExtRefCompany,
      InsurPlcyExtRefReferenceNumber,
      InsurPlcyExtRefReferenceType,
      InsurPlcyExtRefTemplate,
      InsurPlcyBusinessObject,
      LastChangeDateTime
}
where
      InsurPlcyCoverageOptionID = 0
  and InsurPlcyInsuredObjectID  = 0

Learn More