Fins_Rev_Rec_Cos_Plan_View

@AbapCatalog.sqlViewName: 'FINS_RR_COS_PLAN'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Planvalues from COSP_BAP, COSS_BAK, COSPP, COSSP'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

//Adds dimension type of quantity unit to Fins_Rev_Rec_Cos_Plan_View

//Selects from Fins_Rev_Rec_Cos_Plan_View and T006


define view Fins_Rev_Rec_Cos_Plan_View
  as select
    a.versn       as versn,
    a.wrttp       as wrttp,
    a.kstar       as kstar,
    a.objnr       as objnr,
    a.twaer       as twaer,
    a.meinh       as meinh,
    b.dimid       as dimid,
    sum(a.wtgbtr) as wtgbtr,
    sum(a.wkgbtr) as wkgbtr,
    sum(a.wogbtr) as wogbtr,
    sum(a.megbtr) as megbtr
  from              Fins_Rev_Rec_Cos_Plan_Hlp_View as a
    left outer join t006                           as b on a.meinh = b.msehi
  group by
    a.versn,
    a.wrttp,
    a.kstar,
    a.objnr,
    a.twaer,
    a.meinh,
    b.dimid;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINS_REV_REC_COS_PLAN_HLP_VIEW",
"T006"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/