SAP Table T5E20

Provinces

T5E20 (Provinces) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T5E20 to other SAP tables.

T5E20 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PROVN Province PES_PROVN T005S CHAR 3 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
REGFI Tax modifier (employment tax) CODAU NUMC 2 0
01 Araba/Alava
20 Gipuzkoa
31 Navarra
48 Bizkaia
51 Ceuta
52 Melilla
99 Other provinces

T5E20 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T5E20 MANDT T5E20 MANDT T000 Clients MANDT
T5E20 PROVN 'ES ' T005S Taxes: Region (Province) Key LAND1
T5E20 PROVN T5E20 PROVN T005S Taxes: Region (Province) Key BLAND
T5E20 PROVN T5E20 MANDT T005S Taxes: Region (Province) Key MANDT