SAP table T001P (Personnel Area/Subarea)

SAP table T001P has 3 primary key fields being MANDT,WERKS,BTRTL.

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
WERKS Personnel Area CHAR 4 0 T500P PERSA
BTRTL Personnel Subarea CHAR 4 0 BTRTL_001P
BTEXT Personnel Subarea Text CHAR 15 0 BTRTX
MOLGA HCM Localization CHAR 2 0 T500L MOLGA
MOURA Personnel Subarea Grouping for Leave Types NUMC 2 0 MOURA
TRFGB Pay Scale Area CHAR 2 0 T510G TRFGB
TRFAR Pay scale type CHAR 2 0 T510A TRFAR
MOABW Personnel subarea grouping for absence and attendance types NUMC 2 0 MOABW
MOABT Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
MOTAT Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
MOVER Personnel Subarea Grpg for Substitution/Availability Types NUMC 2 0 MOVER
URLKL PS grouping for attendance and absence counting CHAR 2 0 T554X URLKL
JUPER Legal Person CHAR 4 0 JUPER
MOBDE Grouping of Personnel Subareas for Time Recording NUMC 2 0 MOBDE
MOZKO Grouping of Personnel Subareas for Time Quota Types NUMC 2 0 MOZKO
MOPTB Personnel subarea grouping for premiums NUMC 2 0 MOPTB
WKTYP Personnel Subarea for Primary Wage Type and Wage Maintenance CHAR 1 0 WKTYP
MOSTA Statistics Modifier NUMC 2 0 MOSTA
MOBUR Personnel Subarea Grouping for Appraisals NUMC 2 0 * MOBUR
MOFID Public Holiday Calendar CHAR 2 0 THOCI HIDENT
MOSID Personnel Subarea Grouping for Work Schedules NUMC 2 0 T508Z MOSID
MODSZ Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2

T001P foreign key relationships

Table Field Check Table Check Field
0 T001P MANDT T000 Clients MANDT
1 T001P MOLGA T500L Personnel Country Grouping MOLGA
0 T001P MOSID T508Z Assignment of PS Grouping for Work Schedules to Daily WS MANDT
0 T001P MOSID T508Z Assignment of PS Grouping for Work Schedules to Daily WS MOSID
1 T001P TRFAR T510A Pay Scale Types MANDT
1 T001P TRFAR T510A Pay Scale Types MOLGA
1 T001P TRFAR T510A Pay Scale Types TRFAR
0 T001P TRFGB T510G Pay Scale Areas MANDT
0 T001P TRFGB T510G Pay Scale Areas MOLGA
0 T001P TRFGB T510G Pay Scale Areas TRFGB
1 T001P URLKL T554X Rules for Attendance/Absence Counting and Leave Deduction MANDT
1 T001P URLKL T554X Rules for Attendance/Absence Counting and Leave Deduction URLKL
1 T001P URLKL T554X Rules for Attendance/Absence Counting and Leave Deduction ZEITY
1 T001P URLKL T554X Rules for Attendance/Absence Counting and Leave Deduction SEQNO
0 T001P WERKS T500P Personnel Areas MANDT
0 T001P WERKS T500P Personnel Areas PERSA