FTI_LDB_TR_ATTR_DEAL SAP (Transaction Attributes Used in the Logical Database) Structure details

Dictionary Type: Structure
Description: Transaction Attributes Used in the Logical Database




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




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

FTI_LDB_TR_ATTR_DEAL 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 "Transaction Attributes Used in the Logical Database" 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_ATTR_DEAL TYPE FTI_LDB_TR_ATTR_DEAL.

The FTI_LDB_TR_ATTR_DEAL table consists of various fields, each holding specific information or linking keys about Transaction Attributes Used in the Logical Database data available in SAP. These include BUKRS (Company Code), DEAL_NUMBER (Position-Generating Financial Transaction), SE_DEAL_NUMBER (Securities/Futures Transaction), COMMODITY_ID (Commodity ID).. 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: Cannot Be Enhanced


SAP FTI_LDB_TR_ATTR_DEAL 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 BUKRSCHAR4T001BUKRSBUKC_T001
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
SE_DEAL_NUMBERSecurities/Futures Transaction FTI_SE_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
STICHTAGKey date VVSTDATDATS8VVSTDATKEYDATE
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SANLFProduct Category SANLFNUMC3TZAFVVSANLF
PORTFOLIOPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
RANTYP_RContract type FTI_RANTYPCHAR1FTI_RANTYP
RREFKONT_RAcct Assignment Ref. for Operative Valn Area and Loan TB_REFKONTCHAR8T037SUSTRU
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
FINPROJFinance Project TB_TFPROJCHAR13T_TFPROJ
RMAIDMaster Agreement TB_RMAIDCHAR10VTBMAALPHAT_RMAIDTMAVTMA
DBLFZStart of Term DBLFZDATS8DATUM
DELFZEnd of Term DELFZDATS8DATUM
DSCHLUSSDate of business closing VVDSCHLUSSDATS8DATUM
PARTNRPartner with Whom Commitment Exists FTI_LDB_RISK_COUNTERPARTYCHAR10BUT000ALPHABU_PARTNERBUPA
PKONDInterest rate as a percentage TB_PKONDDEC10(7) DECV3_7
BKONDInterest rate as amount TB_BKONDCURR13(2) WERTV7
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
KZAHLAKTPay-in/disbursement rate FTI_PAYINDEC10(7) DEC3_7
RKONTRAReference to Counterparty RKONTRA_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RDEALERTrader RDEALERCHAR12TZDEARDEALER
RGARANTGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
HKONTGeneral ledger account FTI_HKONTCHAR10SKB1ALPHASAKNR
NORDEXTExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
SOL_INS_RANLInstitut Supplying Credit Rating Information for Secur. ID FTI_SOL_INS_RANLCHAR4TP07BP_SOL_INS
RATING_RANLRating for Securities ID Number/OTC Transaction BP_RATING_RANLCHAR3TP06BP_RATING
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5TCURCWAERS
WVERB1Nominal currency borrowing/sale/outgoing side/short FTI_WHR_SHORTCUKY5Assigned to domainWAERS
WFORD1Nominal currency investment/purchase incoming side/long FTI_WHR_LONGCUKY5Assigned to domainWAERS
SWHRKONDInterest Currency TB_WHRKONDCUKY5Assigned to domainWAERS
NOMINAL_AMT_PCNominal Amount in Position Currency FTI_NOMINAL_AMT_PCCURR21(2) TPM_AMOUNT
NOMINAL_AMT_OUT_PCNominal Value, Outgoing Side, in Position Crcy (Outg. Side) FTI_NOMINAL_OUT_PCOUTCURR21(2) TPM_AMOUNT
NOMINAL_AMT_IN_PCNominal Value, Incoming Side, in Position Crcy (Inc. Side) FTI_NOMINAL_IN_PCINCURR21(2) TPM_AMOUNT
INT_CATInterest Category FTI_INTTYPECHAR1FTI_INTEREST_TYPE
CTY_QUANTITYCommodity Quantity to Be Delivered FTI_CTY_QUAN_DELVRDQUAN25(5) FTI_CTY_QUAN
CTY_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
RCOMVALCLGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4Assigned to domainTPM_COM_VAL_CLASSCVC
UL_LOAN_IDUnderlying Loan Contract FTR_UL_LOANCHAR13ALPHARANLRADFTRH_UL_LOAN
CALENDARFactory calendar SKALIDCHAR2Assigned to domainWFCIDH_TFACD
REF_INT_RATEReference Interest Rate SZSREFCHAR10Assigned to domainZIREFKU
INT_RATE_SPREADFormula for variable interest condition - outgoing side FTI_XFORMEL_ASCHAR30T_XTEXT30

Key field Non-key field



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

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

How to access SAP table FTI_LDB_TR_ATTR_DEAL

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