P_Matrix_PCCData

@AbapCatalog.sqlViewName: 'PMCPCCDATA'
@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_PCCData
  as select from P_CnsldtnGroupJrnlEntryItemHC
    inner join   I_CnsldtnVersionRelation as CnsldtnVersionRelation on CnsldtnVersionRelation.ConsolidationVersionElement = P_CnsldtnGroupJrnlEntryItemHC.ConsolidationVersion
{

  // Key Fields

  rclnt,
  ConsolidationLedger                                            as rldnr,
  ConsolidationDimension                                         as rdimen,
  FiscalYear                                                     as ryear,
  CnsldtnGroupJrnlEntry                                          as docnr,
  CnsldtnGroupJrnlEntryItem                                      as docln,

  // Common Fields

  GLRecordType                                                   as rrcty,
  P_CnsldtnGroupJrnlEntryItemHC.ConsolidationVersion             as rvers,
  cast (CnsldtnVersionRelation.ConsolidationVersion as fc_rvers) as ConsolidationVersion,

  TransactionCurrency                                            as rtcur,
  LocalCurrency                                                  as rhcur,
  GroupCurrency                                                  as rkcur,
  BaseUnit                                                       as runit,

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

  DocumentCategory                                               as docct,
  Company                                                        as rcomp,
  ConsolidationUnit                                              as rbunit,
  ConsolidationChartOfAccounts                                   as ritclg,
  FinancialStatementItem                                         as ritem,
  PartnerConsolidationUnit                                       as rbuptr,
  ConsolidationGroup                                             as rcongr,
  CompanyCode                                                    as robukrs,
  SubItemCategory                                                as sityp,
  SubItem                                                        as subit,
  PostingLevel                                                   as plevl,
  ConsolidationApportionment                                     as rpflg,
  CurrencyConversionsDiffType                                    as rtflg,
  ConsolidationDocumentType                                      as docty,
  ConsolidationAcquisitionYear                                   as yracq,
  ConsolidationAcquisitionPeriod                                 as pracq,
  InvesteeConsolidationUnit                                      as coicu,
  InvestorConsolidationUnit                                      as uppcu,

  AmountInTransactionCurrency                                    as tsl,
  AmountInLocalCurrency                                          as hsl,
  AmountInGroupCurrency                                          as ksl,
  CnsldtnQuantityInBaseUnit                                      as msl,

  DocumentItemText                                               as sgtxt,
  ConsolidationPostgItemAutoFlag                                 as autom,
  BusinessTransactionType                                        as activ,
  bvorg,
  PostingDate                                                    as budat,
  CurrencyTranslationDate                                        as wsdat,
  RefConsolidationDocumentNumber                                 as refdocnr,
  ReferenceFiscalYear                                            as refryear,
  RefConsolidationPostingItem                                    as refdocln,
  RefConsolidationDocumentType                                   as refdocct,
  RefBusinessTransactionType                                     as refactiv,
  CreationDateTime                                               as timestamp,
  CreationDate                                                   as cpudt,
  CreationTime                                                   as cputm,
  UserID                                                         as usnam,
  ReverseDocument                                                as rvsdocnr,
  ReversedDocument                                               as orndocnr,
  InvestmentActivityType                                         as coiac,
  InvestmentActivity                                             as coinr,
  ConsolidationDocReversalYear                                   as revyear,
  ReferenceDocumentType                                          as awtyp,
  ReferenceDocumentContext                                       as aworg,
  LogicalSystem                                                  as logsys,

  // Additional Fields

  ChartOfAccounts                                                as ktopl,
  GLAccount                                                      as racct,
  xblnr,
  AssignmentReference                                            as zuonr,

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

  CostCenter                                                     as rcntr,
  ProfitCenter                                                   as prctr,
  FunctionalArea                                                 as rfarea,
  BusinessArea                                                   as rbusa,
  ControllingArea                                                as kokrs,
  Segment                                                        as segment,
  PartnerCostCenter                                              as scntr,
  PartnerProfitCenter                                            as pprctr,
  PartnerFunctionalArea                                          as sfarea,
  PartnerBusinessArea                                            as sbusa,
  PartnerCompany                                                 as rassc,
  PartnerSegment                                                 as psegment,
  OrderID                                                        as aufnr,
  Customer                                                       as kunnr,
  Supplier                                                       as lifnr,
  Material                                                       as matnr,
  MaterialGroup                                                  as matkl_mm,
  Plant                                                          as werks,
  FinancialTransactionType                                       as rmvct,
  WBSElementInternalID                                           as ps_psp_pnr,
  WBSElementExternalID                                           as ps_posid,
  Project                                                        as ps_pspid,

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

  BillingDocumentType                                            as fkart,
  SalesOrganization                                              as vkorg,
  DistributionChannel                                            as vtweg,
  OrganizationDivision                                           as spart,
  SoldProduct                                                    as matnr_copa,
  SoldProductGroup                                               as matkl,
  CustomerGroup                                                  as kdgrp,
  CustomerSupplierCountry                                        as land1,
  CustomerSupplierIndustry                                       as brsch,
  SalesDistrict                                                  as bzirk,
  BillToParty                                                    as kunre,
  ShipToParty                                                    as kunwe,
  CustomerSupplierCorporateGroup                                 as konzs,

  // Additional Fields - Adhoc Item

  CnsldtnAdhocItem                                               as adhocitem,
  CnsldtnAdhocSet                                                as adhocset,
  CnsldtnAdhocSetItem                                            as adhocsetitem,

  //Additional Fields - ICMR

  MatchingReasonCode                                             as rcode,
  OriginType                                                     as orig_type,
  OriginReference                                                as orig_ref
}
where
  (
       GLRecordType = '0'
    or GLRecordType = 'A'
    or GLRecordType = 'D'
    or GLRecordType = 'E'
  )
  and  PostingLevel = '22'