FTI_LDB_TR_DEAL_COMM_FWD SAP (OTC Commodities Reporting) Structure details

Dictionary Type: Structure
Description: OTC Commodities Reporting




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




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

FTI_LDB_TR_DEAL_COMM_FWD 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 "OTC Commodities 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_DEAL_COMM_FWD TYPE FTI_LDB_TR_DEAL_COMM_FWD.

The FTI_LDB_TR_DEAL_COMM_FWD table consists of various fields, each holding specific information or linking keys about OTC Commodities Reporting data available in SAP. These include COMPANYCODE (Company Code), DEAL_NUMBER (Position-Generating Financial Transaction), OBJECTNUMBER (Object number), CONTRACT_TYPE (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: Cannot Be Enhanced


SAP FTI_LDB_TR_DEAL_COMM_FWD 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
COMPANYCODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
OBJECTNUMBERObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
CONTRACT_TYPEContract Type RANTYPCHAR1RANTYP
PRODUCT_CATProduct Category SANLFNUMC3Assigned to domainVVSANLF
PRODUCT_TYPEProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
TRANSACTION_TYPEFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
TRANSACTION_CATTransaction Category TB_SFGTYPNUMC3Assigned to domainT_SFGTYP
ACTIVITY_CATTransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
START_TERMStart of Term FTI_DBLFZ_DEALDATS8DATUM
END_TERMEnd of Term FTI_DELFZ_DEALDATS8DATUM
CONTRACT_DATEContract Conclusion Date TB_DVTRABDATS8DATUM
COUNTERPARTYCounterparty TB_KONTRHCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
EXT_ACCOUNTExternal Account TPM_EXT_ACCOUNTCHAR10TPM_EXT_ACCOUNTTREA_EATREATH_EXT_ACCOUNT
NATIONNationality BP_CNTR_NCHAR3Assigned to domainLAND1
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
CONTRACT_PRICECommodity Contract Price FTI_CTY_PRICEDEC13(5) FTR_COMPRICE
CTY_SPOT_PRICECommodity spot price FTI_CTY_SPOT_PRCDEC13(5) FTR_COMPRICE
PRICE_CURR_UNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
PRICE_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
CMDTY_FIX_STATUSCommodity Fixing Status FTI_CMDTY_FIX_STATUSCHAR1FTI_CMDTY_FIX_STATUS
CONT_BACKCommodity Contango / Backwardation FTR_CONBACKDEC13(5) FTR_COMPRICE
NPV_PCRM Net Present Value in Position Currency TV_NPV_PCCURR15(2) WERTV8_TR
NPV_CCRM NPV in Evaluation Currency TV_NPV_CCCURR15(2) WERTV8_TR
CURRENCYCurrency of Transaction FTI_WGSCHFTCUKY5Assigned to domainWAERS
CALC_CCYEvaluation Currency AFW_EVAL_CURRENCYCUKY5Assigned to domainWAERS
COMMODITY_ID1Commodity ID Outgoing FTI_COMM_ID_OUTCHAR18TPM_CTY_ID
QUANTITY_INIncoming Commodity Quantity FTI_QUAN_INQUAN13(3) FTR_QUAN
UOM_INUnit of Measure for Incoming Commodity FTI_UOM_INUNIT3Assigned to domainCUNITMEINS
CTY_PRICE_INIncoming Comodity Price FTI_CTY_PRICE_INDEC13(5) FTR_COMPRICE
CMDTY_FIX_STATUS_INCommodity Fixing Status: Incoming Side FTI_CMDTY_FIX_STATUS_INCHAR1FTI_CMDTY_FIX_STATUS
COMMODITY_ID2Commodity ID Incoming FTI_COMM_ID_INCHAR18TPM_CTY_ID
QUANTITY_OUTOutgoing Commodity Quantity FTI_QUAN_OUTQUAN13(3) FTR_QUAN
UOM_OUTUnit of Measure for Outgoing Commodity FTI_UOM_OUTUNIT3Assigned to domainCUNITMEINS
CTY_PRICE_OUTOutgoing Commodity Price FTI_CTY_PRICE_OUTDEC13(5) FTR_COMPRICE
CMDTY_FIX_STATUS_OUTCommodity Fixing Status: Outgoing Side FTI_CMDTY_FIX_STATUS_OUTCHAR1FTI_CMDTY_FIX_STATUS
TRADERTrader RDEALERCHAR12Assigned to domainRDEALER
FORWARD_DATEField of type DATS DATSDATS8DATS
DELTADelta, 1st derivation of premium based on underlying rate TV_DELTADEC15(10) T_SENSI
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
ASSIGNMENTAssignment TB_ZUONDCHAR18TEXT18
INTERNAL_REFNCEInternal Reference TB_REFERCHAR16CHAR16
CHARACTERISTICSCharacteristics TB_MERKMCHAR25CHAR25
DZTERMPayment or Delivery Date TB_DZTERMDATS8DATUMT33

Key field Non-key field



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

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

How to access SAP table FTI_LDB_TR_DEAL_COMM_FWD

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