TEXT_POSITIONS SAP (Exposure Positions) Table details

Dictionary Type: Table
Description: Exposure Positions




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




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

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

The TEXT_POSITIONS table consists of various fields, each holding specific information or linking keys about Exposure Positions data available in SAP. These include OS_GUID (Globally Unique Identifier), POSITION_ID (Exposure Position ID), EXP_TYPE (Exposure Position Type), RISK_CAT (Exposure Risk Category).. 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_POSITIONS 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
OS_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
POSITION_IDExposure Position ID FTR_POSITION_IDCHAR20Assigned to domainALPHAFTR_POSITION_IDTEXH_POSITION
EXP_TYPEExposure Position Type FTR_EXPOSURE_TYPECHAR5TEXC_EXP_TYPEFTR_EXPOSURE_TYPETEXH_F4_EXP_TYPE
RISK_CATExposure Risk Category FTR_RISK_CATCHAR1FTR_RISK_CAT
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
TRANSACTION_CATExposure Category of Raw Exposure FTR_RAWEXPOS_TRANSCATCHAR2TEXC_EXP_CATFTR_RAWEXPOS_TRANSCAT
TRANSACTIVITYExposure Activity FTR_TRANSACTNUMC2TEXC_EXP_ACTFTR_TRANSACT
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
PROFIT_CENTERProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18Assigned to domainTPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
FOREIGN_CURRExposure Amount Currency FTR_EXPOSURE_CURRCUKY5Assigned to domainWAERS
TARGET_CURRTarget Currency of Exposure FTR_EXPOSURE_CURRENCY_TARGETCUKY5Assigned to domainWAERS
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
PLANNING_PERIODPlanning Period TEM_PLANNING_PERIODCHAR3TEMC_PERIODTEM_PLANNING_PERIOD
PLANNING_YEARPlanning Year FTR_PLANNING_YEARNUMC4GJAHRGJAHR
DUE_DATEDue Date of an Exposure Position as a Differentiating Term FTR_DUE_DATE_DIFFDATS8Assigned to domainFTR_EXPOSURE_DATE
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
EXP_APPROACH_CATCommodity Exposure Approach Category FTR_EXP_APPR_CATNUMC1FTR_EXP_APPR_CAT
FIXING_STATUSFixing Status FTR_FIXING_STATUSCHAR1FTR_FIXING_STATUS
VAR_PRICE_CATFloating Price Category FTR_VARIABLE_PRICE_CATEGORYCHAR1FTR_VARIABLE_PRICE_CATEGORY
PRODUCT_TYPEProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
HED_COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
HEDGE_PLAN_IDHedge Plan ID THM_PLANNERIDCHAR13THMEXT_PLANNERALPHATHM_PLANNERIDPLN
HED_EXPOSURE_IDExposure ID THM_EXPOSUREIDNUMC5Assigned to domainTHM_EXPOSUREID
HED_TRANS_IDE-HA: Transaction THM_TRANSACTIONCHAR11Assigned to domainALPHATHM_TRANSACTION
OBJNRObject Number (Exposure Positions) FTR_OBJNRCHAR22Assigned to domainJ_OBJNR
DUE_DATE_ATTRDate on Which Exposure Is Due / Expires FTR_EXPOSURE_DATEDATS8Assigned to domainFTR_EXPOSURE_DATE
TRANSACTION_ACTTransaction Activity (E-HA) THM_TRANSACTNUMC2Assigned to domainTHM_TRANSACT
REFERENCEReference FTR_EXPOSURE_REFERENCECHAR16CHAR16
DESCRIPTIONDescription of an exposure position FTR_EXPOSURE_TEXTCHAR50TEXT50
ARCHIVE_STATEArchive Status FTR_ARCHIVE_STATECHAR1FTR_ARCHIVE_STATE
CREATION_DATEFirst Entered on DERFDATS8DATUM
CREATION_TIMETime of Initial Entry TERFTIMS6TIMES
CREATION_USEREntered by RERFCHAR12SYCHAR12
CREATION_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
LASTCHANGE_DATELast Edited on DBEARDATS8DATUM
LASTCHANGE_TIMELast Edited at TBEARTIMS6TIMES
LASTCHANGE_USEREmployee ID RBEARCHAR12SYCHAR12
LASTCHANGE_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD

Key field Non-key field



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

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

SELECT SINGLE *
FROM TEXT_POSITIONS
INTO CORRESPONDING FIELDS OF WA_TEXT_POSITIONS
WHERE...

How to access SAP table TEXT_POSITIONS

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