P_Matrix_CnsldtdDataWthoutElim

@AbapCatalog.sqlViewName: 'PMCCDNE'
@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_CnsldtdDataWthoutElim
  as select from I_CnsldtnGroupJrnlEntryItem
{
  // Key Fields

  ConsolidationLedger               as rldnr,
  ConsolidationDimension            as rdimen,
  FiscalYear                        as ryear,
  CnsldtnGroupJrnlEntry             as docnr,
  CnsldtnGroupJrnlEntryItem         as docln,
  
  // Common Fields

  cast('0' as fc_rrcty)             as rrcty,
  ConsolidationVersion              as rvers,
  
  TransactionCurrency               as rtcur,
  LocalCurrency                     as rhcur,
  GroupCurrency                     as rkcur,
  BaseUnit                          as runit,
  
  cast('' as shkzg preserving type) 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,       // Investor Unit

  
  AmountInTransactionCurrency       as tsl,
  AmountInLocalCurrency             as hsl,
  AmountInGroupCurrency             as ksl,
  CnsldtnQuantityInBaseUnit         as msl,
  
  DocumentItemText                  as sgtxt,
  ConsolidationPostgItemAutoFlag    as autom,
  BusinessTransactionType           as activ,
  ''                                as bvorg,       // missing in I_CnsldtnGroupJrnlEntryItem

  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,
  cast('' as xblnr1)                as 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,
  SoldMaterial                      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
}
where
  GLRecordType = 'U'
union all select from I_CnsldtnGroupJrnlEntryItem
{
  ConsolidationLedger               as rldnr,
  ConsolidationDimension            as rdimen,
  FiscalYear                        as ryear,
  CnsldtnGroupJrnlEntry             as docnr,
  CnsldtnGroupJrnlEntryItem         as docln,
  // Common Fields

  cast('0' as fc_rrcty)             as rrcty,
  ConsolidationVersion              as rvers,
  TransactionCurrency               as rtcur,
  LocalCurrency                     as rhcur,
  GroupCurrency                     as rkcur,
  BaseUnit                          as runit,
  cast('' as shkzg preserving type) 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,       // Investor Unit

  AmountInTransactionCurrency       as tsl,
  AmountInLocalCurrency             as hsl,
  AmountInGroupCurrency             as ksl,
  CnsldtnQuantityInBaseUnit         as msl,
  DocumentItemText                  as sgtxt,
  ConsolidationPostgItemAutoFlag    as autom,
  BusinessTransactionType           as activ,
  ''                                as bvorg,       // missing in I_CnsldtnGroupJrnlEntryItem

  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,
  cast('' as xblnr1)                as 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,
  SoldMaterial                      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
}
where
       GLRecordType = '0'
  and(
       PostingLevel = '' // balance carry forward

    or PostingLevel = '00'
    or PostingLevel = '0C'
    or PostingLevel = '0T'
    or PostingLevel = '01'
    or PostingLevel = '08'
    or PostingLevel = '10'
    or PostingLevel = '30'
  )
union all select from I_CnsldtnGroupJrnlEntryItem as transaction_data
  inner join          I_CnsldtnVersion            as version_assignment on transaction_data.ConsolidationVersion = version_assignment.ConsolidationVersion
  inner join          I_CnsldtnGroupStructure     as group_structure    on  group_structure.ConsolidationDimension        =       transaction_data.ConsolidationDimension
                                                                        and group_structure.ConsolidationStructureVersion =       version_assignment.ConsolidationStructureVersion
                                                                        and group_structure.ConsolidationUnit             =       transaction_data.ConsolidationUnit
                                                                        and group_structure.ConsolidationGroup            =       transaction_data.ConsolidationGroup
                                                                        and transaction_data.FiscalYearPeriod             between group_structure.FromFiscalYearPeriod and group_structure.ToFiscalYearPeriod
{
  transaction_data.ConsolidationLedger    as rldnr,
  transaction_data.ConsolidationDimension as rdimen,
  FiscalYear                              as ryear,
  CnsldtnGroupJrnlEntry                   as docnr,
  CnsldtnGroupJrnlEntryItem               as docln,
  // Common Fields

  cast('0' as fc_rrcty)                   as rrcty,
  transaction_data.ConsolidationVersion   as rvers,
  TransactionCurrency                     as rtcur,
  LocalCurrency                           as rhcur,
  transaction_data.GroupCurrency          as rkcur,
  BaseUnit                                as runit,
  cast('' as shkzg preserving type)       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,
  transaction_data.ConsolidationUnit      as rbunit,
  ConsolidationChartOfAccounts            as ritclg,
  FinancialStatementItem                  as ritem,
  PartnerConsolidationUnit                as rbuptr,
  transaction_data.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, // Investor Unit

  AmountInTransactionCurrency             as tsl,
  AmountInLocalCurrency                   as hsl,
  AmountInGroupCurrency                   as ksl,
  CnsldtnQuantityInBaseUnit               as msl,
  DocumentItemText                        as sgtxt,
  ConsolidationPostgItemAutoFlag          as autom,
  BusinessTransactionType                 as activ,
  ''                                      as bvorg, // missing in I_CnsldtnGroupJrnlEntryItem

  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,
  cast('' as xblnr1)                      as 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,
  SoldMaterial                            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
}
where
  (
       GLRecordType = '0'
    or GLRecordType = 'A'
    or GLRecordType = 'D'
    or GLRecordType = 'E'
  )
  and(
       PostingLevel = '02'
    or PostingLevel = '12'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNGROUPJRNLENTRYITEM",
"I_CNSLDTNGROUPSTRUCTURE",
"I_CNSLDTNVERSION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/