SAP Table FDT_ADMN_0000
FDT: Central Administrative Data
FDT_ADMN_0000 (FDT: Central Administrative Data) 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 FDT_ADMN_0000 to other SAP tables.
FDT_ADMN_0000 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CLIENT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
ID
FDT: Universal Unique Identifier
|
FDT_UUID |
CHAR
|
32 | 0 | ||||||||||||||
|
OBJECT_TYPE
BRFplus: Object Type
|
FDT_OBJECT_TYPE |
CHAR
|
2 | 0 | ||||||||||||||
|
VERSION
FDT: Version
|
FDT_VERSION |
NUMC
|
6 | 0 | ||||||||||||||
|
NAME
FDT: Name
|
FDT_NAME |
CHAR
|
30 | 0 | ||||||||||||||
|
APPLICATION_ID
FDT: Universal Unique Identifier
|
FDT_UUID |
CHAR
|
32 | 0 | ||||||||||||||
|
ACCESS_LEVEL
FDT: Access Level
|
FDT_ACCESS_LEVEL |
CHAR
|
6 | 0 | ||||||||||||||
|
||||||||||||||||||
|
CR_USER
User Name
|
SYUNAME |
CHAR
|
12 | 0 | ||||||||||||||
|
CR_TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
CH_USER
User Name
|
SYUNAME |
CHAR
|
12 | 0 | ||||||||||||||
|
CH_TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
DELETED
FDT: Deleted Option
|
FDT_DELETED_OPTION |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TRANSPORTED
Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
|
BOOLE_D |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DEPL_TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
WTT_TIMESTAMP
FDT: Write to Transport Timestamp
|
FDT_WTT_TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
OSYSID
Name of SAP System
|
SYSYSID |
CHAR
|
8 | 0 | ||||||||||||||
|
OSYSCLIENT
Client name as pure data without special meaning
|
MANDTDATA |
CLNT
|
3 | 0 | ||||||||||||||
|
OBSOLETE
Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
|
BOOLE_D |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LOCAL_OBJECT
Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
|
BOOLE_D |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
JOB_ID
FDT: Job ID
|
FDT_JOB_UUID |
CHAR
|
32 | 0 | ||||||||||||||
|
TV_STATE
FDT: Truncate versioning state
|
FDT_TV_STATE |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TV_TIMESTAMP
BRFplus: Date from which on old versions shall be dropped
|
FDT_TV_TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
TV_SET_TIMESTAMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
P_TV_TIMESTAMP
BRFplus: Date from which on versions are dropped physical
|
FDT_PHY_TV_TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
P_TV_SET_TMSTMP
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
|
TIMESTAMP |
DEC
|
15 | 0 | ||||||||||||||
|
CR_RELEASE
SAP Release
|
SAPRELEASE |
CHAR
|
10 | 0 | ||||||||||||||
|
CH_RELEASE
SAP Release
|
SAPRELEASE |
CHAR
|
10 | 0 | ||||||||||||||
FDT_ADMN_0000 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| FDT_ADMN_0000 | CLIENT | FDT_ADMN_0000 | CLIENT |
T000
Clients
|
MANDT |