Fins_Rev_Rec_Comp_Abgsl

@AbapCatalog.sqlViewName: 'FINS_RR_COMP_KEY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientDependent: true
@EndUserText.label: 'Compatible RA keys'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@AbapCatalog.buffering.status:#ACTIVE 
@AbapCatalog.buffering.type:#FULL

//Determins whether two RA keys are comptible

//Two RA keys are comparible, if they use the same assignment rule

//Selects from fins_trr_val


define view Fins_Rev_Rec_Comp_Abgsl as 

select 
a.bukrs as bukrs,
a.acc_principle as acc_principle,
a.abgsl as abgsl,
a.method as method,
a.ass_rule as ass_rule,
b.abgsl as abgsl_alt,
b.method as method_alt,
c.tbrr_hide as tbrr_hide,
c.tbrr_area as tbrr_area

from fins_trr_val as a
inner join fins_trr_val as b on b.bukrs = a.bukrs and b.acc_principle = a.acc_principle and b.ass_rule = a.ass_rule
inner join tkkaa as c on c.abgsl = b.abgsl

;
  
 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINS_TRR_VAL",
"TKKAA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/