1. Home
  2. Resources
  3. SAP Tables
  4. FTI_LDB_TR_DEAL_MAIN - Treasury: Transaction Reporting, Main Data (-> LDB)

SAP Table FTI_LDB_TR_DEAL_MAIN

Treasury: Transaction Reporting, Main Data (-> LDB)

FTI_LDB_TR_DEAL_MAIN (Treasury: Transaction Reporting, Main Data (-> LDB)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FTI_LDB_TR_DEAL_MAIN to other SAP tables.

FTI_LDB_TR_DEAL_MAIN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
COMPANYCODE Company Code BUKRS T001 CHAR 4 0
DEAL_NUMBER Position-Generating Financial Transaction FTI_POSRFHA CHAR 13 0
SE_DEAL_NUMBER Securities/Futures Transaction FTI_SE_RFHA CHAR 13 0
SIDE Direction of Transaction TB_RKONDGR NUMC 1 0
0 Incoming and outgoing
1 Outgoing
2 Incoming
REFERENCE_NO Reference number (unit no.) KL_NR CHAR 10 0
REFERENCE_TYPE Reference Category (Unit Category) KL_TYP ATR1 CHAR 3 0
OBJECTNUMBER Object number J_OBJNR CHAR 22 0
CREATE_USER Entered by TB_CRUSER CHAR 12 0
CREATE_DATE Entered On TB_DCRDAT DATS 8 0
CREATE_TIME Entry Time TB_TCRTIM TIMS 6 0
UPDATE_USER Last Changed by TB_UPUSER CHAR 12 0
UPDATE_DATE Changed on TB_DUPDAT DATS 8 0
UPDATE_TIME Time changed TB_TUPTIM TIMS 6 0
CONTRACT_TYPE Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
PRODUCT_CAT Product Category SANLF TZAF NUMC 3 0
PRODUCT_TYPE Product Type VVSART TZPA CHAR 3 0
TRANSACTION_CAT Transaction Category TB_SFGTYP AT01 NUMC 3 0
ACTIVITY_CAT Transaction Activity Category TB_SFGZUTY AT02 NUMC 2 0
TRANSACTION_TYPE Financial Transaction Type TB_SFHAART AT10 CHAR 3 0
ABWTYP Processing Category TB_ABWTYP AT05 CHAR 5 0
START_TERM Start of Term FTI_DBLFZ_DEAL DATS 8 0
END_TERM End of Term FTI_DELFZ_DEAL DATS 8 0
ROLLOVER_TERM Rollover Date FTI_ROLLOVER_DEAL DATS 8 0
RLZTG_F Remaining Term in Days FTI_RLZTG_F NUMC 5 0
RLZMO_F Remaining Term in Months FTI_RLZMO_F NUMC 4 0
RLZJA_F Remaining Term in Years FTI_RLZJA_F NUMC 3 0
START_INCLUSIVE Calculation Period: Start Inclusive vs. End Inclusive FTI_SINCLBE CHAR 1 0
NULL Start inclusive
X End inclusive
END_INCLUSIVE End of Term Inclusive Indicator TB_SINCLE CHAR 1 0
X Yes
NULL No
NOTICE_DATE OTC Notice Date TB_NOTICE_DATE DATS 8 0
CONTRACT_DATE Contract Conclusion Date TB_DVTRAB DATS 8 0
CONTRACT_TIME Time of contract conclusion TB_TVTRAB TIMS 6 0
TRADER Trader RDEALER TZDEA CHAR 12 0
COUNTERPARTY Counterparty TB_KONTRH BUT000 CHAR 10 0
TYPE Business Partner Category BP_TYPE_NEW CHAR 1 0
1 Person
2 Organization
3 Group
ISTYPE Industry System BU_ISTYPE TB038 CHAR 4 0
IND_SECTOR Industry BU_IND_SECTOR TB038A CHAR 10 0
CNTRY_COMP Country of Registered Office of Business Partner FTI_LANDBP T005 CHAR 3 0
LEGAL_ENTY Legal Form of Organization BP_LEG_ETY_NEW TB019 CHAR 2 0
LEGAL_ORG Legal Entity of Organization BU_LEGAL_ORG_NEW TB032 CHAR 2 0
NATION Nationality BP_CNTR_N T005 CHAR 3 0
STATE Citizenship BP_CNTR_ST T005 CHAR 3 0
GROUP_ID Business Partner Grouping BU_GRP_ID_NEW TB001 CHAR 4 0
GROUP_D Target Group BP_GROUP_D TP13 CHAR 4 0
STAFF_GRP Employee Group BP_STAFF_G TP05 CHAR 4 0
COMP_RE Organization Relationship BP_COMP_RE CHAR 1 0
1 Affiliated Company
2 Shareholding
3 Other
4 Holding
GRADE Valuation FTI_BP_GRADE TPZ22 CHAR 10 0
GRADE_METHOD Valuation Procedure FTI_BP_GRADE_METHOD TPZ21 CHAR 10 0
SOLVNCY Credit Standing BP_SOLVNCY CHAR 1 0
0 VIP - Preferable Credit Standing
1 Very Good
2 Good
3 Satisfactory
4 Sufficient
5 Poor
6 Unsatisfactory
SOL_INF Status of Credit Standing Information BP_SOL_INF CHAR 1 0
0 Positive
1 Negative
2 Requested
3 Information Agreed
4 information Refused
NULL None
SOL_I_D Date of Credit Standing Information BP_SOL_I_D DATS 8 0
RATING Rating FTI_BP_RATING TP06 CHAR 3 0
SOL_INS Institute providing credit standing information FTI_BP_SOL_INS CHAR 4 0
CONTACT_PERSON Contact Person TB_GSPPART CHAR 19 0
GUARANTOR Guarantor of Financial Transaction TB_RGARANT_NEW BUT000 CHAR 10 0
EXTERNAL_REFNCE External Reference TB_NORDEXT CHAR 16 0
PORTFOLIO Portfolio RPORTB CHAR 10 0
FINANCE_PROJECT Finance Project TB_TFPROJ CHAR 13 0
MASTER_AGREEMENT Master Agreement TB_RMAID CHAR 10 0
ASSIGNMENT Assignment TB_ZUOND CHAR 18 0
INTERNAL_REFNCE Internal Reference TB_REFER CHAR 16 0
CHARACTERISTICS Characteristics TB_MERKM CHAR 25 0
VALUATION_CLASS General Valuation Class TPM_COM_VAL_CLASS TRGC_COM_VALCL NUMC 4 0
FACILITY_DEALNO Transaction Number of Facility TB_FACILITYNR CHAR 13 0
FACILITY_CCODE Company Code of Facility TB_FACILITYBUKRS CHAR 4 0
DEAL_ACTIVE Active Status of Transaction or Activity TB_SAKTIV NUMC 1 0
0 Active
1 Concluded
2 Replaced
3 Reversed
4 Offer
5 Simulation
6 Old Transaction - No Editing Possible
RELEASE_STATUS Transaction Release: Release Status TB_FRGZUST CHAR 1 0
NULL Release Not Checked
1 Release Not Required
2 Release Required
3 Release Granted
4 Release Rejected
REVERSAL_REASON Reason for Reversal SSTOGRD TZST CHAR 2 0
CONFIRM_STATUS Confirmation Status TB_CONF NUMC 1 0
0 Not Required
1 Required
2 Executed
3 Sent
4 Incorrect
CONFIRM_DATE Confirmation Date TB_DCONF DATS 8 0
CONFIRM_USER Confirmation Executed By (User Responsible) TB_UCONF CHAR 12 0
CNTRCONFIRM Counterconfirmation TB_RECONF NUMC 1 0
0 Not Required
1 Required
2 Reminder Sent
3 Matched
4 Incorrect
5 Cannot Be Assigned
CNTRCONFIRM_DATE Counterconfirmation Date TB_DREDAT DATS 8 0
CNTRCONFIRM_USER Counterconfirmation Executed by (User Responsible) TB_URENAM CHAR 12 0
IGT_STATUS IGT: Status of an Intragroup transaction TPM_IGT_STATUS CHAR 1 0
NULL No IGT
1 Open IGT
2 Closed IGT with value transfer
3 Closed IGT without value transfer
CURRENCY Currency of Transaction FTI_WGSCHFT TCURC CUKY 5 0
CURRENCY_RCV Currency of Incoming Side of Transaction FTI_WGSCHF2 TCURC CUKY 5 0
CURRENCY_PAY Currency of Outgoing Side of Transaction FTI_WGSCHF1 TCURC CUKY 5 0
NOM_AMOUNT Nominal Amount FTI_NOMAMT CURR 13 2
NOM_AMOUNT_RCV Nominal Amount: Incoming Side of Transaction FTI_BGSCHF2 CURR 13 2
NOM_AMOUNT_PAY Nominal Amount: Outgoing Side of Transaction FTI_BGSCHF1 CURR 13 2
UNITS Units FTI_POSITIONS_UNITS DEC 22 6
LEAD_CURRENCY Leading Currency FTI_LWAERS TCURC CUKY 5 0
FOLL_CURRENCY Following Currency FTI_FWAERS TCURC CUKY 5 0
RATE Rate of Forex Transaction FTI_LDB_RATE_FE DEC 13 9
SPOTRATE Spot Rate TB_KKASSA DEC 13 9
SWAPRATE Swap Rate TB_KSWAP DEC 13 9
SECPRICE_UNIT Security Price Without Currency Ref. with Unit Quotation TB_BUPRC DEC 15 6
SECURITY_ACCOUNT Securities Account RLDEPO TWD01 CHAR 10 0
SECURITY_ID Security ID Number VVRANLW CHAR 13 0
POSITION_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT CHAR 10 0
EFF_INT Effective Interest Rate TB_PYIELD DEC 10 7
EFF_INT_METHOD Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
INT_CAT Interest Category FTI_INTTYPE CHAR 1 0
1 Fixed Interest Calculation (Plain Vanilla)
2 Scaled Interest
3 Variable Interest Calculation (Floating Rate)
4 Fixed Interest Amount
5 Zero Interest
6 Complex (Variable and Fixed)
7 Variable With Cap
N Not Defined
INT_CURRENT Nominal Interest Rate FTI_NOMINALZINS DEC 10 7
INT_REF Reference Interest Rate FTI_INTREF CHAR 10 0
INT_FORMULA String for Interest Formula FTI_XINTFORMULA CHAR 132 0
INT_STATUS Interest Fixing Status FTI_INTSTATUS CHAR 1 0
1 Interest Fixed
2 Interest Not Fixed
3 No Fixing Required
INT_NEXT_FIX Next Interest Rate Adjustment Date FTI_NEXT_FIXDATE DATS 8 0
INT_NEXT_DUE Next Interest Due Date FTI_NEXT_DUEDATE DATS 8 0
INT_AMOUNT Interest Amount FTI_INTAMOUNT CURR 21 2
INT_CURRENCY Payment Currency TB_WZBETR CUKY 5 0
INT_CAT_IN Interest Category of Incoming Side FTI_INTTYPE_IN CHAR 1 0
1 Fixed Interest Calculation (Plain Vanilla)
2 Scaled Interest
3 Variable Interest Calculation (Floating Rate)
4 Fixed Interest Amount
5 Zero Interest
6 Complex (Variable and Fixed)
7 Variable With Cap
N Not Defined
INT_CURRENT_IN Nominal Interest Rate of Incoming Side FTI_NOMINALZINS_IN DEC 10 7
INT_REF_IN Reference Interest Rate Incoming Side FTI_INTREF_IN CHAR 10 0
INT_FORMULA_IN String for Interest Formula of Incoming Side FTI_XINTFORMULA_IN CHAR 132 0
INT_STATUS_IN Interest Fixing Status: Incoming Side FTI_INTSTATUS_IN CHAR 1 0
1 Interest Fixed
2 Interest Not Fixed
3 No Fixing Required
INT_NEXT_FIX_IN Next Interest Rate Adjustment Date of Incoming Side FTI_NEXT_FIXDATE_IN DATS 8 0
INT_NEXT_DUE_IN Next Interest Due Date FTI_NEXT_DUEDATE DATS 8 0
INT_AMOUNT_IN Interest Amount of Incoming Side FTI_INTAMOUNT_IN CURR 21 2
INT_CURRENCY_IN Payment Currency TB_WZBETR CUKY 5 0
INT_CAT_OUT Interest Category of Outgoing Side FTI_INTTYPE_OUT CHAR 1 0
1 Fixed Interest Calculation (Plain Vanilla)
2 Scaled Interest
3 Variable Interest Calculation (Floating Rate)
4 Fixed Interest Amount
5 Zero Interest
6 Complex (Variable and Fixed)
7 Variable With Cap
N Not Defined
INT_CURRENT_OUT Nominal Interest Rate of Outgoing Side FTI_NOMINALZINS_OUT DEC 10 7
INT_REF_OUT Reference Interest Rate of Outgoing Side FTI_INTREF_OUT CHAR 10 0
INT_FORMULA_OUT String for Interest Formula of Outgoing Side FTI_XINTFORMULA_OUT CHAR 132 0
INT_STATUS_OUT Interest Fixing Status: Outgoing Side FTI_INTSTATUS_OUT CHAR 1 0
1 Interest Fixed
2 Interest Not Fixed
3 No Fixing Required
INT_NEXT_FIX_OUT Next Interest Rate Adjustment Date of Outgoing Side FTI_NEXT_FIXDATE_OUT DATS 8 0
INT_NEXT_DUE_OUT Next Interest Due Date FTI_NEXT_DUEDATE DATS 8 0
INT_AMOUNT_OUT Interest Amount of Outgoing Side FTI_INTAMOUNT_OUT CURR 21 2
INT_CURRENCY_OUT Payment Currency TB_WZBETR CUKY 5 0
PUT_CALL Put/Call Indicator FTI_SPUTCAL NUMC 1 0
1 Put
2 Call
PUT_CALL_EXT External Put/Call Indicator FTI_SPUTCAL_EXT CHAR 10 0
EXPIRATION_DATE Exercise Date FTI_DMATUR DATS 8 0
STRIKE_CURRENCY Strike Currency of Option/Future FTI_OFWAERS CUKY 5 0
STRIKE_AMOUNT Option Strike Amount FTI_OSTRIKE CURR 13 2
STRIKE_PRICE Strike Price (Upper Limit for Cap, Lower Limit for Floor) FTI_STRIKE_PRICE DEC 10 7
EXERCISE_TYPE Exercise Type (American or European) SOPTAUS NUMC 1 0
1 European
2 American
SETTLEMENT_TYPE Settlement indicator TI_SETTLFL CHAR 1 0
1 Physical exercise
2 Cash settlement
* Not yet specified
3 Non-Deliverable Forward
OPTION_CATEGORY Original option category (on closing) TV_OPTTYP NUMC 3 0
SECURITY_ACC_UL Securities Account Underlying FTI_SEC_ACC_UL CHAR 10 0
SECURITY_ID_UL Security ID Underlying FTI_SEC_ID_UL CHAR 13 0
UNITS_UL Units Underlying FTI_UNITS_UL DEC 22 6
STRIKE Security Price Without Currency Ref. with Unit Quotation TB_BUPRC DEC 15 6
DIR_STRIKEAMOUNT Direction of Strike Amount FTI_OSSIGN CHAR 1 0
+ Inflow
- Outflow
BARRIER_CATEGORY Category of Knock-In/Knock-Out Level TI_SLEVELT NUMC 2 0
01 Knock-in exchange rate
02 Knock-out exchange rate
LEAD_CURR_UL Leading Currency of Underlying Transaction FTI_LWAERS_UL CUKY 5 0
FOLLOW_CURR_UL Following Currency of Underlying Transaction FTI_FWAERS_UL CUKY 5 0
BARRIER Barrier as forex rate for exotic options TX_KWKURB1 DEC 13 9
BARRIER2 Barrier 2 as forex rate for exotic options TX_KWKURB2 DEC 13 9
PREMIUM_AMT_PYC Option Premium in Payment Currency FTI_PREMIUM_PYC CURR 13 2
PREMIUM_AMT_LC Option Premium in Local Currency FTI_PREMIUM_LC CURR 13 2
PREMIUM_DATE Premium Payment Date FTI_PREMIUM_DATE DATS 8 0
BPRC_SPOT1 Current Spot Rate in Percentage TB_BPPRC_SPOT1 DEC 15 6
BPRC_SPOT2 Spot Rate at Maturity in Percentage TB_BPPRC_SPOT_MAT DEC 15 6
COST_FWD Forward Rate Cost TB_COSTFWD DEC 15 6
INTEREST_FWD Forward Rate Interest TB_INTERESTFWD DEC 15 6
COMMODITY_ID Commodity ID TRCO_COMM_ID TRCOT_CTY_MASTER CHAR 18 0
QUANTITY_TRADED Commodity Quantity to Be Delivered FTI_CTY_QUAN_DELVRD QUAN 25 5
COMMODITY_UOM Unit of Measure for the Commodity TPM_CTY_UOM UNIT 3 0
QUOTATION_NAME Quotation Name FTI_QUOTNAME CHAR 18 0
QUOTATION_SOURCE Quotation Source TCR_CTY_QUOTSRC CHAR 2 0
QUOTATION_TYPE Commodity Quotation Type TCR_CTY_QUOTTYPE CHAR 5 0
SPREAD Commodity Spread FTR_COMSPREAD DEC 13 5
CONTRACT_PRICE Commodity Contract Price FTI_CTY_PRICE DEC 13 5
CTY_SPOT_PRICE Commodity spot price FTI_CTY_SPOT_PRC DEC 13 5
CONT_BACK Commodity Contango / Backwardation FTR_CONBACK DEC 13 5
PRICE_CURR_UNIT Currency Unit of the Rate TB_RUNIT CHAR 5 0
PRICE_UOM Unit of Measure for the Commodity TPM_CTY_UOM UNIT 3 0
CMDTY_FIX_STATUS Commodity Fixing Status FTI_CMDTY_FIX_STATUS CHAR 1 0
1 Floating Price
2 Fixed Floating Price
3 Fixed Price
COMMODITY_ID2 Commodity ID Incoming FTI_COMM_ID_IN CHAR 18 0
QUANTITY_IN Incoming Commodity Quantity FTI_QUAN_IN QUAN 13 3
UOM_IN Unit of Measure for Incoming Commodity FTI_UOM_IN UNIT 3 0
CTY_PRICE_IN Incoming Comodity Price FTI_CTY_PRICE_IN DEC 13 5
QUOT_NAME_IN Incoming Quotation Name FTI_QUOTNAME_IN CHAR 18 0
QUOT_SOURC_IN Incoming Quotation Source FTI_QUOTSOURCE_IN CHAR 2 0
QUOT_TYPE_IN Incoming Quotation Type FTI_QUOTTYPE_IN CHAR 5 0
CTY_SPREAD_IN Spread Incoming Side FTI_SPREAD_IN DEC 10 7
PRICE_CURR_UNIT_IN Commodity Price Currency Unit Incoming FTI_PCURR_UNIT_IN CHAR 5 0
PRICE_UOM_IN Commodity Price Uom Incoming FTI_PRC_UOM_IN UNIT 3 0
CMDTY_FIX_STATUS_IN Commodity Fixing Status: Incoming Side FTI_CMDTY_FIX_STATUS_IN CHAR 1 0
1 Floating Price
2 Fixed Floating Price
3 Fixed Price
COMMODITY_ID1 Commodity ID Outgoing FTI_COMM_ID_OUT CHAR 18 0
QUANTITY_OUT Outgoing Commodity Quantity FTI_QUAN_OUT QUAN 13 3
UOM_OUT Unit of Measure for Outgoing Commodity FTI_UOM_OUT UNIT 3 0
CTY_PRICE_OUT Outgoing Commodity Price FTI_CTY_PRICE_OUT DEC 13 5
QUOT_NAME_OUT Outgoing Quotation Name FTI_QUOTNAME_OUT CHAR 18 0
QUOT_SOURC_OUT Outgoing Quotation Source FTI_QUOTSOURCE_OUT CHAR 2 0
QUOT_TYPE_OUT Outgoing Quotation Type FTI_QUOTTYPE_OUT CHAR 5 0
CTY_SPREAD_OUT Spread Outgoing Side FTI_SPREAD_OUT DEC 10 7
PRICE_CURR_UNIT_OUT Commodity Price Currency Unit Outgoing FTI_PCURR_UNIT_OUT CHAR 5 0
PRICE_UOM_OUT Commodity Price Uom Outgoing FTI_PRC_UOM_OUT UNIT 3 0
CMDTY_FIX_STATUS_OUT Commodity Fixing Status: Outgoing Side FTI_CMDTY_FIX_STATUS_OUT CHAR 1 0
1 Floating Price
2 Fixed Floating Price
3 Fixed Price
UL_LOAN Underlying Loan Contract FTR_UL_LOAN CHAR 13 0
FORWARD_RATE Pay-in/disbursement rate KZAHLUNG DEC 10 7
CALC_CCY Evaluation Currency AFW_EVAL_CURRENCY TCURC CUKY 5 0
POSITION_CCY Position Currency (Currency of Position Amount) SBWHR CUKY 5 0
LOCAL_CCY Local Currency TB_SHWHR CUKY 5 0
NPV_PC RM Net Present Value in Position Currency TV_NPV_PC CURR 15 2
NPV_CC RM NPV in Evaluation Currency TV_NPV_CC CURR 15 2
NPV_LONG_PC RM NPV of Incoming Side in Currency of Incoming Side TV_NPV_LONG_PC CURR 15 2
NPV_SHORT_PC RM NPV of Outgoing Side in Currency of Outgoing Side TV_NPV_SHORT_PC CURR 15 2
NPV_LONG_CC RM NPV of Incoming Side in Evaluation Currency TV_NPV_LONG_CC CURR 15 2
NPV_SHORT_CC RM NPV of Outgoing Side in Evaluation Currency TV_NPV_SHORT_CC CURR 15 2
CLEAN_PRICE_PC Clean Price in Position Currency TV_CLEAN_PRICE_PC CURR 17 2
CLEAN_PRICE_CC Clean Price in Valuation Currency FTI_CLEAN_PRICE_CC CURR 17 2
BPVALUE_PC Basis Point Value in Position Currency TV_VALBP_PC CURR 17 2
BPVALUE_CC Basis Point Value in Evaluation Currency TV_VALBP CURR 17 2
MAC_DURATION Macaulay Duration TV_MAC_DURATION DEC 12 3
FW_DURATION Fisher/Weil Duration TV_FISHER_WEIL_DURATION DEC 12 3
CONVEXITY Convexity with 5 Decimal Places TV_CONVEXITY_MORE_ACCURATE DEC 11 5
DELTA Delta, 1st derivation of premium based on underlying rate TV_DELTA DEC 15 10
GAMMA Gamma, 2nd derivation of premium based on underlying rate TV_GAMMA DEC 14 8
THETA Theta, 1st derivation of premium according to time TV_THETA DEC 15 10
VEGA Vega, 1st Volatility Derivative TV_VEGA DEC 15 10
NUMBER_TRADED Traded Number of Units for Unit-Quoted Securities/Futures FTI_NUMBER_TRADED DEC 15 5
NOM_AMT_TRADED Traded Nominal Amount FTI_NOMAMT_TRADED CURR 13 2
NOMORGAMT_TRADED Traded Original Nominal Amount FTI_NOMORGAMT_TRADED CURR 13 2
PRICE_TRADED Traded Price of Security (Mixed Representation) FTI_PRICE_TRADED DEC 15 6
PRICE_CCYUNT Currency Unit of the Rate TB_RUNIT CHAR 5 0
PRICE_CCYUNT_PRC Quotation Currency Unit / Percent (Mixed Representation) FTI_QUOT_UNIT_PRCT CHAR 5 0
QUOTATION Quotation type for option, future, security etc. TB_NOTTYPE CHAR 1 0
1 Percentage quotation
2 Direct quotation
3 Point quotation
4 (Obsolete) Inverse Percentage Quotation
5 (Obsolete) Fractional Quotation
MARKET_VAL_QC Market Value in Quotation Currency TB_BEBETR CURR 13 2
QUOTATION_CCY Quotation Currency FTI_QUOT_CCY CUKY 5 0
MARKET_VAL_CC Market Value in Payment Currency FTI_MARKET_CC CURR 21 2
FX_RATE_TO_CC Payment currency rate TB_KZWKURS DEC 9 5
MARKET_VAL_PC Market Value in Position Currency FTI_MARKET_PC CURR 21 2
FX_RATE_TO_PC Position currency rate TB_KBWKURS DEC 9 5
MARKET_VAL_LC Market Value in Local Currency FTI_MARKET_LC CURR 21 2
FX_RATE_TO_LC Local currency rate TB_KHWKURS DEC 9 5
LIMIT_DATE Limit date TB_LIMITDA DATS 8 0
HOUSEBNK_IN Short Key for Own House Bank: Incoming Side FTI_HBANK_IN CHAR 5 0
HOUSEBNKACCT_IN Short Key for House Bank Account: Incoming Side FTI_HBACCT_IN CHAR 5 0
PAYER_PAYEE_IN Payer/Payee of Incoming Side FTI_PAYERPAYEE_IN CHAR 10 0
PARTNERBNK_IN Partner Bank Details of Incoming Side FTI_PBANK_IN CHAR 4 0
HOUSEBNK_OUT Short Key for Own House Bank: Outgoing Side FTI_HBANK_OUT CHAR 5 0
HOUSEBNKACCT_OUT Short Key for House Bank Account: Outgoing Side FTI_HBACCT_OUT CHAR 5 0
PAYER_PAYEE_OUT Payer/Payee of Outgoing Side FTI_PAYERPAYEE_OUT CHAR 10 0
PARTNERBNK_OUT Partner Bank Details of Outgoing Side FTI_PBANK_OUT CHAR 4 0
PURCH_PC Purchase Value in Position Currency FTI_PURCH_PC CURR 21 2
PURCH_LC Purchase Value in Local Currency FTI_PURCH_LC CURR 21 2
AQU_VAL_PC Acquisition Value in Position Currency FTI_AQU_VAL_PC CURR 21 2
AQU_VAL_LC Acquisition Value in Local Currency FTI_AQU_VAL_LC CURR 21 2
BOOK_VAL_PC Book Value in Position Currency FTI_BOOK_VAL_PC CURR 21 2
BOOK_VAL_LC Book Value in Local Currency FTI_BOOK_VAL_LC CURR 21 2
VAL_TI_PC Security Valuation in Position Currency FTI_VAL_TI_PC CURR 21 2
VAL_TI_LC Security Valuation in Local Currency FTI_VAL_TI_LC CURR 21 2
VAL_FX_LC Foreign Currency Valuation in Local Currency FTI_VAL_FX_LC CURR 21 2
VAL_TI_NPL_PC Security Valuation, Not Affecting P/L, in Position Currency FTI_VAL_TI_NPL_PC CURR 21 2
VAL_TI_NPL_LC Security Valuation, Not Affecting P/L, in Local Currency FTI_VAL_TI_NPL_LC CURR 21 2
VAL_FX_NPL_LC Foreign Currency Valuation, Not Affecting P/L, in Local Crcy FTI_VAL_FX_NPL_LC CURR 21 2
SWAPACC_PC Swap/Margin Accrual/Deferral in Position Currency FTI_SWAPACC_PC CURR 21 2
SWAPACC_LC Swap or Margin Accrual/Deferral in Local Currency FTI_SWAPACC_LC CURR 21 2
SWAPVAL_LC Swap Valuation in Local Currency FTI_SWAPVAL_LC CURR 21 2
SPOTVALP_LC Spot Valuation of Purchase Currency in Local Currency FTI_SPOTVALP_LC CURR 21 2
SPOTVALS_LC Spot Valuation of Sale Currency in Local Currency FTI_SPOTVALS_LC CURR 21 2
DIV_PCTC_OTC Percentage of Dividend agreed for Payment in OTC Instruments TB_DIV_PCTC_OTC DEC 7 4
FIXING_DATE Fixing date TB_DFIX DATS 8 0
CLEARING_OPTION Central Clearing Option (TREA) TPM_TREA_CLEARING_OPT NUMC 1 0
0 Not Relevant
1 Central Clearing Optional
2 Central Clearing Mandatory
3 Central Clearing Already Occurred
CLEARING_STATUS Clearing Status (TREA) TPM_TREA_CLEARING_STATUS NUMC 1 0
0 Not Relevant for Clearing
1 Clearing Requested (Planned)
2 Clearing Accepted
3 Clearing Rejected
CLEARING_DATE Planned Clearing Date TPM_TREA_CLEARING_DATE DATS 8 0
EXT_ACCOUNT External Account TPM_EXT_ACCOUNT CHAR 10 0
CLEAR_DATE_ACT Actual Clearing Date TPM_TREA_CLEARING_DATE_ACT DATS 8 0
FORWARD_DATE Forward Date FTR_FWDDATE DATS 8 0

FTI_LDB_TR_DEAL_MAIN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FTI_LDB_TR_DEAL_MAIN ABWTYP FTI_LDB_TR_DEAL_MAIN TRANSACTION_CAT AT05 Processing Categories SFGTYP
FTI_LDB_TR_DEAL_MAIN ABWTYP FTI_LDB_TR_DEAL_MAIN ABWTYP AT05 Processing Categories ABWTYP
FTI_LDB_TR_DEAL_MAIN ABWTYP FTI_LDB_TR_DEAL_MAIN PRODUCT_CAT AT05 Processing Categories SANLF
FTI_LDB_TR_DEAL_MAIN ACTIVITY_CAT FTI_LDB_TR_DEAL_MAIN PRODUCT_CAT AT02 Transaction Activity Category SANLFOR
FTI_LDB_TR_DEAL_MAIN ACTIVITY_CAT FTI_LDB_TR_DEAL_MAIN TRANSACTION_CAT AT02 Transaction Activity Category SFGTYP
FTI_LDB_TR_DEAL_MAIN ACTIVITY_CAT FTI_LDB_TR_DEAL_MAIN ACTIVITY_CAT AT02 Transaction Activity Category SFGZUSTT
FTI_LDB_TR_DEAL_MAIN CALC_CCY FTI_LDB_TR_DEAL_MAIN MANDT TCURC Currency Codes MANDT
FTI_LDB_TR_DEAL_MAIN CALC_CCY FTI_LDB_TR_DEAL_MAIN CALC_CCY TCURC Currency Codes WAERS
FTI_LDB_TR_DEAL_MAIN CNTRY_COMP SYST MANDT T005 Countries MANDT
FTI_LDB_TR_DEAL_MAIN CNTRY_COMP FTI_LDB_TR_DEAL_MAIN CNTRY_COMP T005 Countries LAND1
FTI_LDB_TR_DEAL_MAIN COMMODITY_ID FTI_LDB_TR_DEAL_MAIN MANDT TRCOT_CTY_MASTER Commodity master data MANDT
FTI_LDB_TR_DEAL_MAIN COMMODITY_ID FTI_LDB_TR_DEAL_MAIN COMMODITY_ID TRCOT_CTY_MASTER Commodity master data COMMODITY_ID
FTI_LDB_TR_DEAL_MAIN COMPANYCODE FTI_LDB_TR_DEAL_MAIN MANDT T001 Company Codes MANDT
FTI_LDB_TR_DEAL_MAIN COMPANYCODE FTI_LDB_TR_DEAL_MAIN COMPANYCODE T001 Company Codes BUKRS
FTI_LDB_TR_DEAL_MAIN COUNTERPARTY FTI_LDB_TR_DEAL_MAIN MANDT BUT000 BP: General data I CLIENT
FTI_LDB_TR_DEAL_MAIN COUNTERPARTY FTI_LDB_TR_DEAL_MAIN COUNTERPARTY BUT000 BP: General data I PARTNER
FTI_LDB_TR_DEAL_MAIN CURRENCY FTI_LDB_TR_DEAL_MAIN MANDT TCURC Currency Codes MANDT
FTI_LDB_TR_DEAL_MAIN CURRENCY FTI_LDB_TR_DEAL_MAIN CURRENCY TCURC Currency Codes WAERS
FTI_LDB_TR_DEAL_MAIN CURRENCY_PAY FTI_LDB_TR_DEAL_MAIN MANDT TCURC Currency Codes MANDT
FTI_LDB_TR_DEAL_MAIN CURRENCY_PAY FTI_LDB_TR_DEAL_MAIN CURRENCY_PAY TCURC Currency Codes WAERS
FTI_LDB_TR_DEAL_MAIN CURRENCY_RCV FTI_LDB_TR_DEAL_MAIN CURRENCY_RCV TCURC Currency Codes WAERS
FTI_LDB_TR_DEAL_MAIN CURRENCY_RCV FTI_LDB_TR_DEAL_MAIN MANDT TCURC Currency Codes MANDT
FTI_LDB_TR_DEAL_MAIN FOLL_CURRENCY FTI_LDB_TR_DEAL_MAIN MANDT TCURC Currency Codes MANDT
FTI_LDB_TR_DEAL_MAIN FOLL_CURRENCY FTI_LDB_TR_DEAL_MAIN FOLL_CURRENCY TCURC Currency Codes WAERS
FTI_LDB_TR_DEAL_MAIN GRADE SYST MANDT TPZ22 Business Partner: Ratings CLIENT
FTI_LDB_TR_DEAL_MAIN GRADE FTI_LDB_TR_DEAL_MAIN GRADE_METHOD TPZ22 Business Partner: Ratings GRADE_METHOD
FTI_LDB_TR_DEAL_MAIN GRADE FTI_LDB_TR_DEAL_MAIN GRADE TPZ22 Business Partner: Ratings GRADE
FTI_LDB_TR_DEAL_MAIN GRADE_METHOD SYST MANDT TPZ21 Business Partner: Rating Procedure CLIENT
FTI_LDB_TR_DEAL_MAIN GRADE_METHOD FTI_LDB_TR_DEAL_MAIN GRADE_METHOD TPZ21 Business Partner: Rating Procedure GRADE_METHOD
FTI_LDB_TR_DEAL_MAIN GROUP_D SYST MANDT TP13 Business Partner: Partner Grouping (Target Group) MANDT
FTI_LDB_TR_DEAL_MAIN GROUP_D FTI_LDB_TR_DEAL_MAIN GROUP_D TP13 Business Partner: Partner Grouping (Target Group) GROUP_D
FTI_LDB_TR_DEAL_MAIN GROUP_ID SYST MANDT TB001 BP groupings MANDT
FTI_LDB_TR_DEAL_MAIN GROUP_ID FTI_LDB_TR_DEAL_MAIN GROUP_ID TB001 BP groupings BU_GROUP
FTI_LDB_TR_DEAL_MAIN GUARANTOR FTI_LDB_TR_DEAL_MAIN MANDT BUT000 BP: General data I CLIENT
FTI_LDB_TR_DEAL_MAIN GUARANTOR FTI_LDB_TR_DEAL_MAIN GUARANTOR BUT000 BP: General data I PARTNER
FTI_LDB_TR_DEAL_MAIN IND_SECTOR SYST MANDT TB038A BP Industry Key CLIENT
FTI_LDB_TR_DEAL_MAIN IND_SECTOR FTI_LDB_TR_DEAL_MAIN ISTYPE TB038A BP Industry Key ISTYPE
FTI_LDB_TR_DEAL_MAIN IND_SECTOR FTI_LDB_TR_DEAL_MAIN IND_SECTOR TB038A BP Industry Key IND_SECTOR
FTI_LDB_TR_DEAL_MAIN ISTYPE FTI_LDB_TR_DEAL_MAIN ISTYPE TB038 BP Industry Key Systems ISTYPE
FTI_LDB_TR_DEAL_MAIN ISTYPE SYST MANDT TB038 BP Industry Key Systems CLIENT
FTI_LDB_TR_DEAL_MAIN LEAD_CURRENCY FTI_LDB_TR_DEAL_MAIN MANDT TCURC Currency Codes MANDT
FTI_LDB_TR_DEAL_MAIN LEAD_CURRENCY FTI_LDB_TR_DEAL_MAIN LEAD_CURRENCY TCURC Currency Codes WAERS
FTI_LDB_TR_DEAL_MAIN LEGAL_ENTY SYST MANDT TB019 BP legal forms CLIENT
FTI_LDB_TR_DEAL_MAIN LEGAL_ENTY FTI_LDB_TR_DEAL_MAIN LEGAL_ENTY TB019 BP legal forms LEGAL_ENTY
FTI_LDB_TR_DEAL_MAIN LEGAL_ORG SYST MANDT TB032 BP Legal Entity CLIENT
FTI_LDB_TR_DEAL_MAIN LEGAL_ORG FTI_LDB_TR_DEAL_MAIN LEGAL_ORG TB032 BP Legal Entity LEGAL_ORG
FTI_LDB_TR_DEAL_MAIN MANDT FTI_LDB_TR_DEAL_MAIN MANDT T000 Clients MANDT
FTI_LDB_TR_DEAL_MAIN NATION FTI_LDB_TR_DEAL_MAIN NATION T005 Countries LAND1
FTI_LDB_TR_DEAL_MAIN NATION SYST MANDT T005 Countries MANDT
FTI_LDB_TR_DEAL_MAIN PRODUCT_CAT FTI_LDB_TR_DEAL_MAIN PRODUCT_CAT TZAF Product categories SANLF
FTI_LDB_TR_DEAL_MAIN PRODUCT_TYPE FTI_LDB_TR_DEAL_MAIN MANDT TZPA Financial Assets Management Product Types MANDT
FTI_LDB_TR_DEAL_MAIN PRODUCT_TYPE FTI_LDB_TR_DEAL_MAIN PRODUCT_TYPE TZPA Financial Assets Management Product Types GSART
FTI_LDB_TR_DEAL_MAIN RATING SYST MANDT TP06 Business Partner: Rating MANDT
FTI_LDB_TR_DEAL_MAIN RATING FTI_LDB_TR_DEAL_MAIN RATING TP06 Business Partner: Rating RATING
FTI_LDB_TR_DEAL_MAIN REFERENCE_TYPE FTI_LDB_TR_DEAL_MAIN REFERENCE_TYPE ATR1 Check table for reference categories REFTYP
FTI_LDB_TR_DEAL_MAIN REVERSAL_REASON FTI_LDB_TR_DEAL_MAIN MANDT TZST Reasons for reversal MANDT
FTI_LDB_TR_DEAL_MAIN REVERSAL_REASON FTI_LDB_TR_DEAL_MAIN REVERSAL_REASON TZST Reasons for reversal SSTOGRD
FTI_LDB_TR_DEAL_MAIN SECURITY_ACCOUNT FTI_LDB_TR_DEAL_MAIN COMPANYCODE TWD01 Treasury: Securities Account Master Data BUKRS
FTI_LDB_TR_DEAL_MAIN SECURITY_ACCOUNT FTI_LDB_TR_DEAL_MAIN SECURITY_ACCOUNT TWD01 Treasury: Securities Account Master Data RLDEPO
FTI_LDB_TR_DEAL_MAIN SECURITY_ACCOUNT FTI_LDB_TR_DEAL_MAIN MANDT TWD01 Treasury: Securities Account Master Data MANDT
FTI_LDB_TR_DEAL_MAIN STAFF_GRP SYST MANDT TP05 Business partner: Employee group MANDT
FTI_LDB_TR_DEAL_MAIN STAFF_GRP FTI_LDB_TR_DEAL_MAIN STAFF_GRP TP05 Business partner: Employee group STAFF_GRP
FTI_LDB_TR_DEAL_MAIN STATE SYST MANDT T005 Countries MANDT
FTI_LDB_TR_DEAL_MAIN STATE FTI_LDB_TR_DEAL_MAIN STATE T005 Countries LAND1
FTI_LDB_TR_DEAL_MAIN TRADER FTI_LDB_TR_DEAL_MAIN MANDT TZDEA Trader register MANDT
FTI_LDB_TR_DEAL_MAIN TRADER FTI_LDB_TR_DEAL_MAIN COMPANYCODE TZDEA Trader register BUKRS
FTI_LDB_TR_DEAL_MAIN TRADER FTI_LDB_TR_DEAL_MAIN TRADER TZDEA Trader register RDEALER
FTI_LDB_TR_DEAL_MAIN TRANSACTION_CAT FTI_LDB_TR_DEAL_MAIN PRODUCT_CAT AT01 Transaction Category SANLFOR
FTI_LDB_TR_DEAL_MAIN TRANSACTION_CAT FTI_LDB_TR_DEAL_MAIN TRANSACTION_CAT AT01 Transaction Category SFGTYP
FTI_LDB_TR_DEAL_MAIN TRANSACTION_TYPE FTI_LDB_TR_DEAL_MAIN MANDT AT10 Transaction Types MANDT
FTI_LDB_TR_DEAL_MAIN TRANSACTION_TYPE FTI_LDB_TR_DEAL_MAIN PRODUCT_TYPE AT10 Transaction Types SGSART
FTI_LDB_TR_DEAL_MAIN TRANSACTION_TYPE FTI_LDB_TR_DEAL_MAIN TRANSACTION_TYPE AT10 Transaction Types SFHAART
FTI_LDB_TR_DEAL_MAIN VALUATION_CLASS FTI_LDB_TR_DEAL_MAIN MANDT TRGC_COM_VALCL General valuation class MANDT
FTI_LDB_TR_DEAL_MAIN VALUATION_CLASS FTI_LDB_TR_DEAL_MAIN VALUATION_CLASS TRGC_COM_VALCL General valuation class COM_VAL_CLASS