SAP ABAP Table FTI_LDB_TR_CASH_FLOWS (Treasury: Payment 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_CASH_FLOWS   Table Relationship Diagram
Short Description Treasury: Payment 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 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
3 LAND1 FTI_LAND1 LAND1 CHAR 3   0   Country key of company code T005
4 GSART VVSART VVSART CHAR 3   0   Product Type TZPA
5 PORTFOLIO TPM_PORTFOLIO_DIFF RPORTB CHAR 10   0   Portfolio as Differentiation Characteristic TWPOB
6 SECURITY_ID VVRANLW WP_RANL CHAR 13   0   Security ID Number VWPANLA
7 LOANS_CONTRACT RANL RANL CHAR 13   0   Contract Number VDARL
8 DEAL_NUMBER FTI_POSRFHA T_RFHA CHAR 13   0   Financial Transaction That Creates a Position VTBFHA
9 ACCOUNT_GROUP TPM_SEC_ACCT_GRP TPM_SEC_ACCT_GRP CHAR 10   0   Securities Account Group TRGT_SECACCGRP
10 SECURITY_ACCOUNT VRLDEPO RLDEPO CHAR 10   0   Securities Account TWD01
11 POSITION_ACCOUNT TPM_POS_ACCOUNT_FUT TPM_POS_ACCOUNT_FUT CHAR 10   0   Futures Account for Listed Options and Futures TRFT_POS_ACCOUNT
12 FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT TPM_FLAG_LONG_SHORT CHAR 1   0   Indicator: Long or Short Position  
13 LOT_ID TPM_LOT_ID SYSUUID RAW 16   0   Identifier of the Lot  
14 DLOTGENERATION DLOTGENERATION DATUM DATS 8   0   Date On Which Lot Was Generated  
15 TLOTGENERATION TLOTGENERATION UZEIT TIMS 6   0   Lot Generation Time  
16 LOTGENERATION_USER FTI_LOTGENERATIONUSER SYCHAR12 CHAR 12   0   Lot Entered By  
17 LOTGENERATION_BUSTRANSCAT FTI_LOTGENERATION_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category Which Generated the Lot *
18 LOTPOS_INIT_DATE FTI_LOTPOSITION_INIT_DATE TPM_POSITION_DATE DATS 8   0   Position Acquisition Date of a Lot  
19 LOTPOS_ORG_DATE FTI_LOTPOSITION_ORG_DATE TPM_POSITION_DATE DATS 8   0   Original Position Acquisition Date of a Lot  
20 LOTGEN_BUKRS FTI_LOTGENERATION_BUKRS BUKRS CHAR 4   0   Company Code of Lot-Generating Transaction *
21 LOTGEN_DEALNR FTI_LOTGENERATION_DEALNR T_RFHA CHAR 13   0   Lot-Generating Transaction Number *
22 SANLF SANLF VVSANLF NUMC 3   0   Product Category TZAF
23 RANTYP_R RANTYP RANTYP CHAR 1   0   Contract Type  
24 DBLFZ DBLFZ DATUM DATS 8   0   Start of Term  
25 DELFZ DELFZ DATUM DATS 8   0   End of Term  
26 RLZTG_F FTI_RLZTG_F NUMC5 NUMC 5   0   Remaining Term in Days  
27 RLZMO_F FTI_RLZMO_F NUMC4 NUMC 4   0   Remaining Term in Months  
28 RLZJA_F FTI_RLZJA_F NUMC3 NUMC 3   0   Remaining Term in Years  
29 UEBTG_F FTI_UEBTG_F NUMC5 NUMC 5   0   Overdue Period in Days  
30 UEBMO_F FTI_UEBMO_F NUMC3 NUMC 3   0   Overdue Period in Months  
31 UEBJA_F FTI_UEBJA_F NUMC2 NUMC 2   0   Overdue Period in Years  
32 .INCLUDE       0   0   Include for Data of Commitment Partner (->LDBs)  
33 .INCLUDE       0   0   Treasury: Commitment Partner  
34 PARTNR FTI_LDB_RISK_COUNTERPARTY BU_PARTNER CHAR 10   0   Partner with Whom Commitment Exists BUT000
35 .INCLUDE       0   0   Treasury: Partner Attributes  
36 TYPE BP_TYPE_NEW BU_TYPE CHAR 1   0   Business Partner Category  
37 ISTYPE BU_ISTYPE BU_ISTYPE CHAR 4   0   Industry System TB038
38 IND_SECTOR BU_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry *
39 CNTRY_COMP FTI_LANDBP LAND1 CHAR 3   0   Country of Registered Office of Business Partner *
40 LEGAL_ENTY BP_LEG_ETY_NEW BU_LEGENTY CHAR 2   0   Legal Form of Organization *
41 LEGAL_ORG BU_LEGAL_ORG_NEW BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization *
42 NATION BP_CNTR_N LAND1 CHAR 3   0   Nationality *
43 STATE BP_CNTR_ST LAND1 CHAR 3   0   Citizenship *
44 GROUP_ID BU_GRP_ID_NEW BU_GROUP CHAR 4   0   Business Partner Grouping *
45 GROUP_D BP_GROUP_D BP_GROUP_D CHAR 4   0   Target Group *
46 STAFF_GRP BP_STAFF_G BP_STAFF_G CHAR 4   0   Employee Group *
47 COMP_RE BP_COMP_RE BP_COMP_RE CHAR 1   0   Organization Relationship  
48 .INCLUDE       0   0   Business partner credit standing data  
49 SOLVNCY BP_SOLVNCY BP_SOLVNCY CHAR 1   0   Credit Standing  
50 RATING BP_RATING BP_RATING CHAR 3   0   Rating *
51 SOL_INS BP_SOL_INS BP_SOL_INS CHAR 4   0   Institute Providing Credit Standing Information *
52 SOL_INF BP_SOL_INF BP_SOL_INF CHAR 1   0   Status of Credit Standing Information  
53 SOL_I_D BP_SOL_I_D DATUM DATS 8   0   Date of Credit Standing Information  
54 .INCLUDE       0   0   Include for Counterparty Data  
55 .INCLUDE       0   0   Treasury: Commitment Partner  
56 RKONTRA RKONTRA_NEW BU_PARTNER CHAR 10   0   Reference to Counterparty BUT000
57 .INCLUDE       0   0   Treasury: Partner Attributes (Counterparty)  
58 TYPE_K FTI_BP_KONTR_TYPE BU_TYPE CHAR 1   0   Counterparty Category  
59 ISTYPE_K FTI_BP_KONTR_ISTYPE BU_ISTYPE CHAR 4   0   Industry System of Counterparty TB038
60 IND_SECTOR_K FTI_BP_KONTR_IND_SECTOR BU_INDSECTOR CHAR 10   0   Industry Sector of Counterparty TB038A
61 CNTRY_COMP_K FTI_BP_KONTR_LANDBP LAND1 CHAR 3   0   Country of Registered Office of Counterparty T005
62 LEGAL_ENTY_K FTI_BP_KONTR_LEG_ETY BU_LEGENTY CHAR 2   0   Legal Form of Organization of Counterparty TB019
63 LEGAL_ORG_K FTI_BP_KONTR_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization of Counterparty TB032
64 NATION_K FTI_BP_KONTR_CNTR_N LAND1 CHAR 3   0   Nationality of Counterparty T005
65 STATE_K FTI_BP_KONTR_CNTR_ST LAND1 CHAR 3   0   Citezenship of Counterparty T005
66 GROUP_ID_K FTI_BP_KONTR_GRP_ID BU_GROUP CHAR 4   0   Grouping of Counterparty TB001
67 GROUP_D_K FTI_BP_KONTR_GROUP_D BP_GROUP_D CHAR 4   0   Target Group of Counterparty TP13
68 STAFF_GRP_K FTI_BP_KONTR_STAFF_G BP_STAFF_G CHAR 4   0   Employee Group - Counterparty TP05
69 COMP_RE_K FTI_BP_KONTR_COMP_RE BP_COMP_RE CHAR 1   0   Company Relationship of Counterparty  
70 .INCLUDE       0   0   Business Partner Credit Standing Data (Counterparty)  
71 SOLVNCY_K FTI_BP_KONTR_SOLVNCY BP_SOLVNCY CHAR 1   0   Credit Standing of Counterparty  
72 RATING_K FTI_BP_KONTR_RATING BP_RATING CHAR 3   0   Rating of Counterparty TP06
73 .INCLUDE       0   0   Include for Transaction Attributes Rel. for Position (->LDB)  
74 SFHAART TB_SFHAART T_SFHAART CHAR 3   0   Financial Transaction Type *
75 FINPROJ TB_TFPROJ T_TFPROJ CHAR 13   0   Finance Project  
76 RMAID TB_RMAID T_RMAID CHAR 10   0   Master Agreement *
77 RGARANT TB_RGARANT_NEW BU_PARTNER CHAR 10   0   Guarantor of Financial Transaction *
78 NORDEXT TB_NORDEXT FTI_CHAR16LOW CHAR 16   0   External Reference  
79 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
80 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
81 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
82 PORTFOLIO_TM RPORTB RPORTB CHAR 10   0   Portfolio TWPOB
83 RDPBANK RDEPOTBANK BU_PARTNER CHAR 10   0   Depository Bank BUT000
84 SECACC_TYPE TPM_SECACC_TYPE TPM_SECACC_TYPE CHAR 3   0   Securities Account Type TRSC_SECACC_TYPE
85 SECACC_CAT TPM_SECACC_CAT TPM_SECACC_CAT CHAR 1   0   Securities Account Category  
86 .INCLUDE       0   0   Include for Time-Dependent Class Data (-> LDBs)  
87 SNOTI SNOTI SNOTI NUMC 1   0   Quotation Indicator  
88 ALWPKL ALWPKL ALWPKL CHAR 3   0   General Security Classification *
89 SWERTTYP SWERTTYP SAKTTYP NUMC 1   0   Security Type ID *
90 SOL_INS_RANL FTI_SOL_INS_RANL BP_SOL_INS CHAR 4   0   Institut Supplying Credit Rating Information for Secur. ID *
91 RATING_RANL BP_RATING_RANL BP_RATING CHAR 3   0   Rating for Securities ID Number/OTC Transaction *
92 SWPKLASS SWPKLASS SWPKLASS NUMC 3   0   Classification of bond *
93 SAKAR SAKAR SAKAR NUMC 1   0   Stock category  
94 SFOART VVSFOART VVSFOART CHAR 2   0   Fund category indicator  
95 SFOTY SFOTY SFOTY NUMC 1   0   Fund type indicator *
96 SARTBET SARTBET SARTBET NUMC 2   0   Type of shareholding *
97 SBOERNOT SBOERNOT JANEI CHAR 1   0   Indicator: Listed on an Exchange  
98 VVRANLWX VVRANLWXS CHAR20S CHAR 20   0   Secondary index class data  
99 AAAAKTIE_E FTI_AAAKTIE_E DEC12 DEC 12   0   Number of Stocks Issued: End  
100 KZAHLAKT_E FTI_KZAHLAKT_E DEC3_7 DEC 10   7   Pay-in rate  
101 PKOND_E FTI_PKOND_E DECV3_7 DEC 10   7   Interest rate - end  
102 PEFFZINS_E FTI_PEFFZINS_E DEC3_7 DEC 10   7   Effective Interest Rate at End of Period  
103 SHWHR TB_SHWHR WAERS CUKY 5   0   Local Currency TCURC
104 SBWHR TB_BWHR WAERS CUKY 5   0   Position Currency/Transaction Currency TCURC
105 ANZGW FTI_ANZGW WAERS CUKY 5   0   Display Currency TCURC
106 DBEWEG DBEWEG DATUM DATS 8   0   Flow Date  
107 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
108 DORDER DORDER DATUM DATS 8   0   Order day  
109 DDISPO DDISPO DATUM DATS 8   0   Payment Date  
110 DSCHLUSS VVDSCHLUSS DATUM DATS 8   0   Date of business closing  
111 DFAELL DFAELL DATUM DATS 8   0   Due date  
112 JAHR TB_JAHR GJAHR NUMC 4   0   Calendar year  
113 MONAT TB_MONAT TB_MONAT NUMC 2   0   Calendar month  
114 WOCHE FTI_WOCHE NUMC2 NUMC 2   0   Calendar Week  
115 MONAT_JAHR FTI_MONTH_YEAR MCPERIOD NUMC 6   0   Calendar Month/Year  
116 WOCHE_JAHR FTI_WEEK_YEAR MCPERIOD NUMC 6   0   Calendar Week/Year  
117 SE_DEAL_NUMBER FTI_SE_RFHA T_RFHA CHAR 13   0   Securities/Futures Transaction *
118 RHANDPL VVRHANDPL VVRHANDPL CHAR 10   0   Exchange *
119 JFDBUC FTI_FDBUC FTI_FDBUC CHAR 1   0   Relevance to CM  
120 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
121 ZWELS DZWELS ZWELS CHAR 10   0   List of the Payment Methods to be Considered  
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 RREFKONT_R TB_REFKONT USTRU CHAR 8   0   Acct Assignment Ref. for Operative Valn Area and Loan T037S
126 ACC_ASS_REF TPM_AA_REF_001 TPM_AA_REF CHAR 12   0   Acct Assignment Ref. in Pos. Mgmt for Val. Area 001 TRACC_AA_REF
127 .INCLUDE       0   0   Include for FI Document Data/Filling FI Document Data ->LDB  
128 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
129 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
130 GL_ACCOUNT_D FTI_GLACC_D SAKNR CHAR 10   0   Number of G/L Account: Debit SKB1
131 GL_ACCOUNT_C FTI_GLACC_C SAKNR CHAR 10   0   Number of G/L Account: Credit SKB1
132 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
133 DGJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
134 DMONAT MONAT MONAT NUMC 2   0   Fiscal period  
135 PERIO JAHRPER JAHRPER NUMC 7   0   Period/year  
136 RAHABKI TB_RAHABKI HBKID CHAR 5   0   Selling house bank T012
137 RAHKTID TB_RAHKTID HKTID CHAR 5   0   Selling house bank account T012K
138 BANKK_HB FTI_BANKK BANKK CHAR 15   0   Bank key of house bank  
139 BANKN_HB FTI_BANKN BANKN CHAR 18   0   Bank account number of house bank  
140 BANKK_BP FTI_BANKKP BANKK CHAR 15   0   Bank key of business partner bank  
141 BANKN_BP FTI_BANKNP BANKN CHAR 18   0   Bank account number of business partner  
142 RPBANK TB_RPBANK BVTYP CHAR 4   0   Partner bank details  
143 RPZAHL TB_RPZAHL_NEW BU_PARTNER CHAR 10   0   Payer/payee *
144 BUCHST BUCHST_TR BUCHST_TR CHAR 1   0   Posting status of flow for Treasury  
145 TRL_BOOKINGSTATE BUCHST_CFM_PAR TPM_TRL_BOOKINGSTATE CHAR 1   0   Position Status of Flow for CFM (Parallel Only)  
146 SBFREI TB_SBFREI XFELD CHAR 1   0   Release Given for Flow to Be Posted?  
147 SBEWART_R SBEWART SBEWART CHAR 4   0   Flow Type TZB0A
148 FLOW_TYPE TPM_DIS_FLOWTYPE TPM_DIS_FLOWTYPE CHAR 8   0   Update Type TRDC_DFLOWTYPE
149 BUSTRANSCAT TPM_BUSTRANSCAT TPM_BUSTRANSCAT NUMC 4   0   Business Transaction Category TRDTS_BT_CAT
150 SOURCETARGET_FLG TPM_SOURCE_TARGET_FLG TPM_SOURCE_TARGET_FLG CHAR 1   0   Indicator: Source or Target of a Flow  
151 KMNR KMNR VKMNR CHAR 13   0   Corporate Action Number VWKMKO
152 WZBETR TB_WZBETR WAERS CUKY 5   0   Payment 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 CF_CC FTI_PAYAMOUNT_PYC TPM_AMOUNT CURR 21   2   Payment amount in payment currency  
157 CF_LC FTI_PAYAMOUNT_LC TPM_AMOUNT CURR 21   2   Payment Amount in Local Currency  
158 CF_DC FTI_PAYAMOUNT_DC TPM_AMOUNT CURR 21   2   Payment Amount in Display Currency  
159 BUSTRANSID FTI_BUSTRANSID SYSUUID RAW 16   0   Identifier of the Distributor Business Transaction  
160 TRLFLOWNUMBER TPM_TRLFLOWNR TPM_TRLFLOW_NR INT4 10   0   Number of TRL Flow  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FTI_LDB_TR_CASH_FLOWS ACCOUNT_GROUP TRGT_SECACCGRP SEC_ACCT_GRP    
2 FTI_LDB_TR_CASH_FLOWS ACC_ASS_REF TRACC_AA_REF AA_REF    
3 FTI_LDB_TR_CASH_FLOWS ANZGW TCURC WAERS    
4 FTI_LDB_TR_CASH_FLOWS BUKRS T001 BUKRS    
5 FTI_LDB_TR_CASH_FLOWS BUSTRANSCAT TRDTS_BT_CAT BUSTRANSCAT    
6 FTI_LDB_TR_CASH_FLOWS CNTRY_COMP_K T005 LAND1    
7 FTI_LDB_TR_CASH_FLOWS DEAL_NUMBER VTBFHA RFHA    
8 FTI_LDB_TR_CASH_FLOWS FLOW_TYPE TRDC_DFLOWTYPE DIS_FLOWTYPE    
9 FTI_LDB_TR_CASH_FLOWS GL_ACCOUNT_C SKB1 SAKNR    
10 FTI_LDB_TR_CASH_FLOWS GL_ACCOUNT_D SKB1 SAKNR    
11 FTI_LDB_TR_CASH_FLOWS GROUP_D_K TP13 GROUP_D    
12 FTI_LDB_TR_CASH_FLOWS GROUP_ID_K TB001 BU_GROUP    
13 FTI_LDB_TR_CASH_FLOWS GSART TZPA GSART    
14 FTI_LDB_TR_CASH_FLOWS IND_SECTOR_K TB038A IND_SECTOR    
15 FTI_LDB_TR_CASH_FLOWS ISTYPE TB038 ISTYPE    
16 FTI_LDB_TR_CASH_FLOWS ISTYPE_K TB038 ISTYPE    
17 FTI_LDB_TR_CASH_FLOWS KMNR VWKMKO KMNR    
18 FTI_LDB_TR_CASH_FLOWS LAND1 T005 LAND1    
19 FTI_LDB_TR_CASH_FLOWS LEGAL_ENTY_K TB019 LEGAL_ENTY    
20 FTI_LDB_TR_CASH_FLOWS LEGAL_ORG_K TB032 LEGAL_ORG    
21 FTI_LDB_TR_CASH_FLOWS LOANS_CONTRACT VDARL RANL    
22 FTI_LDB_TR_CASH_FLOWS MANDT T000 MANDT    
23 FTI_LDB_TR_CASH_FLOWS NATION_K T005 LAND1    
24 FTI_LDB_TR_CASH_FLOWS PARTNR BUT000 PARTNER    
25 FTI_LDB_TR_CASH_FLOWS PORTFOLIO TWPOB RPORTB 1 CN
26 FTI_LDB_TR_CASH_FLOWS PORTFOLIO_TM TWPOB RPORTB    
27 FTI_LDB_TR_CASH_FLOWS POSITION_ACCOUNT TRFT_POS_ACCOUNT POS_ACCOUNT    
28 FTI_LDB_TR_CASH_FLOWS PRKEY PAYRQ KEYNO C CN
29 FTI_LDB_TR_CASH_FLOWS RAHABKI T012 HBKID    
30 FTI_LDB_TR_CASH_FLOWS RAHKTID T012K HKTID    
31 FTI_LDB_TR_CASH_FLOWS RATING_K TP06 RATING    
32 FTI_LDB_TR_CASH_FLOWS RDPBANK BUT000 PARTNER    
33 FTI_LDB_TR_CASH_FLOWS RKONTRA BUT000 PARTNER    
34 FTI_LDB_TR_CASH_FLOWS RREFKONT_R T037S RREFKONT    
35 FTI_LDB_TR_CASH_FLOWS SANLF TZAF SANLF    
36 FTI_LDB_TR_CASH_FLOWS SBEWART_R TZB0A SBEWART    
37 FTI_LDB_TR_CASH_FLOWS SBWHR TCURC WAERS    
38 FTI_LDB_TR_CASH_FLOWS SECACC_TYPE TRSC_SECACC_TYPE SECACC_TYPE    
39 FTI_LDB_TR_CASH_FLOWS SECURITY_ACCOUNT TWD01 RLDEPO    
40 FTI_LDB_TR_CASH_FLOWS SECURITY_ID VWPANLA RANL    
41 FTI_LDB_TR_CASH_FLOWS SHWHR TCURC WAERS    
42 FTI_LDB_TR_CASH_FLOWS STAFF_GRP_K TP05 STAFF_GRP C CN
43 FTI_LDB_TR_CASH_FLOWS STATE_K T005 LAND1    
44 FTI_LDB_TR_CASH_FLOWS WZBETR TCURC WAERS    
45 FTI_LDB_TR_CASH_FLOWS ZLSCH T042Z ZLSCH    
History
Last changed by/on SAP  20131127 
SAP Release Created in 200