FTI_LDB_TR_DEAL_MAIN SAP (Treasury: Transaction Reporting, Main Data (-> LDB)) Structure details
Description: Treasury: Transaction Reporting, Main Data (-> LDB)
Related tables to FTI_LDB_TR_DEAL_MAIN
Access table FTI_LDB_TR_DEAL_MAIN
Structure field list including key, data, relationships and ABAP select examples
FTI_LDB_TR_DEAL_MAIN 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: Transaction Reporting, Main Data (-> LDB)" 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_DEAL_MAIN TYPE FTI_LDB_TR_DEAL_MAIN.
The FTI_LDB_TR_DEAL_MAIN table consists of various fields, each holding specific information or linking keys about Treasury: Transaction Reporting, Main Data (-> LDB) data available in SAP. These include COMPANYCODE (Company Code), DEAL_NUMBER (Position-Generating Financial Transaction), SE_DEAL_NUMBER (Securities/Futures Transaction), SIDE (Direction of Transaction).. 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: Can be enhanced (character-type or numeric)
SAP FTI_LDB_TR_DEAL_MAIN 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 |
SE_DEAL_NUMBER | Securities/Futures Transaction | FTI_SE_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
SIDE | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
REFERENCE_NO | Reference number (unit no.) | KL_NR | CHAR | 10 | Assigned to domain | ALPHA | KL_NR | T30 | |
REFERENCE_TYPE | Reference Category (Unit Category) | KL_TYP | CHAR | 3 | ATR1 | KL_TYP | T31 | ||
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 | |
ABWTYP | Processing Category | TB_ABWTYP | CHAR | 5 | AT05 | T_ABWTYP | |||
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 | ||||
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 | ||||
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 |
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 | |||
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 | ||||
REVERSAL_REASON | Reason for Reversal | SSTOGRD | CHAR | 2 | TZST | SSTOGRD | |||
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 | ||||
IGT_STATUS | IGT: Status of an Intragroup transaction | TPM_IGT_STATUS | CHAR | 1 | TPM_IGT_STATUS | ||||
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 | ||||
UNITS | Units | FTI_POSITIONS_UNITS | DEC | 22(6) | TPM_UNITS | ||||
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 | FTI_LDB_RATE_FE | DEC | 13(9) | EXLDB | FTI_LDB_RATE_FE | |||
SPOTRATE | Spot Rate | TB_KKASSA | DEC | 13(9) | TB_KKURS | ||||
SWAPRATE | Swap Rate | TB_KSWAP | DEC | 13(9) | T_SWKURS | ||||
SECPRICE_UNIT | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15(6) | VVPKTKUR | ||||
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ACC_CCD_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | Assigned to domain | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
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_NEXT_DUE | Next Interest Due Date | FTI_NEXT_DUEDATE | 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_NEXT_DUE_IN | Next Interest Due Date | FTI_NEXT_DUEDATE | 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_NEXT_DUE_OUT | Next Interest Due Date | FTI_NEXT_DUEDATE | 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 | ||||
PUT_CALL_EXT | External Put/Call Indicator | FTI_SPUTCAL_EXT | CHAR | 10 | T_CHAR10 | ||||
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 | ||||
STRIKE_PRICE | Strike Price (Upper Limit for Cap, Lower Limit for Floor) | FTI_STRIKE_PRICE | DEC | 10(7) | DECV3_7 | ||||
EXERCISE_TYPE | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
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 | |||
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 | ||||
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_AMT_LC | Option Premium in Local Currency | FTI_PREMIUM_LC | CURR | 13(2) | WERTV7 | ||||
PREMIUM_DATE | Premium Payment Date | FTI_PREMIUM_DATE | DATS | 8 | DATUM | ||||
BPRC_SPOT1 | Current Spot Rate in Percentage | TB_BPPRC_SPOT1 | DEC | 15(6) | VVPKTKUR | ||||
BPRC_SPOT2 | Spot Rate at Maturity in Percentage | TB_BPPRC_SPOT_MAT | DEC | 15(6) | VVPKTKUR | ||||
COST_FWD | Forward Rate Cost | TB_COSTFWD | DEC | 15(6) | VVPKTKUR | ||||
INTEREST_FWD | Forward Rate Interest | TB_INTERESTFWD | DEC | 15(6) | DECV9_6 | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TRCOT_CTY_MASTER | 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 | ||
QUOTATION_NAME | Quotation Name | FTI_QUOTNAME | CHAR | 18 | FTI_QUOTNAME | ||||
QUOTATION_SOURCE | Quotation Source | TCR_CTY_QUOTSRC | CHAR | 2 | Assigned to domain | TCR_CTY_QUOTSRC | |||
QUOTATION_TYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | CHAR | 5 | Assigned to domain | TCR_CTY_QUOTTYPE | |||
SPREAD | Commodity Spread | FTR_COMSPREAD | DEC | 13(5) | FTR_COMPRICE | ||||
CONTRACT_PRICE | Commodity Contract Price | FTI_CTY_PRICE | DEC | 13(5) | FTR_COMPRICE | ||||
CTY_SPOT_PRICE | Commodity spot price | FTI_CTY_SPOT_PRC | DEC | 13(5) | FTR_COMPRICE | ||||
CONT_BACK | Commodity Contango / Backwardation | FTR_CONBACK | DEC | 13(5) | FTR_COMPRICE | ||||
PRICE_CURR_UNIT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
PRICE_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CMDTY_FIX_STATUS | Commodity Fixing Status | FTI_CMDTY_FIX_STATUS | CHAR | 1 | FTI_CMDTY_FIX_STATUS | ||||
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 | ||
CMDTY_FIX_STATUS_IN | Commodity Fixing Status: Incoming Side | FTI_CMDTY_FIX_STATUS_IN | CHAR | 1 | FTI_CMDTY_FIX_STATUS | ||||
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 | ||
CMDTY_FIX_STATUS_OUT | Commodity Fixing Status: Outgoing Side | FTI_CMDTY_FIX_STATUS_OUT | CHAR | 1 | FTI_CMDTY_FIX_STATUS | ||||
UL_LOAN | Underlying Loan Contract | FTR_UL_LOAN | CHAR | 13 | ALPHA | RANL | RAD | FTRH_UL_LOAN | |
FORWARD_RATE | Pay-in/disbursement rate | KZAHLUNG | DEC | 10(7) | DEC3_7 | ||||
CALC_CCY | Evaluation Currency | AFW_EVAL_CURRENCY | CUKY | 5 | TCURC | WAERS | |||
POSITION_CCY | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
LOCAL_CCY | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_CC | RM NPV in Evaluation Currency | TV_NPV_CC | CURR | 15(2) | WERTV8_TR | ||||
NPV_LONG_PC | RM NPV of Incoming Side in Currency of Incoming Side | TV_NPV_LONG_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_SHORT_PC | RM NPV of Outgoing Side in Currency of Outgoing Side | TV_NPV_SHORT_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_LONG_CC | RM NPV of Incoming Side in Evaluation Currency | TV_NPV_LONG_CC | CURR | 15(2) | WERTV8_TR | ||||
NPV_SHORT_CC | RM NPV of Outgoing Side in Evaluation Currency | TV_NPV_SHORT_CC | CURR | 15(2) | WERTV8_TR | ||||
CLEAN_PRICE_PC | Clean Price in Position Currency | TV_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
CLEAN_PRICE_CC | Clean Price in Valuation Currency | FTI_CLEAN_PRICE_CC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC | Basis Point Value in Position Currency | TV_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_CC | Basis Point Value in Evaluation Currency | TV_VALBP | CURR | 17(2) | T_PRESVAL | ||||
MAC_DURATION | Macaulay Duration | TV_MAC_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
FW_DURATION | Fisher/Weil Duration | TV_FISHER_WEIL_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
CONVEXITY | Convexity with 5 Decimal Places | TV_CONVEXITY_MORE_ACCURATE | DEC | 11(5) | DEC6_5SIGN | ||||
DELTA | Delta, 1st derivation of premium based on underlying rate | TV_DELTA | DEC | 15(10) | T_SENSI | ||||
GAMMA | Gamma, 2nd derivation of premium based on underlying rate | TV_GAMMA | DEC | 14(8) | T_GAMMA | ||||
THETA | Theta, 1st derivation of premium according to time | TV_THETA | DEC | 15(10) | T_SENSI | ||||
VEGA | Vega, 1st Volatility Derivative | TV_VEGA | DEC | 15(10) | T_SENSI | ||||
NUMBER_TRADED | Traded Number of Units for Unit-Quoted Securities/Futures | FTI_NUMBER_TRADED | DEC | 15(5) | ASTUECK | ||||
NOM_AMT_TRADED | Traded Nominal Amount | FTI_NOMAMT_TRADED | CURR | 13(2) | WERTV7 | ||||
NOMORGAMT_TRADED | Traded Original Nominal Amount | FTI_NOMORGAMT_TRADED | CURR | 13(2) | WERTV7 | ||||
PRICE_TRADED | Traded Price of Security (Mixed Representation) | FTI_PRICE_TRADED | DEC | 15(6) | FTI_PRICE_TRADED | ||||
PRICE_CCYUNT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
PRICE_CCYUNT_PRC | Quotation Currency Unit / Percent (Mixed Representation) | FTI_QUOT_UNIT_PRCT | CHAR | 5 | FTI_QUOT_UNIT_PRCT | ||||
QUOTATION | Quotation type for option, future, security etc. | TB_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
MARKET_VAL_QC | Market Value in Quotation Currency | TB_BEBETR | CURR | 13(2) | WERTV7 | ||||
QUOTATION_CCY | Quotation Currency | FTI_QUOT_CCY | CUKY | 5 | Assigned to domain | WAERS | |||
MARKET_VAL_CC | Market Value in Payment Currency | FTI_MARKET_CC | CURR | 21(2) | TPM_AMOUNT | ||||
FX_RATE_TO_CC | Payment currency rate | TB_KZWKURS | DEC | 9(5) | EXCRT | UKURS | |||
MARKET_VAL_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 21(2) | TPM_AMOUNT | ||||
FX_RATE_TO_PC | Position currency rate | TB_KBWKURS | DEC | 9(5) | EXCRT | UKURS | |||
MARKET_VAL_LC | Market Value in Local Currency | FTI_MARKET_LC | CURR | 21(2) | TPM_AMOUNT | ||||
FX_RATE_TO_LC | Local currency rate | TB_KHWKURS | DEC | 9(5) | EXCRT | UKURS | |||
LIMIT_DATE | Limit date | TB_LIMITDA | 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 | ||||
PURCH_PC | Purchase Value in Position Currency | FTI_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_LC | Purchase Value in Local Currency | FTI_PURCH_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_LC | Acquisition Value in Local Currency | FTI_AQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_LC | Book Value in Local Currency | FTI_BOOK_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_LC | Security Valuation in Local Currency | FTI_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_LC | Foreign Currency Valuation in Local Currency | FTI_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in Position Currency | FTI_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in Local Currency | FTI_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_NPL_LC | Foreign Currency Valuation, Not Affecting P/L, in Local Crcy | FTI_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Currency | FTI_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_LC | Swap or Margin Accrual/Deferral in Local Currency | FTI_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPVAL_LC | Swap Valuation in Local Currency | FTI_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALP_LC | Spot Valuation of Purchase Currency in Local Currency | FTI_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALS_LC | Spot Valuation of Sale Currency in Local Currency | FTI_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
DIV_PCTC_OTC | Percentage of Dividend agreed for Payment in OTC Instruments | TB_DIV_PCTC_OTC | DEC | 7(4) | T_DIV_PCTC_OTC | ||||
FIXING_DATE | Fixing date | TB_DFIX | DATS | 8 | DATUM | ||||
CLEARING_OPTION | Central Clearing Option (TREA) | TPM_TREA_CLEARING_OPT | NUMC | 1 | TPM_TREA_CLEARING_OPT | ||||
CLEARING_STATUS | Clearing Status (TREA) | TPM_TREA_CLEARING_STATUS | NUMC | 1 | TPM_TREA_CLEARING_STATUS | ||||
CLEARING_DATE | Planned Clearing Date | TPM_TREA_CLEARING_DATE | DATS | 8 | TPM_TREA_CLEARING_DATE | ||||
EXT_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
CLEAR_DATE_ACT | Actual Clearing Date | TPM_TREA_CLEARING_DATE_ACT | DATS | 8 | TPM_TREA_CLEARING_DATE | ||||
FORWARD_DATE | Forward Date | FTR_FWDDATE | DATS | 8 | DATS |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_LDB_TR_DEAL_MAIN using ABAP code?
As FTI_LDB_TR_DEAL_MAIN 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_DEAL_MAIN as there is no data to select.How to access SAP table FTI_LDB_TR_DEAL_MAIN
Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_DEAL_MAIN 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