FTI_LDB_TR_PL_CF SAP (Treasury: Revenue and Cash Flow Information) Structure details
Description: Treasury: Revenue and Cash Flow Information
Related tables to FTI_LDB_TR_PL_CF
Access table FTI_LDB_TR_PL_CF
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_PL_CF is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Treasury: Revenue and Cash Flow Information" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FTI_LDB_TR_PL_CF TYPE FTI_LDB_TR_PL_CF.
The FTI_LDB_TR_PL_CF table consists of various fields, each holding specific information or linking keys about Treasury: Revenue and Cash Flow Information data available in SAP. These include BUKRS (Company Code), LAND1 (Country key of company code), TR_ACC_CODE (Accounting Code), VALUATION_AREA (Valuation Area).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP FTI_LDB_TR_PL_CF structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
LAND1 | Country key of company code | FTI_LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
TR_ACC_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | TRGC_TR_ACC_CODE | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | TRGC_VAL_AREA | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | TPM_ACTIVE_PASSIVE | CHAR | 1 | TPM_ACTIVE_PASSIVE | ||||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
PORTFOLIO | Portfolio as Differentiation Characteristic | TPM_PORTFOLIO_DIFF | CHAR | 10 | TWPOB | RPORTB | |||
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | VDARL | ALPHA | RANL | RAN | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | Assigned to domain | THM_HEDGE_ID | HEDGEID | ||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
SECURITY_ACCOUNT | Securities Account | VRLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ||
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | TRFT_POS_ACCOUNT | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
EXTERNAL_ACCOUNT | External Account (Position) | TPM_EXT_ACCOUNT_POS | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | TPM_DIFF_CURR | ||
EXTACC_DEAL | External Account (Transaction) | TPM_EXT_ACCOUNT_DEAL | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_USER | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_BUSTRANSCAT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
LOTPOS_INIT_DATE | Position Acquisition Date of a Lot | FTI_LOTPOSITION_INIT_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTPOS_ORG_DATE | Original Position Acquisition Date of a Lot | FTI_LOTPOSITION_ORG_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTGEN_BUKRS | Company Code of Lot-Generating Transaction | FTI_LOTGENERATION_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | H_T001 | ||
LOTGEN_DEALNR | Lot-Generating Transaction Number (Listed Derivatives) | FTI_LOTGENERATION_DEALNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_TRANS_NO | |
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
RANTYP_R | Contract type | FTI_RANTYP | CHAR | 1 | FTI_RANTYP | ||||
RREFKONT_R | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | T037S | USTRU | |||
ACC_ASS_REF | Account Assignment Reference of Position Management | TPM_AA_REF | CHAR | 12 | TRACC_AA_REF | TPM_AA_REF | TRAC_AA_REF | ||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
RLZTG_F | Remaining Term in Days | FTI_RLZTG_F | NUMC | 5 | NUMC5 | ||||
RLZMO_F | Remaining Term in Months | FTI_RLZMO_F | NUMC | 4 | NUMC4 | ||||
RLZJA_F | Remaining Term in Years | FTI_RLZJA_F | NUMC | 3 | NUMC3 | ||||
UEBTG_F | Overdue Period in Days | FTI_UEBTG_F | NUMC | 5 | NUMC5 | ||||
UEBMO_F | Overdue Period in Months | FTI_UEBMO_F | NUMC | 3 | NUMC3 | ||||
UEBJA_F | Overdue Period in Years | FTI_UEBJA_F | NUMC | 2 | NUMC2 | ||||
PARTNR | Partner with Whom Commitment Exists | FTI_LDB_RISK_COUNTERPARTY | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
TYPE | Business Partner Category | BP_TYPE_NEW | CHAR | 1 | BU_TYPE | ||||
ISTYPE | Industry System | BU_ISTYPE | CHAR | 4 | TB038 | BU_ISTYPE | |||
IND_SECTOR | Industry | BU_IND_SECTOR | CHAR | 10 | TB038A | BU_INDSECTOR | |||
CNTRY_COMP | Country of Registered Office of Business Partner | FTI_LANDBP | CHAR | 3 | T005 | LAND1 | |||
LEGAL_ENTY | Legal Form of Organization | BP_LEG_ETY_NEW | CHAR | 2 | TB019 | BU_LEGENTY | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG_NEW | CHAR | 2 | TB032 | BU_LEGAL_ORG | |||
NATION | Nationality | BP_CNTR_N | CHAR | 3 | T005 | LAND1 | |||
STATE | Citizenship | BP_CNTR_ST | CHAR | 3 | T005 | LAND1 | |||
GROUP_ID | Business Partner Grouping | BU_GRP_ID_NEW | CHAR | 4 | TB001 | BU_GROUP | BPP | ||
GROUP_D | Target Group | BP_GROUP_D | CHAR | 4 | TP13 | BP_GROUP_D | |||
STAFF_GRP | Employee Group | BP_STAFF_G | CHAR | 4 | TP05 | BP_STAFF_G | |||
COMP_RE | Organization Relationship | BP_COMP_RE | CHAR | 1 | BP_COMP_RE | ||||
GRADE | Valuation | FTI_BP_GRADE | CHAR | 10 | TPZ22 | BP_GRADE | |||
GRADE_METHOD | Valuation Procedure | FTI_BP_GRADE_METHOD | CHAR | 10 | TPZ21 | BP_GRADE_METHOD | |||
SOLVNCY | Credit Standing | BP_SOLVNCY | CHAR | 1 | BP_SOLVNCY | ||||
SOL_INF | Status of Credit Standing Information | BP_SOL_INF | CHAR | 1 | BP_SOL_INF | ||||
SOL_I_D | Date of Credit Standing Information | BP_SOL_I_D | DATS | 8 | DATUM | ||||
RATING | Rating | FTI_BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
SOL_INS | Institute providing credit standing information | FTI_BP_SOL_INS | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
FINPROJ | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
RMAID | Master Agreement | TB_RMAID | CHAR | 10 | VTBMA | ALPHA | T_RMAID | TMA | VTMA |
RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
PORTFOLIO_TM | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
RDPBANK | Depository Bank | RDEPOTBANK | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
SECACC_TYPE | Securities Account Type | TPM_SECACC_TYPE | CHAR | 3 | TRSC_SECACC_TYPE | TPM_SECACC_TYPE | |||
SECACC_CAT | Securities Account Category | TPM_SECACC_CAT | CHAR | 1 | TPM_SECACC_CAT | ||||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | TW11 | SBILK | |||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
ALWPKL | General Security Classification | ALWPKL | CHAR | 3 | TW22 | ALWPKL | |||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | TW20 | SAKTTYP | |||
SOL_INS_RANL | Institut Supplying Credit Rating Information for Secur. ID | FTI_SOL_INS_RANL | CHAR | 4 | TP07 | BP_SOL_INS | |||
RATING_RANL | Rating for Securities ID Number/OTC Transaction | BP_RATING_RANL | CHAR | 3 | TP06 | BP_RATING | |||
SWPKLASS | Classification of bond | SWPKLASS | NUMC | 3 | TW01 | SWPKLASS | |||
SAKAR | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
SFOART | Fund category indicator | VVSFOART | CHAR | 2 | VVSFOART | ||||
SFOTY | Fund type indicator | SFOTY | NUMC | 1 | TW21 | SFOTY | |||
SARTBET | Type of shareholding | SARTBET | NUMC | 2 | TW02 | SARTBET | |||
SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
VVRANLWX | Secondary index class data | VVRANLWXS | CHAR | 20 | CHAR20S | ||||
AAAAKTIE_E | Number of Stocks Issued: End | FTI_AAAKTIE_E | DEC | 12 | DEC12 | ||||
KBNEWE_E | Nominal Value per Stock (Independent of Currency) | FTI_VVBNEWE_E | DEC | 15(6) | VVKWKURS | ||||
KZAHLAKT_E | Pay-in rate | FTI_KZAHLAKT_E | DEC | 10(7) | DEC3_7 | ||||
PKOND_E | Interest Rate: End | FTI_PKOND_E | DEC | 10(7) | DECV3_7 | ||||
BKOND_E | Interest Rate as Amount: End | FTI_BKOND_E | CURR | 13(2) | WERTV7 | ||||
PEFFZINS_E | Effective Interest Rate at End of Period | FTI_PEFFZINS_E | DEC | 10(7) | DEC3_7 | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TRCOT_CTY_MASTER | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | |
SHWHR | Local Currency | TB_SHWHR | CUKY | 5 | TCURC | WAERS | |||
SVWHR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | TCURC | WAERS | |||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
ANZGW | Display Currency | FTI_ANZGW | CUKY | 5 | TCURC | WAERS | FFZ | ||
SWHRKOND | Interest Currency | TB_WHRKOND | CUKY | 5 | TCURC | WAERS | |||
WVERB1 | Nominal currency borrowing/sale/outgoing side/short | FTI_WHR_SHORT | CUKY | 5 | TCURC | WAERS | |||
WFORD1 | Nominal currency investment/purchase incoming side/long | FTI_WHR_LONG | CUKY | 5 | TCURC | WAERS | |||
DBEWEG | Flow Date | DBEWEG | DATS | 8 | DATUM | ||||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
DORDER | Order day | DORDER | DATS | 8 | DATUM | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | DATUM | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
JAHR | Calendar year | TB_JAHR | NUMC | 4 | GJAHR | GJAHR | |||
MONAT | Calendar month | TB_MONAT | NUMC | 2 | TB_MONAT | ||||
WOCHE | Calendar Week | FTI_WOCHE | NUMC | 2 | NUMC2 | ||||
MONAT_JAHR | Calendar Month/Year | FTI_MONTH_YEAR | NUMC | 6 | PERI | MCPERIOD | |||
WOCHE_JAHR | Calendar Week/Year | FTI_WEEK_YEAR | NUMC | 6 | PERI | MCPERIOD | |||
SE_DEAL_NUMBER | Securities/Futures Transaction | FTI_SE_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
RKONTRA | Reference to Counterparty | RKONTRA_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | TWH01 | VVRHANDPL | WHP | ||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
GL_ACCOUNT_D | Number of G/L Account: Debit | FTI_GLACC_D | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
GL_ACCOUNT_C | Number of G/L Account: Credit | FTI_GLACC_C | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | C_SAKNR |
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
DMONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
PERIO | Period/year | JAHRPER | NUMC | 7 | PERI7 | JAHRPER | |||
BUCHST | Posting Status of Flow for CFM (Operative Only) | BUCHST_CFM | CHAR | 1 | BUCHST_CFM | ||||
TRL_BOOKINGSTATE | Position Status of Flow for CFM (Parallel Only) | BUCHST_CFM_PAR | CHAR | 1 | TRLBS | TPM_TRL_BOOKINGSTATE | |||
SBEWART_R | Flow Type | SBEWART | CHAR | 4 | TZB0A | SBEWART | |||
FLOW_TYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | TRDC_DFLOWTYPE | TPM_DIS_FLOWTYPE | |||
BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
BUSTRANSID | Identifier of the Distributor Business Transaction | FTI_BUSTRANSID | RAW | 16 | SYSUUID | ||||
REFBUSTRANSID | ID of Reference Business Transaction | FTI_REFBUSTRANSID | RAW | 16 | SYSUUID | ||||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 1 | TPM_SOURCE_TARGET_FLG | ||||
PL_CATEGORY | P/L Type | TPM_PL_CATEGORY | CHAR | 3 | TRGC_PL_CATE | ALPHA | TPM_PL_CATEGORY | ||
KMNR | Corporate Action Number | KMNR | CHAR | 13 | VWKMKO | ALPHA | VKMNR | KMA | |
SPLWHR | Profit/loss currency | SPLWHR | CUKY | 5 | TCURC | WAERS | |||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
PL_PC | Profit/loss amount in profit/loss currency | FTI_PLAMOUNT_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PL_LC | Profit/loss amount in local currency | FTI_PLAMOUNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
PL_DC | Profit/Loss Amount in Display Currency | FTI_PLAMOUNT_DC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_PC | Revenue Accrued/Deferred in Profit/Loss Currency | FTI_PERACC_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_VC | Period-Based Revenue Accrued/Deferred in Valuation Currency | FTI_PERACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_LC | Revenue Accrued/Deferred in Local Currency | FTI_PERACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
PABGERF_DC | Revenue Accrued/Deferred in Display Currency | FTI_PERACC_DC | CURR | 21(2) | TPM_AMOUNT |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_PL_CF using ABAP code?
As FTI_LDB_TR_PL_CF is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FTI_LDB_TR_PL_CF as there is no data to select.How to access SAP table FTI_LDB_TR_PL_CF
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_PL_CF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects