ACDOCA
transaction S/4HANA status: ActiveUniversal Journal Entry Line Items (S/4HANA)
What the badges mean
- S/4HANA status: Active
- Active and unchanged in S/4HANA.
- S/4HANA status: Deprecated
- Still readable today, but no longer SAP's strategic path — plan around it.
- S/4HANA status: Replaced
- Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
- S/4HANA status: Migrating to IBP
- Planning scope is moving from APO toward IBP.
- S/4HANA status: Active (StRM) · Replaced (EWM)
- Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
- S/4HANA status: Replaced · Compat View
- Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
- S/4HANA status: Active · Proxy View
- Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
- master
- Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
- Linked type codes
CLNT — the client key; filter it explicitly and carry it through every join.
NUMC — fixed-width numeric text; keep it a string and keep the leading zeros.
DATS, TIMS — character date (YYYYMMDD) and time (HHMMSS), zero-filled when initial.
CURR, CUKY, QUAN, UNIT — amounts and quantities, meaningful only beside the currency key or unit that qualifies them.
LANG — a language key in a text table — one row per language.
Fields
10 fields · 6 key
The join key is all 6 key fields together — matching on any single one fans out. See composite keys in the quirks guide.
10 fields.
| Key | Field | Description | Type | Length | References |
|---|---|---|---|---|---|
| Primary key | RCLNT | Client | CLNT | 3 | |
| Primary key | RLDNR | Ledger in General Ledger Accounting | CHAR | 2 | |
| Primary key | RBUKRS | Company Code | CHAR | 4 | T001 |
| Primary key | GJAHR | Fiscal Year | NUMC | 4 | |
| Primary key | BELNR | Accounting Document Number | CHAR | 10 | |
| Primary key | DOCLN | Six-Digit Number of Journal Entry Line Item | CHAR | 6 | |
| RMVCT | Transaction Type | CHAR | 3 | ||
| RACCT | Account Number | CHAR | 10 | ||
| RCNTR | Cost Center | CHAR | 10 | CSKS | |
| PRCTR | Profit Center | CHAR | 10 | CEPC |
Linked type codes in the Type column jump to the matching section of the SAP data quirks guide.
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading ACDOCA on Databricks. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.
3 parameters not filled: <catalog>, <schema>, <GJAHR>
-- ============================================================
-- Table : ACDOCA Universal Journal Entry Line Items (S/4HANA)
-- Purpose: Column-selected read of ACDOCA — auto-generated from field metadata
-- Grain : One row per RCLNT + RLDNR + RBUKRS + GJAHR + BELNR + DOCLN
-- Notes : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
a.RCLNT AS "Client",
a.RLDNR AS "Ledger in General Ledger Accounting",
a.RBUKRS AS "Company Code",
a.GJAHR AS "Fiscal Year",
a.BELNR AS "Accounting Document Number",
a.DOCLN AS "Six-Digit Number of Journal Entry Line Item",
a.RMVCT AS "Transaction Type",
a.RACCT AS "Account Number",
a.RCNTR AS "Cost Center",
a.PRCTR AS "Profit Center"
FROM <catalog>.<schema>.acdoca a
WHERE
a.GJAHR = <GJAHR>
ORDER BY a.RCLNT;Verified August 2026
Released CDS views over this table
Released SAP standard VDM views that read over ACDOCA. Prefer these over classic-table reads on S/4HANA where available.
Relationships
Diagram of 1-hop neighbors — join details below.
Transaction Codes That Use This Table
No t-code mappings populated for this table yet.