Posts

Showing posts from August, 2026

SAP S/4HANA T-code List A to Z - Transactions Used in Our End-to-End Tests

Alphabetical list of the standard SAP transactions we actually used while running end-to-end tests (company codes CC10 / JNC2) on an S/4HANA sandbox - from master data through planning, standard costing, purchasing, production, sales and month-end CO allocation. Transaction titles come from the system (TSTCT); the notes describe what each one did in our scenario. Custom Z-transactions are excluded. Last updated: 2026-08-27 B T-code Title (TSTCT) What we used it for BP Maintain Business Partner Unified Business Partner maintenance (customer/vendor in one) - creates KNA1/LFA1/BUT000 C T-code Title (TSTCT) What we used it for C223 Maintain Production Versions Production version maintenance (MKAL) - links material, BOM and routing CA01 Create Routing Create routing CA02 Change Routing Change routing CA03 Display Routing Display routing CK11N Create Material Cost Estimate Create standard cost estimate - generates KEKO/CKIS itemization per costing...

SAP S/4HANA Table List A to Z — Standard Tables Used in Our End-to-End Tests

Alphabetical list of the standard SAP tables we actually touched while running end-to-end tests (company codes CC10 / JNC2) on an S/4HANA sandbox — master data, purchasing, production, sales, costing, allocation cycles and the data dictionary itself. Table descriptions and field texts come straight from the system DDIC (DD02T / DD03L / DD04T). Custom Z-tables are excluded. Last updated: 2026-08-27 A Table Description Key fields Important fields ACDOCA Universal Journal Entry Line Items RLDNR / RBUKRS / GJAHR / BELNR / DOCLN RLDNR (Ledger in General Ledger Accounting), RBUKRS (Company Code), RACCT (Account Number), RCNTR (Cost Center), RFAREA (Functional Area), BUDAT (Posting Date in the Document), BLART (Document Type), MATNR (Material Number), AUFNR (Order Number), KTOSL (Transaction Key), HSL (Amount in Company Code Currency), MSL (Quantity) AFKO Order Header Data PP Orders AUFNR AUFNR (Order Number), PLNBEZ (Material Number), GAMNG (Total Order Quantity), GMEIN (...

G/L accounts and cost elements by company code: one HANA SQL query in DB02

Every G/L account a company code actually uses, plus which of them are cost elements — one query, one result set. Runs in DB02 → Diagnostics → SQL Editor as plain HANA SQL. Read-only, no ABAP object needed. Verified on an S/4HANA sandbox: client 100, company code CC10. 0. Before you start — chart of accounts and controlling area are different namespaces Case Company code → chart of accounts (KTOPL) / controlling area (KOKRS) — T001 / TKA02 What it does The G/L account master (SKA1/SKB1/SKAT) is keyed by chart of accounts. The cost element master (CSKB) is keyed by controlling area. Check the mapping before you join anything. Watch out On this system CC10 resolves to KTOPL='COA1' but KOKRS='CA10' — two different strings. JNC2 resolves to 'JNC'/'JNC2', which look similar enough to conflate. Result 2 rows SELECT t.BUKRS, t.KTOPL, k.KOKRS FROM T001 t LEFT JOIN TKA02 k ON k.MANDT = t.MANDT AND k.BUKRS = t.BUKRS WHERE t.MANDT = ...