SAP TMP_SPEC Model Service Specifications Table data and field list

TMP_SPEC is a standard SAP Table which is used to store Model Service Specifications data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TMP_SPEC table consists of various fields, each holding specific information or linking keys about Model Service Specifications data available in SAP. These include SPEC_NO (Number of a Set of Model Service Specifications), DEL (Deletion Indicator), BLOCK (Use of model service specifications blocked), WERKS (Plant)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

TMP_SPEC table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP TMP_SPEC table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TMP_SPEC table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
SPEC_NO	Number of a Set of Model Service Specifications	SPEC_NO	CHAR	10		ALPHA	SPEC10	MSP	SPEC
DEL	Deletion Indicator	DEL	CHAR	1			CHAR01
BLOCK	Use of model service specifications blocked	BLOCK_FLAG	CHAR	1			XFELD
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
EKORG	Purchasing Organization	EKORG	CHAR	4	T024E		EKORG	EKO
EKGRP	Purchasing Group	EKGRP	CHAR	3	T024		EKGRP	EKG
MATKL	Material Group	MATKL	CHAR	9	T023		MATKL	MKL	S_WBWG
SORT1	Search term	SPEC_SORT	CHAR	20			CHAR20
TXZ01	Short description of model specifications	SPEC_TXT	CHAR	40			CHAR40
PACKNO	Package number	PACKNO	NUMC	10	ESLH		PACKNO
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
AEDAT	Changed On	AEDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
BEGRU	Authorization Group	BEGRU	CHAR	4			BEGRU
MSTAE	General Purchasing Status for Service	LSTAE	CHAR	2	T141		MMSTA
MSTDE	Validity Date for 'Purchasing' Status	LSTDE	DATS	8			DATUM
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
KNTTP	Account Assignment Category	KNTTP	CHAR	1	T163K		KNTTP	KNT
NETWR	Net Value in Document Currency	NETWR	CURR	15(2)			WERTV8
FLIEF	Fixed Vendor	FLIEF	CHAR	10	Assigned to domain	ALPHA	LIFNR
KONNR	Number of Principal Purchase Agreement	KONNR	CHAR	10	Assigned to domain	ALPHA	EBELN	KTR
KTPNR	Item Number of Principal Purchase Agreement	KTPNR	NUMC	5	Assigned to domain		EBELP
ASTYP	Service Category	ASTYP	CHAR	4	T362		ASTYP	ASY
USE_KONF	Configuration at time of service selection	USE_KONF	CHAR	1			XFELD

Key field

Non-key field

< TMPSPECLST - Model Service Specifications for Configuration TMQ1 - Number Ranges for Quota Arrangement >

How do I retrieve data from SAP table TMP_SPEC using ABAP code

The following ABAP code Example will allow you to do a basic selection on TMP_SPEC to SELECT all data from the table
DATA: WA_TMP_SPEC TYPE TMP_SPEC.

SELECT SINGLE *
FROM TMP_SPEC
INTO CORRESPONDING FIELDS OF WA_TMP_SPEC
WHERE...

How to access SAP table TMP_SPEC

Within an ECC or HANA version of SAP you can also view further information about TMP_SPEC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).