SAP S/4HANA Table Reference — Tables I Actually Query, by Topic

SAP tables I actually queried while building custom reports and running end-to-end tests on an S/4HANA sandbox, grouped by topic. Updated continuously as development goes on.

Each table: Table / Description / Key fields / T-codes / Used in our custom reports. Last updated: 2026-08-13

1. CO — Allocation Cycles (Assessment / Distribution)

Table Description Key fields T-codes Used in our reports
T811C Allocation cycle header
※ Distribution = ALART 'V', assessment = ALART 'U'. Classic CO-OM uses TAB='CCSS'		 TAB / CYCLE / SDATE KSU3, KSV3 ZCO0040 (allocation cycle report), ZCO0041 (distribution cycle detail)
T811S Cycle segments
※ SRULE (sender rule) / RRULE (receiver rule) / SPERCENT / RCDATA (variable portion type) / NEGTEST (negative tracing factors — stored value differs from the screen code)		 TAB / CYCLE / SDATE / SEQNR KSU3, KSV3 ZCO0040, ZCO0041
T811K Selection criteria per segment
※ SETKIND: 0=cycle, 1=sender control, 2=sender, 3=receiver, 4=receiver control (allocation base). Groups in SETID; single values/ranges in VALMIN~VALMAX		 TAB / CYCLE / SDATE / SEQNR / SETKIND / POS KSU3, KSV3 ZCO0040, ZCO0041
T811L Cycle / segment texts
※ SEQNR '0000' = cycle text; any other value = segment text		 LANGU / TAB / CYCLE / SDATE / SEQNR KSU3, KSV3 ZCO0040, ZCO0041
T811F Tracing factors / weighting factors per receiver
※ SRFLAG 'R' = portion/%, 'W' = weighting factor. Default 100 is not stored. ELEMENT1 = receiver, VALUE = value		 TAB / CYCLE / SDATE / SEQNR / SRFLAG / FPOS KSV1 (tab) ZCO0041
T811M Allocation data field texts
※ Names of variable portion types (RCDATA codes SMEI/WKGI, ...)		 LANGU / TAB / FNAME - ZCO0041
SETHEADER(T) Set (group) header / names
※ The same group name can exist multiple times with different class/subclass — query by the full SETID to be exact		 SETCLASS / SUBCLASS / SETNAME (+LANGU) GS03, KAH3, KSH3 ZCO0041

2. CO — Master Data / CO-PA

Table Description Key fields T-codes Used in our reports
CSKS Cost center master KOKRS / KOSTL / DATBI KS03 ZCO0041 (range expansion)
CSKT Cost center names SPRAS / KOKRS / KOSTL / DATBI KS03 ZCO0041
CSKB Cost element master KOKRS / KSTAR / DATBI KA03 ZCO0041 (range expansion)
CSLT Activity type names SPRAS / KOKRS / LSTAR / DATBI KL03 ZCO0020 (standard cost vs actual), ZCO0041
TKT03 Statistical key figure (SKF) names SPRAS / KOKRS / STAGR KK03 ZCO0041
TKA01 / TKA02 Controlling area / company code assignment
※ Used to derive company code → KOKRS → operating concern (ERKRS)		 KOKRS / BUKRS OKKP ZCO0030 (CO-PA line items)
CE1xxxx CO-PA line items (costing-based)
※ One table per operating concern (CE1OC10, CE1JNC2). A PALEDGER='01' filter is mandatory (otherwise every line doubles)		 PALEDGER / VRGAR / PERIO / BELNR ... KE24 ZCO0030

3. Product Costing / FI

