SAP ABAP Table TEMS_PROFILE_POLICY_AL (Communication Structure for UI - Planning Profile POLICY)

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_PROFILE_POLICY_AL	Table Relationship Diagram
Short Description	Communication Structure for UI - Planning Profile POLICY

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	Hedging Policy
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PROFILE_ID	☐	TEM_PLANNING_PROFILE	TEM_PLANNING_PROFILE	CHAR	10	0	Planning Profile	TEMT_PROFILE
4	FOREIGN_CURR	☐	TEM_EXPOSURE_CURRENCY	WAERS	CUKY	5	0	Exposure Currency	TCURC
5	HORIZON	☐	TEM_POLICY_HORIZON	TEM_POLICY_HORIZON	NUMC	4	0	Time Horizon of an Exposure
6	.INCLUDE	☐				0	0	Attributes for an Exposure
7	TRANSACTION_CAT	☐	THM_TRANSCAT	THM_TRANSCAT	NUMC	2	0	Hedge Management: Transaction Category	THMEXTS_CATEGORY
8	SIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
9	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	ATTRIBUTE_01	☐	TEM_ATTRIBUTE_VALUE	TEM_ATTRIBUTE_VALUE	CHAR	20	0	Value of a Free Attribute	TEMC_ATTRIBUTE
12	ATTRIBUTE_02	☐	TEM_ATTRIBUTE_VALUE	TEM_ATTRIBUTE_VALUE	CHAR	20	0	Value of a Free Attribute	TEMC_ATTRIBUTE
13	ATTRIBUTE_03	☐	TEM_ATTRIBUTE_VALUE	TEM_ATTRIBUTE_VALUE	CHAR	20	0	Value of a Free Attribute	TEMC_ATTRIBUTE
14	ATTRIBUTE_04	☐	TEM_ATTRIBUTE_VALUE	TEM_ATTRIBUTE_VALUE	CHAR	20	0	Value of a Free Attribute	TEMC_ATTRIBUTE
15	ATTRIBUTE_05	☐	TEM_ATTRIBUTE_VALUE	TEM_ATTRIBUTE_VALUE	CHAR	20	0	Value of a Free Attribute	TEMC_ATTRIBUTE
16	ATTRIBUTE_06	☐	TEM_ATTRIBUTE_VALUE	TEM_ATTRIBUTE_VALUE	CHAR	20	0	Value of a Free Attribute	TEMC_ATTRIBUTE
17	VALID_FROM	☐	TEM_POLICY_VALID_FROM	TEM_POLICY_VALID_FROM	DATS	8	0	Policy - Valid from
18	PERCENTAGE	☐	TEM_POLICY_PERCENTAGE	DECV3_2	DEC	5	2	Maximum Percentage to Be Hedged
19	PERCENTAGE_MIN	☐	TEM_POLICY_PERCENTAGE_MIN	DECV3_2	DEC	5	2	Minimum Percentage to Be Hedged
20	MINIMUM_AMT	☐	TEM_POLICY_MIN_AMT	TEM_EXPOSURE_AMT	CURR	17	2	Trivial Amount Limit for Hedge (Absolute Amount)
21	CREATION_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
22	CREATION_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
23	CREATION_USER	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
24	LASTCHANGE_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
25	LASTCHANGE_TIME	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
26	LASTCHANGE_USER	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TEMS_PROFILE_POLICY_AL	ATTRIBUTE_01	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
2	TEMS_PROFILE_POLICY_AL	ATTRIBUTE_02	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
3	TEMS_PROFILE_POLICY_AL	ATTRIBUTE_03	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
4	TEMS_PROFILE_POLICY_AL	ATTRIBUTE_04	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
5	TEMS_PROFILE_POLICY_AL	ATTRIBUTE_05	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
6	TEMS_PROFILE_POLICY_AL	ATTRIBUTE_06	TEMC_ATTRIBUTE	ATTRIBUTE_VALUE	KEY	1	CN
7	TEMS_PROFILE_POLICY_AL	COMPANY_CODE	T001	BUKRS
8	TEMS_PROFILE_POLICY_AL	COUNTRY	T005	LAND1
9	TEMS_PROFILE_POLICY_AL	FOREIGN_CURR	TCURC	WAERS	KEY	1	CN
10	TEMS_PROFILE_POLICY_AL	MANDT	T000	MANDT	KEY	1	CN
11	TEMS_PROFILE_POLICY_AL	PROFILE_ID	TEMT_PROFILE	PROFILE_ID	KEY	1	CN
12	TEMS_PROFILE_POLICY_AL	TRANSACTION_CAT	THMEXTS_CATEGORY	TRANSCATEGORY

History

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