P_COSB_COM

@AbapCatalog.sqlViewName: 'PFICOSBCOM'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'P_COSB_COM'

@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true


define view P_COSB_COM
  as select from cosb
{
  key objnr,
  key gjahr,
  key wrttp,
  key versn,
  key cast( abkat as fco_abkat) as abkat, 
  key kstar,
  key hrkft,
  key vrgng,
  key parob,
  key beknz,
  key meinh,

      sum(wkg001) as wkg001,
      sum(wkg002) as wkg002,
      sum(wkg003) as wkg003,
      sum(wkg004) as wkg004,
      sum(wkg005) as wkg005,
      sum(wkg006) as wkg006,
      sum(wkg007) as wkg007,
      sum(wkg008) as wkg008,
      sum(wkg009) as wkg009,
      sum(wkg010) as wkg010,
      sum(wkg011) as wkg011,
      sum(wkg012) as wkg012,
      sum(wkg013) as wkg013,
      sum(wkg014) as wkg014,
      sum(wkg015) as wkg015,
      sum(wkg016) as wkg016,

      sum(wkf001) as wkf001,
      sum(wkf002) as wkf002,
      sum(wkf003) as wkf003,
      sum(wkf004) as wkf004,
      sum(wkf005) as wkf005,
      sum(wkf006) as wkf006,
      sum(wkf007) as wkf007,
      sum(wkf008) as wkf008,
      sum(wkf009) as wkf009,
      sum(wkf010) as wkf010,
      sum(wkf011) as wkf011,
      sum(wkf012) as wkf012,
      sum(wkf013) as wkf013,
      sum(wkf014) as wkf014,
      sum(wkf015) as wkf015,
      sum(wkf016) as wkf016,

      sum(wog001) as wog001,
      sum(wog002) as wog002,
      sum(wog003) as wog003,
      sum(wog004) as wog004,
      sum(wog005) as wog005,
      sum(wog006) as wog006,
      sum(wog007) as wog007,
      sum(wog008) as wog008,
      sum(wog009) as wog009,
      sum(wog010) as wog010,
      sum(wog011) as wog011,
      sum(wog012) as wog012,
      sum(wog013) as wog013,
      sum(wog014) as wog014,
      sum(wog015) as wog015,
      sum(wog016) as wog016,

      sum(meg001) as meg001,
      sum(meg002) as meg002,
      sum(meg003) as meg003,
      sum(meg004) as meg004,
      sum(meg005) as meg005,
      sum(meg006) as meg006,
      sum(meg007) as meg007,
      sum(meg008) as meg008,
      sum(meg009) as meg009,
      sum(meg010) as meg010,
      sum(meg011) as meg011,
      sum(meg012) as meg012,
      sum(meg013) as meg013,
      sum(meg014) as meg014,
      sum(meg015) as meg015,
      sum(meg016) as meg016

}
where
      lednr = '00'
  and perbl = '016'
group by
  objnr,
  gjahr,
  wrttp,
  versn,
  abkat,
  kstar,
  hrkft,
  vrgng,
  parob,
  beknz,
  meinh      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"COSB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/