TEXT_TRANSACTION

Unmatched Exposure Business Transactions | #transactional | Component: Transaction Manager
Column Name Description
MANDT FK Client
OS_GUID Globally Unique Identifier
Column Name Description
💲 Exposure Amount Currency (FOREIGN_CURR):
FOREIGN_AMT Exposure Amount
Column Name Description
📏 Unit of Measure for the Commodity (UNIT_OF_MEASURE):
QUANTITY Quantity
Column Name Description
ATTRIBUTE_DH01 Value of a Free Attribute (Date)
ATTRIBUTE_DI01 Value of a Free Attribute (Date)
DUE_DATE Due Date of an Exposure Position as a Differentiating Term
RELEVANCE_DATE Valid-From Date of Exposure
STATUSCHANGEDON Last Edited On
STATUSCHANGEDAT Last Edited At
Column Name Description
RISK_CAT Exposure Risk Category Show values
EXP_APPROACH_CAT Commodity Exposure Approach Category Show values
FIXING_STATUS Fixation Status Show values
VAR_PRICE_CAT Floating Price Category Show values
MATCH_STATUS Raw Exposure Business Transaction Match Status Show values
ARCHIVE_STATE Archive Status Show values
Column Name Description Domain name
PLANNING_YEAR Planning Year GJAHR
EXPOSURE_ID Raw Exposure ID FTR_RAW_EXPOS_ID
ITEM_ID Raw Exposure Line Item ID FTR_ITEM_ID
SUBEXPOS_ID Sub Raw Exposure ID FTR_SUBITEM_ID
VERSION Version of a Raw Exposure FTR_RAW_EXPOS_VERSION
EXT_DOC_NO External Document Number FTR_EXTERNAL_DOC_NUMBER
ORIGIN_TSTMP Origin Timestamp TZNTSTMPS
STATUSCHANGEDBY Employee ID SYCHAR12
POSITION_ID Exposure Position ID FTR_POSITION_ID
Master Data Relations Join Conditions
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_LH01 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_LI01 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_LI02 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_LI03 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char 20)
  • ?
  • Value of a Free Attribute (Char 20)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_LI04 == TEXC_ATTR_L.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_L.MANDT
Value of a Free Attribute (Char10)
  • ?
  • Value of a Free Attribute (Char10)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_M.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_MI01 == TEXC_ATTR_M.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_M.MANDT
Value of a Free Attribute (Char10)
  • ?
  • Value of a Free Attribute (Char10)
  • Client
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_M.ATTRIBUTE_SUFFIX
  • TEXT_TRANSACTION.ATTRIBUTE_MI02 == TEXC_ATTR_M.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_M.MANDT
Value of a Free Attribute (Char4)
  • Value of a Free Attribute (Char4)
  • ?
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_S.MANDT
  • TEXT_TRANSACTION.ATTRIBUTE_SH01 == TEXC_ATTR_S.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX
Value of a Free Attribute (Char4)
  • Value of a Free Attribute (Char4)
  • ?
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_S.MANDT
  • TEXT_TRANSACTION.ATTRIBUTE_SH02 == TEXC_ATTR_S.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX
Value of a Free Attribute (Char4)
  • Value of a Free Attribute (Char4)
  • ?
  • TEXT_TRANSACTION.MANDT == TEXC_ATTR_S.MANDT
  • TEXT_TRANSACTION.ATTRIBUTE_SI01 == TEXC_ATTR_S.ATTRIBUTE_VALUE
  • TEXT_TRANSACTION.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX
On Behalf of Company Code
  • TEXT_TRANSACTION.MANDT == T001.MANDT
  • TEXT_TRANSACTION.BEHALF_OF_COMPANY == T001.BUKRS
Company Code
  • TEXT_TRANSACTION.MANDT == T001.MANDT
  • TEXT_TRANSACTION.COMPANY_CODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • TEXT_TRANSACTION.COUNTRY == T005.LAND1
  • TEXT_TRANSACTION.MANDT == T005.MANDT
Exposure Origin TEXT_TRANSACTION.EXPOSURE_ORIGIN == TEMTS_ORIGIN.EXPOSURE_ORIGIN
Exposure Position Type
  • Exposure Position Type
  • Client
Segment for Segmental Reporting
  • TEXT_TRANSACTION.MANDT == FAGL_SEGM.MANDT
  • TEXT_TRANSACTION.FB_SEGMENT == FAGL_SEGM.SEGMENT
Business Area
  • TEXT_TRANSACTION.MANDT == TGSB.MANDT
  • TEXT_TRANSACTION.GSBER == TGSB.GSBER
Cost Center
  • ?
  • Cost Center
  • ?
  • TEXT_TRANSACTION.MANDT == CSKS.MANDT
  • TEXT_TRANSACTION.[column in domain "DATBI"] == CSKS.DATBI
  • TEXT_TRANSACTION.KOSTL == CSKS.KOSTL
  • TEXT_TRANSACTION.[column in domain "KOKRS"] == CSKS.KOKRS
Logical system TEXT_TRANSACTION.LOG_SYSTEM == TBDLS.LOGSYS
Client TEXT_TRANSACTION.MANDT == T000.MANDT
Planning Period
Portfolio
  • ?
  • Portfolio
  • Client
  • TEXT_TRANSACTION.[column in domain "BUKRS"] == TWPOB.BUKRS
  • TEXT_TRANSACTION.RPORTB == TWPOB.RPORTB
  • TEXT_TRANSACTION.MANDT == TWPOB.MANDT
Exposure Category of Raw Exposure
Exposure Activity
Unit of Measure for the Commodity
  • TEXT_TRANSACTION.MANDT == T006.MANDT
  • TEXT_TRANSACTION.UNIT_OF_MEASURE == T006.MSEHI