SAP table TMP_SPEC (Model Service Specifications)
SAP table TMP_SPEC has 2 primary key fields being MANDT,SPEC_NO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SPEC_NO | Number of a Set of Model Service Specifications | CHAR | 10 | 0 | SPEC_NO | ||
| DEL | Deletion Indicator | CHAR | 1 | 0 | DEL | ||
| BLOCK | Use of model service specifications blocked | CHAR | 1 | 0 | BLOCK_FLAG | ||
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| EKORG | Purchasing organization | CHAR | 4 | 0 | T024E | EKORG | |
| EKGRP | Purchasing Group | CHAR | 3 | 0 | T024 | EKGRP | |
| MATKL | Material Group | CHAR | 9 | 0 | T023 | MATKL | |
| SORT1 | Search term | CHAR | 20 | 0 | SPEC_SORT | ||
| TXZ01 | Short description of model specifications | CHAR | 40 | 0 | SPEC_TXT | ||
| PACKNO | Package number | NUMC | 10 | 0 | ESLH | PACKNO | |
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| BEGRU | Authorization Group | CHAR | 4 | 0 | BEGRU | ||
| MSTAE | General Purchasing Status for Service | CHAR | 2 | 0 | T141 | LSTAE | |
| MSTDE | Validity Date for "Purchasing" Status | DATS | 8 | 0 | LSTDE | ||
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| KNTTP | Account Assignment Category | CHAR | 1 | 0 | T163K | KNTTP | |
| NETWR | Net Value in Document Currency | CURR | 15 | 2 | NETWR | ||
| FLIEF | Fixed Vendor | CHAR | 10 | 0 | * | FLIEF | |
| KONNR | Number of principal purchase agreement | CHAR | 10 | 0 | * | KONNR | |
| KTPNR | Item number of principal purchase agreement | NUMC | 5 | 0 | * | KTPNR | |
| ASTYP | Service Category | CHAR | 4 | 0 | T362 | ASTYP | |
| USE_KONF | Configuration at time of service selection | CHAR | 1 | 0 | USE_KONF |
TMP_SPEC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TMP_SPEC | ASTYP | T362 | Service Categories | MANDT |
| 1 TMP_SPEC | EKGRP | T024 | Purchasing Groups | EKGRP |
| 0 TMP_SPEC | EKORG | T024E | Purchasing Organizations | EKORG |
| 1 TMP_SPEC | KNTTP | T163K | Account Assignment Categories in Purchasing Document | MANDT |
| 1 TMP_SPEC | KNTTP | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
| 0 TMP_SPEC | MATKL | T023 | Material Groups | MATKL |
| 1 TMP_SPEC | MSTAE | T141 | Material Status from Materials Management/PPC View | MANDT |
| 1 TMP_SPEC | MSTAE | T141 | Material Status from Materials Management/PPC View | MMSTA |
| 0 TMP_SPEC | PACKNO | ESLH | Service Package Header Data | PACKNO |
| 1 TMP_SPEC | WAERS | TCURC | Currency Codes | MANDT |
| 1 TMP_SPEC | WAERS | TCURC | Currency Codes | WAERS |
| 0 TMP_SPEC | WERKS | T001W | Plants/Branches | WERKS |