SAP ABAP Table TEMS_VERSEXPOS_UI (Display Versioned Exposures)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     FTEM_EXPOSURE_MGT_UI (Package) Treasury: Exposure Management - User Interface Layer
Basic Data
Table Category INTTAB    Structure 
Structure TEMS_VERSEXPOS_UI   Table Relationship Diagram
Short Description Display Versioned Exposures    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Display Versioned Exposures  
2 PROFILE_ID TEM_PLANNING_PROFILE TEM_PLANNING_PROFILE CHAR 10   0   Planning Profile *
3 PROFILE_TEXT TEM_PROFILE_TEXT TEXT30 CHAR 30   0   Planning Profile Text  
4 VERSION_NO TEM_VERSION TEM_VERSION NUMC 6   0   Version *
5 VERSION_DATE TEM_VERSION_DATE DATS DATS 8   0   Version Date  
6 .INCLUDE       0   0   Raw Exposure With Texts  
7 .INCLUDE       0   0   External Key for an Exposure  
8 EXPOSURE_ID TEM_EXPOSURE_ID TEM_EXPOSURE_ID CHAR 32   0   Exposure ID *
9 EXPOSURE_ORIGIN TEM_EXPOSURE_ORIGIN TEM_EXPOSURE_ORIGIN CHAR 5   0   Exposure Origin TEMTS_ORIGIN
10 LOG_SYSTEM LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
11 PROCESSING_STATE TEM_RAWEXPOS_PROCESSING_STATE TEM_RAWEXPOS_PROCESSING_STATE CHAR 1   0   Release Status of a Raw Exposure TEMTS_PRCSTATE
12 PROCESSING_STATE_T TEM_RAWEXPOS_PROC_STATE_TEXT TEXT30 CHAR 30   0   Release Status of a Raw Exposure  
13 .INCLUDE       0   0   External Information for Due Date  
14 PLANNING_PERIOD TEM_PLANNING_PERIOD TEM_PLANNING_PERIOD CHAR 3   0   Planning Period TEMC_PERIOD
15 PLANNING_YEAR TEM_PLANNING_YEAR GJAHR NUMC 4   0   Plan Year  
16 DUE_DATE THM_EXPDATE TPM_POSITION_DATE DATS 8   0   Hedge Management: date the exposure is related to  
17 .INCLUDE       0   0   Attributes for an Exposure  
18 TRANSACTION_CAT THM_TRANSCAT THM_TRANSCAT NUMC 2   0   Hedge Management: Transaction Category THMEXTS_CATEGORY
19 SIGN TB_SSIGN T_SSIGN CHAR 1   0   Direction of flow  
20 COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code T001
21 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
22 ATTRIBUTE_01 TEM_ATTRIBUTE_VALUE TEM_ATTRIBUTE_VALUE CHAR 20   0   Value of a Free Attribute TEMC_ATTRIBUTE
23 ATTRIBUTE_02 TEM_ATTRIBUTE_VALUE TEM_ATTRIBUTE_VALUE CHAR 20   0   Value of a Free Attribute TEMC_ATTRIBUTE
24 ATTRIBUTE_03 TEM_ATTRIBUTE_VALUE TEM_ATTRIBUTE_VALUE CHAR 20   0   Value of a Free Attribute TEMC_ATTRIBUTE
25 ATTRIBUTE_04 TEM_ATTRIBUTE_VALUE TEM_ATTRIBUTE_VALUE CHAR 20   0   Value of a Free Attribute TEMC_ATTRIBUTE
26 ATTRIBUTE_05 TEM_ATTRIBUTE_VALUE TEM_ATTRIBUTE_VALUE CHAR 20   0   Value of a Free Attribute TEMC_ATTRIBUTE
27 ATTRIBUTE_06 TEM_ATTRIBUTE_VALUE TEM_ATTRIBUTE_VALUE CHAR 20   0   Value of a Free Attribute TEMC_ATTRIBUTE
28 .INCLUDE       0   0   Texts for Exposure Attributes  
29 TRANSACTION_CAT_TEXT TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
30 COMPANY_CODE_TEXT BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
31 COUNTRY_TEXT LANDX TEXT15 CHAR 15   0   Country Name  
32 ATTRIBUTE_01_TEXT TEM_ATTRIBUTE_TEXT TEXT20 CHAR 20   0   Text for Value of a Free Attribute  
33 ATTRIBUTE_02_TEXT TEM_ATTRIBUTE_TEXT TEXT20 CHAR 20   0   Text for Value of a Free Attribute  
34 ATTRIBUTE_03_TEXT TEM_ATTRIBUTE_TEXT TEXT20 CHAR 20   0   Text for Value of a Free Attribute  
35 ATTRIBUTE_04_TEXT TEM_ATTRIBUTE_TEXT TEXT20 CHAR 20   0   Text for Value of a Free Attribute  
36 ATTRIBUTE_05_TEXT TEM_ATTRIBUTE_TEXT TEXT20 CHAR 20   0   Text for Value of a Free Attribute  
37 ATTRIBUTE_06_TEXT TEM_ATTRIBUTE_TEXT TEXT20 CHAR 20   0   Text for Value of a Free Attribute  
38 FOREIGN_AMT TEM_EXPOSURE_AMT TEM_EXPOSURE_AMT CURR 17   2   Foreign Currency Amount of Exposure  
39 FOREIGN_CURR TEM_EXPOSURE_CURRENCY WAERS CUKY 5   0   Exposure Currency TCURC
40 .INCLUDE       0   0   Description Fields in Hedge Management  
41 DESCRIPTION THA_TRANSTEXT TEXT50 CHAR 50   0   Description of the Exposure Transaction  
42 REFERENCE THM_REFERENCE CHAR16 CHAR 16   0   Hedge Management: Reference  
43 .INCLUDE       0   0   User Data  
44 CREATION_DATE DERF DATUM DATS 8   0   First Entered on  
45 CREATION_TIME TERF TIMES TIMS 6   0   Time of Initial Entry  
46 CREATION_USER RERF SYCHAR12 CHAR 12   0   Entered by  
47 CREATION_TCODE TCODE TCODE CHAR 20   0   Transaction Code *
48 LASTCHANGE_DATE DBEAR DATUM DATS 8   0   Last Edited on  
49 LASTCHANGE_TIME TBEAR TIMES TIMS 6   0   Last Edited at  
50 LASTCHANGE_USER RBEAR SYCHAR12 CHAR 12   0   Employee ID  
51 LASTCHANGE_TCODE TCODE TCODE CHAR 20   0   Transaction Code *
52 .INCLUDE       0   0   Administrative Information for Versioned Exposures  
53 STATE TEM_EXPOSURE_STATE TEM_EXPOSURE_STATE CHAR 1   0   Exposure Status  
54 EXPOSURE_CAT TEM_EXPOSURE_CAT TEM_EXPOSURE_CAT CHAR 1   0   Exposure Category  
55 TRANSFER_CAT TEM_TRANSFER_CAT TEM_TRANSFER_CAT CHAR 1   0   Type of Transfer into Hedge Management  
56 TOT_EXPOSURE_ID TEM_EXPOSURE_ID TEM_EXPOSURE_ID CHAR 32   0   Exposure ID  
57 LAST_VERSION_HED TEM_VERSION TEM_VERSION NUMC 6   0   Version *
58 .INCLUDE       0   0   Texts for Administration Data for Exposures  
59 STATE_TEXT TEXT20 TEXT20 CHAR 20   0   Text (20 Characters)  
60 EXPOSURE_CAT_TEXT TEXT20 TEXT20 CHAR 20   0   Text (20 Characters)  
61 TRANSFER_CAT_TEXT TEXT20 TEXT20 CHAR 20   0   Text (20 Characters)  
62 .INCLUDE       0   0   Key for Transaction in Hedge Management  
63 HED_COMPANY_CODE BUKRS BUKRS CHAR 4   0   Company Code *
64 HEDGE_PLAN_ID THM_PLANNERID THM_PLANNERID CHAR 13   0   Hedge Management: Hedge Plan ID *
65 HED_EXPOSURE_ID THM_EXPOSUREID THM_EXPOSUREID NUMC 5   0   Hedge Management: Exposure ID *
66 TRANSACTION_ID THM_TRANSACTION THM_TRANSACTION CHAR 11   0   Hedge Management: Transaction *
67 TRANSACTION_ACT THM_TRANSACT THM_TRANSACT NUMC 2   0   Hedge Management: Transaction Activity *
68 .INCLUDE       0   0   Texts for Key Fields in Hedge Management  
69 HED_COMP_CODE_TEXT BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
70 HEDGE_PLAN_TEXT THA_PLANNERTEXT TEXT50 CHAR 50   0   Description of Hedge Plan  
71 TRANSACTION_ACT_TEXT TEXT20 TEXT20 CHAR 20   0   Text (20 Characters)  
72 PERIOD_END_DATE TEM_PERIOD_END_DATE TEM_PERIOD_END_DATE DATS 8   0   End of Planning Period  
73 PERIOD_TEXT TEM_PERIOD_TEXT TEM_PERIOD_TEXT CHAR 20   0   Planning Period Description  
74 PERCENTAGE TEM_POLICY_PERCENTAGE DECV3_2 DEC 5   2   Maximum Percentage to Be Hedged  
75 MINIMUM_AMT TEM_POLICY_MIN_AMT TEM_EXPOSURE_AMT CURR 17   2   Trivial Amount Limit for Hedge (Absolute Amount)  
76 FOREIGN_AMT_S TEM_EXPOSURE_AMT TEM_EXPOSURE_AMT CURR 17   2   Foreign Currency Amount of Exposure  
77 MINIMUM_AMT_S TEM_POLICY_MIN_AMT TEM_EXPOSURE_AMT CURR 17   2   Trivial Amount Limit for Hedge (Absolute Amount)  
78 COLOR CHAR3 CHAR3 CHAR 3   0   3-Byte field  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TEMS_VERSEXPOS_UI ATTRIBUTE_01 TEMC_ATTRIBUTE ATTRIBUTE_VALUE KEY 1 CN
2 TEMS_VERSEXPOS_UI ATTRIBUTE_02 TEMC_ATTRIBUTE ATTRIBUTE_VALUE KEY 1 CN
3 TEMS_VERSEXPOS_UI ATTRIBUTE_03 TEMC_ATTRIBUTE ATTRIBUTE_VALUE KEY 1 CN
4 TEMS_VERSEXPOS_UI ATTRIBUTE_04 TEMC_ATTRIBUTE ATTRIBUTE_VALUE KEY 1 CN
5 TEMS_VERSEXPOS_UI ATTRIBUTE_05 TEMC_ATTRIBUTE ATTRIBUTE_VALUE KEY 1 CN
6 TEMS_VERSEXPOS_UI ATTRIBUTE_06 TEMC_ATTRIBUTE ATTRIBUTE_VALUE KEY 1 CN
7 TEMS_VERSEXPOS_UI COMPANY_CODE T001 BUKRS    
8 TEMS_VERSEXPOS_UI COUNTRY T005 LAND1    
9 TEMS_VERSEXPOS_UI EXPOSURE_ORIGIN TEMTS_ORIGIN EXPOSURE_ORIGIN    
10 TEMS_VERSEXPOS_UI FOREIGN_CURR TCURC WAERS    
11 TEMS_VERSEXPOS_UI LOG_SYSTEM TBDLS LOGSYS    
12 TEMS_VERSEXPOS_UI PLANNING_PERIOD TEMC_PERIOD PLANNING_PERIOD KEY C CN
13 TEMS_VERSEXPOS_UI PROCESSING_STATE TEMTS_PRCSTATE PROC_STATE KEY 1 CN
14 TEMS_VERSEXPOS_UI TRANSACTION_CAT THMEXTS_CATEGORY TRANSCATEGORY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 600