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
⤷ 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 |