SAP ABAP Table FTI_S_REP_CHECK_IMPAIRMENT (Data Structure for Selection Report for Impairment)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI (Package) Application development R/3 Treasury information system

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_S_REP_CHECK_IMPAIRMENT	Table Relationship Diagram
Short Description	Data Structure for Selection Report for Impairment

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
4	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
5	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
6	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
7	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
8	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
9	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
10	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
11	PERIOD_BEGIN	☐	FTI_IMPAIR_PERIOD_BEGIN	DATUM	DATS	8	0	Date for Period Start of Selection Report Impairment
12	PERIOD_END	☐	FTI_IMPAIR_PERIOD_END	DATUM	DATS	8	0	Date for Period End of Selection Report Impairment
13	KEY_DATE_REF	☐	FTI_RSTICH_PB	RSTICH_PB	CHAR	1	0	Key Date Reference for Parallel Books
14	PC_CURRENCY	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
15	VC_CURRENCY	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	TCURC
16	EXCHANGE_PC_VC	☐	FTI_IMPAIR_KURST_BEWW	KURST	CHAR	4	0	Rate Type Translation from Position Crcy to Valtn Crcy	TCURV
17	UNITS	☐	FTI_UNITS	TPM_UNITS	DEC	22	6	Number of units
18	NOMINAL_AMT_PC	☐	FTI_NOMINAL_AMT_PC	TPM_AMOUNT	CURR	21	2	Nominal Amount in Position Currency
19	AQU_VAL_PC	☐	FTI_AQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Position Currency
20	AQU_VAL_VC	☐	FTI_AQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Acquisition Value in Valuation Currency
21	AQU_VAL_PC_RATE_PERCENT	☐	FTI_ANKUPR	VVPKTKUR	DEC	15	6	Acquisition Price for Percentage-Quoted Securities in %
22	AQU_VAL_PC_RATE_UNITS	☐	FTI_ANKSBW	VVPKTKUR	DEC	15	6	Acquisition Price f. Unit-Quoted Securities in Position Crcy
23	AQU_VAL_VC_RATE_UNITS	☐	FTI_IMPAIR_AQU_VC_RATE_UNITS	VVPKTKUR	DEC	15	6	Acquisition Price for Unit-Quoted SEC in Valuation Currency
24	RATE_MATURITY	☐	FTI_IMPAIR_RATE_MATURITY		DEC	3	0	Maximum Age of a Market Price for Impairment
25	RATE_INDICATOR	☐	FTI_KURSART	VVSKURSART	CHAR	2	0	Price Type for Securities (Optional Entry)	TW56
26	EXCHANGE_NC_PC	☐	FTI_IMPAIR_KURST_CURR	KURST	CHAR	4	0	Rate Type for Translation from Quotation Currency to PC	TCURV
27	RATE_KEY_DATE	☐	DKURS	DATUM	DATS	8	0	Rate/Price Date
28	MARKET_PLACE	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
29	MARKET_PC	☐	FTI_MARKET_PC	TPM_AMOUNT	CURR	21	2	Market Value in Position Currency
30	MARKET_VC	☐	FTI_IMPAIR_MARKET_VC	TPM_AMOUNT	CURR	21	2	Market Value (SE Only) in Valuation Currency
31	MARKET_PC_RATE_PERCENT	☐	FTI_KURSPR	VVPKTKUR	DEC	15	6	Market Price / % (Percentage-Quoted Securities)
32	MARKET_PC_RATE_UNITS	☐	FTI_KURSBW	VVPKTKUR	DEC	15	6	Market Price/Unit in Position Crcy (Unit-Quoted Securities)
33	MARKET_VC_RATE_UNITS	☐	FTI_IMPAIR_MARKET_VC_RATE_UNIT	VVPKTKUR	DEC	15	6	Market Price / Unit in Valuation Currency
34	MARKET_PC_MEAN	☐	FTI_IMPAIR_MARKET_PC_MEAN	TPM_AMOUNT	CURR	21	2	Mean Market Value (only SEC) in Postion Currency
35	MARKET_PC_MEAN_PERCENT	☐	FTI_IMPAIR_KURSPR_MEAN	VVPKTKUR	DEC	15	6	Mean Market Price / % (for Percentage-Quoted SEC)
36	MARKET_PC_MEAN_UNITS	☐	FTI_IMPAIR_KURSBW_MEAN	VVPKTKUR	DEC	15	6	Mean Market Price/Unit in Postion Currency (Unit-Quoted SEC)
37	KEY_DATE_FLAG	☐	FTI_IMPAIR_KEY_DATE_FLAG	XFELD	CHAR	1	0	Flag Selection Criteria 1: Compare on Key Date
38	KEY_DATE_FLAG_TEXT	☐	FTI_IMPAIR_KEY_DATE_FLAG_TEXT	FTI_CHAR16LOW	CHAR	16	0	Flag Selection Criteria 1: Compare on Key Date
39	KEY_DATE_BARRIER	☐	FTI_IMPAIR_BARRIER		DEC	5	2	Selection Criteria 1: Limit in % (Impairment)
40	KEY_DATE_RESULT	☐	FTI_IMPAIR_BARRIER_RES		DEC	5	2	Selection Criteria 1: Relation in %
41	KEY_DATE_FLAG_M	☐	FTI_IMPAIR_KEY_DATE_FLAG_M	XFELD	CHAR	1	0	Flag Selection Criteria 2: Compare Average Val.and Key Date
42	KEY_DATE_FLAG_M_TEXT	☐	FTI_IMPAIR_KEY_DATE_FLAG_M_TEX	FTI_CHAR16LOW	CHAR	16	0	Flag Selection Criteria 2: Compare Average Val.and Key Date
43	KEY_DATE_BARRIER_M	☐	FTI_IMPAIR_BARRIER_MEAN		DEC	5	2	Selection Criteria 2: Limit Averaged in % (Impairment)
44	KEY_DATE_RESULT_M	☐	FTI_IMPAIR_BARRIER_RES_MEAN		DEC	5	2	Selection Criteria 2: Relation Averaged Market Value in %
45	PERIOD_FLAG	☐	FTI_IMPAIR_PERIOD_FLAG	XFELD	CHAR	1	0	Indicator Selection Criteria 3: Comparison for Period
46	PERIOD_FLAG_TEXT	☐	FTI_IMPAIR_PERIOD_FLAG_TEXT	FTI_CHAR16LOW	CHAR	16	0	Indicator Selection Criteria 3: Comparison for Period
47	PERIOD_BARRIER	☐	FTI_IMPAIR_BARRIER_MAX		DEC	5	2	Selection Criteria 3: Limit Maximum in % (Impairment)
48	PERIOD_RESULT	☐	FTI_IMPAIR_BARRIER_RES_MAX		DEC	5	2	Selection Criteria 3: Relation Maximum in %
49	WARN	☐	FTI_IMPAIR_WARN	CHAR1	CHAR	1	0	Result for Selection Report Impairment
50	EXPORT	☐	FTI_IMPAIR_EXPORT	XFELD	CHAR	1	0	Flag for Exporting Positions for Impairment
51	AMAQU_VAL_PC	☐	FTI_AMAQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Amortized Acquisition Value in Position Currency
52	AMAQU_VAL_VC	☐	FTI_AMAQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Amortized Acquisition Value in Valuation Currency
53	BOOK_VAL_PC	☐	FTI_BOOK_VAL_PC	TPM_AMOUNT	CURR	21	2	Book Value in Position Currency
54	BOOK_VAL_VC	☐	FTI_BOOK_VAL_VC	TPM_AMOUNT	CURR	21	2	Book Value in Valuation Currency
55	IMPMNT_PC	☐	FTI_IMPMNT_PC	TPM_AMOUNT	CURR	21	2	Impairment in Position Currency
56	IMPMNT_VC	☐	FTI_IMPMNT_VC	TPM_AMOUNT	CURR	21	2	Impairment in Valuation Currency
57	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
58	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	*
59	VVRANLWX	☐	VVRANLWX	CHAR20	CHAR	20	0	Secondary index class data
60	MAX_RATE	☐	VVPKTKUR_MAX	VVPKTKUR	DEC	15	6	Maximum Rate of Unit/Percentage-Quoted Security
61	MAX_RATE_DATE	☐	DKURS_MAX	DATUM	DATS	8	0	Rate Date: Maximum Rate
62	MIN_RATE	☐	VVPKTKUR_MIN	VVPKTKUR	DEC	15	6	Minimum Rate of Unit/Percentage-Quoted Security
63	MIN_RATE_DATE	☐	DKURS_MIN	DATUM	DATS	8	0	Rate Date: Minimum Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_S_REP_CHECK_IMPAIRMENT	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
2	FTI_S_REP_CHECK_IMPAIRMENT	BUKRS	T001	BUKRS
3	FTI_S_REP_CHECK_IMPAIRMENT	EXCHANGE_NC_PC	TCURV	KURST
4	FTI_S_REP_CHECK_IMPAIRMENT	EXCHANGE_PC_VC	TCURV	KURST
5	FTI_S_REP_CHECK_IMPAIRMENT	GSART	TZPA	GSART
6	FTI_S_REP_CHECK_IMPAIRMENT	MANDT	T000	MANDT
7	FTI_S_REP_CHECK_IMPAIRMENT	MARKET_PLACE	TWH01	RHANDPL
8	FTI_S_REP_CHECK_IMPAIRMENT	PC_CURRENCY	TCURC	WAERS
9	FTI_S_REP_CHECK_IMPAIRMENT	PORTFOLIO	TWPOB	RPORTB
10	FTI_S_REP_CHECK_IMPAIRMENT	RATE_INDICATOR	TW56	SKURSART
11	FTI_S_REP_CHECK_IMPAIRMENT	SECURITY_ACCOUNT	TWD01	RLDEPO
12	FTI_S_REP_CHECK_IMPAIRMENT	SECURITY_ID	VWPANLA	RANL
13	FTI_S_REP_CHECK_IMPAIRMENT	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
14	FTI_S_REP_CHECK_IMPAIRMENT	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS
15	FTI_S_REP_CHECK_IMPAIRMENT	VC_CURRENCY	TCURC	WAERS

History

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