SAPFree referencePDF, Excel, Word exportSAP ECC / S/4HANA

SAP Controlling (CO) Database Tables List

When a controller asks why a cost center number differs between two reports, the answer is usually in the tables. This reference lists the main SAP CO, product costing and valuation tables with a plain description of what each holds.

Download:

Table	Description	Area	Typical use
TKA01	Controlling areas	Master data	Defines the CO area and its currency.
TKA02	Controlling area assignment to company code	Master data	Links company codes to a CO area.
CSKS	Cost center master data	Cost centers	Cost center, validity dates, hierarchy area.
CSKT	Cost center texts	Cost centers	Join to CSKS for names.
CSLA	Activity type master data	Cost centers	Activity types such as machine or labor hours.
CSSL	Cost center and activity type combinations	Cost centers	Where activity prices are tied to a cost center.
CSKA	Cost element master data (chart of accounts level)	Cost elements	Cost element categories.
CSKB	Cost elements data dependent on controlling area	Cost elements	Cost element type per CO area.
CSKU	Cost element texts	Cost elements	Names for cost elements.
CEPC	Profit center master data	Master data	Profit center and segment.
AUFK	Order master data	Orders	Internal orders and production orders share this header.
AFKO	Order header data for PP orders	Production orders	Planned dates, BOM and routing links.
AFPO	Order item	Production orders	Material, planned quantity.
AFRU	Order completion confirmations	Production orders	Confirmed yield, scrap and hours.
RESB	Reservation and dependent requirements	Production orders	Component requirements and issued quantities.
COBK	CO object: document header	Actual postings	One row per CO document.
COEP	CO object: line items by period	Actual postings	Line-level postings to cost objects.
COSP	CO object: cost totals for external postings	Actual postings	Period totals for primary costs.
COSS	CO object: cost totals for internal postings	Actual postings	Period totals for allocations and secondary costs.
COBRA	Settlement rule for order settlement	Settlement	Where order costs are settled.
COBRB	Distribution rules for settlement rule by object number	Settlement	Receivers and percentages.
PRPS	WBS (Work Breakdown Structure) element master data	Projects	Project cost object.
PROJ	Project definition	Projects	Header for WBS structures.
KEKO	Product costing header	Product costing	One cost estimate per material, plant, version and costing variant.
KEPH	Product cost estimate cost components	Product costing	Cost split by cost component.
MBEW	Material valuation	Valuation	Price control, standard price, moving average price.
MARC	Plant data for material	Valuation	Procurement type, MRP data.
T001W	Plants and branches	Organization	Plant master.
T001K	Valuation area	Organization	Links valuation area to company code.
CKMLHD	Material Ledger header	Material Ledger	Material Ledger document anchor per material and valuation area.
CKMLPP	Material Ledger period totals, quantities	Material Ledger	Period quantity data.
CKMLCR	Material Ledger currency and valuation views	Material Ledger	Period prices and values by currency type.
CRHD	Work center header	Work centers	Work center id, plant, category.
CRCO	Assignment of work center to cost center	Work centers	Links work center activities to cost centers.
PLKO	Task list header	Routing	Routing header.
PLPO	Task list operation	Routing	Standard values per operation.
MAST	Material to BOM link	BOM	Finds the BOM number for a material.
STKO	BOM header	BOM	BOM status and base quantity.
STPO	BOM item	BOM	Component and quantity.
ACDOCA	Universal Journal entry line items (S/4HANA)	S/4HANA	Holds FI and CO line items together.

In S/4HANA, many classic CO totals tables such as COSP and COSS are replaced by compatibility views over ACDOCA. Verify table availability in SE11 on your release.

SAP CO reporting without ABAP

An optional conversation on read-only, natural-language reporting over your SAP controlling data.

Optional. The tool and every export work without this. No spam.

How to use the list

Search by table name or keyword. Each row shows the area, so you can filter to cost centers, production orders, product costing or Material Ledger. The typical-use column tells you why you would open the table in SE16N or SE11. Export to Excel to share with developers building custom reports.

Search a table such as COEP to see its description
Filter by area to see all product costing tables
Export for your documentation set

How the tables connect

A cost center in CSKS is posted to through CO documents: COBK holds the header, COEP the lines, and COSP and COSS the period totals. Production orders start in AUFK with AFKO and AFPO, pull component demand from RESB, and settle through COBRA and COBRB. Product costing writes headers to KEKO and component splits to KEPH, while MBEW stores the resulting standard price or moving average price on the material.

S/4HANA differences

From S/4HANA, the Universal Journal ACDOCA stores finance and controlling line items in one table, and several older CO tables are accessible only through compatibility views. Custom reports that read COEP or COSP directly may still work through those views, but new development should read ACDOCA or the released CDS views. Always confirm in your own system because behavior depends on release.

Common mistakes

Developers often read COSP and COSS separately and forget that COEP holds the line detail with a different period structure. Another mistake is joining KEKO to MBEW without matching the costing variant and version. When pulling cost center names, remember CSKT is language dependent and CSKS is time dependent, so filter on validity date.

Filter CSKS on the validity date
Match costing variant and version in KEKO
Include language key when joining text tables

Frequently Asked Questions

Which table holds SAP cost center master data?

CSKS holds cost center master data with validity dates, and CSKT holds the language-dependent names. Hierarchy relationships come from the standard hierarchy tables. Always filter CSKS by validity date because a cost center can have several time slices.

What is the difference between COSP and COSS?

COSP holds totals for external postings, which are primary costs posted from financial accounting or materials. COSS holds totals for internal postings such as allocations and activity allocations. Together they give period totals by cost object and cost element.

Where is the standard price of a material stored?

In MBEW. The VPRSV field shows the price control, S for standard or V for moving average. STPRS holds the standard price, VERPR the moving average price, and PEINH the price unit.

Does ACDOCA replace the old CO tables?

In S/4HANA, ACDOCA is the single line-item source for FI and CO, and older tables such as COEP are provided as compatibility views. Behavior depends on your release, so verify in the data dictionary before writing new reports.

If you need natural-language answers over SAP CO data without writing joins by hand, Netray can set up a read-only assistant on your own infrastructure.

Talk to an Expert Explore More Free Tools

Related Tools

SAP

More SAP tools

See all

Back to All Tools