Top Table - list SAP © General Ledger Module FI-GL
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11
Masterdata
| Table | Table - name | S/4HANA -Table and general Notes | SKA1 | G/L Account Master (Chart of Accounts) | Field XSPEB GL Account Blocked for Posting. Field XBILK whether Balance Sheet- or Profit & Loss-Account. S/4: New Field "Type of a General Ledger Account" (GLACCOUNT_TYPE) for Cost Element Definition. Edit with transaction OB13. In Logical Database BRF GLU3 SDF. | SKAT | G/L Account Master Record (Chart of Accounts: Description) | SKB1 | G/L account master (company code) | Field XSPEB GL Account Blocked for Posting. In Logical Database BRF GLU3 SDF. |
Transactional Data
| Table | Table - name | S/4HANA -Table and general Notes | BKPF | Accounting Document Header | In Logical Database BMM BRF BRM DDF KDF SDF. | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | BSEG | Accounting Document Segment | In Logical Database BMM BRF BRM DDF KDF SDF. | BSET | Tax Data Document Segment | In Logical Database BRF BRM. | BSIM | Secondary Index, Documents for Material | BSIS | Accounting: Secondary Index for G/L Accounts | For open items migration G/L Accounts. In Logical Database SDF. | GLT0 | G/L account master record transaction figures | In Logical Database GLG. | VBKPF | Document Header for Document Parking | VBSEGS | Document Segment for Document Parking - G/L Account Database | WITH_ITEM | Witholding tax info per W/tax type and FI line item |
Additional tables for Transactional Data in New General Ledger
| Table | Table - name | S/4HANA -Table and general Notes | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | When the document is not relevant for the leading ledger. | FAGLFLEXA | General Ledger: Items | FAGLFLEXP | General Ledger: Plan Line Items | FAGLFLEXT | General Ledger: Totals |
New Finance tables in S/4 for Transactional Data
| Table | Table - name | S/4HANA -Table and general Notes | ACDOCA | Universal Journal Entry Line Items | OSS-Note 3128916 - FI documents has 999 limit of line item in S/4 HANA ? | ACDOCC | Consolidation Journal | ACDOCP | Plan Data Line Items |
Taxes
| Table | Table - name | S/4HANA -Table and general Notes | T007A | Tax Keys | T007B | Tax Processing in Accounting | T007S | Tax Code Names | T007V | Tax Codes to be Transported | T030K | Tax Accounts Determination | T059A | Type of Recipient For Vendors | T059B | Withholding Tax Classes for Vendors: Names | T059C | Types of Recipient: Vendors per Withholding Tax Type | T059E | Income Types | T059F | Formulas for Calculating Withholding Tax | T059G | Income Types: Names | T059K | Withholding tax code and processing key | T059P | Withholding tax types | T059Z | Withholding tax code (enhanced functions) | WITH_ITEM | Witholding tax info per W/tax type and FI line item |
Accrual Management
| Table | Table - name | S/4HANA -Table and general Notes | ACESOBJ | Accrual Subobject | ACESOBJ_ITEM | Item Data for Accrual Subobject | ACESOBJ_ITEM_PER | Period data of Accrual Item | Transactional Data. |
Periodic Processing
| Table | Table - name | S/4HANA -Table and general Notes | T001B | Permitted Posting Periods | Edit with transaction OB52. |
Enterprise Structure Part of the Customizing. To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
| Table | Table - name | S/4HANA -Table and general Notes | FAGL_SEGM | Master Data for Segments | FM01 | Financial Management Areas | T001 | Company Codes | Edit with transaction OBY6 and OBCL. | T004 | Directory of Charts of Accounts | Edit with transaction OB13. | T014 | Credit control areas | T880 | Global Company Data (for KONS Ledger) | T881 | Ledger Master | TFKB | Functional areas | Text and Translations are in table TFKBT. | TGSB | Business Areas | TGSBK | Consolidation business areas | TKA02 | Controlling area assignment | Assigment Company Code to Controlling area. Edit with transaction OX19. |
FI account determination for the various modules Part of the Customizing. To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
| Table | Table - name | S/4HANA -Table and general Notes | C001 | Cust.Grp/MaterialGrp/AcctKey | FI-Accounting determination in SD for invoices Edit with transaction VKOA. | T030 | Standard Accounts Table | FI-Accounting determination in MM. Edit with transaction OBYC or OMWB. | T030K | Tax Accounts Determination | T030S | Accts for Foreign Currency Assets Exchange Rate Difference | T030U | Account Determ.for Balance Sheet Transfer Postings | T074 | Special G/L Accounts | Edit with transaction OBXR. | T095 | Balance sheet accounts for depreciation areas | FI-Accounting determination in FI-AA for the Balance sheet. | T095B | G/L accounts value adjustment | FI-Accounting determination in FI-AA for value adjustment. | TIVEXFIREPSYMB | Replacement of Account Symbol with FI Account | FI-Accounting determination in RE-FX. Evaluate with transaction REISCEACCDET. | TIVSCTRANSACC | Assignment of Clearing Account to Cost Account |
Customizing - Tables To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
| Table | Table - name | S/4HANA -Table and general Notes | NRIV | Number Range Intervals | Edit with transaction SNUM. For FI documents the object name = 'RF_Beleg', value subobject is the company code. Maintain FI-number intervals directly via transaction FBN1. | T003 | Document Types for Finance | In table T003 is the number of the number range. Edit with transaction OBA7. | T009 | Fiscal Year Variants | T077S | G/L account groups | T077Z | Account Group Names (Table T077S) |
Report a missing table or a suggestion for improvement here...
Additional tables for the following modules at Erp-Top.com:
Financial Accounting Module FI Accounts Receivable Module FI-AR Accounts Payable Module FI-AP Banks Module FI-BL Fixed Assets Module FI-AA Controlling Module CO Cost Element Accounting Module CO-OM-CEL Cost Center Accounting Module CO-OM-CCA Internal Orders Module CO-OM-OPA Product Cost Controlling Module CO-PC Profitcenter Module EC-PCA Flexible Real Estate Management Module RE-FX Lease Management RE-FX-LA Sales and Distribution Module SD Materials Management Module MM Purchasing Module MM-PUR Quality-Management Module QM Plant Maintenance Module PM Production Planning and Manufacturing Module PP Production Planning Process Industries Module PP-PI Project System Module PS Personnel Management Module PA for ABAP for the Basis and Administrators Cross Module Business Partner BP, Module AP-MD-BP Top Transaction - list SAP © General Ledger Module FI-GL
Masterdata
| Transaction | Transaction - Name | Notes | FS00 | G/L acct master record maintenance | FSP0 | G/L acct master record in chrt/accts |
Periodic Processing
| Transaction | Transaction - Name | Notes | F-51 | Post with Clearing | F.13 | Automatic Clearing without Currency |
Customizing - Transactions
| Transaction | Transaction - Name | Notes | FBN1 | Accounting Document Number Ranges | O7F1 | Clearing field selection conditions | OB13 | C FI Maintain Table T004 | Change the lenght of GL account number up to 10 digit max | OBA7 | C FI maintain table T003 | Document Types for Finance | OBCL | FI Table Maint. T001 (MWSKV+MWSKA) | OBXR | C FI Table T074 | OBY6 | C FI Maintain Table T001 | Company Code Data | OBYA | C FI Table T030 vrb+buv | Clearing accounts for cross-company code postings | OX19 | Controlling Area: Assgn. to CCode | OXK3 | Coding Block: Maintain CustomerField | Customer-Defined Account Assignments |
Configuring SAP S/4HANA Finance
Financial Accounting (FI) with SAP S/4HANA: Business User Guide
Central Finance and SAP S/4HANA
Implementing SAP S/4HANA Finance
Migrating to SAP S/4HANA
SAP S/4HANA Embedded Analytics
SAP Analytics Cloud
SAP Activate