SAP table PA2501 (HR Master Record for Infotype 2501)
SAP table PA2501 has 8 primary key fields being MANDT,PERNR,SUBTY,OBJPS,SPRPS,ENDDA,BEGDA,SEQNR.
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 | MANDT | ||
| PERNR | Personnel Number | NUMC | 8 | 0 | PA0003 | PERSNO | |
| SUBTY | Subtype | CHAR | 4 | 0 | SUBTY | ||
| OBJPS | Object Identification | CHAR | 2 | 0 | OBJPS | ||
| SPRPS | Lock Indicator for HR Master Data Record | CHAR | 1 | 0 | SPRPS | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| SEQNR | Number of Infotype Record With Same Key | NUMC | 3 | 0 | SEQNR | ||
| AEDTM | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| UNAME | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| HISTO | Historical Record Flag | CHAR | 1 | 0 | HISTO | ||
| ITXEX | Text Exists for Infotype | CHAR | 1 | 0 | ITXEX | ||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | CHAR | 1 | 0 | PRFEX | ||
| ORDEX | Confirmation Fields Exist | CHAR | 1 | 0 | ORDEX | ||
| ITBLD | Infotype Screen Control | CHAR | 2 | 0 | ITBLD | ||
| PREAS | Reason for Changing Master Data | CHAR | 2 | 0 | T530E | PREAS | |
| FLAG1 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| FLAG2 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| FLAG3 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| FLAG4 | Reserved Field/Unused Field | CHAR | 1 | 0 | NUSED | ||
| RESE1 | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||
| RESE2 | Reserved Field/Unused Field of Length 2 | CHAR | 2 | 0 | NUSED2 | ||
| GRPVL | Grouping Value for Personnel Assignments | CHAR | 4 | 0 | PCCE_GPVAL | ||
| ORG_UNIT_WP | Organizational Unit | NUMC | 8 | 0 | * | ORGEH | |
| JOB_WP | Job | NUMC | 8 | 0 | * | STELL | |
| POSITION_WP | Position | NUMC | 8 | 0 | * | PLANS | |
| PERS_AREA_WP | Personnel Area | CHAR | 4 | 0 | * | PERSA | |
| PERS_SUBAREA_WP | Personnel Subarea | CHAR | 4 | 0 | * | BTRTL | |
| EMPL_GROUP_WP | Employee Group | CHAR | 1 | 0 | * | PERSG | |
| EMPL_SUBGROUP_WP | Employee Subgroup | CHAR | 2 | 0 | * | PERSK | |
| CO_AREA_WP | Controlling Area of Master Cost Center | CHAR | 4 | 0 | * | MAST_COAR | |
| COSTCENTER_WP | Master Cost Center | CHAR | 10 | 0 | * | MAST_CCTR | |
| COMP_CODE_WP | Company Code | CHAR | 4 | 0 | BUKRS | ||
| BUS_AREA_WP | Business Area | CHAR | 4 | 0 | * | GSBER | |
| TIME_STATUS_WP | Employee Time Management Status | NUMC | 1 | 0 | PT_ZTERF | ||
| FM_AREA_WP | Financial Management Area | CHAR | 4 | 0 | * | FIKRS | |
| FUND_WP | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| FUNC_AREA_WP | Functional Area | CHAR | 16 | 0 | * | FKBER | |
| GRANT_NBR_WP | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| FISTL_WP | Funds Center | CHAR | 16 | 0 | * | FISTL | |
| BUDGET_PD_WP | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| BUKRS_CO | Debited company code | CHAR | 4 | 0 | * | DEBT_CMPC | |
| GSBER_CO | Debited business area | CHAR | 4 | 0 | * | DEBT_BUSA | |
| KOKRS_CO | Controlling Area | CHAR | 4 | 0 | * | KOKRS | |
| KOSTL_CO | Debited Cost Center | CHAR | 10 | 0 | * | DEBT_CCTR | |
| AUFNR_CO | Debited Order | CHAR | 12 | 0 | * | DEBT_ORDER | |
| PS_POSID_CO | Debited WBS element | CHAR | 24 | 0 | DEBT_WBS_E | ||
| LSTAR_CO | Debited Activity Type | CHAR | 6 | 0 | * | DEBT_ACTT | |
| VORNR_CO | Debited activity | CHAR | 4 | 0 | DEBT_ACTVY | ||
| NPLNR_CO | Debited network | CHAR | 12 | 0 | * | DEBT_NETW | |
| FM_AREA_CO | Financial Management Area | CHAR | 4 | 0 | * | FIKRS | |
| FUND_CO | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| FUNC_AREA_CO | Functional Area | CHAR | 16 | 0 | * | FKBER | |
| GRANT_NBR_CO | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| BUDGET_PD_CO | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| BUKRS_AR | Receiving company code | CHAR | 4 | 0 | * | RECV_CMPC | |
| GSBER_AR | Receiving business area | CHAR | 4 | 0 | * | RECV_BUSA | |
| KOSTL_AR | Receiver Cost Center | CHAR | 10 | 0 | * | RECV_CCTR | |
| AUFNR_AR | Receiver Order | CHAR | 12 | 0 | * | RECV_ORDER | |
| PS_POSID_AR | Receiver WBS element | CHAR | 24 | 0 | RECV_WBS_E | ||
| CO_PRZNR_AR | Receiver Business Process | CHAR | 12 | 0 | * | RECV_PROCS | |
| NPLNR_AR | Receiver network | CHAR | 12 | 0 | * | RECV_NETW | |
| VORNR_AR | Receiving activity | CHAR | 4 | 0 | RECV_ACTVY | ||
| FUND_AR | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| FUNC_AREA_AR | Functional Area | CHAR | 16 | 0 | * | FKBER | |
| GRANT_NBR_AR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| BUDGET_PD_AR | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| BUKRS_AS | Sending company code | CHAR | 4 | 0 | * | SEND_CMPC | |
| GSBER_AS | Sending business area | CHAR | 4 | 0 | * | SEND_BUSA | |
| KOSTL_AS | Sender cost center | CHAR | 10 | 0 | * | SEND_CCTR | |
| LSTAR_AS | Sender Activity Type | CHAR | 6 | 0 | * | SEND_ACTT | |
| FUND_AS | Sender fund | CHAR | 10 | 0 | * | FM_SFONDS | |
| FUNC_AREA_AS | Sending Functional Area | CHAR | 16 | 0 | * | SFKTBER | |
| GRANT_NBR_AS | Sender Grant | CHAR | 20 | 0 | * | GM_GRANT_SENDER | |
| BUDGET_PD_AS | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| ALP_POSITION | Alternative position | NUMC | 8 | 0 | * | ALP_POSTN | |
| ALP_RATE | Alternative valuation basis | CURR | 5 | 2 | ALP_RATE | ||
| ALP_AMOUNT | Wage Type Amount for Payments | CURR | 13 | 2 | PAD_AMT7S | ||
| ALP_CURRENCY | Currency Key | CUKY | 5 | 0 | * | WAERS | |
| REPTT | Reporting Time Type | CHAR | 8 | 0 | * | REPRTT | |
| DUR_ACTUAL | Actual time | QUAN | 9 | 2 | DUR_ACTUAL_Q | ||
| DUR_VALUE | Account-Relevant Time | QUAN | 9 | 2 | DUR_VALUE_Q | ||
| UNIT | Unit of Measure | UNIT | 3 | 0 | * | ROUNIT |
PA2501 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PA2501 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| 0 PA2501 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| 1 PA2501 | PREAS | T530E | Reasons for Changes | MANDT |
| 1 PA2501 | PREAS | T530E | Reasons for Changes | INFTY |
| 1 PA2501 | PREAS | T530E | Reasons for Changes | PREAS |