P_Matrix_VecElim

@AbapCatalog.sqlViewName: 'PMCVECELIM'
@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_VecElim
 with parameters
    p_ryear  : gjahr,
    p_poper  : poper 
  as select from P_ConsolidatedData             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 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 punit_structure.FromFiscalYearPeriod   <= concat( $parameters.p_ryear,$parameters.p_poper )
                                                                      and punit_structure.ToFiscalYearPeriod     >= concat( $parameters.p_ryear,$parameters.p_poper )  
                                                                      and unit_structure.ConsolidationGroup       = punit_structure.ConsolidationGroup
   //    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

//    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 unit_structure.ConsolidationGroup       = punit_structure.ConsolidationGroup

{
  // Key Fields

  rclnt,
  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,
  poper                                              as poper_posting,

  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  unit_structure.ConsolidationGroup                  as 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
}
where
  plevl = '20'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNGROUPSTRUCTURE",
"I_CNSLDTNVERSION",
"P_CONSOLIDATEDDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/