ROXEIS0115 SAP (Commodity Exposure) Structure details

Dictionary Type: Structure
Description: Commodity Exposure




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




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

ROXEIS0115 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 "Commodity Exposure" 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_ROXEIS0115 TYPE ROXEIS0115.

The ROXEIS0115 table consists of various fields, each holding specific information or linking keys about Commodity Exposure data available in SAP. These include EXPOSURE_ID (Raw Exposure ID), ITEM_ID (Raw Exposure Line Item ID), SUBEXPOS_ID (Sub Raw Exposure ID), VERSION (Version of a Raw Exposure).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ROXEIS0115 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
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
SUBEXPOS_IDSub Raw Exposure ID FTR_SUBITEM_IDNUMC4FTR_SUBITEM_ID
VERSIONVersion of a Raw Exposure FTR_RAW_EXPOS_VERSIONNUMC6FTR_RAW_EXPOS_VERSION
OS_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
EXP_GRP_INDPaper/Physical Indicator for Exposure Group FTI_EXP_GROUP_INDICATORCHAR1FTI_EXP_GROUP_INDICATOR
LOG_SYSTEMLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
EXPOSURE_ORIGINExposure Origin FTR_EXPOSURE_ORIGINCHAR5Assigned to domainTEM_EXPOSURE_ORIGIN
EXT_DOC_NOExternal Document Number FTR_EXTERNAL_DOC_NUMBERCHAR75FTR_EXTERNAL_DOC_NUMBER
EXT_ITEM_IDExternal Item ID FTR_EXTERNAL_ITEM_IDCHAR40FTR_EXTERNAL_ITEM_ID
REPORTING_DATEView of EA_FINSERV Data Type FTR_EXPOSURE_DATE TRCIN_DATEDATS8TRCIN_DATE
EXPOSURE_DUE_DATEDate on Which Exposure Is Due / Expires FTR_EXPOSURE_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
PHYS_COMMODITY_IDPhysical Commodity TBA_STOEFFCHENCHAR18Assigned to domainTBA_STOEFFCHEN
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
DCSDerivative Contract Specification ID TBA_DCSIDCHAR6Assigned to domainTBA_DCSIDTBA_DCSIDTBAH_DCS
MICMarket Identifier Code TBA_MICCHAR4Assigned to domainTBA_MICTBA_MICTBAH_MIC
PRICE_TYPEType of Price Quotation TBA_PRICETYPECHAR2Assigned to domainVVSKURSARTRATETYPE_F4
TENORTime to Maturity TBA_TENORCHAR10Assigned to domainTBA_TENORTBAH_TENOR
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
PLANNING_PERIODPlanning Period TEM_PLANNING_PERIODCHAR3Assigned to domainTEM_PLANNING_PERIOD
PLANNING_YEARPlan Year TEM_PLANNING_YEARNUMC4GJAHRGJAHR
SIGNView of EA-FINSERV Data Element FTR_SIGN TRCIN_SIGNCHAR1TRCIN_SIGN
REF_QUANTITYQuantity FTR_EXPOSURE_QTYQUAN13(3) FTR_EXPOSURE_QTY
REF_UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
QUANTITYQuantity FTR_EXPOSURE_QTYQUAN13(3) FTR_EXPOSURE_QTY
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
FOREIGN_AMTExposure Amount FTR_EXPOSURE_AMOUNTCURR17(2) FTR_EXPOSURE_AMOUNT
FOREIGN_CURRExposure Amount Currency FTR_EXPOSURE_CURRCUKY5Assigned to domainWAERS
TARGET_CURRTarget Currency of Exposure FTR_EXPOSURE_CURRENCY_TARGETCUKY5Assigned to domainWAERS
PRICEView of EA_FINSERV Data Element FTR_EXPOSURE_AMOUNT TRCIN_AMOUNTCURR17(2) TRCIN_AMOUNT
PRICE_CURRENCYView of EA_FINSERV Data Element FTR_EXPOSURE_CURR TRCIN_CURRENCYCUKY5Assigned to domainWAERS
PRICE_UNIT_OF_QUOTATIONView of EA-FINSERV Data Element FTR_PRICE_UNIT_OF_QUOT TRCIN_UNIT_OF_QUOTATIONDEC5TRCIN_UNIT_OF_QUOTATION
PRICE_UNIT_OF_MEASUREView of EA_FINSERV Data Element TPM_CTY_UOM TRCIN_UNITUNIT3Assigned to domainCUNITMEINS
PRICE_DATEView of EA_FINSERV Data Type FTR_EXPOSURE_DATE TRCIN_DATEDATS8TRCIN_DATE
PRICE_TIMEView of EA_FINSERV Data Element FTR_QUOTATION_TIME TRCIN_QUOTATION_TIMETIMS6TIME
CHANGE_TIMESTAMPUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPLDEC21(7) TZNTSTMPL
VALID_FROM_TSTUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPLDEC21(7) TZNTSTMPL
VALID_TO_TSTUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPLDEC21(7) TZNTSTMPL
CREATION_INDRaw Exposure Creation Indicator FTR_CREATION_INDICATORCHAR1FTR_CREATION_INDICATOR
CREATION_USEREntered by RERFCHAR12SYCHAR12
CREATION_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
RELEVANCE_DATEValid From Date FTR_VALID_FROMDATS8FTR_VALID_FROM
EXP_FLOW_TYPEExposure Activity Type FTR_EXPOSURE_FLOW_TYPECHAR5Assigned to domainFTR_EXPOSURE_FLOW_TYPETEXH_F4_ACTIVITY_TYPE
TRANSACTION_CATExposure Category of Raw Exposure FTR_RAWEXPOS_TRANSCATCHAR2Assigned to domainFTR_RAWEXPOS_TRANSCAT
RISK_CATExposure Risk Category FTR_RISK_CATCHAR1FTR_RISK_CAT
TRANSACTIVITYExposure Activity FTR_TRANSACTNUMC2Assigned to domainFTR_TRANSACT
FIX_VAR_INDFixed/Floating Indicator FTR_FIX_VARIABLE_INDICATORCHAR1FTR_FIX_VARIABLE_INDICATOR
FIXING_STATUSFixing Status FTR_FIXING_STATUSCHAR1FTR_FIXING_STATUS
REVERSE_INDICATORReverse Indicator TRCIN_REVERSE_INDICATORCHAR1TRCIN_REVERSE_INDICATOR
MP_EXPOSURE_RULEView of EA_FINSERV Data Element FTR_MP_EXPOSURE_RULE TRCIN_MP_EXPOSURE_RULECHAR2TRCIN_MP_EXPOSURE_RULE
EXP_APPROACH_CATCommodity Exposure Approach Category FTR_EXP_APPR_CATNUMC1FTR_EXP_APPR_CAT
PRODUCT_TYPEProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
TRANSACTION_ACTTransaction Activity (E-HA) THM_TRANSACTNUMC2Assigned to domainTHM_TRANSACT
HED_COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
HEDGE_PLAN_IDHedge Plan ID THM_PLANNERIDCHAR13Assigned to domainALPHATHM_PLANNERIDPLN
HED_EXPOSURE_IDExposure ID THM_EXPOSUREIDNUMC5Assigned to domainTHM_EXPOSUREID
HED_TRANS_IDE-HA: Transaction THM_TRANSACTIONCHAR11Assigned to domainALPHATHM_TRANSACTION
EXP_TYPEExposure Position Type FTR_EXPOSURE_TYPECHAR5Assigned to domainFTR_EXPOSURE_TYPETEXH_F4_EXP_TYPE
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
PROFIT_CENTERProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
STORAGE_LOCATIONStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BATCHNRBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
CONDITION_TYPEView of EA_FINSERV Data Element FTR_CONDITION_TYPE TRCIN_CONDITION_TYPECHAR4TRCIN_CONDITION_TYPE
PAYMENT_DATEDate on which the Payment will be made FTR_PAYMENT_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
DELIVERY_DATEDate on which the Item will be delivered FTR_DELIVERY_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
INVOICING_STATUSInvoicing Status FTR_INVOICING_STATUSCHAR1FTR_INVOICING_STATUS
DELIVERY_STATUSDelivery Status FTR_DELIVERY_STATUSCHAR1FTR_DELIVERY_STATUS
ROOT_DOCUMENT_IDRoot Document ID FTR_ROOT_DOCUMENT_IDCHAR75FTR_ROOT_DOCUMENT_ID
REFERENCE_IDReference ID FTR_REFERENCE_IDCHAR75FTR_REFERENCE_ID
ATTRIBUTE_SH01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4TEXC_ATTR_SFTR_ATTRIBUTE_SHORT
ATTRIBUTE_SH02Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4TEXC_ATTR_SFTR_ATTRIBUTE_SHORT
ATTRIBUTE_LH01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_DH01Value of a free attribute (Date) FTR_ATTRIBUTE_DATEDATS8FTR_ATTRIBUTE_DATE
ATTRIBUTE_LI01Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_LI02Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_LI03Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_LI04Value of a free attribute (Char 20) FTR_ATTRIBUTE_LONGCHAR20TEXC_ATTR_LFTR_ATTRIBUTE_LONG
ATTRIBUTE_MI01Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10TEXC_ATTR_MFTR_ATTRIBUTE_MEDIUM
ATTRIBUTE_MI02Value of a free attribute (Char10) FTR_ATTRIBUTE_MEDIUMCHAR10TEXC_ATTR_MFTR_ATTRIBUTE_MEDIUM
ATTRIBUTE_SI01Value of a free attribute (Char4) FTR_ATTRIBUTE_SHORTCHAR4TEXC_ATTR_SFTR_ATTRIBUTE_SHORT
ATTRIBUTE_DI01Value of a free attribute (Date) FTR_ATTRIBUTE_DATEDATS8FTR_ATTRIBUTE_DATE

Key field Non-key field



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

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

How to access SAP table ROXEIS0115

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