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
⤷ 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
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 200 |