FTI_LDB_TR_OTC_DEAL_1 SAP (Treasury RAPIs - OTC Transaction Reporting) Structure details
Description: Treasury RAPIs - OTC Transaction Reporting
Related tables to FTI_LDB_TR_OTC_DEAL_1
Access table FTI_LDB_TR_OTC_DEAL_1
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_OTC_DEAL_1 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 RAPIs - OTC Transaction Reporting" 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_OTC_DEAL_1 TYPE FTI_LDB_TR_OTC_DEAL_1.
The FTI_LDB_TR_OTC_DEAL_1 table consists of various fields, each holding specific information or linking keys about Treasury RAPIs - OTC Transaction Reporting data available in SAP. These include COMPANYCODE (Company Code), DEAL_NUMBER (Position-Generating Financial Transaction), OBJECTNUMBER (Object number), CREATE_USER (Entered by).. 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_OTC_DEAL_1 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 | |||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
OBJECTNUMBER | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CREATE_USER | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
CREATE_DATE | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
CREATE_TIME | Entry Time | TB_TCRTIM | TIMS | 6 | UZEIT | ||||
UPDATE_USER | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
UPDATE_DATE | Changed on | TB_DUPDAT | DATS | 8 | DATUM | ||||
UPDATE_TIME | Time changed | TB_TUPTIM | TIMS | 6 | UZEIT | ||||
CONTRACT_TYPE | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
PRODUCT_CAT | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
TRANSACTION_CAT | Transaction Category | TB_SFGTYP | NUMC | 3 | AT01 | T_SFGTYP | |||
ACTIVITY_CAT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | AT02 | T_SFGZUTY | C_AT02 | ||
TRANSACTION_TYPE | Financial Transaction Type | TB_SFHAART | CHAR | 3 | AT10 | T_SFHAART | T02 | C_AT10 | |
START_TERM | Start of Term | FTI_DBLFZ_DEAL | DATS | 8 | DATUM | ||||
END_TERM | End of Term | FTI_DELFZ_DEAL | DATS | 8 | DATUM | ||||
ROLLOVER_TERM | Rollover Date | FTI_ROLLOVER_DEAL | DATS | 8 | DATUM | ||||
START_INCLUSIVE | Calculation Period: Start Inclusive vs. End Inclusive | FTI_SINCLBE | CHAR | 1 | T_SINCLBE | ||||
END_INCLUSIVE | End of Term Inclusive Indicator | TB_SINCLE | CHAR | 1 | XFELD | ||||
NOTICE_DATE | OTC Notice Date | TB_NOTICE_DATE | DATS | 8 | DATUM | ||||
CONTRACT_DATE | Contract Conclusion Date | TB_DVTRAB | DATS | 8 | DATUM | ||||
CONTRACT_TIME | Time of contract conclusion | TB_TVTRAB | TIMS | 6 | UZEIT | ||||
TRADER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
COUNTERPARTY | Counterparty | TB_KONTRH | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
CONTACT_PERSON | Contact Person | TB_GSPPART | CHAR | 19 | TEXT19 | ||||
GUARANTOR | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
EXTERNAL_REFNCE | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
FINANCE_PROJECT | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
MASTER_AGREEMENT | Master Agreement | TB_RMAID | CHAR | 10 | Assigned to domain | ALPHA | T_RMAID | TMA | VTMA |
ASSIGNMENT | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
INTERNAL_REFNCE | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
CHARACTERISTICS | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
VALUATION_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | ||
FACILITY_DEALNO | Transaction Number of Facility | TB_FACILITYNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_FTR_FC | |
FACILITY_CCODE | Company Code of Facility | TB_FACILITYBUKRS | CHAR | 4 | Assigned to domain | BUKRS | H_T001 | ||
DEAL_ACTIVE | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 1 | T_SAKTIV | ||||
RELEASE_STATUS | Transaction Release: Release Status | TB_FRGZUST | CHAR | 1 | T_FRGZUST | ||||
CONFIRM_STATUS | Confirmation Status | TB_CONF | NUMC | 1 | TB_CONF | ||||
CONFIRM_DATE | Confirmation Date | TB_DCONF | DATS | 8 | DATUM | ||||
CONFIRM_USER | Confirmation Executed By (User Responsible) | TB_UCONF | CHAR | 12 | USNAM | ||||
CNTRCONFIRM | Counterconfirmation | TB_RECONF | NUMC | 1 | TB_RECONF | ||||
CNTRCONFIRM_DATE | Counterconfirmation Date | TB_DREDAT | DATS | 8 | DATUM | ||||
CNTRCONFIRM_USER | Counterconfirmation Executed by (User Responsible) | TB_URENAM | CHAR | 12 | USNAM | ||||
CURRENCY | Currency of Transaction | FTI_WGSCHFT | CUKY | 5 | TCURC | WAERS | |||
CURRENCY_RCV | Currency of Incoming Side of Transaction | FTI_WGSCHF2 | CUKY | 5 | TCURC | WAERS | |||
CURRENCY_PAY | Currency of Outgoing Side of Transaction | FTI_WGSCHF1 | CUKY | 5 | TCURC | WAERS | |||
NOM_AMOUNT | Nominal Amount | FTI_NOMAMT | CURR | 13(2) | WERTV7 | ||||
NOM_AMOUNT_RCV | Nominal Amount: Incoming Side of Transaction | FTI_BGSCHF2 | CURR | 13(2) | WERTV7 | ||||
NOM_AMOUNT_PAY | Nominal Amount: Outgoing Side of Transaction | FTI_BGSCHF1 | CURR | 13(2) | WERTV7 | ||||
LEAD_CURRENCY | Leading Currency | FTI_LWAERS | CUKY | 5 | TCURC | WAERS | |||
FOLL_CURRENCY | Following Currency | FTI_FWAERS | CUKY | 5 | TCURC | WAERS | |||
RATE | Rate of Forex Transaction | TB_KKURS | DEC | 13(9) | TB_KKURS | ||||
SPOTRATE | Spot Rate | TB_KKASSA | DEC | 13(9) | TB_KKURS | ||||
SWAPRATE | Swap Rate | TB_KSWAP | DEC | 13(9) | T_SWKURS | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
QUANTITY_TRADED | Commodity Quantity to Be Delivered | FTI_CTY_QUAN_DELVRD | QUAN | 25(5) | FTI_CTY_QUAN | ||||
COMMODITY_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CONTRACT_PRICE | Commodity Price | FTR_COMPRICE | DEC | 13(5) | FTR_COMPRICE | ||||
CTY_SPOT_PRICE | Commodity spot price | FTI_CTY_SPOT_PRC | DEC | 13(5) | FTR_COMPRICE | ||||
PRICE_CCYUNT | Commodity price currency unit | FTI_CTY_CCYUNT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
CONT_BACK | Commodity Contango / Backwardation | FTR_CONBACK | DEC | 13(5) | FTR_COMPRICE | ||||
EFF_INT | Effective Interest Rate | TB_PYIELD | DEC | 10(7) | DECV3_7 | ||||
EFF_INT_METHOD | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
INT_CAT | Interest Category | FTI_INTTYPE | CHAR | 1 | FTI_INTEREST_TYPE | ||||
INT_CURRENT | Nominal Interest Rate | FTI_NOMINALZINS | DEC | 10(7) | DEC3_7 | ||||
INT_REF | Reference Interest Rate | FTI_INTREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
INT_FORMULA | String for Interest Formula | FTI_XINTFORMULA | CHAR | 132 | TEXT132 | ||||
INT_STATUS | Interest Fixing Status | FTI_INTSTATUS | CHAR | 1 | FTI_INTSTATUS | ||||
INT_NEXT_FIX | Next Interest Rate Adjustment Date | FTI_NEXT_FIXDATE | DATS | 8 | DATUM | ||||
INT_AMOUNT | Interest Amount | FTI_INTAMOUNT | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CURRENCY | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
INT_CAT_IN | Interest Category of Incoming Side | FTI_INTTYPE_IN | CHAR | 1 | FTI_INTEREST_TYPE | ||||
INT_CURRENT_IN | Nominal Interest Rate of Incoming Side | FTI_NOMINALZINS_IN | DEC | 10(7) | DEC3_7 | ||||
INT_REF_IN | Reference Interest Rate Incoming Side | FTI_INTREF_IN | CHAR | 10 | Assigned to domain | ZIREFKU | |||
INT_FORMULA_IN | String for Interest Formula of Incoming Side | FTI_XINTFORMULA_IN | CHAR | 132 | TEXT132 | ||||
INT_STATUS_IN | Interest Fixing Status: Incoming Side | FTI_INTSTATUS_IN | CHAR | 1 | FTI_INTSTATUS | ||||
INT_NEXT_FIX_IN | Next Interest Rate Adjustment Date of Incoming Side | FTI_NEXT_FIXDATE_IN | DATS | 8 | DATUM | ||||
INT_AMOUNT_IN | Interest Amount of Incoming Side | FTI_INTAMOUNT_IN | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CURRENCY_IN | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
INT_CAT_OUT | Interest Category of Outgoing Side | FTI_INTTYPE_OUT | CHAR | 1 | FTI_INTEREST_TYPE | ||||
INT_CURRENT_OUT | Nominal Interest Rate of Outgoing Side | FTI_NOMINALZINS_OUT | DEC | 10(7) | DEC3_7 | ||||
INT_REF_OUT | Reference Interest Rate of Outgoing Side | FTI_INTREF_OUT | CHAR | 10 | Assigned to domain | ZIREFKU | |||
INT_FORMULA_OUT | String for Interest Formula of Outgoing Side | FTI_XINTFORMULA_OUT | CHAR | 132 | TEXT132 | ||||
INT_STATUS_OUT | Interest Fixing Status: Outgoing Side | FTI_INTSTATUS_OUT | CHAR | 1 | FTI_INTSTATUS | ||||
INT_NEXT_FIX_OUT | Next Interest Rate Adjustment Date of Outgoing Side | FTI_NEXT_FIXDATE_OUT | DATS | 8 | DATUM | ||||
INT_AMOUNT_OUT | Interest Amount of Outgoing Side | FTI_INTAMOUNT_OUT | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CURRENCY_OUT | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
PUT_CALL | Put/Call Indicator | FTI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
EXPIRATION_DATE | Exercise Date | FTI_DMATUR | DATS | 8 | DATUM | ||||
STRIKE_CURRENCY | Strike Currency of Option/Future | FTI_OFWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
STRIKE_AMOUNT | Option Strike Amount | FTI_OSTRIKE | CURR | 13(2) | WERTV7 | ||||
SETTLEMENT_TYPE | Settlement indicator | TI_SETTLFL | CHAR | 1 | T_SETTLFL | ||||
OPTION_CATEGORY | Original option category (on closing) | TV_OPTTYP | NUMC | 3 | Assigned to domain | T_OPTTYP | |||
DIR_STRIKEAMOUNT | Direction of Strike Amount | FTI_OSSIGN | CHAR | 1 | T_SSIGN | ||||
BARRIER_CATEGORY | Category of Knock-In/Knock-Out Level | TI_SLEVELT | NUMC | 2 | T_SLEVELT | ||||
LEAD_CURR_UL | Leading Currency of Underlying Transaction | FTI_LWAERS_UL | CUKY | 5 | Assigned to domain | WAERS | |||
FOLLOW_CURR_UL | Following Currency of Underlying Transaction | FTI_FWAERS_UL | CUKY | 5 | Assigned to domain | WAERS | |||
BARRIER | Barrier as forex rate for exotic options | TX_KWKURB1 | DEC | 13(9) | TB_KKURS | ||||
BARRIER2 | Barrier 2 as forex rate for exotic options | TX_KWKURB2 | DEC | 13(9) | TB_KKURS | ||||
PREMIUM_AMT_PYC | Option Premium in Payment Currency | FTI_PREMIUM_PYC | CURR | 13(2) | WERTV7 | ||||
PREMIUM_DATE | Premium Payment Date | FTI_PREMIUM_DATE | DATS | 8 | DATUM | ||||
HOUSEBNK_IN | Short Key for Own House Bank: Incoming Side | FTI_HBANK_IN | CHAR | 5 | Assigned to domain | HBKID | |||
HOUSEBNKACCT_IN | Short Key for House Bank Account: Incoming Side | FTI_HBACCT_IN | CHAR | 5 | Assigned to domain | HKTID | |||
PAYER_PAYEE_IN | Payer/Payee of Incoming Side | FTI_PAYERPAYEE_IN | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNERBNK_IN | Partner Bank Details of Incoming Side | FTI_PBANK_IN | CHAR | 4 | BVTYP | ||||
HOUSEBNK_OUT | Short Key for Own House Bank: Outgoing Side | FTI_HBANK_OUT | CHAR | 5 | Assigned to domain | HBKID | |||
HOUSEBNKACCT_OUT | Short Key for House Bank Account: Outgoing Side | FTI_HBACCT_OUT | CHAR | 5 | Assigned to domain | HKTID | |||
PAYER_PAYEE_OUT | Payer/Payee of Outgoing Side | FTI_PAYERPAYEE_OUT | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNERBNK_OUT | Partner Bank Details of Outgoing Side | FTI_PBANK_OUT | CHAR | 4 | BVTYP | ||||
EXERCISE_TYPE | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
SECURITY_ACC_UL | Securities Account Underlying | FTI_SEC_ACC_UL | CHAR | 10 | Assigned to domain | RLDEPO | |||
SECURITY_ID_UL | Security ID Underlying | FTI_SEC_ID_UL | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | ||
UNITS_UL | Units Underlying | FTI_UNITS_UL | DEC | 22(6) | TPM_UNITS | ||||
STRIKE | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15(6) | VVPKTKUR | ||||
COMMODITY_ID2 | Commodity ID Incoming | FTI_COMM_ID_IN | CHAR | 18 | TPM_CTY_ID | ||||
QUANTITY_IN | Incoming Commodity Quantity | FTI_QUAN_IN | QUAN | 13(3) | FTR_QUAN | ||||
UOM_IN | Unit of Measure for Incoming Commodity | FTI_UOM_IN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CTY_PRICE_IN | Incoming Comodity Price | FTI_CTY_PRICE_IN | DEC | 13(5) | FTR_COMPRICE | ||||
QUOT_NAME_IN | Incoming Quotation Name | FTI_QUOTNAME_IN | CHAR | 18 | FTI_QUOTNAME | ||||
QUOT_SOURC_IN | Incoming Quotation Source | FTI_QUOTSOURCE_IN | CHAR | 2 | Assigned to domain | TCR_CTY_QUOTSRC | |||
QUOT_TYPE_IN | Incoming Quotation Type | FTI_QUOTTYPE_IN | CHAR | 5 | Assigned to domain | TCR_CTY_QUOTTYPE | |||
CTY_SPREAD_IN | Spread Incoming Side | FTI_SPREAD_IN | DEC | 10(7) | DECV3_7 | ||||
PRICE_CURR_UNIT_IN | Commodity Price Currency Unit Incoming | FTI_PCURR_UNIT_IN | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
PRICE_UOM_IN | Commodity Price Uom Incoming | FTI_PRC_UOM_IN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
COMMODITY_ID1 | Commodity ID Outgoing | FTI_COMM_ID_OUT | CHAR | 18 | TPM_CTY_ID | ||||
QUANTITY_OUT | Outgoing Commodity Quantity | FTI_QUAN_OUT | QUAN | 13(3) | FTR_QUAN | ||||
UOM_OUT | Unit of Measure for Outgoing Commodity | FTI_UOM_OUT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CTY_PRICE_OUT | Outgoing Commodity Price | FTI_CTY_PRICE_OUT | DEC | 13(5) | FTR_COMPRICE | ||||
QUOT_NAME_OUT | Outgoing Quotation Name | FTI_QUOTNAME_OUT | CHAR | 18 | FTI_QUOTNAME | ||||
QUOT_SOURC_OUT | Outgoing Quotation Source | FTI_QUOTSOURCE_OUT | CHAR | 2 | Assigned to domain | TCR_CTY_QUOTSRC | |||
QUOT_TYPE_OUT | Outgoing Quotation Type | FTI_QUOTTYPE_OUT | CHAR | 5 | Assigned to domain | TCR_CTY_QUOTTYPE | |||
CTY_SPREAD_OUT | Spread Outgoing Side | FTI_SPREAD_OUT | DEC | 10(7) | DECV3_7 | ||||
PRICE_CURR_UNIT_OUT | Commodity Price Currency Unit Outgoing | FTI_PCURR_UNIT_OUT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
PRICE_UOM_OUT | Commodity Price Uom Outgoing | FTI_PRC_UOM_OUT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DIV_PCTC_OTC | Percentage of Dividend agreed for Payment in OTC Instruments | TB_DIV_PCTC_OTC | DEC | 7(4) | T_DIV_PCTC_OTC |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_OTC_DEAL_1 using ABAP code?
As FTI_LDB_TR_OTC_DEAL_1 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_OTC_DEAL_1 as there is no data to select.How to access SAP table FTI_LDB_TR_OTC_DEAL_1
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_OTC_DEAL_1 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