Fins_Rev_Rec_Comp_Abgsl

DDL: FINS_REV_REC_COMP_ABGSL Type: view_entity Package: FINS_REV_REC_CUST

Compatible RA keys

Fins_Rev_Rec_Comp_Abgsl is a CDS View that provides data about "Compatible RA keys" in SAP S/4HANA. It reads from 3 data sources (fins_trr_val, fins_trr_val, tkkaa) and exposes 8 fields with key fields bukrs, abgsl. Part of development package FINS_REV_REC_CUST.

Data Sources (3)

SourceAliasJoin Type
fins_trr_val a from
fins_trr_val b inner
tkkaa c inner

Annotations (6)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Compatible RA keys view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY bukrs fins_trr_val bukrs
KEY abgsl fins_trr_val abgsl
tbrr_area tkkaa tbrr_area
method fins_trr_val method
ass_rule fins_trr_val ass_rule
abgsl_alt fins_trr_val abgsl
method_alt fins_trr_val method
tbrr_hide tkkaa tbrr_hide
 @AbapCatalog.entityBuffer.definitionAllowed: true
 @AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Compatible RA keys'

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

//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 entity Fins_Rev_Rec_Comp_Abgsl
  as

  select

  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
{
    key a.bukrs         as bukrs,
    key a.acc_principle as acc_principle,
    key a.abgsl         as abgsl,
        c.tbrr_area     as tbrr_area, //PuC only

        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
   
};