TMP_SPEC SAP table for – Model Service Specifications

Here we would like to draw your attention to TMP_SPEC table in SAP. As we know it is being mainly used with the SAP MM-SRV (External Services in MM) component which is coming under MM module (Material Management). TMP_SPEC is a SAP standard transparent table used for storing Model Service Specifications related data in SAP. It comes under the package ML.

SAP TMP_SPEC table

Table TMP_SPEC technical data

TableTMP_SPEC
Data storingModel Service Specifications
ModuleMM
ComponentMM-SRV
SAP PackageML
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP TMP_SPEC Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TMP_SPEC table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • TXZ01
    Its data type is C (Character String) with field length 40
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • BEGRU
    Its data type is C (Character String) with field length 4
  • MSTAE
    Its data type is C (Character String) with field length 2
  • MSTDE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • SPEC_NO
    Its a key field. Its data type is C (Character String) with field length 10
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • FLIEF
    Its data type is C (Character String) with field length 10
  • KONNR
    Its data type is C (Character String) with field length 10
  • KTPNR
    Its data type is N (Character String with Digits Only) with field length 5
  • ASTYP
    Its data type is C (Character String) with field length 4
  • USE_KONF
    Its data type is C (Character String) with field length 1
  • DEL
    Its data type is C (Character String) with field length 1
  • BLOCK : CMC : Block Indicator
    Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • SORT1 : (Not Supported) Search Term
    Its data type is C (Character String) with field length 20