FTI_LDB_TR_DEAL_UNDERLYING SAP (Treasury: Transaction Reporting, Underlying Data (-> LDB)) Structure details

Dictionary Type: Structure
Description: Treasury: Transaction Reporting, Underlying Data (-> LDB)




ABAP Code to SELECT data from FTI_LDB_TR_DEAL_UNDERLYING
Related tables to FTI_LDB_TR_DEAL_UNDERLYING
Access table FTI_LDB_TR_DEAL_UNDERLYING




Structure field list including key, data, relationships and ABAP select examples

FTI_LDB_TR_DEAL_UNDERLYING 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, Underlying 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_UNDERLYING TYPE FTI_LDB_TR_DEAL_UNDERLYING.

The FTI_LDB_TR_DEAL_UNDERLYING table consists of various fields, each holding specific information or linking keys about Treasury: Transaction Reporting, Underlying Data (-> LDB) data available in SAP. These include DEAL_NUMBER (Position-Generating Financial Transaction), UL_NUMBER (Number of Underlying Transaction), PRODUCT_CATEGORY (Product Category of Underlying Transaction), TRANSACTION_CATEGORY (Financial Transaction Category of Underlying).. 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_UNDERLYING 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
COMPANYCODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
UL_NUMBERNumber of Underlying Transaction FTI_RFHA_ULCHAR13Assigned to domainALPHAT_RFHA
PRODUCT_CATEGORYProduct Category of Underlying Transaction FTI_SANLF_ULNUMC3Assigned to domainVVSANLF
TRANSACTION_CATEGORYFinancial Transaction Category of Underlying FTI_SFGTYP_ULNUMC3Assigned to domainT_SFGTYP
PRODUCT_TYPEProduct Type of Underlying FTI_PRODART_ULCHAR3Assigned to domainVVSART
TRANSACTION_TYPEUnderlying Transaction Type FTI_GART_ULCHAR3Assigned to domainT_SFHAART
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
START_TERMTerm Start TB_DBLFZDATS8DATUM
END_TERMUnderlying Fullfillment date FTI_UL_FULFILLMENT_DATEDATS8DATUM
CURRENCYCurrency of Transaction FTI_WGSCHFTCUKY5Assigned to domainWAERS
CURRENCY_PAYCurrency of Outgoing Side of Transaction FTI_WGSCHF1CUKY5Assigned to domainWAERS
CURRENCY_RECEIVECurrency of Incoming Side of Transaction FTI_WGSCHF2CUKY5Assigned to domainWAERS
SEC_ACCTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
FIN_PROJECTFinance Project TB_TFPROJCHAR13T_TFPROJ
EXTERNAL_REFERENCEExternal order number NORDEXTCHAR20CHAR20
STRIKE_FXRate of Forex Transaction TB_KKURSDEC13(9) TB_KKURS
SPOTRATESpot Rate TB_KKASSADEC13(9) TB_KKURS
SWAPRATESwap Rate TB_KSWAPDEC13(9) T_SWKURS
LEAD_CURRLeading Currency of Underlying Transaction FTI_LWAERS_ULCUKY5Assigned to domainWAERS
FOLL_CURRFollowing Currency of Underlying Transaction FTI_FWAERS_ULCUKY5Assigned to domainWAERS
ROLLOVERFLPoss. to Roll Over TI_ROLLOVERFLCHAR1T_ROLLOVERFL

Key field Non-key field



How do I retrieve data from SAP structure FTI_LDB_TR_DEAL_UNDERLYING using ABAP code?

As FTI_LDB_TR_DEAL_UNDERLYING 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_UNDERLYING as there is no data to select.

How to access SAP table FTI_LDB_TR_DEAL_UNDERLYING

Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_DEAL_UNDERLYING and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!