SAP Table M_PREMK
Generated Table for View
M_PREMK (Generated Table for View) 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 M_PREMK to other SAP tables.
M_PREMK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| WERKS | Personnel Area | PERSA | T500P | CHAR | 4 | 0 | ||
| BTRTL | Personnel Subarea | BTRTL | T001P | CHAR | 4 | 0 | ||
| PERSG | Employee Group | PERSG | T501 | CHAR | 1 | 0 | ||
| PERSK | Employee Subgroup | PERSK | T503K | CHAR | 2 | 0 | ||
| ABKRS | Payroll Area | ABKRS | T549A | CHAR | 2 | 0 | ||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||
| ORGEH | Organizational Unit | ORGEH | T527X | NUMC | 8 | 0 | ||
| VDSK1 | Organizational Key | VDSK1 | T527O | CHAR | 14 | 0 | ||
| SBMOD | Administrator Group | SBMOD | CHAR | 4 | 0 | |||
| SACHZ | Administrator for Time Recording | SACHZ | T526 | CHAR | 3 | 0 | ||
| NCHMC | Last Name (Field for Search Help) | NACHNMC | CHAR | 25 | 0 | |||
| VNAMC | First Name (Field for Search Help) | VORNAMC | CHAR | 25 | 0 | |||
| PERNR | Personnel number | PERSNO | NUMC | 8 | 0 | |||
| ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | 0 | |||
| BEGDA_0001 | Start Date | BEGDA | DATS | 8 | 0 | |||
| ENDDA_0001 | End Date | ENDDA | DATS | 8 | 0 | |||
M_PREMK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| M_PREMK | ABKRS | M_PREMK | ABKRS | T549A | Payroll areas | ABKRS |
| M_PREMK | ABKRS | M_PREMK | MANDT | T549A | Payroll areas | MANDT |
| M_PREMK | BTRTL | M_PREMK | MANDT | T001P | Personnel Area/Subarea | MANDT |
| M_PREMK | BTRTL | M_PREMK | WERKS | T001P | Personnel Area/Subarea | WERKS |
| M_PREMK | BTRTL | M_PREMK | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| M_PREMK | BUKRS | M_PREMK | BUKRS | T001 | Company Codes | BUKRS |
| M_PREMK | BUKRS | M_PREMK | MANDT | T001 | Company Codes | MANDT |
| M_PREMK | MANDT | M_PREMK | MANDT | T000 | Clients | MANDT |
| M_PREMK | ORGEH | SYST | MANDT | T527X | Organizational Units | MANDT |
| M_PREMK | ORGEH | * | T527X | Organizational Units | SPRSL | |
| M_PREMK | ORGEH | M_PREMK | ORGEH | T527X | Organizational Units | ORGEH |
| M_PREMK | ORGEH | * | T527X | Organizational Units | ENDDA | |
| M_PREMK | PERSG | M_PREMK | MANDT | T501 | Employee Group | MANDT |
| M_PREMK | PERSG | M_PREMK | PERSG | T501 | Employee Group | PERSG |
| M_PREMK | PERSK | M_PREMK | MANDT | T503K | Employee subgroup | MANDT |
| M_PREMK | PERSK | M_PREMK | PERSK | T503K | Employee subgroup | PERSK |
| M_PREMK | SACHZ | SYST | MANDT | T526 | Administrators | MANDT |
| M_PREMK | SACHZ | M_PREMK | SBMOD | T526 | Administrators | WERKS |
| M_PREMK | SACHZ | M_PREMK | SACHZ | T526 | Administrators | SACHX |
| M_PREMK | VDSK1 | SYST | MANDT | T527O | Organizational Key Validation | MANDT |
| M_PREMK | VDSK1 | '1' | T527O | Organizational Key Validation | HIRAR | |
| M_PREMK | VDSK1 | M_PREMK | VDSK1 | T527O | Organizational Key Validation | ORGKY |
| M_PREMK | WERKS | M_PREMK | WERKS | T500P | Personnel Areas | PERSA |
| M_PREMK | WERKS | M_PREMK | MANDT | T500P | Personnel Areas | MANDT |
