P_ReportedFinancialData_RL_AG

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PREPFINDRLAG'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

//@AccessControl.authorizationCheck: #NOT_ALLOWED

@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view P_ReportedFinancialData_RL_AG
  // data that has been released in the data submit task

  // aggregated to the consolidation structure


  as select from acdocu
{
  rclnt,
  cast('' as gu_recid)            as gl_sirid,
  rldnr,
  cast('0' as rrcty)              as rrcty,
  rvers,
  ryear,

  rtcur,
  rhcur,
  rkcur,

  runit,
  cast('' as shkzg)               as drcrk,
  poper,
  cast(fiscyearper as fis_jahrper_conv preserving type )              as fiscyearper, //bbrCC1908

  docct,
//  cast(refdocnr as belnr_d)       as docnr,  //bbrCC1905

//  cast(refdocln as docln6)        as docln,  //bbrCC1905

  docnr,                                    //bbrCC1905

  docln,                                    //bbrCC1905

  rcomp,
  rdimen,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,
  cast('000' as updhp)            as updhp,

  tsl,
  hsl,
  ksl,

  msl,
  sgtxt,
  autom,
  activ,
  bvorg,
  budat,
  wsdat,
  refdocnr,
  refryear,
  refdocln,
  refdocct,
  refactiv,
  cpudt,
  cputm,
  usnam,
  rvsdocnr,
  orndocnr,
  coiac,
  coinr,
  uppcu,
  revyear,
  awtyp,
  aworg,
  logsys,

//  cast(0 as timestamp)            as timestamp,

  timestamp,
  racct,

  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  rmvct,

  matnr,
  werks,
  kunnr,
  lifnr,

  ps_posid,
  ps_pspid,

  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  zuonr,
  aufnr,
  xblnr,
  matkl_mm,
  ps_psp_pnr,
  ktopl,
  cast('' as data_temperature )                                                                          as _dataaging
}
where
  rrcty = 'U'