SAP Table TPMP
Maintenance profile
TPMP (Maintenance profile) 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 TPMP to other SAP tables.
TPMP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| AUART | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||||||
| USERN | User name | USERN | CHAR | 12 | 0 | |||||||
| PROFWOC | Profile rels.& graphic / General order | PROFILWOC | TCN41 | CHAR | 7 | 0 | ||||||
| PROFEXT | External procurement profile | PROFILEXT | TPEXT | CHAR | 7 | 0 | ||||||
| PROFMAT | External material profile | PROFILMAT | TPEXT | CHAR | 7 | 0 | ||||||
| MGVRG | Operation Quantity | MGVRG | QUAN | 13 | 3 | |||||||
| MEINH | Unit of Measure for Activity/Operation | VORME | T006 | UNIT | 3 | 0 | ||||||
| SCREENTY | Scenario or Subscreen Category | SCRTP | TQBT | CHAR | 4 | 0 | ||||||
| SEL_OPR | Include task list with operation selection | SEL_OPR | CHAR | 1 | 0 |
Possible values
|
||||||
| WCENTER | Include task list with work center selection | WCENTER | CHAR | 1 | 0 |
Possible values
|
||||||
| NEW_NUM | Include task list with renumbering | NEW_NUM | CHAR | 1 | 0 |
Possible values
|
||||||
| ONE_OPR | Include task list only once completely | ONE_OPR | CHAR | 1 | 0 |
Possible values
|
||||||
| SEQUENC | Sorted inclusion of operations in the order | SEQUENC | CHAR | 1 | 0 |
Possible values
|
||||||
TPMP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TPMP | AUART | TPMP | MANDT | T003O | Order Types | CLIENT |
| TPMP | AUART | TPMP | AUART | T003O | Order Types | AUART |
| TPMP | MANDT | TPMP | MANDT | T000 | Clients | MANDT |
| TPMP | MEINH | TPMP | MEINH | T006 | Units of Measurement | MSEHI |
| TPMP | MEINH | TPMP | MANDT | T006 | Units of Measurement | MANDT |
| TPMP | PROFEXT | TPMP | PROFEXT | TPEXT | Profile for external procurement | PROFIL |
| TPMP | PROFEXT | TPMP | MANDT | TPEXT | Profile for external procurement | MANDT |
| TPMP | PROFMAT | TPMP | MANDT | TPEXT | Profile for external procurement | MANDT |
| TPMP | PROFMAT | TPMP | PROFMAT | TPEXT | Profile for external procurement | PROFIL |
| TPMP | PROFWOC | TPMP | MANDT | TCN41 | Network Defaults | MANDT |
| TPMP | PROFWOC | 'I' | TCN41 | Network Defaults | PLNAW | |
| TPMP | PROFWOC | TPMP | PROFWOC | TCN41 | Network Defaults | PROFIDNETZ |
| TPMP | SCREENTY | TPMP | SCREENTY | TQBT | Screen type table for subscreen | SCREENTY |
| TPMP | WERKS | TPMP | MANDT | T001W | Plants/Branches | MANDT |
| TPMP | WERKS | TPMP | WERKS | T001W | Plants/Branches | WERKS |
