TEMS_VERSEXPOS_AL SAP (Display Versioned Exposures) Structure details

Dictionary Type: Structure
Description: Display Versioned Exposures




ABAP Code to SELECT data from TEMS_VERSEXPOS_AL
Related tables to TEMS_VERSEXPOS_AL
Access table TEMS_VERSEXPOS_AL




Structure field list including key, data, relationships and ABAP select examples

TEMS_VERSEXPOS_AL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Display Versioned Exposures" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TEMS_VERSEXPOS_AL TYPE TEMS_VERSEXPOS_AL.

The TEMS_VERSEXPOS_AL table consists of various fields, each holding specific information or linking keys about Display Versioned Exposures data available in SAP. These include PROFILE_TEXT (Planning Profile Text), VERSION_NO (Version), VERSION_DATE (Version Date), EXPOSURE_ID (Exposure ID).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TEMS_VERSEXPOS_AL structure 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
PROFILE_IDPlanning Profile TEM_PLANNING_PROFILECHAR10Assigned to domainTEM_PLANNING_PROFILETEM_PLANPROFIL
PROFILE_TEXTPlanning Profile Text TEM_PROFILE_TEXTCHAR30TEXT30
VERSION_NOVersion TEM_VERSIONNUMC6Assigned to domainTEM_VERSION
VERSION_DATEVersion Date TEM_VERSION_DATEDATS8DATS
EXPOSURE_IDExposure ID TEM_EXPOSURE_IDCHAR32TEM_EXPOSURE_ID
EXPOSURE_ORIGINExposure Origin TEM_EXPOSURE_ORIGINCHAR5TEMTS_ORIGINTEM_EXPOSURE_ORIGIN
LOG_SYSTEMLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
PROCESSING_STATERelease Status of a Raw Exposure TEM_RAWEXPOS_PROCESSING_STATECHAR1TEMTS_PRCSTATETEM_RAWEXPOS_PROCESSING_STATE
PROCESSING_STATE_TRelease Status of a Raw Exposure TEM_RAWEXPOS_PROC_STATE_TEXTCHAR30TEXT30
PLANNING_PERIODPlanning Period TEM_PLANNING_PERIODCHAR3TEMC_PERIODTEM_PLANNING_PERIOD
PLANNING_YEARPlan Year TEM_PLANNING_YEARNUMC4GJAHRGJAHR
DUE_DATEDate to Which Exposure Refers THM_EXPDATEDATS8TPM_POSITION_DATE
TRANSACTION_CATTransaction Category (E-HA) THM_TRANSCATNUMC2THMEXTS_CATEGORYTHM_TRANSCAT
SIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
COMPANY_CODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
ATTRIBUTE_01Value of a Free Attribute TEM_ATTRIBUTE_VALUECHAR20TEMC_ATTRIBUTETEM_ATTRIBUTE_VALUE
ATTRIBUTE_02Value of a Free Attribute TEM_ATTRIBUTE_VALUECHAR20TEMC_ATTRIBUTETEM_ATTRIBUTE_VALUE
ATTRIBUTE_03Value of a Free Attribute TEM_ATTRIBUTE_VALUECHAR20TEMC_ATTRIBUTETEM_ATTRIBUTE_VALUE
ATTRIBUTE_04Value of a Free Attribute TEM_ATTRIBUTE_VALUECHAR20TEMC_ATTRIBUTETEM_ATTRIBUTE_VALUE
ATTRIBUTE_05Value of a Free Attribute TEM_ATTRIBUTE_VALUECHAR20TEMC_ATTRIBUTETEM_ATTRIBUTE_VALUE
ATTRIBUTE_06Value of a Free Attribute TEM_ATTRIBUTE_VALUECHAR20TEMC_ATTRIBUTETEM_ATTRIBUTE_VALUE
TRANSACTION_CAT_TEXTText (30 Characters) TEXT30CHAR30TEXT30
COMPANY_CODE_TEXTName of Company Code or Company BUTXTCHAR25TEXT25
COUNTRY_TEXTCountry Name LANDXCHAR15TEXT15
ATTRIBUTE_01_TEXTText for Value of a Free Attribute TEM_ATTRIBUTE_TEXTCHAR20TEXT20
ATTRIBUTE_02_TEXTText for Value of a Free Attribute TEM_ATTRIBUTE_TEXTCHAR20TEXT20
ATTRIBUTE_03_TEXTText for Value of a Free Attribute TEM_ATTRIBUTE_TEXTCHAR20TEXT20
ATTRIBUTE_04_TEXTText for Value of a Free Attribute TEM_ATTRIBUTE_TEXTCHAR20TEXT20
ATTRIBUTE_05_TEXTText for Value of a Free Attribute TEM_ATTRIBUTE_TEXTCHAR20TEXT20
ATTRIBUTE_06_TEXTText for Value of a Free Attribute TEM_ATTRIBUTE_TEXTCHAR20TEXT20
FOREIGN_AMTForeign Currency Amount of Exposure TEM_EXPOSURE_AMTCURR17(2) TEM_EXPOSURE_AMT
FOREIGN_CURRExposure Currency TEM_EXPOSURE_CURRENCYCUKY5TCURCWAERS
DESCRIPTIONDescription of the Exposure Transaction THA_TRANSTEXTCHAR50TEXT50
REFERENCEReference (E-HA) THM_REFERENCECHAR16CHAR16
CREATION_DATEFirst Entered on DERFDATS8DATUM
CREATION_TIMETime of Initial Entry TERFTIMS6TIMES
CREATION_USEREntered by RERFCHAR12SYCHAR12
CREATION_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
LASTCHANGE_DATELast Edited on DBEARDATS8DATUM
LASTCHANGE_TIMELast Edited at TBEARTIMS6TIMES
LASTCHANGE_USEREmployee ID RBEARCHAR12SYCHAR12
LASTCHANGE_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
STATEExposure Status TEM_EXPOSURE_STATECHAR1TEM_EXPOSURE_STATE
EXPOSURE_CATExposure Category TEM_EXPOSURE_CATCHAR1TEM_EXPOSURE_CAT
TRANSFER_CATType of Transfer to Hedge Accounting for Exposures TEM_TRANSFER_CATCHAR1TEM_TRANSFER_CAT
TOT_EXPOSURE_IDExposure ID TEM_EXPOSURE_IDCHAR32TEM_EXPOSURE_ID
LAST_VERSION_HEDVersion TEM_VERSIONNUMC6Assigned to domainTEM_VERSION
STATE_TEXTText (20 Characters) TEXT20CHAR20TEXT20
EXPOSURE_CAT_TEXTText (20 Characters) TEXT20CHAR20TEXT20
TRANSFER_CAT_TEXTText (20 Characters) TEXT20CHAR20TEXT20
HED_COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
HEDGE_PLAN_IDHedge Plan ID THM_PLANNERIDCHAR13Assigned to domainALPHATHM_PLANNERIDPLN
HED_EXPOSURE_IDExposure ID THM_EXPOSUREIDNUMC5Assigned to domainTHM_EXPOSUREID
TRANSACTION_IDE-HA: Transaction THM_TRANSACTIONCHAR11Assigned to domainALPHATHM_TRANSACTION
TRANSACTION_ACTTransaction Activity (E-HA) THM_TRANSACTNUMC2Assigned to domainTHM_TRANSACT
HED_COMP_CODE_TEXTName of Company Code or Company BUTXTCHAR25TEXT25
HEDGE_PLAN_TEXTDescription of Hedge Plan THA_PLANNERTEXTCHAR50TEXT50
TRANSACTION_ACT_TEXTText (20 Characters) TEXT20CHAR20TEXT20
PERIOD_END_DATEEnd of Planning Period TEM_PERIOD_END_DATEDATS8TEM_PERIOD_END_DATE
PERIOD_TEXTPlanning Period Description TEM_PERIOD_TEXTCHAR20TEM_PERIOD_TEXT
PERCENTAGEMaximum Percentage to Be Hedged TEM_POLICY_PERCENTAGEDEC5(2) DECV3_2
MINIMUM_AMTTrivial Amount Limit for Hedge (Absolute Amount) TEM_POLICY_MIN_AMTCURR17(2) TEM_EXPOSURE_AMT

Key field Non-key field



How do I retrieve data from SAP structure TEMS_VERSEXPOS_AL using ABAP code?

As TEMS_VERSEXPOS_AL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TEMS_VERSEXPOS_AL as there is no data to select.

How to access SAP table TEMS_VERSEXPOS_AL

Within an ECC or HANA version of SAP you can also view further information about TEMS_VERSEXPOS_AL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!