SAP tableObjectT001BModuleFI_FICO

T001B table — FI Posting Period Intervals

T001B stores Financial Accounting posting-period interval control by posting-period variant, account type, account range, period, and fiscal-year boundaries. The effective posting permission is not simply 'company code open or closed': the company code points to a posting-period variant, and multiple account-type or account-range intervals can allow or block the same posting date differently.

A consultant-focused reference for T001B covering its purpose, key fields, joins, safe query restrictions, proof steps, release context, ownership and recurring interpretation traps.

Published 20 Sept 2026· 937 words

What it stores

T001B stores open and closed FI posting-period intervals by company code, account type and account range. Each row must be interpreted using the complete technical key and the application process that writes it. A consultant should first establish whether the row represents current state, a dated master-data slice, a document item, a history event, an index entry or a compatibility representation. Organizational levels, validity dates, fiscal years, ledgers, languages, statuses and sequence numbers are part of the grain whenever those dimensions exist. The table should be read as evidence of application behavior, not as an isolated spreadsheet. Confirm the owning business object and configuration before deciding that a value is wrong.

Key fields

These are the fields most useful for identification, scoping and investigation. Verify key flags and data elements in SE11 for the exact installed release before building permanent extraction logic.

  • Posting-period variant — assigned from company-code configuration.
  • KOART — account type such as G/L, customer, vendor, asset, or material.
  • Account from/to range — narrows the interval to specific accounts.
  • Open period and fiscal-year interval(s) — define permitted posting dates.
  • Company-code assignment to posting-period variant — required to know which T001B rows apply.

How it joins the data model

Use complete business keys, not field-name similarity. Include client and organizational dimensions on both sides, respect validity dates and language, and test cardinality before aggregating. A one-to-many child join can multiply financial or quantity totals without producing a database error.

  • B
  • U
  • K
  • R
  • S
  • t
  • o
  • T
  • 0
  • 0
  • 1
  • |
  • a
  • c
  • c
  • o
  • u
  • n
  • t
  • i
  • n
  • t
  • e
  • r
  • v
  • a
  • l
  • t
  • o
  • t
  • h
  • e
  • r
  • e
  • l
  • e
  • v
  • a
  • n
  • t
  • G
  • /
  • L
  • ,
  • c
  • u
  • s
  • t
  • o
  • m
  • e
  • r
  • ,
  • v
  • e
  • n
  • d
  • o
  • r
  • o
  • r
  • a
  • s
  • s
  • e
  • t
  • m
  • a
  • s
  • t
  • e
  • r
  • |
  • p
  • e
  • r
  • i
  • o
  • d
  • l
  • o
  • g
  • i
  • c
  • t
  • o
  • t
  • h
  • e
  • f
  • i
  • s
  • c
  • a
  • l
  • -
  • y
  • e
  • a
  • r
  • v
  • a
  • r
  • i
  • a
  • n
  • t
  • a
  • s
  • s
  • i
  • g
  • n
  • e
  • d
  • t
  • o
  • t
  • h
  • e
  • c
  • o
  • m
  • p
  • a
  • n
  • y
  • c
  • o
  • d
  • e

How to read it safely

Begin with one known business object and the narrowest possible selection. Include MANDT where the table is client-dependent and never assume a document, partner, asset, material or account number is globally unique. Add the relevant company code, controlling area, plant, sales area, fiscal year, ledger, language, validity interval, item and sequence fields. Check inactive, deletion, reversal and status indicators before counting a row as operational. For high-volume transaction or change-history tables, restrict by object key and date before joining. Confirm indexes and key flags in the target system because releases and activated components can alter structure and performance. Use supported transactions, apps or APIs for correction; direct database updates are unsafe and unsupported.

How to prove it in the data

Take one reproducible example from the relevant SAP screen, report or application log. Record its full displayed key, organizational context, key date, language and status. Locate the matching T001B row using those values, then follow the documented parent and child joins without dropping key components. Compare the result using the same key date and ledger. When values differ, test for leading-zero conversion, multiple validity slices, inactive history, parallel ledgers, fiscal-year boundaries, archived data and asynchronous replication. Save the read-only evidence before escalating. If the row is wrong, reproduce the maintenance path in a non-production system and route the fix to the application owner rather than changing the table.

ECC vs S/4HANA

T001B remains part of S/4HANA FI posting-period control. Universal Journal storage does not remove the posting-period variant and account-type interval checks. Analyze the company code's assigned posting-period variant and the matching interval before changing period configuration.

Common pitfalls

  • Selecting by one convenient identifier and silently mixing organizational units, years, ledgers, languages or validity periods.
  • Joining on a partial key or descriptive value and creating duplicates that appear to be legitimate business rows.
  • Ignoring inactive, deletion, reversal or status indicators and reporting retained history as current state.
  • Assuming this table is authoritative without checking S/4HANA simplification, Business Partner synchronization, Universal Journal, MATDOC, CDS views or an external cloud source.
  • Treating a missing row as proof that an event never occurred even though logging, replication, authorization and archiving scope can differ.
  • Updating table rows directly instead of correcting data through the supported transaction, app, API or migration process.

Whose problem this is

The functional team owning the underlying business process owns interpretation and configuration. Master-data or operations teams own missing or incorrectly maintained records. ABAP, integration and data teams own extraction, conversion and join defects. Basis, security and database teams own authorization and performance issues. Ownership should be assigned only after the same business key has been reconciled across the application, this table and its related objects.

Related SAP objects

Reviewed pages this object connects to in the ERPClimb knowledge graph.

Source: ERPClimb — https://erpclimb.com/sap-tables/t001bERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.