P_Matrix_VecPCC

@AbapCatalog.sqlViewName: 'PMCVECPCC'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view P_Matrix_VecPCC
 with parameters
    p_ryear  : gjahr,
    p_poper  : poper
  as select from acdocu
{
  // Key Fields

  rclnt,
  rldnr,
  rdimen,
  ryear,
  docnr,
  docln,

  // Common Fields

  rrcty,
  rvers,


  rtcur,
  rhcur,
  rkcur,
  runit,

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

  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,

  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,
  adhocitem,
  adhocset
}
where
      rrcty = '0'
  and plevl = '30'
  and draft <> 'X'

union all select from acdocu                         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 transaction_data.rdimen                  = group_structure.ConsolidationDimension
                                                                           and version_assignment.ConsolidationStructureVersion = group_structure.ConsolidationStructureVersion
                                                                           and transaction_data.rbunit                 = group_structure.ConsolidationUnit
                                                                           and transaction_data.rcongr                 = group_structure.ConsolidationGroup
                                                                           and group_structure.FromFiscalYearPeriod   <= concat( $parameters.p_ryear,$parameters.p_poper )
                                                                           and group_structure.ToFiscalYearPeriod     >= concat( $parameters.p_ryear,$parameters.p_poper )
//  inner join          P_Matrix_GroupStructurePerYear as group_structure    on  transaction_data.rdimen                 = group_structure.ConsolidationDimension

//                                                                           and version_assignment.ConsolidationVersion = group_structure.ConsolidationStructureVersion

//                                                                           and transaction_data.rbunit                 = group_structure.ConsolidationUnit

//                                                                           and transaction_data.ryear                  = group_structure.FiscalYear

//                                                                           and transaction_data.rcongr                 = group_structure.ConsolidationGroup

{
  // Key Fields

  rclnt,
  rldnr,
  rdimen,
  ryear,
  docnr,
  docln,

  // Common Fields

  rrcty,
  rvers,


  rtcur,
  rhcur,
  rkcur,
  runit,

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

  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,

  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,
  adhocitem,
  adhocset
}
where
  (
       rrcty = '0'
    or rrcty = 'A'
    or rrcty = 'D'
    or rrcty = 'E'
  )
  and(
       plevl = '02'
    or plevl = '12'
  )
  and draft <> 'X'

union all select from acdocu                         as transaction_data
  inner join          I_CnsldtnVersion               as version_assignment on transaction_data.rvers = version_assignment.ConsolidationVersion
  inner join          I_CnsldtnGroupStructure        as unit_structure     on  transaction_data.rdimen                 = unit_structure.ConsolidationDimension
                                                                           and version_assignment.ConsolidationStructureVersion = unit_structure.ConsolidationStructureVersion
                                                                           and transaction_data.rbunit                 = unit_structure.ConsolidationUnit
                                                                           and transaction_data.rcongr                 = unit_structure.ConsolidationGroup
                                                                           and unit_structure.FromFiscalYearPeriod    <= concat( $parameters.p_ryear,$parameters.p_poper )
                                                                           and unit_structure.ToFiscalYearPeriod      >= concat( $parameters.p_ryear,$parameters.p_poper )
  inner join          I_CnsldtnGroupStructure        as punit_structure    on  transaction_data.rdimen                 = punit_structure.ConsolidationDimension
                                                                           and version_assignment.ConsolidationStructureVersion = punit_structure.ConsolidationStructureVersion
                                                                           and transaction_data.rbuptr                 = punit_structure.ConsolidationUnit
                                                                           and transaction_data.rcongr                 = punit_structure.ConsolidationGroup
                                                                           and punit_structure.FromFiscalYearPeriod   <= concat( $parameters.p_ryear,$parameters.p_poper )
                                                                           and punit_structure.ToFiscalYearPeriod     >= concat( $parameters.p_ryear,$parameters.p_poper )
//  inner join          P_Matrix_GroupStructurePerYear as unit_structure     on  transaction_data.rdimen                 = unit_structure.ConsolidationDimension

//                                                                           and version_assignment.ConsolidationVersion = unit_structure.ConsolidationStructureVersion

//                                                                           and transaction_data.rbunit                 = unit_structure.ConsolidationUnit

//                                                                           and transaction_data.ryear                  = unit_structure.FiscalYear

//                                                                           and transaction_data.rcongr                 = unit_structure.ConsolidationGroup

//  inner join          P_Matrix_GroupStructurePerYear as punit_structure    on  transaction_data.rdimen                 = punit_structure.ConsolidationDimension

//                                                                           and version_assignment.ConsolidationVersion = punit_structure.ConsolidationStructureVersion

//                                                                           and transaction_data.rbuptr                 = punit_structure.ConsolidationUnit

//                                                                           and transaction_data.ryear                  = punit_structure.FiscalYear

//                                                                           and transaction_data.rcongr                 = punit_structure.ConsolidationGroup

{
  // Key Fields

  rclnt,
  rldnr,
  rdimen,
  ryear,
  docnr,
  docln,

  // Common Fields

  rrcty,
  rvers,


  rtcur,
  rhcur,
  rkcur,
  runit,

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

  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,

  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,
  adhocitem,
  adhocset
}
where
  (
       rrcty = '0'
    or rrcty = 'A'
    or rrcty = 'D'
    or rrcty = 'E'
  )
  and  plevl = '22'
  and draft <> 'X'