Category: Tables

Useful SAP Tables

Useful SAP Tables

DEVACCESS: Developer key.
ADIRACCESS : object registration key.

DD02L: Table containing name of tables available in the system.
DD03L: Table fields.

T005S: State, province and county.

T511K: Amount constant.
TVARVC : Text constant.

SAP Number range

SAP Number range

Number range is a persistent counter. As an example, in HCM, it holds sequence of employee number.

  • Tcode: SNRO, SNUM;
    • RP_PREL Personnel Administration number ranges or direct access through tcode PA04.
  • Table NRIV can be used to in tcode SE16 to list number ranges.

Tax Reporter tables

Tax Reporter tables

Here are some useful tables used by Tax Reporter (tcode PU19).

T51T0 – TAXTY and LGART
T5UTO – link between Tax Type (TAXTY) and wage types (LGART)
T5UTP – link between Tax form group (TAXTP) and Tax Type (TAXTY)
T5UTI – link between Tax authority (TAXAU) and Tax type (TAXTY)
T5UT3 – Tax form field (TXITM)

Constant table

Constant table

  • You can use table T511K to define an amount as a constant and use it in a program;
  • Table TVARVC to store a constants as text. Tcode STVARVC calls maintenance screen.