P_Matrix_VecSFD

@AbapCatalog.sqlViewName: 'PMCVECSFD'
@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_VecSFD
 with parameters
    p_ryear  : gjahr,
    p_poper  : poper 
  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 transaction_data.rdimen                  = group_structure.ConsolidationDimension
                                                                      and version_assignment.ConsolidationStructureVersion = group_structure.ConsolidationStructureVersion
                                                                      and transaction_data.rbunit                 = group_structure.ConsolidationUnit
                                                                      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

{
  // 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,
  group_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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNGROUPSTRUCTURE",
"I_CNSLDTNVERSION",
"P_STANDARDIZEDDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/