C_InactiveGLAcctJrnlEntry

Journals posted to inactive GLAccounts | view: CGRCINACTACJREN | Extraction: Not supported | Component: Information System
Tables used: ACDOCABKPF
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
JournalEntry Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Accounting Document Entry Date
PostingDate Posting Date
DocumentDate Journal Entry Date
LastChangeDate Last Change Date
LatestPostingDateBeforeKeyDate null
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
TransactionCode Transaction Code TCODE
ReverseDocument Reverse Document BELNR
DocumentReferenceID Document Reference ID XBLNR1
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == T003.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.CHARTOFACCOUNTS == T004.KTOPL
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.COMPANYCODE == T001.BUKRS
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == TCURC.MANDT
  • C_INACTIVEGLACCTJRNLENTRY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.CONTROLLINGAREA == TKA01.KOKRS
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.CONTROLLINGAREA == CSKS.KOKRS
  • C_INACTIVEGLACCTJRNLENTRY.COSTCENTER == CSKS.KOSTL
  • C_INACTIVEGLACCTJRNLENTRY.[column in domain "DATBI"] == CSKS.DATBI
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == CSKS.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.GLACCOUNT == SKB1.SAKNR
  • C_INACTIVEGLACCTJRNLENTRY.COMPANYCODE == SKB1.BUKRS
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == SKB1.MANDT
Ledger
  • Client
  • Ledger
Profit Center
  • Controlling Area
  • ?
  • Client
  • Profit Center
  • C_INACTIVEGLACCTJRNLENTRY.CONTROLLINGAREA == CEPC.KOKRS
  • C_INACTIVEGLACCTJRNLENTRY.[column in domain "DATBI"] == CEPC.DATBI
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == CEPC.MANDT
  • C_INACTIVEGLACCTJRNLENTRY.PROFITCENTER == CEPC.PRCTR
Reference Document Type C_INACTIVEGLACCTJRNLENTRY.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplier
  • Supplier
  • Client
  • C_INACTIVEGLACCTJRNLENTRY.SUPPLIER == LFA1.LIFNR
  • C_INACTIVEGLACCTJRNLENTRY.MANDT == LFA1.MANDT