SAP table T5UG0 (HR: Garnishment Order Types)
SAP table T5UG0 has 2 primary key fields being MANDT,ORDCD.
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
Garnishment order type
CHAR
2
0
PB10_ORDCD
ORDTX
Garnishment order code text
CHAR
30
0
PB10_ORDTX
GCATE
Garnishment document category
CHAR
1
0
T5UG1
PB10_GCATE
PRPSL
Garnishment order proposal indicator
CHAR
1
0
PB10_PRPSL
OCATE
Garnishment order category
CHAR
1
0
PB10_OCATE
Possible values
1
Support
2
Levy
3
Generic
4
Voluntary
5
Service charge
6
Fee
OPRIO
Garnishment order priority
NUMC
3
0
PB10_OPRIO
OMULT
Garnishment multiple order indicator
CHAR
1
0
PB10_OMULT
BALAN
Garnishment order initial balance indicator
CHAR
1
0
PB10_OBALN
Possible values
1
Optional
2
Prohibited
3
Required
DEDUC
Garnishment order deduction indicator
CHAR
1
0
PB10_DEDUC
LIMI1
Garnishment order indicator for limit 1
CHAR
1
0
PB10_VALI1
LIMI2
Garnishment order indicator for limit 2
CHAR
1
0
PB10_VALI2
ADDIT
Garnishment order indicator for additional amount
CHAR
1
0
P106_ADDIT
ORDLG
Wage type for order code
CHAR
4
0
T512W
PB10_ORDLG
ORULE
Garnishment order rule indicator
CHAR
1
0
P106_ORULE
T5UG0 foreign key relationships
Table
Field
Check Table
Check Field
0 T5UG0
GCATE
T5UG1 HR: Garnishment Document Category
GCATE
1 T5UG0
ORDLG
T512W Wage Type Valuation
MANDT
1 T5UG0
ORDLG
T512W Wage Type Valuation
MOLGA
1 T5UG0
ORDLG
T512W Wage Type Valuation
ENDDA