SAP Table PA0031

HR Master Record: Infotype 0031 (Reference Pers.Nos.)

PA0031 (HR Master Record: Infotype 0031 (Reference Pers.Nos.)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PA0031 to other SAP tables.

PA0031 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
RFP01 Reference Personnel Number RFPNR NUMC 8 0
RFP02 Reference Personnel Number RFPNR NUMC 8 0
RFP03 Reference Personnel Number RFPNR NUMC 8 0
RFP04 Reference Personnel Number RFPNR NUMC 8 0
RFP05 Reference Personnel Number RFPNR NUMC 8 0
RFP06 Reference Personnel Number RFPNR NUMC 8 0
RFP07 Reference Personnel Number RFPNR NUMC 8 0
RFP08 Reference Personnel Number RFPNR NUMC 8 0
RFP09 Reference Personnel Number RFPNR NUMC 8 0
RFP10 Reference Personnel Number RFPNR NUMC 8 0
RFP11 Reference Personnel Number RFPNR NUMC 8 0
RFP12 Reference Personnel Number RFPNR NUMC 8 0
RFP13 Reference Personnel Number RFPNR NUMC 8 0
RFP14 Reference Personnel Number RFPNR NUMC 8 0
RFP15 Reference Personnel Number RFPNR NUMC 8 0
RFP16 Reference Personnel Number RFPNR NUMC 8 0
RFP17 Reference Personnel Number RFPNR NUMC 8 0
RFP18 Reference Personnel Number RFPNR NUMC 8 0
RFP19 Reference Personnel Number RFPNR NUMC 8 0
RFP20 Reference Personnel Number RFPNR NUMC 8 0

PA0031 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PA0031 MANDT PA0031 MANDT T000 Clients MANDT
PA0031 PERNR PA0031 MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
PA0031 PERNR PA0031 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
PA0031 PREAS '0031' T530E Reasons for Changes INFTY
PA0031 PREAS PA0031 PREAS T530E Reasons for Changes PREAS
PA0031 PREAS PA0031 MANDT T530E Reasons for Changes MANDT