FTI_LDB_TR_SEC_DEAL_1 SAP (Treasury RAPIs - Securities and Futures Transact. Reporting) Structure details

Dictionary Type: Structure
Description: Treasury RAPIs - Securities and Futures Transact. Reporting




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




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

FTI_LDB_TR_SEC_DEAL_1 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 RAPIs - Securities and Futures Transact. Reporting" 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_SEC_DEAL_1 TYPE FTI_LDB_TR_SEC_DEAL_1.

The FTI_LDB_TR_SEC_DEAL_1 table consists of various fields, each holding specific information or linking keys about Treasury RAPIs - Securities and Futures Transact. Reporting data available in SAP. These include COMPANYCODE (Company Code), SE_DEAL_NUMBER (Securities/Futures Transaction), OBJECTNUMBER (Object number), CREATE_USER (Entered by).. 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_SEC_DEAL_1 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 MANDTCLNT3T000MANDT
COMPANYCODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SE_DEAL_NUMBERSecurities/Futures Transaction FTI_SE_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
OBJECTNUMBERObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
CREATE_USEREntered by TB_CRUSERCHAR12SYCHAR12
CREATE_DATEEntered On TB_DCRDATDATS8DATUM
CREATE_TIMEEntry Time TB_TCRTIMTIMS6UZEIT
UPDATE_USERLast Changed by TB_UPUSERCHAR12SYCHAR12
UPDATE_DATEChanged on TB_DUPDATDATS8DATUM
UPDATE_TIMETime changed TB_TUPTIMTIMS6UZEIT
CONTRACT_TYPEContract Type RANTYPCHAR1RANTYP
PRODUCT_CATProduct Category SANLFNUMC3TZAFVVSANLF
PRODUCT_TYPEProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
TRANSACTION_CATTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
ACTIVITY_CATTransaction Activity Category TB_SFGZUTYNUMC2AT02T_SFGZUTYC_AT02
TRANSACTION_TYPEFinancial Transaction Type TB_SFHAARTCHAR3AT10T_SFHAARTT02C_AT10
CONTRACT_DATEContract Conclusion Date TB_DVTRABDATS8DATUM
CONTRACT_TIMETime of contract conclusion TB_TVTRABTIMS6UZEIT
TRADERTrader RDEALERCHAR12TZDEARDEALER
COUNTERPARTYCounterparty TB_KONTRHCHAR10BUT000ALPHABU_PARTNERBPABUPA
CONTACT_PERSONContact Person TB_GSPPARTCHAR19TEXT19
GUARANTORGuarantor of Financial Transaction TB_RGARANT_NEWCHAR10BUT000ALPHABU_PARTNERBPABUPA
EXTERNAL_REFNCEExternal Reference TB_NORDEXTCHAR16FTI_CHAR16LOW
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
FINANCE_PROJECTFinance Project TB_TFPROJCHAR13T_TFPROJ
MASTER_AGREEMENTMaster Agreement TB_RMAIDCHAR10Assigned to domainALPHAT_RMAIDTMAVTMA
ASSIGNMENTAssignment TB_ZUONDCHAR18TEXT18
INTERNAL_REFNCEInternal Reference TB_REFERCHAR16CHAR16
CHARACTERISTICSCharacteristics TB_MERKMCHAR25CHAR25
VALUATION_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
DEAL_ACTIVEActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
RELEASE_STATUSTransaction Release: Release Status TB_FRGZUSTCHAR1T_FRGZUST
CONFIRM_STATUSConfirmation Status TB_CONFNUMC1TB_CONF
CONFIRM_DATEConfirmation Date TB_DCONFDATS8DATUM
CONFIRM_USERConfirmation Executed By (User Responsible) TB_UCONFCHAR12USNAM
CNTRCONFIRMCounterconfirmation TB_RECONFNUMC1TB_RECONF
CNTRCONFIRM_DATECounterconfirmation Date TB_DREDATDATS8DATUM
CNTRCONFIRM_USERCounterconfirmation Executed by (User Responsible) TB_URENAMCHAR12USNAM
CURRENCYCurrency of Transaction FTI_WGSCHFTCUKY5TCURCWAERS
NOM_AMOUNTNominal Amount FTI_NOMAMTCURR13(2) WERTV7
UNITSUnits FTI_POSITIONS_UNITSDEC22(6) TPM_UNITS
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10TWD01RLDEPODEPACC_CCD_CORE
SECURITY_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
POSITION_CCYPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
LOCAL_CCYLocal Currency TB_SHWHRCUKY5Assigned to domainWAERS
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
QUANTITY_TRADEDCommodity Quantity to Be Delivered FTI_CTY_QUAN_DELVRDQUAN25(5) FTI_CTY_QUAN
COMMODITY_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
EFF_INTEffective Interest Rate TB_PYIELDDEC10(7) DECV3_7
EFF_INT_METHODEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
NOMORGAMT_TRADEDTraded Original Nominal Amount FTI_NOMORGAMT_TRADEDCURR13(2) WERTV7
NOM_AMT_TRADEDTraded Nominal Amount FTI_NOMAMT_TRADEDCURR13(2) WERTV7
NUMBER_TRADEDTraded Number of Units for Unit-Quoted Securities/Futures FTI_NUMBER_TRADEDDEC15(5) ASTUECK
PRICE_CCYUNT_PRCQuotation Currency Unit / Percent (Mixed Representation) FTI_QUOT_UNIT_PRCTCHAR5FTI_QUOT_UNIT_PRCT
PRICE_CCYUNTCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
PRICE_TRADEDTraded Price of Security (Mixed Representation) FTI_PRICE_TRADEDDEC15(6) FTI_PRICE_TRADED
QUOTATIONQuotation type for option, future, security etc. TB_NOTTYPECHAR1T_NOTTYPE
MARKET_VAL_QCMarket Value in Quotation Currency TB_BEBETRCURR13(2) WERTV7
QUOTATION_CCYQuotation Currency FTI_QUOT_CCYCUKY5Assigned to domainWAERS
MARKET_VAL_CCMarket Value in Payment Currency FTI_MARKET_CCCURR21(2) TPM_AMOUNT
FX_RATE_TO_CCPayment currency rate TB_KZWKURSDEC9(5) EXCRTUKURS
MARKET_VAL_PCMarket Value in Position Currency FTI_MARKET_PCCURR21(2) TPM_AMOUNT
FX_RATE_TO_PCPosition currency rate TB_KBWKURSDEC9(5) EXCRTUKURS
MARKET_VAL_LCMarket Value in Local Currency FTI_MARKET_LCCURR21(2) TPM_AMOUNT
FX_RATE_TO_LCLocal currency rate TB_KHWKURSDEC9(5) EXCRTUKURS
HOUSEBNK_INShort Key for Own House Bank: Incoming Side FTI_HBANK_INCHAR5Assigned to domainHBKID
HOUSEBNKACCT_INShort Key for House Bank Account: Incoming Side FTI_HBACCT_INCHAR5Assigned to domainHKTID
PAYER_PAYEE_INPayer/Payee of Incoming Side FTI_PAYERPAYEE_INCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNERBNK_INPartner Bank Details of Incoming Side FTI_PBANK_INCHAR4BVTYP
HOUSEBNK_OUTShort Key for Own House Bank: Outgoing Side FTI_HBANK_OUTCHAR5Assigned to domainHBKID
HOUSEBNKACCT_OUTShort Key for House Bank Account: Outgoing Side FTI_HBACCT_OUTCHAR5Assigned to domainHKTID
PAYER_PAYEE_OUTPayer/Payee of Outgoing Side FTI_PAYERPAYEE_OUTCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNERBNK_OUTPartner Bank Details of Outgoing Side FTI_PBANK_OUTCHAR4BVTYP

Key field Non-key field



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

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

How to access SAP table FTI_LDB_TR_SEC_DEAL_1

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