SAP Tables – Financial Accounting & Controlling
Oct 18th, 2009 | By Ole | Category: SAP Tables & ViewsThe SAP FI Module has the capability of meeting all the accounting and financial needs of an organization. It is within this module that Financial Managers as well as other Managers within your business can review the financial position of the company in real time as compared to legacy systems which often times require overnight updates before financial statements can be generated and run for management review.
The SAP CO (Controlling) Module provides supporting information to Management for the purpose of planning, reporting, as well as monitoring the operations of their business. Management decision-making can be achieved with the level of information provided by this module.
We have chosen to divide the tables into the following groups. Please click on the group description to view each groups tables.
If you are interested in tables from other areas of SAP, we have chosen to divide the tables into the following groups. Please click on the group description to view each groups tables.
| AGKO | Cleared Accounts | - |
| ANAR | Asset Types | - |
| ANAT | Asset type text | - |
| ANAT | Asset type text | - |
| ANBZ | Help structure for asset line item | - |
| ANEK | Document Header Asset Posting | - |
| ANEK_KEY | ANEK Key Fields | - |
| ANEP | Asset Line Items | - |
| ANEP_KEY | ANEP Key Fields | - |
| ANEPI_VD | Asset Line Items (ANEP + ANEA + ANEK) | - |
| ANEPV | Asset Line Items (ANEP + ANEA + ANEK) | - |
| ANEV | Asset downpayment settlement | - |
| ANEV_KEY | ANEV Key Fields | - |
| ANKAZ | Asset class: extension for technical fields | - |
| ANKT | Asset classes: Description | - |
| ANLA | Asset Master Record Segment | - |
| ANLA_ERR | Assets with errors, including the errors | - |
| ANLA_KEY | ANLA Key | - |
| ANLATXT | Asset Text | - |
| ANLB | Depreciation terms | - |
| ANLC | Asset Value Fields | - |
| ANLE | Asset Origin by Line Item | - |
| ANLH | Main asset number | - |
| ANLI1 | Link table for capital investment measure -> AuC | - |
| ANLIX | Link table inv.measure -> AuC – Update flags | - |
| ANLK | Asset Origin by Cost Element | - |
| ANLK_KEY | Key fields of ANLK | - |
| ANLKX | IM substructure ANLK for summary settlement history values | - |
| ANPTX | Change document structure; generated by RSSCD000 | - |
| AT02A | Transaction Code for Menu TIMN | - |
| AT02T | Transaction Activity Category: Description | - |
| AT10 | Transaction type | - |
| AT10T | Name of Transaction Type | - |
| BKDF | Document Header Supplement for Recurring Entry | - |
| BKORM | Accounting Correspondence Requests | - |
| BKPF | Accounting Document Header | Accounting documents // indices |
| PAYR | Payment Medium File | Accounting documents |
| BVOR | Intercompany posting procedures | Accounting documents |
| BLPK | Document log header | - |
| BLPP | Document log item | - |
| BLPR | Document Log Index and Planned Order (Backflush) | - |
| BNKA | Bank master record | - |
| BP000 | Business Partner Master (General Data) | - |
| BPBK | Doc.Header | Controlling Object |
| BPEG | Line Item Overall Values | Controlling Object |
| BPEJ | Line Item Annual Values | Controlling Object |
| BPEP | Line Item Period Values | Controlling Object |
| BPGE | Totals Record for Total Value | Controlling Object |
| BPJA | Totals Record for Annual Total | Controlling Object |
| BSAD | Accounting: Secondary index for customers (cleared items) | Accounting documents // indices |
| BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | Accounting documents // indices |
| BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | Accounting documents // indices |
| BSEC | One-Time Account Data Document Segment | - |
| BSEG | Accounting Document Segment | Accounting documents // indices |
| BSET | Tax data document segment | - |
| BSID | Accounting: Secondary Index for Customers | Accounting documents // indices |
| BSIK | Accounting: Secondary Index for Vendors | Accounting documents // indices |
| BSIM | Secondary Index, Documents for Material | Accounting documents // indices |
| BSIP | Index for vendor validation of double documents | Accounting documents // indices |
| BSIS | Accounting: Secondary index for G/L accounts | Accounting documents // indices |
| CEPC | Profit Center Master Data Table | - |
| CEPCT | Texts for Profit Center Master Data | - |
| COBK | CO Object: Document header | Cost center accounting |
| COBRA | Settlement Rule for Order Settlement | - |
| COBRB | Distribution Rules Settlement Rule Order Settlement | - |
| COEJ | CO object: year-related line items | CO Object: Line Items (by Fiscal Year) |
| COEJL | CO Object: Line Items for Activity Types (by Fiscal Year) | - |
| COEP | CO Object: Line Items (by Period) | Cost center accounting |
| COEPB | CO Object: Line Items Variance/Period-based Results Analysis | - |
| COEPL | CO Object: Line Items for Activity Types (by Period) | - |
| COEPR | CO Object: Statistical Key Figure Line Items (by Period) | - |
| COKA | CO Object- Control Data for Cost Elements | - |
| COKP | CO Object: Control Data for Primary Planning | - |
| COSB | CO Object: Total Variances/Results Analyses | - |
| COSBD | CO Object: Total of variances/accruals, of which settled | - |
| COSL | CO Object: Activity Type Totals | - |
| COSP | CO Object: Cost Totals for External Postings | Cost center accounting |
| COSPD | CO Object: Settled Primary Cost Totals | - |
| COSS | CO Object- Cost Totals for Internal Postings | - |
| COST | CO Object: Price Totals | Cost center accounting |
| CSKA | Cost Elements (Data Dependent on Chart of Accounts) | - |
| CSKB | Cost Elements (Data Dependent on Controlling Area) | - |
| CSKS | Cost Center Master Data | Cost center master data |
| CSKT | Cost center texts | Cost center master data |
| CSLA | Activity master | - |
| CSLT | Activity type texts | - |
| CSSK | Cost center /cost element | - |
| CSSL | Cost Center/Activity Type | - |
| FEBEP | Electronic Bank Statement Line Items | - |
| FPLA | Billing Plan | - |
| FPLT | Billing Plan: Dates | - |
| GLIDXA | Index to Find FI-SL Documents Based on AWKEY | - |
| GLPCT | EC-PCA: Totals Table | - |
| GLT0 | G/L Account Master Record Monthly Debits and Credits | G/L account master record transaction figures |
| KALO | Costing objects | Costing Run: Costing Objects (KVMK) |
| KANZ | Sales order items – costing objects | Assignment of Sales Order Items – Costing Objects |
| KEKO | Product Costing – Header Data | - |
| KEPH | Cost components for cost of goods manuf. | - |
| KNA1 | General Data in Customer Master | Customers |
| KNAS | Customer master (VAT registration numbers general section) | Customers |
| KNB1 | Customer master (company code) | Customers |
| KNB4 | Customer payment history | Customers |
| KNB5 | Customer master (dunning data) | Customers |
| KNC3 | Customer master (special G/L transaction figures) | Customers |
| KNKA | Customer master credit management: Central data | Customers |
| KNKK | Customer master credit management: Control area data | Customers |
| KOMK | Pricing Communication Header | Communication Header for Pricing |
| LFA1 | Vendor Master (General Section) | - |
| LFBK | Vendor Master (Bank Details) | - |
| LFC1 | Vendor master (transaction figures) | - |
| MAHNV | Management Records for the Dunning Program | - |
| NBNK | Number range for banks | - |
| NKUK | Number range for change documents | - |
| PCEC | Prenumbered Checks | - |
| REGUA | Change of payment proposals: user and time | - |
| REGUH | Settlement data from payment program | - |
| REGUH | Settlement data from payment program | Payment run |
| REGUP | Processed items from payment program | - |
| REGUP | Processed items from payment program | Payment run |
| REGUS | Acounts blocked by payment proposal | - |
| REGUT | TemSe – Administration Data | - |
| REGUV | Control records for the payment program | - |
| SETLEAF | Group – child nodes | Values in Sets |
| SKA1 | G/L Account Master (Chart of Accounts) | - |
| SKA1 | G/L Account Master (Chart of Accounts) | - |
| SKAT | G/L Account Master Record (Chart of Accounts- Description) | - |
| SKAT | G/L Account Master Record (Chart of Accounts: Description) | - |
| SKB1 | G/L account master (company code) | - |
| SKB1 | G/L account master (company code) | - |
| T001 | Company Codes | - |
| T001B | Permitted Posting Periods | FI Documents |
| T001K | Assign plant (valuation area) to company code | - |
| T001W | Plant / sales organisation | Plants/Branches |
| T003 | Document Types | FI Documents |
| T003T | Document Type Texts | - |
| T004 | Chart of accounts | Directory of Charts of Accounts |
| T005 | Countries | - |
| T005S | Taxes: Region (Province) Key | - |
| T005U | Taxes: Region Key: Texts | - |
| T007A | Tax Keys | - |
| T007S | Tax Code Names | - |
| T009 | Fiscal Year Variants | Company code |
| T010O | Posting period variant | FI Documents |
| T010P | Posting Period Variant Names | FI Documents |
| T012 | House banks | FI Documents |
| T012 | House banks | - |
| T012T | House bank account names | - |
| T014 | Credit control area | - |
| T077S | Account group (g/l accounts) | G/L account groups |
| T087J | Text | - |
| T134 | Material Types | - |
| T179 | Materials: Product Hierarchies | - |
| T179T | Materials: Product hierarchies: Texts | - |
| T390 | PM: Shop papers for print control | - |
| T499S | Locations | - |
| T811D | Allocations: Document Numbers | - |
| T880 | Global Company Data (for KONS Ledger) | Definition |
| TAPRFT | Text tab. for investment profile | - |
| TBSL | Posting keys | - |
| TBSLT | Posting key names | - |
| TCURC | Currency codes | - |
| TCURF | Conversion Factors | - |
| TCURR | Currency exchange rates | - |
| TCURT | Currency code names | - |
| TCURV | Exchange rate types for currency translation | - |
| TGSB | Business Areas | - |
| TGSBT | Business area names | - |
| TINC | Customer incoterms | - |
| TJ02T | Status text | System status texts |
| TKA01 | Controlling Areas | - |
| TKA02 | Assign company code to controlling area | Controlling area assignment |
| TKA09 | Basic Settings for Versions | - |
| TKVS | CO Versions | - |
| TSPA | Organizational Unit: Sales Divisions | - |
| TVFK | Billing: Document Types | - |
| TZB0T | Flow types text table | - |
| TZPAT | Financial Assets Management product type texts | - |
| VBSEGS | Document Segment for G/L Accounts Document Parking | - |
| VTBFHA | Transaction | - |
| VTBFHAPO | Transaction Flow | - |
| VTBFHAZU | Transaction Activity | - |
| VTBFINKO | Transaction Condition | - |
| VTIDERI | Master Data Listed Options and Futures | - |
| VTIFHA | Underlying transaction | - |
| VTIFHAPO | Underlying transaction flows | - |
| VTIFHAZU | Underlying transaction status table | - |
| VTIOF | Options Additional Data | - |
| VWPANLA | Asset master for securities | - |
