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