Table Description Key fields T-codes Used in our reports
KEKO Product cost estimate header
※ Standard cost = KALKA='01', FREIG='X' (released), latest KADKY		 BZOBJ / KALNR / KALKA / TVERS ... CK13N ZCO0020
CKIS Cost estimate itemization
※ TYPPS: M = material, E = activity, I = other (e.g. subcontracting purchase price)		 KALNR family + POSNR CK13N ZCO0020
MBEW Material valuation
※ Price control S = standard / V = moving average		 MATNR / BWKEY MM03 (Accounting view) ZCO0020
MAST / STKO / STPO BOM link / header / items MATNR / WERKS / STLNR CS03 ZMM0010 (material list), ZCO0020 (subcontracting BOM explosion)
ACDOCA Universal Journal (actual line items)
※ RLDNR='0L'. Activity allocations to production orders and subcontracting fees (KTOSL='FRL') are aggregated here too		 RCLNT / RLDNR / RBUKRS / GJAHR / BELNR / DOCLN FB03 etc. ZFI0030 (P&L tree), ZFI0031 (BS tree), ZCO0020, ZCO0030
BKPF / BSEG Accounting document header / lines
※ BSEG-KTOSL (account determination key), AWTYP/AWKEY (source document)		 BUKRS / BELNR / GJAHR (+BUZEI) FB03 ZFI0040 (G/L line items)
BSIS_VIEW / BSAS_VIEW G/L open / cleared items (compatibility views)
※ In S/4HANA, referencing BSIS/BSAS directly is a syntax error — use the compatibility views. Anchor TABLES/SELECT-OPTIONS on SKB1/BKPF instead		 BUKRS / HKONT / ... FBL3N ZFI0040
SKA1 / SKB1 / SKAT G/L account master / company-code segment / names KTOPL·SAKNR / BUKRS·SAKNR FS00 ZFI0010, ZFI0020, ZFI0040, ZCO0041
RFDT FSV (financial statement version) cluster
※ A direct SELECT on T011P/Q returns nothing — read via FMs FI_IMPORT_BALANCE_SHEET_POS/TEXT		 RELID / SRTFD OB58, F.01 ZFI0030, ZFI0031
TFKBT Functional area names SPRAS / FKBER OKBD ZFI0030

4. MM — Purchasing / Inventory

Table Description Key fields T-codes Used in our reports
MARA / MAKT / MARD Material master / names / storage location stock
※ MARD: LABST (unrestricted) / INSME (in QI) / SPEME (blocked) / UMLME (in transfer) / RETME (returns)		 MATNR (+WERKS/LGORT) MM03, MB52 ZMM0010, ZMM0020, ZMM0060 (negative stock)
MKPF / MSEG Material document header / lines
※ Movement types 101/102 (GR), 261/262 (issue to order), 543/544 (subcontracting components)		 MBLNR / MJAHR (+ZEILE) MB51, MIGO ZMM0040, ZCO0020
EKKO / EKPO Purchase order header / items EBELN (+EBELP) ME23N, ME2M ZMM0030
EKBE Purchase order history
※ VGABE '2' = invoice receipt — not the same thing as EREKZ (final invoice flag)		 EBELN / EBELP / ZEKKN / VGABE ... ME23N (history tab) ZMM0030
EBAN / EBKN Purchase requisition / account assignment BANFN (+BNFPO) ME53N, ME5A ZMM0050
EINA Purchasing info record INFNR ME1M ZMM0010
LFA1 Vendor general master LIFNR BP ZMM0030, ZMM0050

5. SD / PP / BP

Table Description Key fields T-codes Used in our reports
VBAK / VBAP Sales order header / items
※ S/4HANA removed VBUK/VBUP — read status directly from VBAP-LFSTA/FKSAA/GBSTA		 VBELN (+POSNR) VA03, VA05 ZSD0010 (sales order list)
KNA1 Customer general master KUNNR BP ZSD0010
AUFK / AFKO Order header / PP order detail
※ AUFK-KTEXT (order name), AFKO-PLNBEZ (material). ZCO0041 uses it for receiver order names		 AUFNR CO03, KO03 ZPP0010, ZCO0020, ZCO0041
MKAL / MAPL Production versions / routing assignment MATNR / WERKS C223, CA03 ZMM0010
BUT000 Business partner general data
※ Name fields differ by TYPE: 1=person / 2=organization / 3=group		 PARTNER BP ZBP0010 (BP list)
CVI_CUST_LINK / CVI_VEND_LINK BP ↔ customer / vendor links
※ The path from BP to KNB1 (customer company code) / LFB1 (vendor company code)		 PARTNER_GUID BP ZBP0010

