R_InsurPlcyCommsnRoleTP

@EndUserText.label: 'Commission Role'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY, /*#NOT_REQUIRED,*/
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   semanticKey: [ 'InsurPlcyCommissionRoleId' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@ObjectModel.sapObjectNodeType.name: 'InsurancePolicy'
@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'CMR',
  allowNewDatasources: false,
  allowNewCompositions: true,
  dataSources: [ '_Extension' ],
  quota: {
    maximumFields: 100,
    maximumBytes: 1000
  }
}
define view entity R_InsurPlcyCommsnRoleTP
  as select from I_InsurPlcyCommissionRoleBasic as CommissionRole

  association        to parent R_InsurPlcyCommissionTP as _Commission on  $projection.InsurPlcyUUID               = _Commission.InsurPlcyUUID
                                                                      and $projection.InsurPlcyInsurContr         = _Commission.InsurPlcyInsurContr
                                                                      and $projection.InsurancePolicyCommissionId = _Commission.InsurancePolicyCommissionId

  association [1..1] to E_InsurPolicyCommissionRole    as _Extension  on  $projection.InsurPlcyUUID               = _Extension.InsurPlcyUUID
                                                                      and $projection.InsurPlcyJrnlEndNmbr        = _Extension.InsurPlcyJrnlEndNmbr
                                                                      and $projection.InsurPlcyJrnlNmbr           = _Extension.InsurPlcyJrnlNmbr
                                                                      and $projection.InsurPlcyInsurContr         = _Extension.InsurPlcyInsurContr
                                                                      and $projection.InsurancePolicyCommissionId = _Extension.InsurancePolicyCommissionId
                                                                      and $projection.InsurPlcyCommissionRoleId   = _Extension.InsurPlcyCommissionRoleId

  association        to R_InsurancePolicyTP_2          as _Policy     on  $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID
{
  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
  key InsurancePolicyCommissionId,
  key InsurPlcyCommissionRoleId,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyJrnlNmbr,
      InsurPlcyProductPackageID,
      InsurPlcyCommsnRoleIsCancelled,
      InsurPlcyCommsnRoleDrctRate,
      InsurPlcyCommsnRoleIndrctRate,
      InsurPlcyCommsnRoleCode,
      InsurPlcyCommsnRoleIsActive,
      InsurPlcyBusinessObject,
      LastChangeDateTime,

      /*Association*/
      _Commission,
      _Policy
}
where
 1 = 2 //added just in case of security that R view returns no data as it is handled in unmanaged query on A view

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYCOMMISSIONROLEBASIC"
],
"ASSOCIATED":
[
"R_INSURANCEPOLICYTP_2",
"R_INSURPLCYCOMMISSIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/