R_InsurPlcyCommissionTP

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

  association        to parent R_InsurancePolicyTP_2 as _Policy    on  $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID

  composition [0..*] of R_InsurPlcyCommsnRoleTP      as _CommissionRole
  association [1..1] to E_InsurancePolicyCommission  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

{
  key Commission.InsurPlcyUUID,
  key Commission.InsurPlcyInsurContr,
  key Commission.InsurancePolicyCommissionId,
      Commission.InsurPlcyJrnlEndNmbr,
      Commission.InsurPlcyJrnlNmbr,
      Commission.InsurPlcyProductPackageID,
      Commission.InsurPlcyCommissionIsCancelled,
      Commission.InsurPlcyCommissionPrtcpntRole,
      Commission.InsurPlcyCommissionPrtcpntBPID,
      Commission.InsurPlcyCommissionContrID,
      Commission.InsurPlcyCommissionContrGrpID,
      Commission.InsurPlcyCommissionPrtnIsOwner,
      Commission.InsurPlcyBusinessObject,
      Commission.LastChangeDateTime,

      /*Associations*/
      _CommissionRole,
      _Policy

}
where
  Commission.InsurPlcyInsurContr = 0
  and 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_INSURPLCYCOMMISSIONBASIC"
],
"ASSOCIATED":
[
"R_INSURANCEPOLICYTP_2",
"R_INSURPLCYCOMMSNROLETP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/