ROXEIS0113 SAP () Structure details

Dictionary Type: Structure
Description:




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




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

ROXEIS0113 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 "" 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_ROXEIS0113 TYPE ROXEIS0113.

The ROXEIS0113 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include ABSTR_COMM_ID (Abstract Commodity ID (Parent)), COMMODITY_ID (Commodity ID), LOCATION (Pricing Location), PRODUCT_TYPE (Product 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: Not classified


SAP ROXEIS0113 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
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
ABSTR_COMM_IDAbstract Commodity ID (Parent) TRCO_ABSTR_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
LOCATIONPricing Location TPM_DEL_LOCATIONCHAR4Assigned to domainTPM_DEL_LOCATION
PRODUCT_TYPEProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
DIRECTIONDirection of Position FTI_DIRECTIONCHAR1CHAR1
PRICE_TYPEFixed/Floating Price Indicator FTI_FIX_FLOATING_INDICATORCHAR1FTI_FIX_FLOATING_INDICATOR
DUE_DATEMapped Due Date FTI_DUEDATEDATS8DATS
QUANTQuantity on Original/Contract Unit of Measure FTI_QUANQUAN25(5) FTI_CTY_QUAN
UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_DQuantity in Display Unit of Measure FTI_QUAN_DISPQUAN25(5) FTI_CTY_QUAN
DISP_UOMDisplay UOM for Commodity FTI_CTY_DISP_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_PHYSICALPhysical Quantity FTI_QUAN_PHYSICALQUAN25(5) FTI_CTY_QUAN
UOM001Unit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_PHYSICAL_DPhysical Quantity in Display of Unit of Measure FTI_QUAN_DISP_PHYSICALQUAN25(5) FTI_CTY_QUAN
DISP_UOM004Display UOM for Commodity FTI_CTY_DISP_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_FIXEDQuantity Fixed in Original/Contract Unit of Measure FTI_QUAN_FIXQUAN25(5) FTI_CTY_QUAN
UOM002Unit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_FIXED_DFixed Quantity in Display Unit of Measure FTI_QUAN_DISP_FIXQUAN25(5) FTI_CTY_QUAN
DISP_UOM005Display UOM for Commodity FTI_CTY_DISP_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_FLOATQuantity Floating in Original/Contract Unit of Measure FTI_QUAN_FLOATQUAN25(5) FTI_CTY_QUAN
UOM003Unit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
QUANT_FLOAT_DFloating Quantity in Display Unit of Measure FTI_QUAN_DISP_FLOATQUAN25(5) FTI_CTY_QUAN
DISP_UOM006Display UOM for Commodity FTI_CTY_DISP_UOMUNIT3Assigned to domainCUNITMEINS
CONTRACT_VALUE_PContract Value FTI_CONTRACT_VALCURR21(2) TPM_AMOUNT
POS_CURRPosition Currency TPM_POSITION_CURRCUKY5Assigned to domainWAERS
CONTRACT_VALUE_DContract Value in Display Currency FTI_CONTRACT_VAL_DISPCURR21(2) TPM_AMOUNT
DISP_CURRDisplay Currency FTI_ANZGWCUKY5Assigned to domainWAERSFFZ
NPV_PCRM Net Present Value in Position Currency TV_NPV_PCCURR15(2) WERTV8_TR
POS_CURR007Position Currency TPM_POSITION_CURRCUKY5Assigned to domainWAERS
NPV_DCRM NPV in Display Currency from Position Currency TV_NPV_DCCURR15(2) WERTV8_TR
DISP_CURR008Display Currency FTI_ANZGWCUKY5Assigned to domainWAERSFFZ
ASSIGNMENTAssignment TB_ZUONDCHAR18TEXT18
INTERNAL_REFNCEInternal Reference TB_REFERCHAR16CHAR16
CHARACTERISTICSCharacteristics TB_MERKMCHAR25CHAR25
CREATION_DATEFirst Entered on DERFDATS8DATUM
EXP_TYPEExposure Position Type FTR_EXPOSURE_TYPECHAR5Assigned to domainFTR_EXPOSURE_TYPETEXH_F4_EXP_TYPE
EXPOSURE_IDRaw Exposure ID FTR_RAW_EXPOS_IDCHAR13Assigned to domainALPHAFTR_RAW_EXPOS_ID
ITEM_IDRaw Exposure Line Item ID FTR_ITEM_IDNUMC5Assigned to domainFTR_ITEM_ID
LASTCHANGE_DATELast Edited on DBEARDATS8DATUM
POSITION_IDExposure Position ID FTR_POSITION_IDCHAR20Assigned to domainALPHAFTR_POSITION_IDTEXH_POSITION
PROFIT_CENTERProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
RISK_CATExposure Risk Category FTR_RISK_CATCHAR1FTR_RISK_CAT
SUBEXPOS_IDSub Raw Exposure ID FTR_SUBITEM_IDNUMC4FTR_SUBITEM_ID
TRANSACTION_ACTTransaction Activity (E-HA) THM_TRANSACTNUMC2Assigned to domainTHM_TRANSACT
TRANSACTION_CATExposure Category of Raw Exposure FTR_RAWEXPOS_TRANSCATCHAR2Assigned to domainFTR_RAWEXPOS_TRANSCAT
POS_ACCFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
EXP_GRP_INDPaper/Physical Indicator for Exposure Group FTI_EXP_GROUP_INDICATORCHAR1FTI_EXP_GROUP_INDICATOR
ACTIVITY_CATTransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
ACTIVITY_STATUSActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
ATTRIBUTE_SH01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4Assigned to domainFTR_ATTRIBUTE_SHORT
ATTRIBUTE_SH02Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4Assigned to domainFTR_ATTRIBUTE_SHORT
ATTRIBUTE_LH01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
ATTRIBUTE_DH01Value of a free attribute (Date) FTR_ATTRIBUTE_DATEDATS8FTR_ATTRIBUTE_DATE
ATTRIBUTE_LI01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
ATTRIBUTE_LI02Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
ATTRIBUTE_LI03Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
ATTRIBUTE_LI04Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
ATTRIBUTE_MI01Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10FTR_ATTRIBUTE_MEDIUM
ATTRIBUTE_MI02Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10FTR_ATTRIBUTE_MEDIUM
ATTRIBUTE_SI01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4Assigned to domainFTR_ATTRIBUTE_SHORT
ATTRIBUTE_DI01Value of a free attribute (Date) FTR_ATTRIBUTE_DATEDATS8FTR_ATTRIBUTE_DATE
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
CONT_BACKCommodity Contango / Backwardation FTR_CONBACKDEC13(5) FTR_COMPRICE
CONTRACT_DATEContract Conclusion Date TB_DVTRABDATS8DATUM
CONTRACT_PRICECommodity Contract Price FTI_CTY_PRICEDEC13(5) FTR_COMPRICE
CONTRACT_TYPEContract Type RANTYPCHAR1RANTYP
COUNTERPARTYCounterparty TB_KONTRHCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
CTY_SPOT_PRICECommodity spot price FTI_CTY_SPOT_PRCDEC13(5) FTR_COMPRICE
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
END_TERMEnd of Term FTI_DELFZ_DEALDATS8DATUM
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
PRODUCT_CATProduct Category SANLFNUMC3Assigned to domainVVSANLF
SIDEDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
START_TERMStart of Term FTI_DBLFZ_DEALDATS8DATUM
TRADERTrader RDEALERCHAR12Assigned to domainRDEALER
TRANSACTION_TYPEFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
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
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
BETICK_CTYTick Amount (Commodity) TI_BETICK_COMMODITYDEC13(7) DEC13_7
BWTICK_CTYTick Value (Commodity) TI_BWTICK_COMMODITYDEC13(7) DEC13_7
CLASS_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
CONTRACT_SIZEContract Size TPM_CTY_CONTRACT_SIZEQUAN13(3) FTR_QUAN
CONTRACT_SZ_UNITMengeneinheit der Kontraktgröße TPM_CTY_CONTRACT_SIZE_UNITUNIT3Assigned to domainTRCO_COMM_UOM
EXPIRY_DATEExpiration date TI_DVERFDATS8DATUM
ISSUERIssuer Identity Key REPKE_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
LAST_TRADING_DAYLast trade date TI_DLHANDDATS8DATUM
POS_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
BROKER_ACCBroker Account Number TPM_POS_ACCOUNT_NUMBERCHAR15ABNKR
POSITION_DATEField of type DATS DATSDATS8DATS
SETTLEMENT_DAYSettlement date TI_DERFUEDATS8DATUM
UNITSNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
FLAG_LONG_SHORTIndicator: Long or Short Position TPM_FLAG_LONG_SHORTCHAR1TPM_FLAG_LONG_SHORT
PARAM_P_AUSWTEvaluation Type (Risk Management) FTI_EVALTYPECHAR4Assigned to domainJBREVALFTI_EVALTYPE
PARAM_P_DATEKey Date FTI_STICHTAGDATS8VVSTDATKEYDATE
PARAM_P_DCURRDisplay Currency FTI_ANZGWCUKY5Assigned to domainWAERSFFZ
PARAM_P_DUOMDisplay UOM for Commodity FTI_CTY_DISP_UOMUNIT3Assigned to domainCUNITMEINS
PARAM_P_ERRLOGIndicator: Display Error Log FTI_LDB_FLG_ERRLOG_OUTPUTCHAR1XFELDFTI_FLG_HISTKR
PARAM_P_EXPSelect Exposure Positions for Commodities FTI_LDB_FLG_COMM_EXPCHAR1XFELDFTI_FLG_OTC
PARAM_P_LOGSAVSave Application Log (CFM)? - Yes/No FTI_FLG_BALLOG_DB_SAVE_CFMCHAR1XFELDFTI_FLG_LOF
PARAM_P_LSDSelect Commodity Related Listed Derivatives FTI_LDB_FLG_COMM_LSDCHAR1XFELDFTI_FLG_OTC
PARAM_P_MEM_IDMemory ID to Transfer Error Table Using LDB_PROCESS FTI_MEMORY_ID_ERRORTABCHAR40CHAR40
PARAM_P_NUMBRNumber of translation key in currency translation CFNUMBRNUMC3Assigned to domainCFNUMBRNBR
PARAM_P_OTCSelect Commodity Related OTC Transactions FTI_LDB_FLG_COMM_OTCCHAR1XFELDFTI_FLG_OTC
PARAM_P_USEBFRCheckbox XFELDCHAR1XFELD
SELECT_SO_ACTCATransaction Activity Category TB_SFGZUTYNUMC2Assigned to domainT_SFGZUTYC_AT02
SELECT_SO_ACTSTActive Status of Transaction or Activity TB_SAKTIVNUMC1T_SAKTIV
SELECT_SO_ACTYAbstract Commodity ID (Parent) TRCO_ABSTR_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
SELECT_SO_ASSIGAssignment TB_ZUONDCHAR18TEXT18
SELECT_SO_BROACBroker Account Number TPM_POS_ACCOUNT_NUMBERCHAR15ABNKR
SELECT_SO_BUSPTCounterparty TB_KONTRHCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SELECT_SO_CHARACharacteristics TB_MERKMCHAR25CHAR25
SELECT_SO_CNTRCountry Key LAND1CHAR3Assigned to domainLAND1LND
SELECT_SO_COMPCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SELECT_SO_CTYCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
SELECT_SO_EXHIDRaw Exposure ID FTR_RAW_EXPOS_IDCHAR13Assigned to domainALPHAFTR_RAW_EXPOS_ID
SELECT_SO_EXIIDRaw Exposure Line Item ID FTR_ITEM_IDNUMC5Assigned to domainFTR_ITEM_ID
SELECT_SO_EXSIDSub Raw Exposure ID FTR_SUBITEM_IDNUMC4FTR_SUBITEM_ID
SELECT_SO_EXTYExposure Position Type FTR_EXPOSURE_TYPECHAR5Assigned to domainFTR_EXPOSURE_TYPETEXH_F4_EXP_TYPE
SELECT_SO_FLGIndicator: Long or Short Position TPM_FLAG_LONG_SHORTCHAR1TPM_FLAG_LONG_SHORT
SELECT_SO_FUTACFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
SELECT_SO_IDNBRSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SELECT_SO_INREFInternal Reference TB_REFERCHAR16CHAR16
SELECT_SO_LH01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
SELECT_SO_LI01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
SELECT_SO_LI02Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
SELECT_SO_LI03Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
SELECT_SO_LI04Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20FTR_ATTRIBUTE_LONG
SELECT_SO_MI01Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10FTR_ATTRIBUTE_MEDIUM
SELECT_SO_MI02Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10FTR_ATTRIBUTE_MEDIUM
SELECT_SO_PCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
SELECT_SO_PORTFPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
SELECT_SO_POSIDExposure Position ID FTR_POSITION_IDCHAR20Assigned to domainALPHAFTR_POSITION_IDTEXH_POSITION
SELECT_SO_PRDTYProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SELECT_SO_RFHAPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SELECT_SO_SFHARFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
SELECT_SO_SH01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4Assigned to domainFTR_ATTRIBUTE_SHORT
SELECT_SO_SH02Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4Assigned to domainFTR_ATTRIBUTE_SHORT
SELECT_SO_SI01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4Assigned to domainFTR_ATTRIBUTE_SHORT
SELECT_SO_TRCTExposure Category of Raw Exposure FTR_RAWEXPOS_TRANSCATCHAR2Assigned to domainFTR_RAWEXPOS_TRANSCAT

Key field Non-key field



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

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

How to access SAP table ROXEIS0113

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