FTI_BIW_DELTA_DEAL_ATTR SAP (TR-BI: Transaction Master Data) Structure details
Description: TR-BI: Transaction Master Data
Related tables to FTI_BIW_DELTA_DEAL_ATTR
Access table FTI_BIW_DELTA_DEAL_ATTR
Structure field list including key, data, relationships and ABAP select examples
FTI_BIW_DELTA_DEAL_ATTR 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 "TR-BI: Transaction Master Data" 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_BIW_DELTA_DEAL_ATTR TYPE FTI_BIW_DELTA_DEAL_ATTR.
The FTI_BIW_DELTA_DEAL_ATTR table consists of various fields, each holding specific information or linking keys about TR-BI: Transaction Master Data data available in SAP. These include BUKRS (Company Code), DEAL_NUMBER (Position-Generating Financial Transaction), FLAG_DEAL_TYPE (Transaction Category - OTC / Non-OTC), OBJECTNUMBER (Object number).. 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_BIW_DELTA_DEAL_ATTR 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 | Assigned to domain | MANDT | |||
BUKRS | 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 |
FLAG_DEAL_TYPE | Transaction Category - OTC / Non-OTC | FTI_DEAL_TYPE | CHAR | 1 | Assigned to domain | FTI_DEAL_TYPE | |||
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 | ||||
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 | ||||
REVERSAL_REASON | Reason for Reversal | SSTOGRD | CHAR | 2 | TZST | SSTOGRD | |||
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 | ||||
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 | ||||
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 | |
EXT_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
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 | ||
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 | ||||
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 | ||||
PRC_CURUNT_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 | ||||
PRC_CURUNT_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 | ||
PAYMENT_DATE | Payment or Delivery Date | TB_DZTERM | DATS | 8 | DATUM | T33 | |||
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_RATE | Nominal Interest Rate | FTI_NOMINALZINS | DEC | 10(7) | DEC3_7 | ||||
INT_REF | Reference Interest Rate | FTI_INTREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
INT_REF_SPRD | Spread for Reference Interest Rate (Variable Interest) | FTI_VAR_OFFSET | DEC | 10(7) | DECV3_7 | ||||
INT_CALMETHD | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
INT_FORMULA | String for Interest Formula | FTI_XINTFORMULA | CHAR | 132 | TEXT132 | ||||
INT_AMOUNT | Interest Amount | FTI_INTAMOUNT | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CAT_IN | Interest Category of Incoming Side | FTI_INTTYPE_IN | CHAR | 1 | FTI_INTEREST_TYPE | ||||
INT_RATE_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_REF_SPRD_IN | Spread Incoming Side | FTI_SPREAD_IN | DEC | 10(7) | DECV3_7 | ||||
INT_CALMETHD_IN | Interest Calculation Method of Incoming Side | FTI_INTCALMETHD_IN | CHAR | 1 | SZBMETH | ||||
INT_FORMULA_IN | String for Interest Formula of Incoming Side | FTI_XINTFORMULA_IN | CHAR | 132 | TEXT132 | ||||
INT_AMOUNT_IN | Interest Amount of Incoming Side | FTI_INTAMOUNT_IN | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CAT_OUT | Interest Category of Outgoing Side | FTI_INTTYPE_OUT | CHAR | 1 | FTI_INTEREST_TYPE | ||||
INT_RATE_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_REF_SPRD_OUT | Spread Outgoing Side | FTI_SPREAD_OUT | DEC | 10(7) | DECV3_7 | ||||
INT_CALMETHD_OUT | Interest Calculation Method of Outgoing Side | FTI_INTCALMETHD_OUT | CHAR | 1 | SZBMETH | ||||
INT_FORMULA_OUT | String for Interest Formula of Outgoing Side | FTI_XINTFORMULA_OUT | CHAR | 132 | TEXT132 | ||||
INT_AMOUNT_OUT | Interest Amount of Outgoing Side | FTI_INTAMOUNT_OUT | CURR | 21(2) | TPM_AMOUNT | ||||
EXERCISE_TYPE | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
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 | ||||
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 | ||||
UL_LOAN | Underlying Loan Contract | FTR_UL_LOAN | CHAR | 13 | ALPHA | RANL | RAD | FTRH_UL_LOAN | |
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 | |||
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 | ||||
NUMBER_TRADED | Traded Number of Units for Unit-Quoted Securities/Futures | FTI_NUMBER_TRADED | DEC | 15(5) | ASTUECK | ||||
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 | |||
TIMESTAMP_DEAL | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
VALID_FROM | Valid From | VALID_FRM | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | VALID_TODAT | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure FTI_BIW_DELTA_DEAL_ATTR using ABAP code?
As FTI_BIW_DELTA_DEAL_ATTR 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_BIW_DELTA_DEAL_ATTR as there is no data to select.How to access SAP table FTI_BIW_DELTA_DEAL_ATTR
Within an ECC or HANA version of SAP you can also view further information about FTI_BIW_DELTA_DEAL_ATTR 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