TEXS_COEX_BW_EXTRACTION SAP (Extraction structure for Commodity Price Exposures) Structure details
Description: Extraction structure for Commodity Price Exposures
Related tables to TEXS_COEX_BW_EXTRACTION
Access table TEXS_COEX_BW_EXTRACTION
Structure field list including key, data, relationships and ABAP select examples
TEXS_COEX_BW_EXTRACTION 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 "Extraction structure for Commodity Price Exposures" 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_TEXS_COEX_BW_EXTRACTION TYPE TEXS_COEX_BW_EXTRACTION.
The TEXS_COEX_BW_EXTRACTION table consists of various fields, each holding specific information or linking keys about Extraction structure for Commodity Price Exposures data available in SAP. These include MANDT (Client), EXP_GRP_IND (Paper/Physical Indicator for Exposure Group), COMPANY_CODE (Company Code), EXPOSURE_ID (Commodity Price Exposure ID).. 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: Can be enhanced (character-type or numeric)
SAP TEXS_COEX_BW_EXTRACTION 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 |
ROCANCEL | Indicator: Cancel Data Record | ROCANCEL | CHAR | 1 | BOOLE | ||||
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
EXP_GRP_IND | Paper/Physical Indicator for Exposure Group | FTI_EXP_GROUP_INDICATOR | CHAR | 1 | FTI_EXP_GROUP_INDICATOR | ||||
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
EXPOSURE_ID | Commodity Price Exposure ID | FTR_CTY_EXPOS_ID | CHAR | 13 | Assigned to domain | ALPHA | FTR_CTY_EXPOS_ID | ||
ITEM_ID | Commodity Exposure Line Item ID | FTR_CTY_ITEM_ID | NUMC | 5 | Assigned to domain | FTR_CTY_ITEM_ID | |||
SUBEXPOS_ID | Commodity Exposure Sub Item ID | FTR_CTY_SUBITEM_ID | NUMC | 4 | FTR_CTY_SUBITEM_ID | ||||
VERSION | Version of a Commodity Price Exposure | FTR_CTY_EXPOS_VERSION | NUMC | 10 | FTR_CTY_EXPOS_VERSION | ||||
OS_GUID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
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 | Reporting Date | FTR_REPORTING_DATE | DATS | 8 | FTR_REPORTING_DATE | ||||
EXPOS_DUE_DATE | Date on Which Exposure Is Due / Expires | FTR_EXPOSURE_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
PHYS_COMM_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 | |||
REPORTING_PERIOD | Reporting Period | FTR_CTY_REPORTING_PERIOD | CHAR | 3 | Assigned to domain | TEM_PLANNING_PERIOD | |||
REPORTING_YEAR | Reporting Year | FTR_CTY_REPORTING_YEAR | NUMC | 4 | GJAHR | GJAHR | |||
BASE_QUANTITY | Basis Quantity | FTR_EXPOSURE_BASE_QTY | QUAN | 13(3) | FTR_EXPOSURE_QTY | ||||
BASE_UOM | Basis Unit of Measure for the Commodity | TPM_CTY_BASE_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 | ||
NUMBER_OF_CONTRACTS | Number of Contracts | TB_CONTRACTS_NUMBER | DEC | 15(5) | ASTUECK | ||||
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 | Exposure Amount | FTR_EXPOSURE_AMOUNT | CURR | 17(2) | FTR_EXPOSURE_AMOUNT | ||||
PRICE_CURRENCY | Exposure Amount Currency | FTR_EXPOSURE_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
PRICE_UNIT_QUOT | Price Unit of Quotation | FTR_PRICE_UNIT_OF_QUOT | DEC | 5 | FTR_PRICE_UNIT_OF_QUOT | ||||
PRICE_UOM | Price Unit of Measure for the Commodity | TPM_CTY_PRICE_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PRICE_DATE | Price Date | FTR_PRICE_DATE | DATS | 8 | FTR_PRICE_DATE | ||||
PRICE_TIME | Price Quotation Time | FTR_QUOTATION_TIME | TIMS | 6 | TIME | ||||
VALID_FROM_TST | Valid From Timestamp | FTR_VALID_FROM_STMP | DEC | 15 | TZNTSTMPS | ||||
VALID_TO_TST | Valid To Timestamp | FTR_VALID_TO_STMP | DEC | 15 | TZNTSTMPS | ||||
CREATION_IND | Raw Exposure Creation Indicator | FTR_CREATION_INDICATOR | CHAR | 1 | FTR_CREATION_INDICATOR | ||||
VALID_FROM_DATE | Valid From Date | FTR_VALID_FROM | DATS | 8 | FTR_VALID_FROM | ||||
VALID_FROM_TIME | Valid From Time | FTR_VALID_FROM_TIME | TIMS | 6 | FTR_VALID_FROM_TIME | ||||
VALID_TO_DATE | Valid To Date | FTR_VALID_TO | DATS | 8 | FTR_VALID_TO | ||||
VALID_TO_TIME | Valid To Time | FTR_VALID_TO_TIME | TIMS | 6 | FTR_VALID_TO_TIME | ||||
EXP_FLOW_TYPE | Exposure Activity Type | FTR_EXPOSURE_FLOW_TYPE | CHAR | 5 | Assigned to domain | FTR_EXPOSURE_FLOW_TYPE | TEXH_F4_ACTIVITY_TYPE | ||
P_TRANS_CAT | Exposure Category of Raw Exposure | FTR_RAWEXPOS_TRANSCAT | CHAR | 2 | Assigned to domain | FTR_RAWEXPOS_TRANSCAT | |||
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 | ||||
SIDE | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
RISK_PROFILE_ID | Commodity Risk Profile ID | FTR_COEX_RISK_PROFILE_ID | CHAR | 3 | Assigned to domain | FTR_COEX_RISK_PROFILE_ID | |||
REPORTING_GRP | Exposure Reporting Group | FTR_CTY_EXP_REP_GRP | CHAR | 2 | FTR_CTY_EXP_REP_GRP | ||||
PRC_FIXATION_STATUS | Status of Price Fixation Option | CPET_PRCFIX_STATUS | CHAR | 1 | STATV | ||||
EXER_DATE_EARLIEST | CPE Price Fixation - Earliest Exercise Date | CPET_PRCFIX_EARLY_EXERCISEDATE | DATS | 8 | DATE | ||||
EXER_DATE_LATEST | CPE Price Fixation - Latest Exercise Date | CPET_PRCFIX_LATE_EXERCISEDATE | DATS | 8 | DATE | ||||
EXP_APPROACH_CAT | Commodity Exposure Approach Category | FTR_EXP_APPR_CAT | NUMC | 1 | FTR_EXP_APPR_CAT | ||||
EXP_TYPE | Exposure Position Type | FTR_EXPOSURE_TYPE | CHAR | 5 | Assigned to domain | FTR_EXPOSURE_TYPE | TEXH_F4_EXP_TYPE | ||
PRODUCT_CAT | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
F_TRANS_CAT | Transaction Category | TB_SFGTYP | NUMC | 3 | Assigned to domain | T_SFGTYP | |||
TRANS_TYPE | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
TRANS_ACT_TYPE | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | Assigned to domain | T_SFGZUTY | C_AT02 | ||
TRANS_ID | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
COUNTERPARTY_ID | Business Partner Number | TB_KUNNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
EXT_ACCOUNT_ID | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
FUTURES_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | Assigned to domain | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
DERIVATIVE_CONTRACT_ID | Contract for Listed Options and Futures | FTR_DERIVATIVE_CONTRACT_ID | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
FINANCE_PROJECT | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
ASSIGNMENT | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
INTERNAL_REF | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
CHARACTERISTICS | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
CONTRACT_DATE | Contract Conclusion Date | TB_DVTRAB | DATS | 8 | DATUM | ||||
START_TERM | Term Start | TB_DBLFZ | DATS | 8 | DATUM | ||||
END_TERM | Term End | TB_DELFZ | DATS | 8 | DATUM | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
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_APPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP | ||
CONDITION_TYPE | Condition Type | FTR_CONDITION_TYPE | CHAR | 4 | FTR_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 TEXS_COEX_BW_EXTRACTION using ABAP code?
As TEXS_COEX_BW_EXTRACTION 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 TEXS_COEX_BW_EXTRACTION as there is no data to select.How to access SAP table TEXS_COEX_BW_EXTRACTION
Within an ECC or HANA version of SAP you can also view further information about TEXS_COEX_BW_EXTRACTION 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