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