6. Misc — DDIC / System / Custom Tables

Table Description Key fields T-codes Used in our reports
TSTC / TSTCT Transaction codes / names
※ TSTCP holds the PARAM of parameter transactions (e.g. SM30 views)		 TCODE (+SPRSL) SE93 ZJNC0010 (program catalog), ZJNC launchpad family
DD02T / DD03L / DD07T Table names / fields / domain fixed-value texts
※ Domain texts explain codes such as SRULE/RRULE/NEGTEST in the reports		 TABNAME / FIELDNAME / DOMNAME SE11 ZCO0040, ZCO0041, ...
T001 / T001W Company codes / plants BUKRS / WERKS OX02, OX10 shared by most reports
ZJNCT0010~0050 Personal program registries (custom)
※ Maintained via SM30 (ZJNC0050V, ...); parallel tables with identical structure		 CLIENT / PROGNAME / TCODE ZJNC0010, ZJNC0020~0050 ZJNC launchpad family
Where these documents come from
Everything on this blog comes from one small dumpling factory built end-to-end in an S/4HANA sandbox — one plant, one product, one month, every document number real. The whole build is written up in two books.
· Free 16-page sample — the opening chapters, no email required
· How Sarah Joined a K-Dumpling Company and Became an SAP Genius — the business novel, 53 pages, $25
· The Dumpling Factory: Building a Complete SAP S/4HANA Company from Scratch — the build manual, 85 pages, $50

Comments

Post a Comment

Popular posts from this blog

Modern ABAP Syntax Notes — Patterns and Pitfalls from Real Development

ABAP syntax actually used while developing our custom Z reports, organized by topic. Examples come from working sources, together with the pitfalls we actually hit. Structure: syntax item → explanation → example code. Last updated: 2026-08-13 1. Data Declarations and Types ▷ Inline declarations DATA(...) / @DATA(...) — Declare and assign in one statement. SELECT result tables land directly in @DATA(lt_...) — the structure is derived from the SELECT list SELECT matnr, maktx FROM makt INTO TABLE @DATA(lt_makt) WHERE spras = @sy-langu. DATA(lv_qty) = ls_stpo-menge * iv_losgr / lv_bmeng. LOOP AT lt_mat INTO DATA(ls_mat). " loop variable inline too ENDLOOP. ▷ FIELD-SYMBOLS / ASSIGNING — Modify internal table rows in place without copying. ASSIGN COMPONENT lets you pick the column name at runtime (used for dynamic logic such as auto-hiding empty columns) LOOP AT gt_list ASSIGNING FIELD-SYMBOL(<ls_list>) WHERE typps = 'M'. <ls_list...
Read more

A 36% margin became 6% at month-end, and every posting was correct

On the day we shipped, the billing document said the margin was 36% . Three weeks later, after the close, the same sale carried a margin of 6% . Nobody made a mistake. No posting was reversed. Every document in between was correct. This is the part of SAP that spreadsheets never prepare you for, so it is worth walking through with real numbers. Everything below comes from a small dumpling factory I built from an empty S/4HANA client and drove through one complete business month. 1. The sale looked great A sales order for 20,000 KRW of dumplings, delivered and billed: Step Transaction Effect Sales order VA01 Revenue 20,000 · standard cost of goods 12,800 → expected margin 7,200 (36%) Goods issue VL01N → PGI Cost of goods sold hits the P&L for the first time — at standard Billing VF01 Revenue 20,000, receivable 22,000 (incl. tax) If you stop reading the system here — and a lot of people do, because t...
Read more