FTI_LDB_TR_DEALS SAP (Transactions) Structure details

Dictionary Type: Structure
Description: Transactions




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




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

FTI_LDB_TR_DEALS 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 "Transactions" 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_DEALS TYPE FTI_LDB_TR_DEALS.

The FTI_LDB_TR_DEALS table consists of various fields, each holding specific information or linking keys about Transactions data available in SAP. These include BUKRS (Company Code), RFHA (Financial Transaction), DEAL_NUMBER (Position-Generating Financial Transaction), RANTYP (Contract Type).. 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)


SAP FTI_LDB_TR_DEALS 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
RANTYPContract Type RANTYPCHAR1RANTYP
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
GSARTBusiness type (interest reference) GSARTCHAR3CHAR3
SFGTYPTransaction Category TB_SFGTYPNUMC3Assigned to domainT_SFGTYP
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
RGATTClass TI_RGATTCHAR13ALPHAT_RGATTT04
RMAIDMaster Agreement TB_RMAIDCHAR10Assigned to domainALPHAT_RMAIDTMAVTMA
KONTRHBusiness Partner Number TB_KUNNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RGARANTGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RPORTBPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
WGSCHFTCurrency of transaction TB_WGSCHFTCUKY5Assigned to domainWAERS
WGSCHFT1Currency of Outgoing Side TB_WGSCHF1CUKY5Assigned to domainWAERS
WGSCHFT2Currency of Incoming Side TB_WGSCHF2CUKY5Assigned to domainWAERS
DBLFZTerm Start TB_DBLFZDATS8DATUM
DELFZTerm End TB_DELFZDATS8DATUM
ZUONRFinance Project TB_TFPROJCHAR13T_TFPROJ
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RLDEPOSecurities Account VRLDEPOCHAR10Assigned to domainRLDEPODEP
POSACCFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
FACILITYNRTransaction Number of Facility TB_FACILITYNRCHAR13Assigned to domainALPHAT_RFHAF4_FTR_FC
FACILITYBUKRSCompany Code of Facility TB_FACILITYBUKRSCHAR4Assigned to domainBUKRSH_T001

Key field Non-key field



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

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

How to access SAP table FTI_LDB_TR_DEALS

Within an ECC or HANA version of SAP you can also view further information about FTI_LDB_TR_DEALS 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!