PREL is a standard Personnel Administration Transparent Table in SAP Personnel Mgmt application, which stores HR Master Data (Old Version, For Conversion Only) data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, and Authorization Objects for PREL. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

PREL — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3 *
    2 PERNR Personnel No. PERNR_D X NUMC 8
    3 INFTY Infotype INFTY X CHAR 4 T582A
    4 SUBTY Subtype SUBTY X CHAR 4
    5 OBJPS Object Identification OBJPS X CHAR 2
    6 SPRPS Lock Indicator for HR Master Data Record SPRPS X CHAR 1
    7 ENDDA End Date ENDDA X DATS 8
    8 BEGDA Start Date BEGDA X DATS 8
    9 SEQNR Sequence Number SEQNR X NUMC 3
    10 AEDTM Date of Last Change AEDAT DATS 8
    11 UNAME User Name UNAME CHAR 12
    12 HISTO Historical Record Flag HISTO CHAR 1
    13 ITXNR Text Module for Infotype ITXNR NUMC 8
    14 PREAS Reason for Changing Master Data PREAS CHAR 2 T530E
    15 DATA1 PRELDATA RAW 250
    16 DATA2 PRELDATA RAW 250
    17 DATA3 PRELDATA RAW 250
    18 DATA4 PRELDAT4 RAW 178