SAP ABAP Table FTI_LDB_TR_PL_CF (Treasury: Revenue and Cash 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
⤷ 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_PL_CF | Table Relationship Diagram |
Short Description | Treasury: Revenue and Cash 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 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | LAND1 | FTI_LAND1 | LAND1 | CHAR | 3 | 0 | Country key of company code | T005 | |
4 | TR_ACC_CODE | TPM_ACC_CODE | TPM_ACC_CODE | CHAR | 4 | 0 | Accounting Code | TRGC_TR_ACC_CODE | |
5 | VALUATION_AREA | TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | TRGC_VAL_AREA | |
6 | VALUATION_CLASS | TPM_VAL_CLASS | TPM_VAL_CLASS | NUMC | 4 | 0 | Valuation Class | TRGC_VAL_CLASS | |
7 | ACTIVE_PASSIVE | TPM_ACTIVE_PASSIVE | TPM_ACTIVE_PASSIVE | CHAR | 1 | 0 | Indicator: Assets/Liabilities Position | ||
8 | GSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
9 | PORTFOLIO | TPM_PORTFOLIO_DIFF | RPORTB | CHAR | 10 | 0 | Portfolio as Differentiation Characteristic | TWPOB | |
10 | SECURITY_ID | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | VWPANLA | |
11 | LOANS_CONTRACT | RANL | RANL | CHAR | 13 | 0 | Contract Number | VDARL | |
12 | DEAL_NUMBER | FTI_POSRFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction That Creates a Position | VTBFHA | |
13 | HEDGE_ID | THM_HEDGE_ID | THM_HEDGE_ID | NUMC | 10 | 0 | Hedge Item Identification Number | * | |
14 | ACCOUNT_GROUP | TPM_SEC_ACCT_GRP | TPM_SEC_ACCT_GRP | CHAR | 10 | 0 | Securities Account Group | TRGT_SECACCGRP | |
15 | SECURITY_ACCOUNT | VRLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | TWD01 | |
16 | POSITION_ACCOUNT | TPM_POS_ACCOUNT_FUT | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | Futures Account for Listed Options and Futures | TRFT_POS_ACCOUNT | |
17 | FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | TPM_FLAG_LONG_SHORT | CHAR | 1 | 0 | Indicator: Long or Short Position | ||
18 | LOT_ID | TPM_LOT_ID | SYSUUID | RAW | 16 | 0 | Identifier of the Lot | ||
19 | DLOTGENERATION | DLOTGENERATION | DATUM | DATS | 8 | 0 | Date On Which Lot Was Generated | ||
20 | TLOTGENERATION | TLOTGENERATION | UZEIT | TIMS | 6 | 0 | Lot Generation Time | ||
21 | LOTGENERATION_USER | FTI_LOTGENERATIONUSER | SYCHAR12 | CHAR | 12 | 0 | Lot Entered By | ||
22 | LOTGENERATION_BUSTRANSCAT | FTI_LOTGENERATION_BUSTRANSCAT | TPM_BUSTRANSCAT | NUMC | 4 | 0 | Business Transaction Category Which Generated the Lot | TRDTS_BT_CAT | |
23 | LOTPOS_INIT_DATE | FTI_LOTPOSITION_INIT_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Position Acquisition Date of a Lot | ||
24 | LOTPOS_ORG_DATE | FTI_LOTPOSITION_ORG_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Original Position Acquisition Date of a Lot | ||
25 | LOTGEN_BUKRS | FTI_LOTGENERATION_BUKRS | BUKRS | CHAR | 4 | 0 | Company Code of Lot-Generating Transaction | * | |
26 | LOTGEN_DEALNR | FTI_LOTGENERATION_DEALNR | T_RFHA | CHAR | 13 | 0 | Lot-Generating Transaction Number | * | |
27 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
28 | RANTYP_R | FTI_RANTYP | FTI_RANTYP | CHAR | 1 | 0 | Contract type | ||
29 | RREFKONT_R | TB_REFKONT | USTRU | CHAR | 8 | 0 | Acct Assignment Ref. for Operative Valn Area and Loan | T037S | |
30 | ACC_ASS_REF | TPM_AA_REF | TPM_AA_REF | CHAR | 12 | 0 | Account Assignment Reference of Position Management | TRACC_AA_REF | |
31 | DBLFZ | DBLFZ | DATUM | DATS | 8 | 0 | Start of Term | ||
32 | DELFZ | DELFZ | DATUM | DATS | 8 | 0 | End of Term | ||
33 | .INCLUDE | 0 | 0 | Quasi Key Figures Occurring in Position and Flow Lists | |||||
34 | RLZTG_F | FTI_RLZTG_F | NUMC5 | NUMC | 5 | 0 | Remaining Term in Days | ||
35 | RLZMO_F | FTI_RLZMO_F | NUMC4 | NUMC | 4 | 0 | Remaining Term in Months | ||
36 | RLZJA_F | FTI_RLZJA_F | NUMC3 | NUMC | 3 | 0 | Remaining Term in Years | ||
37 | UEBTG_F | FTI_UEBTG_F | NUMC5 | NUMC | 5 | 0 | Overdue Period in Days | ||
38 | UEBMO_F | FTI_UEBMO_F | NUMC3 | NUMC | 3 | 0 | Overdue Period in Months | ||
39 | UEBJA_F | FTI_UEBJA_F | NUMC2 | NUMC | 2 | 0 | Overdue Period in Years | ||
40 | .INCLUDE | 0 | 0 | Include for Data of Commitment Partner (->LDBs) | |||||
41 | .INCLUDE | 0 | 0 | Treasury: Commitment Partner | |||||
42 | PARTNR | FTI_LDB_RISK_COUNTERPARTY | BU_PARTNER | CHAR | 10 | 0 | Partner with Whom Commitment Exists | BUT000 | |
43 | .INCLUDE | 0 | 0 | Treasury: Partner Attributes | |||||
44 | TYPE | BP_TYPE_NEW | BU_TYPE | CHAR | 1 | 0 | Business Partner Category | ||
45 | ISTYPE | BU_ISTYPE | BU_ISTYPE | CHAR | 4 | 0 | Industry System | TB038 | |
46 | IND_SECTOR | BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | TB038A | |
47 | CNTRY_COMP | FTI_LANDBP | LAND1 | CHAR | 3 | 0 | Country of Registered Office of Business Partner | T005 | |
48 | LEGAL_ENTY | BP_LEG_ETY_NEW | BU_LEGENTY | CHAR | 2 | 0 | Legal Form of Organization | TB019 | |
49 | LEGAL_ORG | BU_LEGAL_ORG_NEW | BU_LEGAL_ORG | CHAR | 2 | 0 | Legal Entity of Organization | TB032 | |
50 | NATION | BP_CNTR_N | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
51 | STATE | BP_CNTR_ST | LAND1 | CHAR | 3 | 0 | Citizenship | T005 | |
52 | GROUP_ID | BU_GRP_ID_NEW | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | TB001 | |
53 | GROUP_D | BP_GROUP_D | BP_GROUP_D | CHAR | 4 | 0 | Target Group | TP13 | |
54 | STAFF_GRP | BP_STAFF_G | BP_STAFF_G | CHAR | 4 | 0 | Employee Group | TP05 | |
55 | COMP_RE | BP_COMP_RE | BP_COMP_RE | CHAR | 1 | 0 | Organization Relationship | ||
56 | .INCLUDE | 0 | 0 | Business partner credit standing data | |||||
57 | SOLVNCY | BP_SOLVNCY | BP_SOLVNCY | CHAR | 1 | 0 | Credit Standing | ||
58 | RATING | BP_RATING | BP_RATING | CHAR | 3 | 0 | Rating | TP06 | |
59 | SOL_INS | BP_SOL_INS | BP_SOL_INS | CHAR | 4 | 0 | Institute Providing Credit Standing Information | TP07 | |
60 | SOL_INF | BP_SOL_INF | BP_SOL_INF | CHAR | 1 | 0 | Status of Credit Standing Information | ||
61 | SOL_I_D | BP_SOL_I_D | DATUM | DATS | 8 | 0 | Date of Credit Standing Information | ||
62 | .INCLUDE | 0 | 0 | Include for Transaction Attributes Rel. for Position (->LDB) | |||||
63 | SFHAART | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | * | |
64 | FINPROJ | TB_TFPROJ | T_TFPROJ | CHAR | 13 | 0 | Finance Project | ||
65 | RMAID | TB_RMAID | T_RMAID | CHAR | 10 | 0 | Master Agreement | VTBMA | |
66 | RGARANT | TB_RGARANT_NEW | BU_PARTNER | CHAR | 10 | 0 | Guarantor of Financial Transaction | BUT000 | |
67 | NORDEXT | TB_NORDEXT | FTI_CHAR16LOW | CHAR | 16 | 0 | External Reference | ||
68 | ZUOND | TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
69 | REFER | TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
70 | MERKM | TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics | ||
71 | PORTFOLIO_TM | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
72 | RDEALER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | TZDEA | |
73 | RDPBANK | RDEPOTBANK | BU_PARTNER | CHAR | 10 | 0 | Depository Bank | BUT000 | |
74 | SECACC_TYPE | TPM_SECACC_TYPE | TPM_SECACC_TYPE | CHAR | 3 | 0 | Securities Account Type | TRSC_SECACC_TYPE | |
75 | SECACC_CAT | TPM_SECACC_CAT | TPM_SECACC_CAT | CHAR | 1 | 0 | Securities Account Category | ||
76 | SBILK | SBILK | SBILK | CHAR | 2 | 0 | Balance Sheet Indicator | TW11 | |
77 | .INCLUDE | 0 | 0 | Include for Time-Dependent Class Data (-> LDBs) | |||||
78 | SNOTI | SNOTI | SNOTI | NUMC | 1 | 0 | Quotation Indicator | ||
79 | ALWPKL | ALWPKL | ALWPKL | CHAR | 3 | 0 | General Security Classification | TW22 | |
80 | SWERTTYP | SWERTTYP | SAKTTYP | NUMC | 1 | 0 | Security Type ID | TW20 | |
81 | SOL_INS_RANL | FTI_SOL_INS_RANL | BP_SOL_INS | CHAR | 4 | 0 | Institut Supplying Credit Rating Information for Secur. ID | TP07 | |
82 | RATING_RANL | BP_RATING_RANL | BP_RATING | CHAR | 3 | 0 | Rating for Securities ID Number/OTC Transaction | TP06 | |
83 | SWPKLASS | SWPKLASS | SWPKLASS | NUMC | 3 | 0 | Classification of bond | TW01 | |
84 | SAKAR | SAKAR | SAKAR | NUMC | 1 | 0 | Stock category | ||
85 | SFOART | VVSFOART | VVSFOART | CHAR | 2 | 0 | Fund category indicator | ||
86 | SFOTY | SFOTY | SFOTY | NUMC | 1 | 0 | Fund type indicator | TW21 | |
87 | SARTBET | SARTBET | SARTBET | NUMC | 2 | 0 | Type of shareholding | TW02 | |
88 | SBOERNOT | SBOERNOT | JANEI | CHAR | 1 | 0 | Indicator: Listed on an Exchange | ||
89 | VVRANLWX | VVRANLWXS | CHAR20S | CHAR | 20 | 0 | Secondary index class data | ||
90 | AAAAKTIE_E | FTI_AAAKTIE_E | DEC12 | DEC | 12 | 0 | Number of Stocks Issued: End | ||
91 | KBNEWE_E | FTI_VVBNEWE_E | VVKWKURS | DEC | 15 | 6 | Nominal Value per Stock (Independent of Currency) | ||
92 | KZAHLAKT_E | FTI_KZAHLAKT_E | DEC3_7 | DEC | 10 | 7 | Pay-in rate | ||
93 | PKOND_E | FTI_PKOND_E | DECV3_7 | DEC | 10 | 7 | Interest rate - end | ||
94 | BKOND_E | FTI_BKOND_E | WERTV7 | CURR | 13 | 2 | Interest Rate as Amount: End | ||
95 | PEFFZINS_E | FTI_PEFFZINS_E | DEC3_7 | DEC | 10 | 7 | Effective Interest Rate at End of Period | ||
96 | SHWHR | TB_SHWHR | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
97 | SVWHR | TPM_VALUATION_CURR | WAERS | CUKY | 5 | 0 | Valuation Currency | TCURC | |
98 | SBWHR | TB_BWHR | WAERS | CUKY | 5 | 0 | Position Currency/Transaction Currency | TCURC | |
99 | ANZGW | FTI_ANZGW | WAERS | CUKY | 5 | 0 | Display Currency | TCURC | |
100 | SWHRKOND | TB_WHRKOND | WAERS | CUKY | 5 | 0 | Interest Currency | TCURC | |
101 | WVERB1 | FTI_WHR_SHORT | WAERS | CUKY | 5 | 0 | Nominal currency borrowing/sale/outgoing side/short | TCURC | |
102 | WFORD1 | FTI_WHR_LONG | WAERS | CUKY | 5 | 0 | Nominal currency investment/purchase incoming side/long | TCURC | |
103 | DBEWEG | DBEWEG | DATUM | DATS | 8 | 0 | Flow Date | ||
104 | DBESTAND | DBESTAND | DATUM | DATS | 8 | 0 | Position value date | ||
105 | DORDER | DORDER | DATUM | DATS | 8 | 0 | Order day | ||
106 | DDISPO | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
107 | DSCHLUSS | VVDSCHLUSS | DATUM | DATS | 8 | 0 | Date of business closing | ||
108 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
109 | JAHR | TB_JAHR | GJAHR | NUMC | 4 | 0 | Calendar year | ||
110 | MONAT | TB_MONAT | TB_MONAT | NUMC | 2 | 0 | Calendar month | ||
111 | WOCHE | FTI_WOCHE | NUMC2 | NUMC | 2 | 0 | Calendar Week | ||
112 | MONAT_JAHR | FTI_MONTH_YEAR | MCPERIOD | NUMC | 6 | 0 | Calendar Month/Year | ||
113 | WOCHE_JAHR | FTI_WEEK_YEAR | MCPERIOD | NUMC | 6 | 0 | Calendar Week/Year | ||
114 | SE_DEAL_NUMBER | FTI_SE_RFHA | T_RFHA | CHAR | 13 | 0 | Securities/Futures Transaction | * | |
115 | RKONTRA | RKONTRA_NEW | BU_PARTNER | CHAR | 10 | 0 | Reference to Counterparty | BUT000 | |
116 | RHANDPL | VVRHANDPL | VVRHANDPL | CHAR | 10 | 0 | Exchange | TWH01 | |
117 | JFDBUC | FTI_FDBUC | FTI_FDBUC | CHAR | 1 | 0 | Relevance to CM | ||
118 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
119 | BANKK_HB | FTI_BANKK | BANKK | CHAR | 15 | 0 | Bank key of house bank | ||
120 | BANKN_HB | FTI_BANKN | BANKN | CHAR | 18 | 0 | Bank account number of house bank | ||
121 | BANKK_BP | FTI_BANKKP | BANKK | CHAR | 15 | 0 | Bank key of business partner bank | ||
122 | BANKN_BP | FTI_BANKNP | BANKN | CHAR | 18 | 0 | Bank account number of business partner | ||
123 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
124 | SPAYRQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
125 | PRKEY | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | PAYRQ | |
126 | .INCLUDE | 0 | 0 | Include for FI Document Data/Filling FI Document Data ->LDB | |||||
127 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
128 | AWKEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
129 | GL_ACCOUNT_D | FTI_GLACC_D | SAKNR | CHAR | 10 | 0 | Number of G/L Account: Debit | SKB1 | |
130 | GL_ACCOUNT_C | FTI_GLACC_C | SAKNR | CHAR | 10 | 0 | Number of G/L Account: Credit | SKB1 | |
131 | DBUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
132 | DGJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
133 | DMONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
134 | PERIO | JAHRPER | JAHRPER | NUMC | 7 | 0 | Period/year | ||
135 | RAHABKI | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | T012 | |
136 | RAHKTID | TB_RHKTID | HKTID | CHAR | 5 | 0 | Short key for house bank account | T012K | |
137 | BUCHST | BUCHST_CFM | BUCHST_CFM | CHAR | 1 | 0 | Posting Status of Flow for CFM (Operative Only) | ||
138 | TRL_BOOKINGSTATE | BUCHST_CFM_PAR | TPM_TRL_BOOKINGSTATE | CHAR | 1 | 0 | Position Status of Flow for CFM (Parallel Only) | ||
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 | SOURCETARGET_FLG | TPM_SOURCE_TARGET_FLG | TPM_SOURCE_TARGET_FLG | CHAR | 1 | 0 | Indicator: Source or Target of a Flow | ||
144 | PL_CATEGORY | TPM_PL_CATEGORY | TPM_PL_CATEGORY | CHAR | 3 | 0 | P/L Type | TRGC_PL_CATE | |
145 | KMNR | KMNR | VKMNR | CHAR | 13 | 0 | Corporate Action Number | VWKMKO | |
146 | WZBETR | TB_WZBETR | WAERS | CUKY | 5 | 0 | Payment Currency | TCURC | |
147 | SPLWHR | SPLWHR | WAERS | CUKY | 5 | 0 | Profit/loss currency | TCURC | |
148 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
149 | CF_CC | FTI_PAYAMOUNT_PYC | TPM_AMOUNT | CURR | 21 | 2 | Payment amount in payment currency | ||
150 | CF_LC | FTI_PAYAMOUNT_LC | TPM_AMOUNT | CURR | 21 | 2 | Payment Amount in Local Currency | ||
151 | CF_DC | FTI_PAYAMOUNT_DC | TPM_AMOUNT | CURR | 21 | 2 | Payment Amount in Display Currency | ||
152 | PL_PC | FTI_PLAMOUNT_PLC | TPM_AMOUNT | CURR | 21 | 2 | Profit/loss amount in profit/loss currency | ||
153 | PL_LC | FTI_PLAMOUNT_LC | TPM_AMOUNT | CURR | 21 | 2 | Profit/loss amount in local currency | ||
154 | PL_DC | FTI_PLAMOUNT_DC | TPM_AMOUNT | CURR | 21 | 2 | Profit/Loss Amount in Display Currency | ||
155 | PABGERF_PC | FTI_PERACC_PLC | TPM_AMOUNT | CURR | 21 | 2 | Revenue Accrued/Deferred in Profit/Loss Currency | ||
156 | PABGERF_VC | FTI_PERACC_VC | TPM_AMOUNT | CURR | 21 | 2 | Period-Based Revenue Accrued/Deferred in Valuation Currency | ||
157 | PABGERF_LC | FTI_PERACC_LC | TPM_AMOUNT | CURR | 21 | 2 | Revenue Accrued/Deferred in Local Currency | ||
158 | PABGERF_DC | FTI_PERACC_DC | TPM_AMOUNT | CURR | 21 | 2 | Revenue Accrued/Deferred in Display Currency |
Foreign Keys
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 110 |