R_InsurPlcyContrExtRefTP

@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: 'InsurancePolicyContract'
@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'ERE',
  allowNewDatasources: false,
  allowNewCompositions: true,
  dataSources: [ '_Extension' ],
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}
define view entity R_InsurPlcyContrExtRefTP
  as select from I_InsurPlcyExtReferenceBasic

  association        to parent R_InsurPlcyContractTP as _Contract  on  $projection.InsurPlcyUUID       = _Contract.InsurPlcyUUID
                                                                   and $projection.InsurPlcyInsurContr = _Contract.InsurPlcyInsurContr

  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,

      /*Association*/
      _Contract
}
where
      InsurPlcyCoveragePackageID = 0
  and InsurPlcyCoverageID        = 0
  and InsurPlcyCoverageOptionID  = 0
  and InsurPlcyInsuredObjectID   = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYEXTREFERENCEBASIC"
],
"ASSOCIATED":
[
"R_INSURPLCYCONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/