P_Matrix_SFDWGroupDerived

@AbapCatalog: {
    sqlViewName: 'PMCONSSFDWGR',
    compiler.compareFilter: true
}
@VDM: {
    viewType: #COMPOSITE,
    private:true
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #NOT_REQUIRED
}
@ClientHandling: {
    algorithm:#SESSION_VARIABLE
}
@ObjectModel: {
    usageType: {
        serviceQuality: #X,
        dataClass: #MIXED,
        sizeCategory: #XL
    }
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
define view P_Matrix_SFDWGroupDerived
  as select from P_StandardizedData      as transaction_data
    inner join   I_CnsldtnVersion        as version_assignment on transaction_data.rvers = version_assignment.ConsolidationVersion
    inner join   I_CnsldtnGroupStructure as group_structure    on  group_structure.ConsolidationDimension        =  transaction_data.rdimen
                                                               and group_structure.ConsolidationStructureVersion =  version_assignment.ConsolidationStructureVersion
                                                               and group_structure.ConsolidationUnit             =  transaction_data.rbunit
                                                               and group_structure.FromFiscalYearPeriod          <= transaction_data.fiscyearper
                                                               and group_structure.ToFiscalYearPeriod            >= transaction_data.fiscyearper
{
  // Key Fields

  rldnr,
  rdimen,
  ryear,
  docnr,
  docln,

  // Common Fields

  rrcty,
  rvers,
  rtcur,
  rhcur,
  rkcur,
  runit,

  drcrk,
  poper,
  fiscyearper,
  cast('PER' as fincs_period_mode)   as period_mode,
  transaction_data.poper             as poper_posting,

  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  group_structure.ConsolidationGroup as rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,
  uppcu,

  tsl,
  hsl,
  ksl,
  msl,

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

  // Additional Fields

  ktopl,
  racct,
  xblnr,
  zuonr,

  // Additional Fields - Universal Journal Entry: G/L additional account assignments

  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  aufnr,
  kunnr,
  lifnr,
  matnr,
  matkl_mm,
  werks,
  rmvct,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,

  // Additional Fields - SFIN: Universal Journal Entry - Fixed CO-PA fields

  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNGROUPSTRUCTURE",
"I_CNSLDTNVERSION",
"P_STANDARDIZEDDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/