TEXT_REXP_ITEM SAP (Raw Exposure Item) Table details

Dictionary Type: Table
Description: Raw Exposure Item




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




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

TEXT_REXP_ITEM is a standard SAP Table which is used to store Raw Exposure Item data and is available within R/3 SAP systems depending on the version and release level.

The TEXT_REXP_ITEM table consists of various fields, each holding specific information or linking keys about Raw Exposure Item data available in SAP. These include HEAD_OS_GUID (Globally Unique Identifier), ITEM_ID (Raw Exposure Line Item ID), EXT_ITEM_NO (External Item Number), EXT_ITEM_ID (External Item 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: 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 TEXT_REXP_ITEM table 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
HEAD_OS_GUIDGlobally Unique Identifier OS_GUIDRAW16TEXT_RAWEXPOSSYSUUID
ITEM_IDRaw Exposure Line Item ID FTR_ITEM_IDNUMC5FTR_ITEM_ID
EXT_ITEM_NOExternal Item Number FTR_EXTERNAL_ITEM_NUMBERNUMC6
EXT_ITEM_IDExternal Item ID FTR_EXTERNAL_ITEM_IDCHAR40FTR_EXTERNAL_ITEM_ID
PLANNING_PERIODPlanning Period TEM_PLANNING_PERIODCHAR3TEMC_PERIODTEM_PLANNING_PERIOD
PLANNING_YEARPlanning Year FTR_PLANNING_YEARNUMC4GJAHRGJAHR
DUE_DATEDate on Which Exposure Is Due / Expires FTR_EXPOSURE_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TRCOT_CTY_MASTERTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
QUANTITYQuantity FTR_EXPOSURE_QTYQUAN13(3) FTR_EXPOSURE_QTY
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
FIX_VAR_INDFixed/Floating Indicator FTR_FIX_VARIABLE_INDICATORCHAR1FTR_FIX_VARIABLE_INDICATOR
FIX_VAR_IND_TDescription Fixed/Floating Indicator FTR_FIX_VARIABLE_INDICATOR_TCHAR20TEXT20
FOREIGN_AMTExposure Amount FTR_EXPOSURE_AMOUNTCURR17(2) FTR_EXPOSURE_AMOUNT
FOREIGN_CURRExposure Amount Currency FTR_EXPOSURE_CURRCUKY5TCURCWAERS
TARGET_CURRTarget Currency of Exposure FTR_EXPOSURE_CURRENCY_TARGETCUKY5TCURCWAERS
PROFIT_CENTERProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BATCHNRBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
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
ARCHIVE_STATEArchive Status FTR_ARCHIVE_STATECHAR1FTR_ARCHIVE_STATE
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
MP_EXPOSURE_RULEMarket Price Exposure Rule FTR_MP_EXPOSURE_RULECHAR2FTR_MP_EXPOSURE_RULE
CONDITION_TYPECondition Type FTR_CONDITION_TYPECHAR4FTR_CONDITION_TYPE
STORAGE_LOCATIONStorage Location LGORT_DCHAR4T001LLGORTLAG
VAR_PRICE_CATFloating Price Category FTR_VARIABLE_PRICE_CATEGORYCHAR1FTR_VARIABLE_PRICE_CATEGORY
PRC_FIXATION_STATUSStatus of Price Fixation Option CPET_PRCFIX_STATUSCHAR1STATV
PRC_FIXATION_STATUS_TDescription Status of Price Fixation Option FTR_PRC_FIXATION_STATUS_TCHAR20TEXT20
EXER_DATE_EARLIESTCPE Price Fixation - Earliest Exercise Date CPET_PRCFIX_EARLY_EXERCISEDATEDATS8DATE
EXER_DATE_LATESTCPE Price Fixation - Latest Exercise Date CPET_PRCFIX_LATE_EXERCISEDATEDATS8DATE

Key field Non-key field



How do I retrieve data from SAP table TEXT_REXP_ITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on TEXT_REXP_ITEM to SELECT all data from the table
DATA: WA_TEXT_REXP_ITEM TYPE TEXT_REXP_ITEM.

SELECT SINGLE *
FROM TEXT_REXP_ITEM
INTO CORRESPONDING FIELDS OF WA_TEXT_REXP_ITEM
WHERE...

How to access SAP table TEXT_REXP_ITEM

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