TEXT_POSITIONS

Exposure Positions | #transactional | Component: Transaction Manager

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (8)
☰ Categorical (5)
Other (16)
🔗 Relations (23)

Column Name	Description
MANDT	Client
OS_GUID	Globally Unique Identifier

Column Name	Description

Column Name	Description

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
DUE_DATE_ATTR	Date on which the exposure is due and expires
CREATION_DATE	First Entered On
CREATION_TIME	Time of Creation
LASTCHANGE_DATE	Last Edited On
LASTCHANGE_TIME	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
ARCHIVE_STATE	Archive Status	Show values

Column Name	Description	Domain name
POSITION_ID	Exposure Position ID	FTR_POSITION_ID
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
HED_COMPANY_CODE	Company Code	BUKRS
HED_EXPOSURE_ID	Exposure ID	THM_EXPOSUREID
HED_TRANS_ID	E-HA: Transaction	THM_TRANSACTION
OBJNR	Financial Object Number	J_OBJNR
TRANSACTION_ACT	Transaction Activity (E-HA)	THM_TRANSACT
REFERENCE	Reference	CHAR16
DESCRIPTION	Description of an exposure position	TEXT50
CREATION_USER	Entered By	SYCHAR12
CREATION_TCODE	Transaction Code	TCODE
LASTCHANGE_USER	Employee ID	SYCHAR12
LASTCHANGE_TCODE	Transaction Code	TCODE

Master Data Relations	Join Conditions
Value of a Free Attribute (Char 20) ? Value of a Free Attribute (Char 20) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_LH01 == TEXC_ATTR_L.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_L.MANDT`
Value of a Free Attribute (Char 20) ? Value of a Free Attribute (Char 20) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_LI01 == TEXC_ATTR_L.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_L.MANDT`
Value of a Free Attribute (Char 20) ? Value of a Free Attribute (Char 20) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_LI02 == TEXC_ATTR_L.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_L.MANDT`
Value of a Free Attribute (Char 20) ? Value of a Free Attribute (Char 20) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_LI03 == TEXC_ATTR_L.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_L.MANDT`
Value of a Free Attribute (Char 20) ? Value of a Free Attribute (Char 20) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_L.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_LI04 == TEXC_ATTR_L.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_L.MANDT`
Value of a Free Attribute (Char10) ? Value of a Free Attribute (Char10) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_M.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_MI01 == TEXC_ATTR_M.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_M.MANDT`
Value of a Free Attribute (Char10) ? Value of a Free Attribute (Char10) Client	`TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_M.ATTRIBUTE_SUFFIX` `TEXT_POSITIONS.ATTRIBUTE_MI02 == TEXC_ATTR_M.ATTRIBUTE_VALUE` `TEXT_POSITIONS.MANDT == TEXC_ATTR_M.MANDT`
Value of a Free Attribute (Char4) Value of a Free Attribute (Char4) ?	`TEXT_POSITIONS.MANDT == TEXC_ATTR_S.MANDT` `TEXT_POSITIONS.ATTRIBUTE_SH01 == TEXC_ATTR_S.ATTRIBUTE_VALUE` `TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX`
Value of a Free Attribute (Char4) Value of a Free Attribute (Char4) ?	`TEXT_POSITIONS.MANDT == TEXC_ATTR_S.MANDT` `TEXT_POSITIONS.ATTRIBUTE_SH02 == TEXC_ATTR_S.ATTRIBUTE_VALUE` `TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX`
Value of a Free Attribute (Char4) Value of a Free Attribute (Char4) ?	`TEXT_POSITIONS.MANDT == TEXC_ATTR_S.MANDT` `TEXT_POSITIONS.ATTRIBUTE_SI01 == TEXC_ATTR_S.ATTRIBUTE_VALUE` `TEXT_POSITIONS.[column in domain "FTR_ATTRIBUTE_SUFFIX"] == TEXC_ATTR_S.ATTRIBUTE_SUFFIX`
On Behalf of Company Code	`TEXT_POSITIONS.MANDT == T001.MANDT` `TEXT_POSITIONS.BEHALF_OF_COMPANY == T001.BUKRS`
Country/Region Key Country/Region Key Client	`TEXT_POSITIONS.COUNTRY == T005.LAND1` `TEXT_POSITIONS.MANDT == T005.MANDT`
Exposure Position Type Exposure Position Type Client	`TEXT_POSITIONS.EXP_TYPE == TEXC_EXP_TYPE.EXP_TYPE` `TEXT_POSITIONS.MANDT == TEXC_EXP_TYPE.MANDT`
Segment for Segmental Reporting	`TEXT_POSITIONS.MANDT == FAGL_SEGM.MANDT` `TEXT_POSITIONS.FB_SEGMENT == FAGL_SEGM.SEGMENT`
Business Area	`TEXT_POSITIONS.MANDT == TGSB.MANDT` `TEXT_POSITIONS.GSBER == TGSB.GSBER`
Cost Center ? Cost Center ?	`TEXT_POSITIONS.MANDT == CSKS.MANDT` `TEXT_POSITIONS.[column in domain "DATBI"] == CSKS.DATBI` `TEXT_POSITIONS.KOSTL == CSKS.KOSTL` `TEXT_POSITIONS.[column in domain "KOKRS"] == CSKS.KOKRS`
Planning Period	`TEXT_POSITIONS.MANDT == TEMC_PERIOD.MANDT` `TEXT_POSITIONS.PLANNING_PERIOD == TEMC_PERIOD.PLANNING_PERIOD`
Product Type Product Type Client	`TEXT_POSITIONS.PRODUCT_TYPE == TZPA.GSART` `TEXT_POSITIONS.MANDT == TZPA.MANDT`
Portfolio ? Portfolio Client	`TEXT_POSITIONS.[column in domain "BUKRS"] == TWPOB.BUKRS` `TEXT_POSITIONS.RPORTB == TWPOB.RPORTB` `TEXT_POSITIONS.MANDT == TWPOB.MANDT`
Exposure Category of Raw Exposure	`TEXT_POSITIONS.MANDT == TEXC_EXP_CAT.MANDT` `TEXT_POSITIONS.TRANSACTION_CAT == TEXC_EXP_CAT.EXP_CAT`
Exposure Activity	`TEXT_POSITIONS.MANDT == TEXC_EXP_ACT.MANDT` `TEXT_POSITIONS.TRANSACTIVITY == TEXC_EXP_ACT.EXP_ACT`