SAP table T503 (Employee Group/Subgroup)
SAP table T503 has 3 primary key fields being MANDT,PERSG,PERSK.
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
MANDT
Client
CLNT
3
0
T000
MANDT
PERSG
Employee Group
CHAR
1
0
T501
PERSG
PERSK
Employee Subgroup
CHAR
2
0
T503Z
PERSK
ABART
Employee subgroup grouping for personnel calculation rule
CHAR
1
0
T546A
ABRAR
ABTYP
Employee subgroup grouping for primary wage tpyes
CHAR
1
0
ABTYP
ANTYP
Employee category
CHAR
1
0
ANTYP
TRFKZ
ES grouping for collective agreement provision
CHAR
1
0
TRFKZ
ZEITY
Employee Subgroup Grouping for Work Schedules
CHAR
1
0
DZEITY
AKSTA
Activity status
NUMC
1
0
AKSTA
ANSTA
Employment status
NUMC
1
0
ANSTA
AUSTA
Training status
NUMC
1
0
AUSTA
KONTY
Employee Subgroup Grouping for Time Quota Types
CHAR
1
0
MOPGK
BURKZ
Employee subgroup grouping for appraisal
NUMC
1
0
BURKZ
MOLGA
Reserved Field/Unused Field of Length 2
CHAR
2
0
NUSED2
TYPSZ
Single-Character Flag
CHAR
1
0
CHAR1
INWID
Participation in Incentive Wages
CHAR
1
0
INWID
Possible values
Does not participate in Incentive Wages
X
Participates in Incentive Wages
T503 foreign key relationships
Table
Field
Check Table
Check Field
0 T503
ABART
T546A
Employee Subgroup Grouping for Payroll
MANDT
1 T503
PERSG
T501
Employee Group
MANDT
1 T503
PERSG
T501
Employee Group
PERSG
0 T503
PERSK
T503Z
Country Assignment for Employee Group/Subgroup
MANDT
0 T503
PERSK
T503Z
Country Assignment for Employee Group/Subgroup
MOLGA
0 T503
PERSK
T503Z
Country Assignment for Employee Group/Subgroup
PERSG
0 T503
PERSK
T503Z
Country Assignment for Employee Group/Subgroup
PERSK