ROXEIS0115 SAP (Commodity Exposure) Structure details
Description: Commodity Exposure
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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
EXPOSURE_ID | Raw Exposure ID | FTR_RAW_EXPOS_ID | CHAR | 13 | Assigned to domain | ALPHA | FTR_RAW_EXPOS_ID | ||
ITEM_ID | Raw Exposure Line Item ID | FTR_ITEM_ID | NUMC | 5 | Assigned to domain | FTR_ITEM_ID | |||
SUBEXPOS_ID | Sub Raw Exposure ID | FTR_SUBITEM_ID | NUMC | 4 | FTR_SUBITEM_ID | ||||
VERSION | Version of a Raw Exposure | FTR_RAW_EXPOS_VERSION | NUMC | 6 | FTR_RAW_EXPOS_VERSION | ||||
OS_GUID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
EXP_GRP_IND | Paper/Physical Indicator for Exposure Group | FTI_EXP_GROUP_INDICATOR | CHAR | 1 | FTI_EXP_GROUP_INDICATOR | ||||
LOG_SYSTEM | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
EXPOSURE_ORIGIN | Exposure Origin | FTR_EXPOSURE_ORIGIN | CHAR | 5 | Assigned to domain | TEM_EXPOSURE_ORIGIN | |||
EXT_DOC_NO | External Document Number | FTR_EXTERNAL_DOC_NUMBER | CHAR | 75 | FTR_EXTERNAL_DOC_NUMBER | ||||
EXT_ITEM_ID | External Item ID | FTR_EXTERNAL_ITEM_ID | CHAR | 40 | FTR_EXTERNAL_ITEM_ID | ||||
REPORTING_DATE | View of EA_FINSERV Data Type FTR_EXPOSURE_DATE | TRCIN_DATE | DATS | 8 | TRCIN_DATE | ||||
EXPOSURE_DUE_DATE | Date on Which Exposure Is Due / Expires | FTR_EXPOSURE_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
PHYS_COMMODITY_ID | Physical Commodity | TBA_STOEFFCHEN | CHAR | 18 | Assigned to domain | TBA_STOEFFCHEN | |||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
DCS | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
PRICE_TYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
TENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | Assigned to domain | TBA_TENOR | TBAH_TENOR | ||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
PLANNING_PERIOD | Planning Period | TEM_PLANNING_PERIOD | CHAR | 3 | Assigned to domain | TEM_PLANNING_PERIOD | |||
PLANNING_YEAR | Plan Year | TEM_PLANNING_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
SIGN | View of EA-FINSERV Data Element FTR_SIGN | TRCIN_SIGN | CHAR | 1 | TRCIN_SIGN | ||||
REF_QUANTITY | Quantity | FTR_EXPOSURE_QTY | QUAN | 13(3) | FTR_EXPOSURE_QTY | ||||
REF_UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUANTITY | Quantity | FTR_EXPOSURE_QTY | QUAN | 13(3) | FTR_EXPOSURE_QTY | ||||
UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FOREIGN_AMT | Exposure Amount | FTR_EXPOSURE_AMOUNT | CURR | 17(2) | FTR_EXPOSURE_AMOUNT | ||||
FOREIGN_CURR | Exposure Amount Currency | FTR_EXPOSURE_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
TARGET_CURR | Target Currency of Exposure | FTR_EXPOSURE_CURRENCY_TARGET | CUKY | 5 | Assigned to domain | WAERS | |||
PRICE | View of EA_FINSERV Data Element FTR_EXPOSURE_AMOUNT | TRCIN_AMOUNT | CURR | 17(2) | TRCIN_AMOUNT | ||||
PRICE_CURRENCY | View of EA_FINSERV Data Element FTR_EXPOSURE_CURR | TRCIN_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
PRICE_UNIT_OF_QUOTATION | View of EA-FINSERV Data Element FTR_PRICE_UNIT_OF_QUOT | TRCIN_UNIT_OF_QUOTATION | DEC | 5 | TRCIN_UNIT_OF_QUOTATION | ||||
PRICE_UNIT_OF_MEASURE | View of EA_FINSERV Data Element TPM_CTY_UOM | TRCIN_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PRICE_DATE | View of EA_FINSERV Data Type FTR_EXPOSURE_DATE | TRCIN_DATE | DATS | 8 | TRCIN_DATE | ||||
PRICE_TIME | View of EA_FINSERV Data Element FTR_QUOTATION_TIME | TRCIN_QUOTATION_TIME | TIMS | 6 | TIME | ||||
CHANGE_TIMESTAMP | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | TZNTSTMPL | DEC | 21(7) | TZNTSTMPL | ||||
VALID_FROM_TST | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | TZNTSTMPL | DEC | 21(7) | TZNTSTMPL | ||||
VALID_TO_TST | UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) | TZNTSTMPL | DEC | 21(7) | TZNTSTMPL | ||||
CREATION_IND | Raw Exposure Creation Indicator | FTR_CREATION_INDICATOR | CHAR | 1 | FTR_CREATION_INDICATOR | ||||
CREATION_USER | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
CREATION_TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
RELEVANCE_DATE | Valid From Date | FTR_VALID_FROM | DATS | 8 | FTR_VALID_FROM | ||||
EXP_FLOW_TYPE | Exposure Activity Type | FTR_EXPOSURE_FLOW_TYPE | CHAR | 5 | Assigned to domain | FTR_EXPOSURE_FLOW_TYPE | TEXH_F4_ACTIVITY_TYPE | ||
TRANSACTION_CAT | Exposure Category of Raw Exposure | FTR_RAWEXPOS_TRANSCAT | CHAR | 2 | Assigned to domain | FTR_RAWEXPOS_TRANSCAT | |||
RISK_CAT | Exposure Risk Category | FTR_RISK_CAT | CHAR | 1 | FTR_RISK_CAT | ||||
TRANSACTIVITY | Exposure Activity | FTR_TRANSACT | NUMC | 2 | Assigned to domain | FTR_TRANSACT | |||
FIX_VAR_IND | Fixed/Floating Indicator | FTR_FIX_VARIABLE_INDICATOR | CHAR | 1 | FTR_FIX_VARIABLE_INDICATOR | ||||
FIXING_STATUS | Fixing Status | FTR_FIXING_STATUS | CHAR | 1 | FTR_FIXING_STATUS | ||||
REVERSE_INDICATOR | Reverse Indicator | TRCIN_REVERSE_INDICATOR | CHAR | 1 | TRCIN_REVERSE_INDICATOR | ||||
MP_EXPOSURE_RULE | View of EA_FINSERV Data Element FTR_MP_EXPOSURE_RULE | TRCIN_MP_EXPOSURE_RULE | CHAR | 2 | TRCIN_MP_EXPOSURE_RULE | ||||
EXP_APPROACH_CAT | Commodity Exposure Approach Category | FTR_EXP_APPR_CAT | NUMC | 1 | FTR_EXP_APPR_CAT | ||||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
TRANSACTION_ACT | Transaction Activity (E-HA) | THM_TRANSACT | NUMC | 2 | Assigned to domain | THM_TRANSACT | |||
HED_COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
HEDGE_PLAN_ID | Hedge Plan ID | THM_PLANNERID | CHAR | 13 | Assigned to domain | ALPHA | THM_PLANNERID | PLN | |
HED_EXPOSURE_ID | Exposure ID | THM_EXPOSUREID | NUMC | 5 | Assigned to domain | THM_EXPOSUREID | |||
HED_TRANS_ID | E-HA: Transaction | THM_TRANSACTION | CHAR | 11 | Assigned to domain | ALPHA | THM_TRANSACTION | ||
EXP_TYPE | Exposure Position Type | FTR_EXPOSURE_TYPE | CHAR | 5 | Assigned to domain | FTR_EXPOSURE_TYPE | TEXH_F4_EXP_TYPE | ||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
PROFIT_CENTER | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
STORAGE_LOCATION | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
BATCHNR | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
CONDITION_TYPE | View of EA_FINSERV Data Element FTR_CONDITION_TYPE | TRCIN_CONDITION_TYPE | CHAR | 4 | TRCIN_CONDITION_TYPE | ||||
PAYMENT_DATE | Date on which the Payment will be made | FTR_PAYMENT_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
DELIVERY_DATE | Date on which the Item will be delivered | FTR_DELIVERY_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
INVOICING_STATUS | Invoicing Status | FTR_INVOICING_STATUS | CHAR | 1 | FTR_INVOICING_STATUS | ||||
DELIVERY_STATUS | Delivery Status | FTR_DELIVERY_STATUS | CHAR | 1 | FTR_DELIVERY_STATUS | ||||
ROOT_DOCUMENT_ID | Root Document ID | FTR_ROOT_DOCUMENT_ID | CHAR | 75 | FTR_ROOT_DOCUMENT_ID | ||||
REFERENCE_ID | Reference ID | FTR_REFERENCE_ID | CHAR | 75 | FTR_REFERENCE_ID | ||||
ATTRIBUTE_SH01 | Value of a free attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 4 | TEXC_ATTR_S | FTR_ATTRIBUTE_SHORT | |||
ATTRIBUTE_SH02 | Value of a free attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 4 | TEXC_ATTR_S | FTR_ATTRIBUTE_SHORT | |||
ATTRIBUTE_LH01 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_DH01 | Value of a free attribute (Date) | FTR_ATTRIBUTE_DATE | DATS | 8 | FTR_ATTRIBUTE_DATE | ||||
ATTRIBUTE_LI01 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_LI02 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_LI03 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_LI04 | Value of a free attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 20 | TEXC_ATTR_L | FTR_ATTRIBUTE_LONG | |||
ATTRIBUTE_MI01 | Value of a free attribute (Char10) | FTR_ATTRIBUTE_MEDIUM | CHAR | 10 | TEXC_ATTR_M | FTR_ATTRIBUTE_MEDIUM | |||
ATTRIBUTE_MI02 | Value of a free attribute (Char10) | FTR_ATTRIBUTE_MEDIUM | CHAR | 10 | TEXC_ATTR_M | FTR_ATTRIBUTE_MEDIUM | |||
ATTRIBUTE_SI01 | Value of a free attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 4 | TEXC_ATTR_S | FTR_ATTRIBUTE_SHORT | |||
ATTRIBUTE_DI01 | Value of a free attribute (Date) | FTR_ATTRIBUTE_DATE | DATS | 8 | FTR_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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects