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
@VDM.lifecycle.status: #DEPRECATED

//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,
    //@Semantics.amount.currencyCode: 'twaer' // Transaction currency

    sum(a.wtgbtr) as wtgbtr,
    // Controlling area currency TKA01-WAERS, Needed to select COEP-KOKRS via OBJNR and GJAHR?

    sum(a.wkgbtr) as wkgbtr,
    // Company Code currency = Object currency see FUNC K_OBJECT_INFORMATION_GET, extend Fins_Rev_Rec_Cos_Plan_Hlp_View of BUKRS, alternatively I_CompanyCode-Currency

    sum(a.wogbtr) as wogbtr,
    //@Semantics.quantity.unitOfMeasure: 'co_meinh'   // Total quantity COSPP-MEINH

    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;