SAP ABAP Table FTI_LDB_TR_PERIOD_FLOWS (Treasury: Flow Information)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI_LDB (Package) Logical Databases for the R/3 CFM Information System

Basic Data

Table Category	INTTAB	Structure
Structure	FTI_LDB_TR_PERIOD_FLOWS	Table Relationship Diagram
Short Description	Treasury: Flow Information

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	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
3	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
6	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
7	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
8	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
11	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
12	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
13	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	VTBFHA
14	HEDGE_ID	☐	THM_HEDGE_ID	THM_HEDGE_ID	NUMC	10	0	Hedge Item Identification Number	*
15	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
16	SECURITY_ACCOUNT	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
17	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
18	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
19	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
20	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
21	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
22	LOTGENERATION_USER	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
23	LOTGENERATION_BUSTRANSCAT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
24	LOTPOS_INIT_DATE	☐	FTI_LOTPOSITION_INIT_DATE	TPM_POSITION_DATE	DATS	8	0	Position Acquisition Date of a Lot
25	LOTPOS_ORG_DATE	☐	FTI_LOTPOSITION_ORG_DATE	TPM_POSITION_DATE	DATS	8	0	Original Position Acquisition Date of a Lot
26	LOTGEN_BUKRS	☐	FTI_LOTGENERATION_BUKRS	BUKRS	CHAR	4	0	Company Code of Lot-Generating Transaction	*
27	LOTGEN_DEALNR	☐	FTI_LOTGENERATION_DEALNR	T_RFHA	CHAR	13	0	Lot-Generating Transaction Number	*
28	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
29	RANTYP_R	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
30	RREFKONT_R	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
31	ACC_ASS_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
32	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
33	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
34	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
35	RLZTG_F	☐	FTI_RLZTG_F	NUMC5	NUMC	5	0	Remaining Term in Days
36	RLZMO_F	☐	FTI_RLZMO_F	NUMC4	NUMC	4	0	Remaining Term in Months
37	RLZJA_F	☐	FTI_RLZJA_F	NUMC3	NUMC	3	0	Remaining Term in Years
38	UEBTG_F	☐	FTI_UEBTG_F	NUMC5	NUMC	5	0	Overdue Period in Days
39	UEBMO_F	☐	FTI_UEBMO_F	NUMC3	NUMC	3	0	Overdue Period in Months
40	UEBJA_F	☐	FTI_UEBJA_F	NUMC2	NUMC	2	0	Overdue Period in Years
41	.INCLUDE	☐				0	0	Include for Data of Commitment Partner (->LDBs)
42	.INCLUDE	☐				0	0	Treasury: Commitment Partner
43	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
44	.INCLUDE	☐				0	0	Treasury: Partner Attributes
45	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
46	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
47	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
48	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	*
49	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	*
50	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
51	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	*
52	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	*
53	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
54	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	*
55	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	*
56	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
57	.INCLUDE	☐				0	0	Business partner credit standing data
58	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
59	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
60	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	*
61	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
62	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
63	.INCLUDE	☐				0	0	Include for Transaction Attributes Rel. for Position (->LDB)
64	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
65	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
66	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	*
67	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	*
68	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
69	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
70	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
71	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
72	PORTFOLIO_TM	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
73	RDPBANK	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	BUT000
74	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
75	.INCLUDE	☐				0	0	Include for Time-Dependent Class Data (-> LDBs)
76	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
77	ALWPKL	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	*
78	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	*
79	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	*
80	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	*
81	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	*
82	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
83	SFOART	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
84	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	*
85	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	*
86	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
87	VVRANLWX	☐	VVRANLWXS	CHAR20S	CHAR	20	0	Secondary index class data
88	AAAAKTIE_E	☐	FTI_AAAKTIE_E	DEC12	DEC	12	0	Number of Stocks Issued: End
89	KBNEWE_E	☐	FTI_VVBNEWE_E	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
90	KZAHLAKT_E	☐	FTI_KZAHLAKT_E	DEC3_7	DEC	10	7	Pay-in rate
91	PKOND_E	☐	FTI_PKOND_E	DECV3_7	DEC	10	7	Interest rate - end
92	BKOND_E	☐	FTI_BKOND_E	WERTV7	CURR	13	2	Interest Rate as Amount: End
93	PEFFZINS_E	☐	FTI_PEFFZINS_E	DEC3_7	DEC	10	7	Effective Interest Rate at End of Period
94	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	TCURC
95	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
96	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
97	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
98	NOTWAERS	☐	VVNOTWAERS	WAERS	CUKY	5	0	Quotation currency (which prices are in)	TCURC
99	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	TCURC
100	WVERB1	☐	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	*
101	WFORD1	☐	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	*
102	DBEWEG	☐	DBEWEG	DATUM	DATS	8	0	Flow Date
103	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
104	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
105	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
106	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
107	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
108	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
109	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
110	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
111	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
112	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
113	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
114	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	*
115	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
116	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
117	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
118	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
119	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
120	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
121	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
122	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
123	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
124	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
125	.INCLUDE	☐				0	0	Include for FI Document Data/Filling FI Document Data ->LDB
126	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
127	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
128	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	SKB1
129	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	SKB1
130	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
131	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
132	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
133	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
134	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
135	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
136	BUCHST	☐	BUCHST_CFM	BUCHST_CFM	CHAR	1	0	Posting Status of Flow for CFM (Operative Only)
137	TRL_BOOKINGSTATE	☐	BUCHST_CFM_PAR	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Position Status of Flow for CFM (Parallel Only)
138	LEDGER_POSTING_STATE	☐	FTR_LEDGER_POSTING_STATE	FTR_LEDGER_POSTING_STATE	CHAR	1	0	Ledger Posting Status
139	SBEWART_R	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
140	FLOW_TYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
141	GSVGANG	☐	GSVGANG	GSVGANG	NUMC	3	0	TR transaction activity for securities
142	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
143	GEN_BUSTRANSCAT	☐	FTI_GENERATING_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Generating Business Transaction Category	TRDTS_BT_CAT
144	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
145	BUSTRANSID	☐	FTI_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
146	TRLFLOWNUMBER	☐	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
147	QUANT_CAT	☐	FTI_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
148	AMOUNT_CAT	☐	FTI_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category	TRLTS_PMCAT
149	PL_CATEGORY	☐	TPM_PL_CATEGORY	TPM_PL_CATEGORY	CHAR	3	0	P/L Type	TRGC_PL_CATE
150	KMNR	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	VWKMKO
151	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
152	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	TCURC
153	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
154	D_UNITS	☐	FTI_D_UNITS	TPM_UNITS	DEC	22	6	Delta Number of Units
155	D_NOMINAL_AMT_PC	☐	FTI_D_NOMINAL_AMT_PC	TPM_AMOUNT	CURR	21	2	Delta Nominal Amount in Position Currency
156	D_NOMINAL_ORG_AMT_PC	☐	FTI_D_NOMINAL_ORG_AMT_PC	TPM_AMOUNT	CURR	21	2	Delta: Original Nominal Amount in Position Currency
157	D_PURCH_PC	☐	FTI_D_PURCH_PC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Position Currency
158	D_PURCH_LC	☐	FTI_D_PURCH_LC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Local Currency
159	D_PURCH_VC	☐	FTI_D_PURCH_VC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Valuation Currency
160	D_PURCH_DC	☐	FTI_D_PURCH_DC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Display Currency (From Pos. Crcy)
161	D_AQU_VAL_PC	☐	FTI_D_AQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Position Currency
162	D_AQU_VAL_LC	☐	FTI_D_AQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Local Currency
163	D_AQU_VAL_VC	☐	FTI_D_AQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Valuation Currency
164	D_AQU_VAL_DC	☐	FTI_D_AQU_VAL_DC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Display Currency (From Pos. Crcy)
165	D_BOOK_VAL_PC	☐	FTI_D_BOOK_VAL_PC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Position Currency
166	D_BOOK_VAL_LC	☐	FTI_D_BOOK_VAL_LC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Local Currency
167	D_BOOK_VAL_VC	☐	FTI_D_BOOK_VAL_VC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Valuation Currency
168	D_BOOK_VAL_DC	☐	FTI_D_BOOK_VAL_DC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Display Currency (From Position Crcy)
169	D_CHARGE_PC	☐	FTI_D_CHARGE_PC	TPM_AMOUNT	CURR	21	2	Delta Costs in Position Currency
170	D_CHARGE_LC	☐	FTI_D_CHARGE_LC	TPM_AMOUNT	CURR	21	2	Delta Costs in Local Currency
171	D_CHARGE_VC	☐	FTI_D_CHARGE_VC	TPM_AMOUNT	CURR	21	2	Delta Costs in Valuation Currency
172	D_CHARGE_DC	☐	FTI_D_CHARGE_DC	TPM_AMOUNT	CURR	21	2	Delta Costs in Display Currency (From Position Currency)
173	D_BOOK_VAL_EX_PC	☐	FTI_D_BOOK_VAL_EX_PC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Position Currency
174	D_BOOK_VAL_EX_LC	☐	FTI_D_BOOK_VAL_EX_LC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Local Currency
175	D_BOOK_VAL_EX_VC	☐	FTI_D_BOOK_VAL_EX_VC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Valuation Currency
176	D_BOOK_VAL_EX_DC	☐	FTI_D_BOOK_VAL_EX_DC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Display Currency (From PC)
177	D_VAL_TI_PC	☐	FTI_D_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Position Currency
178	D_VAL_TI_LC	☐	FTI_D_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Local Currency
179	D_VAL_TI_VC	☐	FTI_D_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Valuation Currency
180	D_VAL_TI_DC	☐	FTI_D_VAL_TI_DC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Display Currency (From Pos.Crcy)
181	D_VAL_FX_LC	☐	FTI_D_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation in Local Currency
182	D_VAL_FX_VC	☐	FTI_D_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation in Valuation Currency
183	D_VAL_CH_TI_PC	☐	FTI_D_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Security, in PC
184	D_VAL_CH_TI_LC	☐	FTI_D_VAL_CH_TI_LC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Security, in LC
185	D_VAL_CH_TI_VC	☐	FTI_D_VAL_CH_TI_VC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Security, in VC
186	D_VAL_CH_TI_DC	☐	FTI_D_VAL_CH_TI_DC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Sec., in DC (from PC)
187	D_VAL_CH_FX_LC	☐	FTI_D_VAL_CH_FX_LC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, FX, in Local Currency
188	D_VAL_CH_FX_VC	☐	FTI_D_VAL_CH_FX_VC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, FX, in Valuation Crcy
189	D_AMORT_PC	☐	FTI_D_AMORT_PC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Position Currency
190	D_AMORT_LC	☐	FTI_D_AMORT_LC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Local Currency
191	D_AMORT_VC	☐	FTI_D_AMORT_VC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Valuation Currency
192	D_AMORT_DC	☐	FTI_D_AMORT_DC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Display Currency (From Position Crcy)
193	D_IMPMNT_PC	☐	FTI_D_IMPMNT_PC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Position Currency
194	D_IMPMNT_LC	☐	FTI_D_IMPMNT_LC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Local Currency
195	D_IMPMNT_VC	☐	FTI_D_IMPMNT_VC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Valuation Currency
196	D_IMPMNT_DC	☐	FTI_D_IMPMNT_DC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Display Currency
197	D_REPAYMENT_PC	☐	FTI_D_REPAYMENT_PC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Position Currency
198	D_REPAYMENT_LC	☐	FTI_D_REPAYMENT_LC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Local Currency
199	D_REPAYMENT_VC	☐	FTI_D_REPAYMENT_VC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Valuation Currency
200	D_REPAYMENT_DC	☐	FTI_D_REPAYMENT_DC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Display Currency
201	D_AMAQU_VAL_PC	☐	FTI_D_AMAQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Position Currency
202	D_AMAQU_VAL_LC	☐	FTI_D_AMAQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Local Currency
203	D_AMAQU_VAL_VC	☐	FTI_D_AMAQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Valuation Currency
204	D_AMAQU_VAL_DC	☐	FTI_D_AMAQU_VAL_DC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Display Currency
205	D_DISAGIO_PC	☐	FTI_D_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Position Currency
206	D_DISAGIO_LC	☐	FTI_D_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Local Currency
207	D_DISAGIO_VC	☐	FTI_D_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Valuation Currency
208	D_DISAGIO_DC	☐	FTI_D_DISAGIO_DC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Display Currency
209	D_VAL_TI_NPL_PC	☐	FTI_D_VAL_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in Pos. Crcy
210	D_VAL_TI_NPL_LC	☐	FTI_D_VAL_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in Local Crcy
211	D_VAL_TI_NPL_VC	☐	FTI_D_VAL_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in Val. Crcy
212	D_VAL_TI_NPL_DC	☐	FTI_D_VAL_TI_NPL_DC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in DC (From PC)
213	D_VAL_FX_NPL_LC	☐	FTI_D_VAL_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation, Not Affecting P/L, in LC
214	D_VAL_FX_NPL_VC	☐	FTI_D_VAL_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation, Not Affecting P/L, in VC
215	D_VAL_CH_TI_NPL_PC	☐	FTI_D_VAL_CH_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy
216	D_VAL_CH_TI_NPL_LC	☐	FTI_D_VAL_CH_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy
217	D_VAL_CH_TI_NPL_VC	☐	FTI_D_VAL_CH_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, Valuation Crcy
218	D_VAL_CH_TI_NPL_DC	☐	FTI_D_VAL_CH_TI_NPL_DC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in DC (from PC)
219	D_VAL_CH_FX_NPL_LC	☐	FTI_D_VAL_CH_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy
220	D_VAL_CH_FX_NPL_VC	☐	FTI_D_VAL_CH_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy
221	D_VARMAR_PC	☐	FTI_D_VARMAR_PC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Position Currency
222	D_VARMAR_LC	☐	FTI_D_VARMAR_LC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Local Currency
223	D_VARMAR_VC	☐	FTI_D_VARMAR_VC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Valuation Currency
224	D_VARMAR_DC	☐	FTI_D_VARMAR_DC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Display Currency
225	D_SPOTVALP_LC	☐	FTI_D_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Purchase Crcy in Local Currency
226	D_SPOTVALP_VC	☐	FTI_D_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Purchase Crcy in Valuation Currency
227	D_SPOTVALS_LC	☐	FTI_D_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Sale Currency in Local Currency
228	D_SPOTVALS_VC	☐	FTI_D_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Sale Currency in Valuation Currency
229	D_SWAPACC_PC	☐	FTI_D_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Position Currency
230	D_SWAPACC_LC	☐	FTI_D_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Local Currency
231	D_SWAPACC_VC	☐	FTI_D_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Valuation Currency
232	D_SWAPACC_DC	☐	FTI_D_SWAPACC_DC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Display Currency
233	D_SWAPVAL_LC	☐	FTI_D_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Delta Swap Valuation in Local Currency
234	D_SWAPVAL_VC	☐	FTI_D_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Delta Swap Valuation in Valuation Currency
235	CF_CC	☐	FTI_PAYAMOUNT_PYC	TPM_AMOUNT	CURR	21	2	Payment amount in payment currency
236	CF_LC	☐	FTI_PAYAMOUNT_LC	TPM_AMOUNT	CURR	21	2	Payment Amount in Local Currency
237	CF_DC	☐	FTI_PAYAMOUNT_DC	TPM_AMOUNT	CURR	21	2	Payment Amount in Display Currency
238	PL_PC	☐	FTI_PLAMOUNT_PLC	TPM_AMOUNT	CURR	21	2	Profit/loss amount in profit/loss currency
239	PL_LC	☐	FTI_PLAMOUNT_LC	TPM_AMOUNT	CURR	21	2	Profit/loss amount in local currency
240	PL_DC	☐	FTI_PLAMOUNT_DC	TPM_AMOUNT	CURR	21	2	Profit/Loss Amount in Display Currency
241	PABGERF_PC	☐	FTI_PERACC_PLC	TPM_AMOUNT	CURR	21	2	Revenue Accrued/Deferred in Profit/Loss Currency
242	PABGERF_VC	☐	FTI_PERACC_VC	TPM_AMOUNT	CURR	21	2	Period-Based Revenue Accrued/Deferred in Valuation Currency
243	PABGERF_LC	☐	FTI_PERACC_LC	TPM_AMOUNT	CURR	21	2	Revenue Accrued/Deferred in Local Currency
244	PABGERF_DC	☐	FTI_PERACC_DC	TPM_AMOUNT	CURR	21	2	Revenue Accrued/Deferred in Display Currency
245	D_AMOUNT_PC	☐	FTI_D_AMOUNT_PC	TPM_AMOUNT	CURR	21	2	Flow Amount in Position Currency
246	D_AMOUNT_VC	☐	FTI_D_AMOUNT_VC	TPM_AMOUNT	CURR	21	2	Flow Amount in Valuation Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_LDB_TR_PERIOD_FLOWS	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
2	FTI_LDB_TR_PERIOD_FLOWS	ACC_ASS_REF	TRACC_AA_REF	AA_REF
3	FTI_LDB_TR_PERIOD_FLOWS	AMOUNT_CAT	TRLTS_PMCAT	AMOUNT_CAT
4	FTI_LDB_TR_PERIOD_FLOWS	ANZGW	TCURC	WAERS
5	FTI_LDB_TR_PERIOD_FLOWS	BUKRS	T001	BUKRS
6	FTI_LDB_TR_PERIOD_FLOWS	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
7	FTI_LDB_TR_PERIOD_FLOWS	DEAL_NUMBER	VTBFHA	RFHA
8	FTI_LDB_TR_PERIOD_FLOWS	FLOW_TYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE
9	FTI_LDB_TR_PERIOD_FLOWS	GEN_BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
10	FTI_LDB_TR_PERIOD_FLOWS	GL_ACCOUNT_C	SKB1	SAKNR
11	FTI_LDB_TR_PERIOD_FLOWS	GL_ACCOUNT_D	SKB1	SAKNR
12	FTI_LDB_TR_PERIOD_FLOWS	GSART	TZPA	GSART
13	FTI_LDB_TR_PERIOD_FLOWS	HKONT	SKB1	SAKNR
14	FTI_LDB_TR_PERIOD_FLOWS	ISTYPE	TB038	ISTYPE
15	FTI_LDB_TR_PERIOD_FLOWS	KMNR	VWKMKO	KMNR
16	FTI_LDB_TR_PERIOD_FLOWS	LAND1	T005	LAND1
17	FTI_LDB_TR_PERIOD_FLOWS	LOANS_CONTRACT	VDARL	RANL
18	FTI_LDB_TR_PERIOD_FLOWS	MANDT	T000	MANDT
19	FTI_LDB_TR_PERIOD_FLOWS	NOTWAERS	TCURC	WAERS
20	FTI_LDB_TR_PERIOD_FLOWS	PARTNR	BUT000	PARTNER
21	FTI_LDB_TR_PERIOD_FLOWS	PL_CATEGORY	TRGC_PL_CATE	PL_CATEGORY
22	FTI_LDB_TR_PERIOD_FLOWS	PORTFOLIO	TWPOB	RPORTB		1	CN
23	FTI_LDB_TR_PERIOD_FLOWS	PORTFOLIO_TM	TWPOB	RPORTB
24	FTI_LDB_TR_PERIOD_FLOWS	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT
25	FTI_LDB_TR_PERIOD_FLOWS	PRKEY	PAYRQ	KEYNO		C	CN
26	FTI_LDB_TR_PERIOD_FLOWS	RAHABKI	T012	HBKID
27	FTI_LDB_TR_PERIOD_FLOWS	RAHKTID	T012K	HKTID
28	FTI_LDB_TR_PERIOD_FLOWS	RDPBANK	BUT000	PARTNER
29	FTI_LDB_TR_PERIOD_FLOWS	RREFKONT_R	T037S	RREFKONT
30	FTI_LDB_TR_PERIOD_FLOWS	SANLF	TZAF	SANLF
31	FTI_LDB_TR_PERIOD_FLOWS	SBEWART_R	TZB0A	SBEWART
32	FTI_LDB_TR_PERIOD_FLOWS	SBILK	TW11	SBILK
33	FTI_LDB_TR_PERIOD_FLOWS	SBWHR	TCURC	WAERS
34	FTI_LDB_TR_PERIOD_FLOWS	SECURITY_ACCOUNT	TWD01	RLDEPO
35	FTI_LDB_TR_PERIOD_FLOWS	SECURITY_ID	VWPANLA	RANL
36	FTI_LDB_TR_PERIOD_FLOWS	SHWHR	TCURC	WAERS
37	FTI_LDB_TR_PERIOD_FLOWS	SPLWHR	TCURC	WAERS		C	CN
38	FTI_LDB_TR_PERIOD_FLOWS	SWHRKOND	TCURC	WAERS
39	FTI_LDB_TR_PERIOD_FLOWS	TR_ACC_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
40	FTI_LDB_TR_PERIOD_FLOWS	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
41	FTI_LDB_TR_PERIOD_FLOWS	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS
42	FTI_LDB_TR_PERIOD_FLOWS	WZBETR	TCURC	WAERS
43	FTI_LDB_TR_PERIOD_FLOWS	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in	110