SAP ABAP Table TMP_SPEC (Model Service Specifications)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ ML (Package) R/3 services management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TMP_SPEC	Table Relationship Diagram
Short Description	Model Service Specifications

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SPEC_NO	☑	SPEC_NO	SPEC10	CHAR	10	0	Number of a Set of Model Service Specifications
3	DEL	☐	DEL	CHAR01	CHAR	1	0	Deletion Indicator
4	BLOCK	☐	BLOCK_FLAG	XFELD	CHAR	1	0	Use of model service specifications blocked
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
7	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
8	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
9	SORT1	☐	SPEC_SORT	CHAR20	CHAR	20	0	Search term
10	TXZ01	☐	SPEC_TXT	CHAR40	CHAR	40	0	Short description of model specifications
11	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
14	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
17	MSTAE	☐	LSTAE	MMSTA	CHAR	2	0	General Purchasing Status for Service	T141
18	MSTDE	☐	LSTDE	DATUM	DATS	8	0	Validity Date for "Purchasing" Status
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
21	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
22	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
23	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
24	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
25	ASTYP	☐	ASTYP	ASTYP	CHAR	4	0	Service Category	T362
26	USE_KONF	☐	USE_KONF	XFELD	CHAR	1	0	Configuration at time of service selection

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TMP_SPEC	ASTYP	T362	ASTYP
2	TMP_SPEC	EKGRP	T024	EKGRP
3	TMP_SPEC	EKORG	T024E	EKORG
4	TMP_SPEC	KNTTP	T163K	KNTTP
5	TMP_SPEC	MANDT	T000	MANDT
6	TMP_SPEC	MATKL	T023	MATKL
7	TMP_SPEC	MSTAE	T141	MMSTA
8	TMP_SPEC	PACKNO	ESLH	PACKNO
9	TMP_SPEC	WAERS	TCURC	WAERS
10	TMP_SPEC	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in