C_JrnlEntrItmPriorFsclPerd

Jrnl Entr Item Postd Prior Fiscal Period | view: CFIJEPREVPERIOD | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, BKPF, T001, TKA02, TKA01, T000, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, FINSC_LEDGER_REP, FINSC_PERIOD
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
JournalEntry Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
Column Name Description
CreationDate Creation Date
PostingDate Posting Date
FiscalPeriodEndDate End Date of Fiscal Period
FiscalPeriodStartDate Start Date of Fiscal Period
DocumentDate Journal Entry Date
Column Name Description
IsSpecialPeriod Indicator: Is Special Period Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FullName Full Name of Person TEXT80
LedgerFiscalYear Ledger Fiscal Year GJAHR
CompanyCodeName Name of Company Code or Company TEXT25
ControllingAreaName Controlling Area Name TEXT25
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
AccountingDocumentHeaderText Document Header Text TEXT25
TransactionCode Transaction Code TCODE
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_JRNLENTRITMPRIORFSCLPERD.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == T003.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == TCURC.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == T004.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_JRNLENTRITMPRIORFSCLPERD.COMPANYCODE == T001.BUKRS
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == TCURC.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == TKA01.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == CSKS.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.COSTCENTER == CSKS.KOSTL
  • C_JRNLENTRITMPRIORFSCLPERD.[column in domain "DATBI"] == CSKS.DATBI
  • C_JRNLENTRITMPRIORFSCLPERD.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == KNA1.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.CUSTOMER == KNA1.KUNNR
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == T009.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.FISCALYEARVARIANT == T009.PERIV
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_JRNLENTRITMPRIORFSCLPERD.GLACCOUNT == SKB1.SAKNR
  • C_JRNLENTRITMPRIORFSCLPERD.COMPANYCODE == SKB1.BUKRS
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == TCURC.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • Client
  • Profit Center
  • ?
  • Controlling Area
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == CEPC.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.PROFITCENTER == CEPC.PRCTR
  • C_JRNLENTRITMPRIORFSCLPERD.[column in domain "DATBI"] == CEPC.DATBI
  • C_JRNLENTRITMPRIORFSCLPERD.CONTROLLINGAREA == CEPC.KOKRS
Supplier
  • Client
  • Supplier
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == LFA1.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_JRNLENTRITMPRIORFSCLPERD.MANDT == TCURC.MANDT
  • C_JRNLENTRITMPRIORFSCLPERD.TRANSACTIONCURRENCY == TCURC.WAERS