I_CompactJournal

Compact Journal | view: IFICMPTJRNL | TRAN | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
GLDebitAmountInCoCodeCrcy G/L Account - Debit Amount in Company Code Currency
AssetDebitAmtInCoCodeCrcy Asset - Debit Amount in Company Code Currency
MaterialDebitAmtInCoCodeCrcy Material - Debit Amount in Company Code Currency
DebtorDebitAmtInCoCodeCrcy Customer - Debit Amount in Company Code Currency
CreditorDebitAmtInCoCodeCrcy Supplier - Debit Amount in Company Code Currency
GLCreditAmountInCoCodeCrcy G/L Account - Credit Amount in Company Code Currency
AssetCreditAmtInCoCodeCrcy Asset - Credit Amount in Company Code Currency
MaterialCreditAmtInCoCodeCrcy Material - Credit Amount in Company Code Currency
DebtorCreditAmtInCoCodeCrcy Customer - Credit Amount in Company Code Currency
CreditorCreditAmtInCoCodeCrcy Supplier - Credit Amount in Company Code Currency
💲 Functional Currency (FunctionalCurrency):
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
DebitAmountInFreeDefinedCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDefinedCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
DebitAmountInFreeDefinedCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDefinedCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
DebitAmountInFreeDefinedCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDefinedCrcy3 Credit Amount in Free Defined Currency 3
Column Name Description
Column Name Description
PostingDate Posting Date
CreationDate Creation Date
DocumentDate Journal Entry Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
FiscalPeriod Fiscal Period POPER
GLAccountName G/L Account Short Text TEXT20
AccountingDocumentItem Journal Entry Posting View Item BUZEI
DocumentItemText Item Text TEXT50
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LedgerFiscalYear Ledger Fiscal Year GJAHR
SegmentName Segment Name TEXT50
AccountingDocumentTypeName Document Type Name TEXT20
TransactionTypeDetermination Transaction Key CHAR3
WBSElement WBS Element FIS_WBS
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_COMPACTJOURNAL.MANDT == T003.MANDT
  • I_COMPACTJOURNAL.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • ?
  • Client
  • Alternative G/L Account Number In Company Code
  • I_COMPACTJOURNAL.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_COMPACTJOURNAL.MANDT == SKA1.MANDT
  • I_COMPACTJOURNAL.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • I_COMPACTJOURNAL.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_COMPACTJOURNAL.MANDT == T006.MANDT
  • I_COMPACTJOURNAL.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • I_COMPACTJOURNAL.MANDT == TGSB.MANDT
  • I_COMPACTJOURNAL.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_COMPACTJOURNAL.MANDT == T004.MANDT
  • I_COMPACTJOURNAL.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_COMPACTJOURNAL.COMPANYCODE == T001.BUKRS
  • I_COMPACTJOURNAL.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_COMPACTJOURNAL.COMPANYCODECURRENCY == TCURC.WAERS
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_COMPACTJOURNAL.MANDT == TKA01.MANDT
  • I_COMPACTJOURNAL.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Cost Center
  • Client
  • Controlling Area
  • I_COMPACTJOURNAL.[column in domain "DATBI"] == CSKS.DATBI
  • I_COMPACTJOURNAL.COSTCENTER == CSKS.KOSTL
  • I_COMPACTJOURNAL.MANDT == CSKS.MANDT
  • I_COMPACTJOURNAL.CONTROLLINGAREA == CSKS.KOKRS
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_COMPACTJOURNAL.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_COMPACTJOURNAL.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_COMPACTJOURNAL.FISCALYEARVARIANT == T009.PERIV
  • I_COMPACTJOURNAL.MANDT == T009.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
  • I_COMPACTJOURNAL.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
  • I_COMPACTJOURNAL.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
  • I_COMPACTJOURNAL.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • I_COMPACTJOURNAL.MANDT == TFKB.MANDT
  • I_COMPACTJOURNAL.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
  • I_COMPACTJOURNAL.FUNCTIONALCURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_COMPACTJOURNAL.COMPANYCODE == SKB1.BUKRS
  • I_COMPACTJOURNAL.MANDT == SKB1.MANDT
  • I_COMPACTJOURNAL.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Posting Key
  • Client
  • Posting Key
  • I_COMPACTJOURNAL.MANDT == TBSL.MANDT
  • I_COMPACTJOURNAL.POSTINGKEY == TBSL.BSCHL
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • I_COMPACTJOURNAL.[column in domain "DATBI"] == CEPC.DATBI
  • I_COMPACTJOURNAL.PROFITCENTER == CEPC.PRCTR
  • I_COMPACTJOURNAL.MANDT == CEPC.MANDT
  • I_COMPACTJOURNAL.CONTROLLINGAREA == CEPC.KOKRS
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • I_COMPACTJOURNAL.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_COMPACTJOURNAL.SPECIALGLCODE == T074U.UMSKZ
  • I_COMPACTJOURNAL.MANDT == T074U.MANDT
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • I_COMPACTJOURNAL.MANDT == T007A.MANDT
  • I_COMPACTJOURNAL.[column in domain "KALSM_D"] == T007A.KALSM
  • I_COMPACTJOURNAL.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • I_COMPACTJOURNAL.MANDT == TCURC.MANDT
  • I_COMPACTJOURNAL.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Valuation area
  • Client
  • I_COMPACTJOURNAL.VALUATIONAREA == T001K.BWKEY
  • I_COMPACTJOURNAL.MANDT == T001K.MANDT