Contents
Journal entry Transaction codes
Here is a list of transaction codes used to deal with Journal in SAP
- GC26 : FI-LC: Journal Entry Report
- GC27 : FI-LC: Customize Journal Entry Reprt
- O3UH_ARJE : A/R Journal Entry Generation
- OIUH_JE04 : Journal Entry Batch Control
- OIUH_JE05 : Manual Journal Entry
- CX58 : Journal Entry Report
- CX59 : Journal Entry Layouts
- CXDT_TF515 : Translation: Journal Entry Layouts
SAP Journal entry Tables
Here is a list of important tables storing Journal related data in SAP
- ECMCA : SAP Cons.: Journal Entry Table (Actual)
- FILCA : FI-LC: Actual journal entry table with 2 object tables
- J_3RFREGCUSEDI : VAT Invoice Journal: Entry Protection
- OIUHS_JE_ACC_ID : PRA: Journal Entry Posting Rules per Account Type
- OIUHS_JE_ACC_TYP : PRA: Journal Entry Posting Rules per Account Type
- OIUHS_JE_ACR : PRA: Journal Entry Account Categories
- OIUH_RV_APSL : Journal Entry Accounts Payable Subledger Table
- OIUH_RV_ARSL : Journal Entry Accounts Receivable Subledger Table
- OIUH_RV_EXSL : Journal Entry Expense Subledger Table
- OIUH_RV_GL : Journal Entry General Ledger Table
- OIUH_RV_GTAX : Journal Entry Gross Tax Amounts Table
- OIUH_RV_ICSL : Journal Entry Intercompany Subledger Table
- OIUH_RV_INSL : Journal Entry Income Subledger Table
- OIUH_RV_JE : Journal Entry
- OIUH_RV_LSSL : Journal Entry Legal Suspense Subledger Table
- OIUH_RV_MSSL : Journal Entry Miscellaneous Subledger Table
- OIUH_RV_ODED : Journal Entry Other Deductions Table
- OIUH_RV_OPSL : Journal Entry Owner Payable Subledger Table
- OIUH_RV_OTAX : Journal Entry Owner Tax Amounts Table
- OIUH_RV_RJE : Journal Entry
- OIUH_RV_STSL : Journal Entry Statistical Subledger Table
- OIUH_RV_TPSL : Journal Entry Taxes Payable Subledger Table
- OIUH_TEMP_GL : Journal Entry General Ledger Table
- OIUH_TEMP_OPSL : Journal Entry Owner Payable Subledger Table
- OIUPH_RV_RJE : Journal Entry (PDM Shadow)
- TF515 : Journal Entry Layout: Field Names
- TF516 : Journal Entry Layout: Description
- TF517 : Journal Entry Layout: Field Names
Table Data elements available for Journal entries
- GRRM_OB_ORX_JOURNAL_ENTRY_REF : ORX – Journal Entry Reference Number
- OIUH_JELINENO : Journal Entry Line Number
- OIUH_RECORD_TYPE : PRA Journal Entry Record Type (0=Control, 1= Line item)
- OIUH_JELINEST : Journal Entry Line Status
- OIU_LEASEFUEL : Lease fuel journal entry configuration options
- CJDOCSTAT : Cash Journal Entry Document Status
- FC_JEFRM : Journal entry layout
- FC_DEFLT : Use journal entry layout as default
- XBRCD_KK : Cash Desk/Cash Journal: Display Entry Field for Barcode