TMP_SPEC

Model Service Specifications | #masterdata | Component: External Services
Column Name Description
MANDT FK Client
SPEC_NO Number of a Set of Model Service Specifications
Column Name Description
💲 Currency Key (WAERS):
NETWR Net Value in Document Currency
Column Name Description
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
MSTDE Validity Date for "Purchasing" Status
Column Name Description
BLOCK Use of model service specifications blocked Show values
USE_KONF Configuration at time of service selection Show values
Column Name Description Domain name
DEL Deletion Indicator CHAR01
SORT1 Search term CHAR20
TXZ01 Short description of model specifications CHAR40
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
BEGRU Authorization Group BEGRU
FLIEF Fixed Vendor LIFNR
KONNR Number of principal purchase agreement EBELN
KTPNR Item number of principal purchase agreement EBELP
Master Data Relations Join Conditions
Service Category
  • TMP_SPEC.MANDT == T362.MANDT
  • TMP_SPEC.ASTYP == T362.ASTYP
Purchasing Group
  • Purchasing Group
  • Client
  • TMP_SPEC.EKGRP == T024.EKGRP
  • TMP_SPEC.MANDT == T024.MANDT
Purchasing organization
  • TMP_SPEC.MANDT == T024E.MANDT
  • TMP_SPEC.EKORG == T024E.EKORG
Account Assignment Category
  • TMP_SPEC.MANDT == T163K.MANDT
  • TMP_SPEC.KNTTP == T163K.KNTTP
Client TMP_SPEC.MANDT == T000.MANDT
Material Group
  • TMP_SPEC.MANDT == T023.MANDT
  • TMP_SPEC.MATKL == T023.MATKL
General Purchasing Status for Service
  • TMP_SPEC.MANDT == T141.MANDT
  • TMP_SPEC.MSTAE == T141.MMSTA
Package number
  • TMP_SPEC.MANDT == ESLH.MANDT
  • TMP_SPEC.PACKNO == ESLH.PACKNO
Currency Key
  • TMP_SPEC.MANDT == TCURC.MANDT
  • TMP_SPEC.WAERS == TCURC.WAERS
Plant
  • TMP_SPEC.MANDT == T001W.MANDT
  • TMP_SPEC.WERKS == T001W.WERKS