SAP ABAP Table TEMS_ANALYZED_EXPOSURE (Analysis Result)

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_ANALYZED_EXPOSURE	Table Relationship Diagram
Short Description	Analysis Result

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

Foreign Keys

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

History

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