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