SAP table TUID (UID Handling)
SAP table TUID has 2 primary key fields being MANDT,UID_TYPE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Type of UID
CHAR
10
0
UID_TYPE
Possible values
IUID
Item Unique Identification
UID_USED
Flag indicating usage of UID Coding/Screens
CHAR
1
0
UID_USED
Possible values
UID-Related Coding and Screens are not Used (Default)
X
UID-Related Coding and Screens are Used
UID_MAX_LENGTH
Maximum Length Allowed for Concatenated Field
NUMC
3
0
UID_MAX_LENGTH
LIFSP
Default Delivery Block
CHAR
2
0
TVLS
LIFSP
CAPID
Application
CHAR
4
0
TC04
CAPID
IDOC_MESSAGE
UID IDoc Communication
CHAR
1
0
UID_IDOC
ESOA_MESSAGE
UID eSOA Communication
CHAR
1
0
UID_ESOA
REGISTRY_CUST
Dummy Registry Customer for Evaluating Distribution Model
CHAR
10
0
IUID_REGISTRY_CUST
N_UNIQ_MSG_TYPE
Message Type for IUID Consistency Check
CHAR
1
0
IUID_N_UNIQ_MSG_TYPE
Possible values
TUID foreign key relationships
Table
Field
Check Table
Check Field
0 TUID
CAPID
TC04 Applic-Specific Criteria for Alternative Determination
MANDT
0 TUID
CAPID
TC04 Applic-Specific Criteria for Alternative Determination
CAPID
1 TUID
LIFSP
TVLS Deliveries: Blocking Reasons/Criteria
MANDT
1 TUID
LIFSP
TVLS Deliveries: Blocking Reasons/Criteria
LIFSP