SAP table T5U25 (WC: Job Attributes)
SAP table T5U25 has 5 primary key fields being MANDT,STELL,WCSTATE,WCCODE,ENDDA.
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
Job
NUMC
8
0
T513
STELL
Region (State, Province, County)
CHAR
3
0
T005S
REGIO
Workers' Compensation Classification Code
CHAR
4
0
T5UWC
WCCODE
End Date
DATS
8
0
ENDDA
BEGDA
Start Date
DATS
8
0
BEGDA
WCTITLEWY
WC Title Code for Wyoming
CHAR
1
0
WCTITLEWY
Possible values
O
Others
P
President
S
Secretary
T
Treasurer
V
Vice President
WCSOCODE
WC: Standard Occupational Code
CHAR
10
0
T5USO
WCSOCODE
WCAKAREACD
Alaska Workers' Comp. Area Code
CHAR
2
0
T5UAC
WCAKAREACD
T5U25 foreign key relationships
Table
Field
Check Table
Check Field
0 T5U25
STELL
T513 Jobs
MANDT
0 T5U25
STELL
T513 Jobs
STELL
0 T5U25
STELL
T513 Jobs
ENDDA
1 T5U25
WCAKAREACD
T5UAC Alaska Workers Compensation Area Code
MANDT
1 T5U25
WCAKAREACD
T5UAC Alaska Workers Compensation Area Code
WCAREACODE
0 T5U25
WCCODE
T5UWC WC: Classification Code
WCSTATE
0 T5U25
WCCODE
T5UWC WC: Classification Code
ENDDA
1 T5U25
WCSOCODE
T5USO WC: Standard Occupational Code
WCSTATE
1 T5U25
WCSOCODE
T5USO WC: Standard Occupational Code
ENDDA
0 T5U25
WCSTATE
T005S Taxes: Region (Province) Key
LAND1