TEXT_TRANSACTION SAP (Unmatched Exposure Business Transactions) Table details

Dictionary Type: Table
Description: Unmatched Exposure Business Transactions




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




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

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

The TEXT_TRANSACTION table consists of various fields, each holding specific information or linking keys about Unmatched Exposure Business Transactions data available in SAP. These include OS_GUID (Globally Unique Identifier), EXP_TYPE (Exposure Position Type), RISK_CAT (Exposure Risk Category), COUNTRY (Country Key).. 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_TRANSACTION 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 MANDTCLNT3T000MANDT
OS_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
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 BUKRSCHAR4T001BUKRSBUKC_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
VERSIONVersion of a Raw Exposure FTR_RAW_EXPOS_VERSIONNUMC6FTR_RAW_EXPOS_VERSION
RELEVANCE_DATEValid From Date FTR_VALID_FROMDATS8FTR_VALID_FROM
QUANTITYQuantity FTR_EXPOSURE_QTYQUAN13(3) FTR_EXPOSURE_QTY
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3T006CUNITMEINS
FOREIGN_AMTExposure Amount FTR_EXPOSURE_AMOUNTCURR17(2) FTR_EXPOSURE_AMOUNT
LOG_SYSTEMLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
EXPOSURE_ORIGINExposure Origin FTR_EXPOSURE_ORIGINCHAR5TEMTS_ORIGINTEM_EXPOSURE_ORIGIN
EXT_DOC_NOExternal Document Number FTR_EXTERNAL_DOC_NUMBERCHAR75FTR_EXTERNAL_DOC_NUMBER
MATCH_STATUSRaw Exposure Business Transaction Match Status FTR_REXP_TRANS_STATUSCHAR1FTR_REXP_TRANS_STATUS
STATUSCHANGEDBYEmployee ID RBEARCHAR12SYCHAR12
STATUSCHANGEDONLast Edited on DBEARDATS8DATUM
STATUSCHANGEDATLast Edited at TBEARTIMS6TIMES
ARCHIVE_STATEArchive Status FTR_ARCHIVE_STATECHAR1FTR_ARCHIVE_STATE
POSITION_IDExposure Position ID FTR_POSITION_IDCHAR20Assigned to domainALPHAFTR_POSITION_IDTEXH_POSITION

Key field Non-key field



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

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

SELECT SINGLE *
FROM TEXT_TRANSACTION
INTO CORRESPONDING FIELDS OF WA_TEXT_TRANSACTION
WHERE...

How to access SAP table TEXT_TRANSACTION

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