TEMT_PROFILE SAP (Planning profile) Table details
Dictionary Type: Table
Description: Planning profile
Description: Planning profile
Table field list including key, data, relationships and ABAP select examples
TEMT_PROFILE is a standard SAP Table which is used to store Planning profile data and is available within R/3 SAP systems depending on the version and release level.
The TEMT_PROFILE table consists of various fields, each holding specific information or linking keys about Planning profile data available in SAP. These include PROFILE_ID (Planning Profile), PROFILE_TYPE (Type of Exposure Planning Profile), YEAR_VARIANT (Fiscal Year Variant), TRANSCAT (Transaction Category (E-HA)).. 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. .
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)
Text table = TEMT_PROFILE_T
SAP TEMT_PROFILE table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| PROFILE_ID | Planning Profile | TEM_PLANNING_PROFILE | CHAR | 10 | TEM_PLANNING_PROFILE | TEM_PLANPROFIL | |||
| PROFILE_TYPE | Type of Exposure Planning Profile | TEM_PROFILE_TYPE | CHAR | 4 | TEMC_PROF_TYPE | TEM_PROFILE_TYPE | |||
| YEAR_VARIANT | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
| TRANSCAT | Transaction Category (E-HA) | THM_TRANSCAT | NUMC | 2 | THMEXTS_CATEGORY | THM_TRANSCAT | |||
| TRANSACT | Transaction Activity (E-HA) | THM_TRANSACT | NUMC | 2 | THMEXTS_ACTIVITY | THM_TRANSACT | |||
| COMPANY_CODE_REL | Indicator: 'Company Code' as Attribute | TEM_FLAG_COMPANY_CODE_REL | CHAR | 1 | FLAG | ||||
| COUNTRY_REL | Indicator: 'Country' as Attribute | TEM_FLAG_COUNTRY_REL | CHAR | 1 | FLAG | ||||
| ATTRIBUTE_01_REL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
| ATTRIBUTE_02_REL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
| ATTRIBUTE_03_REL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
| ATTRIBUTE_04_REL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
| ATTRIBUTE_05_REL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
| ATTRIBUTE_06_REL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
| SIGN_REL | Indicator: 'Plus/Minus Sign' as Attribute | TEM_FLAG_SIGN_REL | CHAR | 1 | FLAG | ||||
| MAX_AGE | Maximum Age of an Exposure in Days | TEM_MAX_AGE | NUMC | 3 | NUMC3 | ||||
| CREATION_DATE | First Entered on | DERF | DATS | 8 | DATUM | ||||
| CREATION_TIME | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
| CREATION_USER | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
| LASTCHANGE_DATE | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
| LASTCHANGE_TIME | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
| LASTCHANGE_USER | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 |
| Key field | Non-key field |
How do I retrieve data from SAP table TEMT_PROFILE using ABAP code
The following ABAP code Example will allow you to do a basic selection on TEMT_PROFILE to SELECT all data from the tableDATA: WA_TEMT_PROFILE TYPE TEMT_PROFILE.
SELECT SINGLE *
FROM TEMT_PROFILE
INTO CORRESPONDING FIELDS OF WA_TEMT_PROFILE
WHERE...
How to access SAP table TEMT_PROFILE
Within an ECC or HANA version of SAP you can also view further information about TEMT_PROFILE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects