1. Home
  2. Resources
  3. SAP Tables
  4. PREL - HR Master Data (Old Version, For Conversion Only)

SAP Table PREL

HR Master Data (Old Version, For Conversion Only)

PREL (HR Master Data (Old Version, For Conversion Only)) 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 PREL to other SAP tables.

PREL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFTY T582A CHAR 4 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 User Name UNAME CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
DATA1 HR master data field PRELDATA RAW 250 0
DATA2 HR master data field PRELDATA RAW 250 0
DATA3 HR master data field PRELDATA RAW 250 0
DATA4 HR master data field PRELDAT4 RAW 178 0

PREL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PREL INFTY PREL MANDT T582A Infotypes: Customer-Specific Settings MANDT
PREL INFTY PREL INFTY T582A Infotypes: Customer-Specific Settings INFTY
PREL PREAS PREL PREAS T530E Reasons for Changes PREAS
PREL PREAS PREL MANDT T530E Reasons for Changes MANDT
PREL PREAS PREL INFTY T530E Reasons for Changes INFTY