P_MJEL_CnsldtnFndnWithHier

Matrix Consolidation: Foundation View with Hierarchy | view: P_MCFNDVHIER | Extraction: Not supported | Component: Embedded Analytics
Tables used: SCAL_TT_YEAR, ACDOCU, ACDOCA, ACDOCP, RTC_PULL_REQ, ACDOCU, ACDOCA, TF500, FINCS_FSITEM, FINCS_GRPSTR, TF110, TF160, TF162, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINCS_FSITEM, T000, TF164, HRRP_NODE, T881, TF165, TF200, TF110, T881, TF165, TF168, TF200, TF110, TF103A, TF001, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010, TFIN010, TFIN010, TF040
Column Name Description
Column Name Description
💲 Currency Key (rtcur):
tsl Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl Value in Local Currency
💲 Currency key of the ledger currency (rkcur):
ksl Value in Group Currency
Column Name Description
📏 Base Unit of Measure (runit):
msl Quantity
Column Name Description
budat Posting Date in the Document
wsdat Value Date for Currency Translation
cpudt Day On Which Accounting Document Was Entered
cputm Time of Entry
Column Name Description
rrcty Record Type Show values
drcrk Debit/Credit Indicator Show values
period_mode Period Mode Show values
docct Document Category Show values
plevl Posting Level Show values
rpflg Apportionment Show values
rtflg Currency Translation Show values
refdocct Document Category Show values
coiac Consolidation of Investments Activity Show values
CnsldtnJrnlEntryItemOrigin Consolidation Journal Entry Item Origin Show values
Column Name Description Domain name
rldnr Ledger RLDNR
rdimen Dimension FC_DIMEN
ryear Fiscal Year GJAHR
docnr Document Number of an Accounting Document BELNR
docln Six-Character Posting Item for Ledger DOCLN6
rvers Version RVERS
poper Reporting Period POPER
fiscyearper Fiscal Year + Fiscal Period FINS_FYEARPERIOD
poper_posting Posting period POPER
rcomp Company RCOMP
rbunit Consolidation Unit FC_BUNIT
rbunit_eliminated Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
ritclg Consolidation Chart of Accounts FC_ITCLG
ritem Financial Statement Item FC_ITEM
rbuptr Partner Unit FC_BUNIT
rcongr Consolidation Group FC_CONGR
robukrs Original company code BUKRS
sityp Subitem Category FC_SITYP
subit Subitem FC_SITEM
docty Document Type FC_DOCTY
yracq Year of Acquisition GJAHR
pracq Period of Acquisition NUM03
coicu Investee Unit FC_BUNIT
sgtxt Item Text TEXT50
autom Indicator: Automatic posting lines TEXT1
activ Business Transaction CHAR4
bvorg Number of Cross-Company Code Posting Transaction BVORG
refdocnr Document Number of an Accounting Document BELNR
refryear Fiscal Year GJAHR
refdocln Six-figure number of line item BUZEI6
refactiv Business Transaction CHAR4
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
usnam User Name XUBNAME
rvsdocnr Reverse Document Number BELNR
orndocnr Number of Reversed Document BELNR
coinr Consolidation of Investments Activity Number BELNR
revyear Year of reversal document or reversed document GJAHR
awtyp Reference procedure AWTYP
aworg Reference Organizational Units AWORG
logsys Logical system LOGSYS
racct Account Number SAKNR
xblnr Reference Document Number XBLNR1
zuonr Assignment number ZUONR
rcntr Cost Center KOSTL
prctr Profit Center PRCTR
prctr_eliminated Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
rfarea Functional Area FKBER
rbusa Business Area GSBER
segment Segment for Segmental Reporting FB_SEGMENT
segment_eliminated Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
rmvct Transaction type RMVCT
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
ps_pspid Project definition PS_PSPID
konzs Group key KONZS
ConsolidationUnitHierarchy null
ConsolidationPrftCtrHier null
ConsolidationSegmentHier null
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number FIS_RSPM_TSN
FinancialPlanningDataPacket Financial Planning Data Packet Number NUM6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
rldnr_fin Ledger in General Ledger Accounting FINS_LEDGER
adhocitem Ad Hoc Item FINCS_ADHOCITEM
adhocset Ad Hoc Set FINCS_ADHOCSET
adhocsetitem Ad Hoc Set Item FINCS_ADHOCSETITEM
rcode Reason Code ICA_RCODE
orig_type Origin Type FINCS_ORIG_TYPE
orig_ref Origin Reference FINCS_ORIG_REF
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.AUFNR == AUFK.AUFNR
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == AUFK.MANDT
Industry key
  • Industry key
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.BRSCH == T016.BRSCH
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T016.MANDT
Sales District
  • Client
  • Sales District
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T171.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.BZIRK == T171.BZIRK
Billing Type
  • Billing Type
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.FKART == TVFK.FKART
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TVFK.MANDT
Customer Group
  • Client
  • Customer Group
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T151.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.KDGRP == T151.KDGRP
Controlling Area
  • Client
  • Controlling Area
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TKA01.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T004.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.KTOPL == T004.KTOPL
Customer Number
  • Customer Number
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.KUNNR == KNA1.KUNNR
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == KNA1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.KUNRE == KNA1.KUNNR
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == KNA1.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.KUNWE == KNA1.KUNNR
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == KNA1.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T005.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.LAND1 == T005.LAND1
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.LIFNR == LFA1.LIFNR
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == LFA1.MANDT
Product Sold Group
  • Client
  • Product Sold Group
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T023.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.MATKL == T023.MATKL
Material Group
  • Material Group
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.MATKL_MM == T023.MATKL
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T023.MANDT
Material Number
  • Client
  • Material Number
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == MARA.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.MATNR == MARA.MATNR
Product Sold
  • Client
  • Product Sold
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == MARA.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.MATNR_COPA == MARA.MATNR
Partner Profit Center
  • ?
  • Client
  • Controlling Area
  • Partner Profit Center
  • P_MJEL_CNSLDTNFNDNWITHHIER.[column in domain "DATBI"] == CEPC.DATBI
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == CEPC.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.KOKRS == CEPC.KOKRS
  • P_MJEL_CNSLDTNFNDNWITHHIER.PPRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_MJEL_CNSLDTNFNDNWITHHIER.PSEGMENT == FAGL_SEGM.SEGMENT
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == FAGL_SEGM.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T880.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.RASSC == T880.RCOMP
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TGSB.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.SBUSA == TGSB.GSBER
Sender cost center
  • ?
  • Client
  • Sender cost center
  • Controlling Area
  • P_MJEL_CNSLDTNFNDNWITHHIER.[column in domain "DATBI"] == CSKS.DATBI
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == CSKS.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.SCNTR == CSKS.KOSTL
  • P_MJEL_CNSLDTNFNDNWITHHIER.KOKRS == CSKS.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TFKB.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.SFAREA == TFKB.FKBER
Division
  • Client
  • Division
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TSPA.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.SPART == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TVKO.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == TVTW.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • P_MJEL_CNSLDTNFNDNWITHHIER.MANDT == T001W.MANDT
  • P_MJEL_CNSLDTNFNDNWITHHIER.WERKS == T001W.WERKS