The SAP table dictionary

Eleven load-bearing tables, documented: the universal journal, the masters, and the documents. Each page carries key fields and everything that reads it.

The SAP tables documented here are the load-bearing few: the universal journal and the master and document tables the finance pages read. Each page carries key fields, what the table consolidated, and which reports and CDS views sit above it.

Table	What it is
ACDOCA
ANLA	The asset master, every asset’s identity: number, class, description, and capitalization date. In S/4HANA the asset values moved i
AUFK	The order master, one record per internal order. An internal order is a short-lived cost collector: a campaign, an event, a mainte
BKPF	The header of every accounting document, one header, many lines. In S/4HANA the line items moved into ACDOCA, but the header stays
BSEG	The accounting document line items, the entry view of a financial document. In S/4HANA, BSEG still exists as a real table, but it
BSET	The tax line-item table, one summarized tax line per document, per tax code: the base, the tax amount, and whether it is output ta
CEPC	The profit center master, one record per profit center, per validity period. It carries the controlling area, company code, the se
CSKS	The cost center master, one record per cost center, per validity period. It carries the controlling area, company code, the profit
SKAT	The G/L account descriptions, the names behind every account number. SKAT is the text table for SKA1: one row per account, per lan
T007A	The tax-code Customizing table, it registers each tax code per tax procedure and its type, input or output. The percentage rate it
WITH_ITEM	The withholding-tax line-item table, one row per withholding type per FI line: the base, the withholding code, and the amount with

Use case

Problem

The SAP table pages existed but their crumb pointed at a directory with no index; entry was by search only.

What we build

The hub listing every documented SAP table with its role, linking each page with key fields and the layers above it.

What you get

A front door for the SAP dictionary layer, two clicks from any table to its keys and readers.

Working against these tables in your own warehouse?

We build the owned SAP layer these pages describe.

Talk to us

Terms on this page

SAP S/4HANA: The source system whose tables this dictionary documents.
CDS view: A released, supported read surface over the tables; its own hub is linked above.
universal journal: The single line-item table modern SAP accounting posts to.