P_Cc_JournalEntryFact

Journal Entry Fact | view: PCCJRNLENTRFACT | Extraction: Not supported | Component: S4HANA Financial Consolidation[Cloud]
Tables used: ECMCA, ECMCA, T000, T881, TF200, TF164, TF004
Column Name Description
gl_sirid Record number of the line item record
Column Name Description
💲 Currency Key (rtcur):
tsl Value in Transaction Currency
hsl Value in Local Currency
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
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
Column Name Description Domain name
ryear Fiscal Year GJAHR
poper Posting period POPER
docnr Document Number of an Accounting Document BELNR
docln Six-Character Posting Item for Ledger DOCLN6
yracq Year of Acquisition GJAHR
pracq Period of Acquisition NUM03
updhp Highest update period POPER
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
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
Master Data Relations Join Conditions
Investee Unit
  • Investee Unit
  • Dimension
  • Client
  • P_CC_JOURNALENTRYFACT.COICU == TF160.BUNIT
  • P_CC_JOURNALENTRYFACT.RDIMEN == TF160.DIMEN
  • P_CC_JOURNALENTRYFACT.MANDT == TF160.MANDT
Document Type
  • Dimension
  • Client
  • Document Type
  • P_CC_JOURNALENTRYFACT.RDIMEN == TF500.DIMEN
  • P_CC_JOURNALENTRYFACT.MANDT == TF500.MANDT
  • P_CC_JOURNALENTRYFACT.DOCTY == TF500.DOCTY
Consolidation Unit
  • Dimension
  • Consolidation Unit
  • Client
  • P_CC_JOURNALENTRYFACT.RDIMEN == TF160.DIMEN
  • P_CC_JOURNALENTRYFACT.RBUNIT == TF160.BUNIT
  • P_CC_JOURNALENTRYFACT.MANDT == TF160.MANDT
Partner Unit
  • Dimension
  • Partner Unit
  • Client
  • P_CC_JOURNALENTRYFACT.RDIMEN == TF160.DIMEN
  • P_CC_JOURNALENTRYFACT.RBUPTR == TF160.BUNIT
  • P_CC_JOURNALENTRYFACT.MANDT == TF160.MANDT
Company
  • Client
  • Company
  • P_CC_JOURNALENTRYFACT.MANDT == T880.MANDT
  • P_CC_JOURNALENTRYFACT.RCOMP == T880.RCOMP
Consolidation Group
  • Dimension
  • Consolidation Group
  • Client
  • P_CC_JOURNALENTRYFACT.RDIMEN == TF180.DIMEN
  • P_CC_JOURNALENTRYFACT.RCONGR == TF180.CONGR
  • P_CC_JOURNALENTRYFACT.MANDT == TF180.MANDT
Dimension
  • Dimension
  • Client
  • P_CC_JOURNALENTRYFACT.RDIMEN == TF150.DIMEN
  • P_CC_JOURNALENTRYFACT.MANDT == TF150.MANDT
Local Currency
  • Local Currency
  • Client
  • P_CC_JOURNALENTRYFACT.RHCUR == TCURC.WAERS
  • P_CC_JOURNALENTRYFACT.MANDT == TCURC.MANDT
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • P_CC_JOURNALENTRYFACT.MANDT == TF120.MANDT
  • P_CC_JOURNALENTRYFACT.RITCLG == TF120.ITCLG
Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • Financial Statement Item
  • P_CC_JOURNALENTRYFACT.MANDT == TF100.MANDT
  • P_CC_JOURNALENTRYFACT.RITCLG == TF100.ITCLG
  • P_CC_JOURNALENTRYFACT.RITEM == TF100.ITEM
Currency key of the ledger currency
  • Client
  • Currency key of the ledger currency
  • P_CC_JOURNALENTRYFACT.MANDT == TCURC.MANDT
  • P_CC_JOURNALENTRYFACT.RKCUR == TCURC.WAERS
Ledger
  • Ledger
  • Client
  • P_CC_JOURNALENTRYFACT.RLDNR == T881.RLDNR
  • P_CC_JOURNALENTRYFACT.MANDT == T881.MANDT
Original company code
  • Original company code
  • Client
  • P_CC_JOURNALENTRYFACT.ROBUKRS == T001.BUKRS
  • P_CC_JOURNALENTRYFACT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_CC_JOURNALENTRYFACT.MANDT == TCURC.MANDT
  • P_CC_JOURNALENTRYFACT.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_CC_JOURNALENTRYFACT.RUNIT == T006.MSEHI
  • P_CC_JOURNALENTRYFACT.MANDT == T006.MANDT
Version
  • Ledger
  • Version
  • Client
  • P_CC_JOURNALENTRYFACT.RLDNR == T894.RLDNR
  • P_CC_JOURNALENTRYFACT.RVERS == T894.RVERS
  • P_CC_JOURNALENTRYFACT.MANDT == T894.MANDT
Subitem Category
  • Client
  • Subitem Category
  • P_CC_JOURNALENTRYFACT.MANDT == TF110.MANDT
  • P_CC_JOURNALENTRYFACT.SITYP == TF110.SITYP
Subitem
  • Client
  • Subitem
  • Subitem Category
  • P_CC_JOURNALENTRYFACT.MANDT == TF115.MANDT
  • P_CC_JOURNALENTRYFACT.SUBIT == TF115.SITEM
  • P_CC_JOURNALENTRYFACT.SITYP == TF115.SITYP
User Name
  • Client
  • User Name
  • P_CC_JOURNALENTRYFACT.MANDT == USR02.MANDT
  • P_CC_JOURNALENTRYFACT.USNAM == USR02.BNAME