TEXT_TRANSACTION - Unmatched Exposure Business Transactions
Unmatched Exposure Business Transactions information is stored in SAP table TEXT_TRANSACTION.
It is part of development package FTR_EXPOSURE_MANAGEMENT in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "NeXt Exposure Management".
It is part of development package FTR_EXPOSURE_MANAGEMENT in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "NeXt Exposure Management".
Fields for table TEXT_TRANSACTION
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| OS_GUID | Globally Unique Identifier | X | OS_GUID | RAW | 16 | |
| .INCLUDE | TEXS_DIFF_ATTRIBUTES | 0 | ||||
| EXP_TYPE | Exposure Position Type | FTR_EXPOSURE_TYPE | CHAR | 10 | TEXC_EXP_TYPE | |
| RISK_CAT | Exposure Risk Category | FTR_RISK_CAT | CHAR | 2 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| COMPANY_CODE | Company Code | BUKRS | CHAR | 8 | T001 | |
| TRANSACTION_CAT | Exposure Category of Raw Exposure | FTR_RAWEXPOS_TRANSCAT | CHAR | 4 | TEXC_EXP_CAT | |
| TRANSACTIVITY | Exposure Activity | FTR_TRANSACT | NUMC | 4 | TEXC_EXP_ACT | |
| .INCLUDE | TEXS_HEADER_FREE_ATTR | 0 | ||||
| ATTRIBUTE_SH01 | Value of a Free Attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 8 | TEXC_ATTR_S | |
| ATTRIBUTE_SH02 | Value of a Free Attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 8 | TEXC_ATTR_S | |
| ATTRIBUTE_LH01 | Value of a Free Attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 40 | TEXC_ATTR_L | |
| ATTRIBUTE_DH01 | Value of a Free Attribute (Date) | FTR_ATTRIBUTE_DATE | DATS | 16 | ||
| PROFIT_CENTER | Profit Center | PRCTR | CHAR | 20 | ||
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 36 | ||
| FOREIGN_CURR | Exposure Amount Currency | FTR_EXPOSURE_CURR | CUKY | 10 | ||
| TARGET_CURR | Target Currency of Exposure | FTR_EXPOSURE_CURRENCY_TARGET | CUKY | 10 | ||
| .INCLUDE | TEXS_ITEM_FREE_ATTR | 0 | ||||
| ATTRIBUTE_LI01 | Value of a Free Attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 40 | TEXC_ATTR_L | |
| ATTRIBUTE_LI02 | Value of a Free Attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 40 | TEXC_ATTR_L | |
| ATTRIBUTE_LI03 | Value of a Free Attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 40 | TEXC_ATTR_L | |
| ATTRIBUTE_LI04 | Value of a Free Attribute (Char 20) | FTR_ATTRIBUTE_LONG | CHAR | 40 | TEXC_ATTR_L | |
| ATTRIBUTE_MI01 | Value of a Free Attribute (Char10) | FTR_ATTRIBUTE_MEDIUM | CHAR | 20 | TEXC_ATTR_M | |
| ATTRIBUTE_MI02 | Value of a Free Attribute (Char10) | FTR_ATTRIBUTE_MEDIUM | CHAR | 20 | TEXC_ATTR_M | |
| ATTRIBUTE_SI01 | Value of a Free Attribute (Char4) | FTR_ATTRIBUTE_SHORT | CHAR | 8 | TEXC_ATTR_S | |
| ATTRIBUTE_DI01 | Value of a Free Attribute (Date) | FTR_ATTRIBUTE_DATE | DATS | 16 | ||
| .INCLUDE | TEXS_ATTRIBUTES_OE | 0 | ||||
| RPORTB | Portfolio | RPORTB | CHAR | 20 | TWPOB | |
| KOSTL | Cost Center | KOSTL | CHAR | 20 | CSKS | |
| GSBER | Business Area | GSBER | CHAR | 8 | TGSB | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | PRPS | |
| FB_SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 20 | FAGL_SEGM | |
| BEHALF_OF_COMPANY | On Behalf of Company Code | TRBA_BEHALF_OF_COMPANY | CHAR | 8 | T001 | |
| .INCLUDE | TEXS_POS_DATE_INFO | 0 | ||||
| PLANNING_PERIOD | Planning Period | TEM_PLANNING_PERIOD | CHAR | 6 | TEMC_PERIOD | |
| PLANNING_YEAR | Planning Year | FTR_PLANNING_YEAR | NUMC | 8 | ||
| DUE_DATE | Due Date of an Exposure Position as a Differentiating Term | FTR_DUE_DATE_DIFF | DATS | 16 | ||
| .INCLUDE | TEXS_SUBITEM_KEY | 0 | ||||
| EXPOSURE_ID | Raw Exposure ID | FTR_RAW_EXPOS_ID | CHAR | 26 | * | |
| ITEM_ID | Raw Exposure Line Item ID | FTR_ITEM_ID | NUMC | 10 | * | |
| SUBEXPOS_ID | Sub Raw Exposure ID | FTR_SUBITEM_ID | NUMC | 8 | ||
| EXP_APPROACH_CAT | Commodity Exposure Approach Category | FTR_EXP_APPR_CAT | NUMC | 2 | ||
| FIXING_STATUS | Fixation Status | FTR_FIXING_STATUS | CHAR | 2 | ||
| VAR_PRICE_CAT | Floating Price Category | FTR_VARIABLE_PRICE_CATEGORY | CHAR | 2 | ||
| VERSION | Version of a Raw Exposure | FTR_RAW_EXPOS_VERSION | NUMC | 12 | ||
| RELEVANCE_DATE | Valid-From Date of Exposure | FTR_VALID_FROM | DATS | 16 | ||
| QUANTITY | Quantity | FTR_EXPOSURE_QTY | QUAN | 7 | ||
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 6 | T006 | |
| FOREIGN_AMT | Exposure Amount | FTR_EXPOSURE_AMOUNT | CURR | 9 | ||
| .INCLUDE | TEXS_RAW_EXPOS_KEY | 0 | ||||
| LOG_SYSTEM | Logical system | LOGSYS | CHAR | 20 | TBDLS | |
| EXPOSURE_ORIGIN | Exposure Origin | FTR_EXPOSURE_ORIGIN | CHAR | 10 | TEMTS_ORIGIN | |
| EXT_DOC_NO | External Document Number | FTR_EXTERNAL_DOC_NUMBER | CHAR | 152 | ||
| ORIGIN_TSTMP | Origin Timestamp | FTR_ORIGIN_TSTMP | DEC | 8 | ||
| MATCH_STATUS | Raw Exposure Business Transaction Match Status | FTR_REXP_TRANS_STATUS | CHAR | 2 | ||
| STATUSCHANGEDBY | Employee ID | RBEAR | CHAR | 24 | ||
| STATUSCHANGEDON | Last Edited On | DBEAR | DATS | 16 | ||
| STATUSCHANGEDAT | Last Edited At | TBEAR | TIMS | 12 | ||
| ARCHIVE_STATE | Archive Status | FTR_ARCHIVE_STATE | CHAR | 2 | ||
| POSITION_ID | Exposure Position ID | FTR_POSITION_ID | CHAR | 40 |