R_InsurPlcyContrExtRefTP

DDL: R_INSURPLCYCONTREXTREFTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API_COMMON

External Reference under Contract

R_InsurPlcyContrExtRefTP is a Transactional CDS View that provides data about "External Reference under Contract" 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.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyExternalReferenceID = _Extension.InsurPlcyExternalReferenceID and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID

Annotations (8)

NameValueLevelField
EndUserText.label External Reference under Contract 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 Contract'
@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_InsurPlcyContrExtRefTP
  as select from I_InsurPlcyExtReferenceBasic

  association [1..1] to E_InsurPlcyExtRef as _Extension on  $projection.InsurPlcyInsuredObjectID     = _Extension.InsurPlcyInsuredObjectID
                                                        and $projection.InsurPlcyInsurContr          = _Extension.InsurPlcyInsurContr
                                                        and $projection.InsurPlcyJrnlEndNmbr         = _Extension.InsurPlcyJrnlEndNmbr
                                                        and $projection.InsurPlcyJrnlNmbr            = _Extension.InsurPlcyJrnlNmbr
                                                        and $projection.InsurPlcyUUID                = _Extension.InsurPlcyUUID
                                                        and $projection.InsurPlcyExternalReferenceID = _Extension.InsurPlcyExternalReferenceID
                                                        and $projection.InsurPlcyCoveragePackageID   = _Extension.InsurPlcyCoveragePackageID
                                                        and $projection.InsurPlcyCoverageOptionID    = _Extension.InsurPlcyCoverageOptionID
                                                        and $projection.InsurPlcyCoverageID          = _Extension.InsurPlcyCoverageID

{

  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
      InsurPlcyCoveragePackageID = 0
  and InsurPlcyCoverageID        = 0
  and InsurPlcyCoverageOptionID  = 0
  and InsurPlcyInsuredObjectID   = 0

Learn More