SAP ABAP Table TEMS_VERSEXPOS_AL (Display Versioned Exposures)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTEM_EXPOSURE_MGT_AL (Package) Treasury: Exposure Management - Applic. Service Layer

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TEMS_VERSEXPOS_AL	ATTRIBUTE_01	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
2	TEMS_VERSEXPOS_AL	ATTRIBUTE_02	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
3	TEMS_VERSEXPOS_AL	ATTRIBUTE_03	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
4	TEMS_VERSEXPOS_AL	ATTRIBUTE_04	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
5	TEMS_VERSEXPOS_AL	ATTRIBUTE_05	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
6	TEMS_VERSEXPOS_AL	ATTRIBUTE_06	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
7	TEMS_VERSEXPOS_AL	COMPANY_CODE	T001	BUKRS
8	TEMS_VERSEXPOS_AL	COUNTRY	T005	LAND1
9	TEMS_VERSEXPOS_AL	EXPOSURE_ORIGIN	TEMTS_ORIGIN	EXPOSURE_ORIGIN
10	TEMS_VERSEXPOS_AL	FOREIGN_CURR	TCURC	WAERS
11	TEMS_VERSEXPOS_AL	LOG_SYSTEM	TBDLS	LOGSYS
12	TEMS_VERSEXPOS_AL	PLANNING_PERIOD	TEMC_PERIOD	PLANNING_PERIOD	KEY	C	CN
13	TEMS_VERSEXPOS_AL	PROCESSING_STATE	TEMTS_PRCSTATE	PROC_STATE	KEY	1	CN
14	TEMS_VERSEXPOS_AL	TRANSACTION_CAT	THMEXTS_CATEGORY	TRANSCATEGORY

History

Last changed by/on	SAP	20130529
SAP Release Created in	600