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