SAP Table T005X

Countries - decimal point and date format (SET COUNTRY)

T005X (Countries - decimal point and date format (SET COUNTRY)) 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 T005X to other SAP tables.

T005X table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

LAND

Country Key

LAND1

T005

CHAR

XDEZP

Decimal Format

XUDCPFM

CHAR

Possible values

NULL	1.234.567,89
X	1,234,567.89
Y	1 234 567,89

DATFM

Date format

XUDATFM

CHAR

Possible values

1	DD.MM.YYYY
2	MM/DD/YYYY
3	MM-DD-YYYY
4	YYYY.MM.DD
5	YYYY/MM/DD
6	YYYY-MM-DD
7	GYY.MM.DD (Japanese Date)
8	GYY/MM/DD (Japanese Date)
9	GYY-MM-DD (Japanese Date)
A	YYYY/MM/DD (Islamic Date 1)
B	YYYY/MM/DD (Islamic Date 2)
C	YYYY/MM/DD (Iranian Date)

TIMEFM

Time Format (12-/24-Hour Specification)

XUTIMEFM

CHAR

Possible values

0	24 Hour Format (Example: 12:05:10)
1	12 Hour Format (Example: 12:05:10 PM)
2	12 Hour Format (Example: 12:05:10 pm)
3	Hours from 0 to 11 (Example: 00:05:10 PM)
4	Hours from 0 to 11 (Example: 00:05:10 pm)

T005X foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
T005X	LAND	T005X	MANDT	T005	Countries	MANDT
T005X	LAND	T005X	LAND	T005	Countries	LAND1
T005X	MANDT	T005X	MANDT	T000	Clients	MANDT