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.
- PA (Personnel Management)
- PA-PA (Personnel Administration)
- PREL - HR Master Data (Old Version, For Conversion Only)
- PA-PA (Personnel Administration)
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 |
Most searched SAP Personnel Management Tables
- Employee Tables
- Country Codes Tables
- Salary Tables
- Personnel Number Tables
- Reason Codes Tables
- Valuation Type Tables
- Personnel Area Tables
- Country Region Tables
- Employee Salary Tables
- Payroll Area Tables
- Valuation Area Tables
- Infotype Subtype Tables
- Country Key Tables
- Pay Scale Tables
- Iban Tables
- Employee Subgroup Tables
- Employee Master Tables
- Hr Mini Master Tables
- Infotype Table Tables
- Currency Type Tables
- Hr Payroll Tables
- Hr Master Tables