TRLS_POSITION_VALUE_ATTR_TXT SAP (Structure: Position Attributes Texts) Structure details
Description: Structure: Position Attributes Texts
Related tables to TRLS_POSITION_VALUE_ATTR_TXT
Access table TRLS_POSITION_VALUE_ATTR_TXT
Structure field list including key, data, relationships and ABAP select examples
TRLS_POSITION_VALUE_ATTR_TXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure: Position Attributes Texts" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TRLS_POSITION_VALUE_ATTR_TXT TYPE TRLS_POSITION_VALUE_ATTR_TXT.
The TRLS_POSITION_VALUE_ATTR_TXT table consists of various fields, each holding specific information or linking keys about Structure: Position Attributes Texts data available in SAP. These include VALUATION_AREA (Valuation Area), COM_VAL_CLASS (General Valuation Class), VALUATION_CLASS (Valuation Class), ACCOUNTING_CODE (Accounting Code).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TRLS_POSITION_VALUE_ATTR_TXT structure 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 |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | ||
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
ACCOUNTING_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | TRGC_TR_ACC_CODE | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ACC_CCD_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
PORTFOLIO | Portfolio as Differentiation Characteristic | TPM_PORTFOLIO_DIFF | CHAR | 10 | TWPOB | RPORTB | |||
TRADER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | VDARL | ALPHA | RANL | RAN | |
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | Assigned to domain | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
LOT_ID | Lot ID for External Display | TPM_LOT_ID_EXT | CHAR | 32 | TPM_DB_OS_GUID | ||||
DEAL_NUMBER | Financial Transaction | TB_RFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | Assigned to domain | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC |
EXTERNAL_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | ||
DIFF_CURRENCY | Currency as Differentiation Term | TPM_DIFF_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | TPM_DIFF_CURR | ||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_USER | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_BUSTRANSCAT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | Assigned to domain | TPM_BUSTRANSCAT | |||
LOTPOSITION_INIT_DATE | Position Acquisition Date of a Lot | FTI_LOTPOSITION_INIT_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTPOSITION_ORG_DATE | Original Position Acquisition Date of a Lot | FTI_LOTPOSITION_ORG_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTGENERATION_BUKRS | Company Code of Lot-Generating Transaction | FTI_LOTGENERATION_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | H_T001 | ||
LOTGENERATION_DEALNR | Lot-Generating Transaction Number (Listed Derivatives) | FTI_LOTGENERATION_DEALNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_TRANS_NO | |
POSITION_OID | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
TRL_POSITION_STATUS | TRL Position Status for Key Date | FTI_TRL_POSITION_STATUS | CHAR | 1 | FTI_TRL_POSITION_STATUS | ||||
UNITS | Units | TPM_UNITS | DEC | 22(6) | TPM_UNITS | ||||
NOMINAL_AMT | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
NOMINAL_ORG_AMT_PC | Original Nominal Amount in Position Currency | TPM_NOMINAL_ORG_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SVWHR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
PURCH_PC | Purchase Value in Position Currency | FTI_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_IDXCL_PC | Purchase Value, Index-Clean, in Position Currency | FTI_PURCH_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
PURCH_VC | Purchase Value in Valuation Currency | FTI_PURCH_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_PC | Costs in position currency | FTI_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_IDXCL_PC | Costs, Index-Clean, in Position Currency | FTI_CHARGE_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CHARGE_VC | Costs in Valuation Currency | FTI_CHARGE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_PC | Acquisition Value in Position Currency | FTI_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_IDXCL_PC | Acquisition Value, Index-Clean, in Position Currency | FTI_AQU_VAL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AQU_VAL_VC | Acquisition Value in Valuation Currency | FTI_AQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_PC | Impairment in Position Currency | FTI_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_IDXCL_PC | Impairment in Position Currency, Index Clean | FTI_IMPMNT_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_VC | Impairment in Valuation Currency | FTI_IMPMNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
IMPMNT_FX_VC | FX Impairment in Valuation Currency | FTI_IMPMNT_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_PC | Amortization in Position Currency | FTI_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_IDXCL_PC | Amortization, Index-Clean, in Position Currency | FTI_AMORT_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_VC | Amortization in Valuation Currency | FTI_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_NEG_SPR_PC | Amortized Negotiation Spread in Position Currency | FTI_AMORT_NEG_SPREAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_NEG_SPR_IDXCL_PC | Amort. Negotiation Spread in Position Currency, Index-Clean | FTI_AMORT_NEG_SPREAD_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMORT_NEG_SPR_VC | Amortized Negotiation Spread in Valuation Currency | FTI_AMORT_NEG_SPREAD_VC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_PC | Cumulative Repayment in Position Currency | TPM_REPAYMENT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_IDXCL_PC | Cumulative Repayment in Position Currency Index-Clean | TPM_REPAYMENT_IDX_CLEAN | CURR | 21(2) | TPM_AMOUNT | ||||
REPAYMENT_VC | Cumulative Repayment in Valuation Currency | TPM_REPAYMENT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_AMAQU_VAL_VC | FX Valuation of Amort.Acquisition Value in Valuation Crcy | FTI_VAL_FX_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_PC | Amortized Acquisition Value in Position Currency | FTI_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_IDXCL_PC | Amortized Acquisition Value, Index-Clean, in Position Crcy | FTI_AMAQU_VAL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMAQU_VAL_VC | Amortized Acquisition Value in Valuation Currency | FTI_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_PC | Cleared PD Deferral/Tax Compensation in Position Currency | FTI_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_IDXCL_PC | Cleared PD Deferral/Tax Compensation in PC: Index-Clean | FTI_DISAGIO_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
DISAGIO_VC | Cleared PD Deferral/Tax Compensation in Valuation Currency | FTI_DISAGIO_VC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_PC | Hedge Adjustment in Position Currency | FTI_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_IDXCL_PC | Hedge Adjustment in Position Currency, Index-Clean | FTI_HADJ_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HADJ_VC | Hedge Adjustment in Valuation Currency | FTI_HADJ_VC | CURR | 21(2) | TPM_AMOUNT | ||||
HAMORT_PC | Hedge Amortization in Position Currency | FTI_HAMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HAMORT_IDXCL_PC | Hedge Amortization in Position Crcy, Index-Clean | FTI_HAMORT_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
HAMORT_VC | Hedge Amortization in Valuation Currency | FTI_HAMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_PC | Security Valuation in Position Currency | FTI_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_IDXCL_PC | Security Valuation, Index-Clean, in Position Currency | FTI_VAL_TI_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_UP_PC | Security Write-Up in Position Currency | FTI_VAL_UP_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_DOWN_PC | Security Write-Down in Position Currency | FTI_VAL_DOWN_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_VC | Security Valuation in Valuation Currency | FTI_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_UP_VC | Security Write-Up in Valuation Currency | FTI_VAL_UP_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_DOWN_VC | Security Write-Down in Valuation Currency | FTI_VAL_DOWN_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_VC | Foreign Currency Valuation in Valuation Currency | FTI_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_UP_VC | Forex Write-Up in Valuation Currency | FTI_VAL_FX_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_DOWN_VC | Forex Write-Down in Valuation Currency | FTI_VAL_FX_DOWN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_PC | Index Valuation in Position Currency | FTI_VAL_IDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_UP_PC | Index Write-Up in Position Currency | FTI_VAL_IDX_UP_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_DOWN_PC | Index Write-Down in Position Currency | FTI_VAL_IDX_DOWN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_VC | Index Valuation in Valuation Currency | FTI_VAL_IDX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_UP_VC | Index Write-Up in Valuation Currency | FTI_VAL_IDX_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_DOWN_VC | Index Write-Down in Valuation Currency | FTI_VAL_IDX_DOWN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | FTI_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_IDXCL_PC | Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy | FTI_VAL_CH_TI_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_UP_PC | Write-Up of Capitalized Costs, Security Valn in Pos.Crcy | FTI_VAL_CH_TI_UP_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_DOWN_PC | Write-Down of Capitalized Costs, Security Valn in Pos.Crcy | FTI_VAL_CH_TI_DOWN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_VC | Valuation of Cap. Costs, Security, in Valuation Currency | FTI_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_UP_VC | Write-Up of Capitalized Costs, Security Valn in Val.Crcy | FTI_VAL_CH_TI_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_DOWN_VC | Write-Down of Capitalized Costs, Security Valn in Val.Crcy | FTI_VAL_CH_TI_DOWN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Valuation Currency | FTI_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_UP_VC | Write-Up of Capitalized Costs, FX Valuation in Val.Crcy | FTI_VAL_CH_FX_UP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_DOWN_VC | Write-Down of Capitalized Costs, FX Valuation in Val.Crcy | FTI_VAL_CH_FX_DOWN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALP_VC | Spot Valuation of Purchase Currency in Valuation Currency | FTI_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SPOTVALS_VC | Spot Valuation of Sale Currency in Valuation Currency | FTI_SPOTVALS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPVAL_VC | Swap Valuation in Valuation Currency | FTI_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_PC | Swap/Margin Accrual/Deferral in Position Currency | FTI_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SWAPACC_VC | Swap or Margin Accrual/Deferral in Valuation Currency | FTI_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_PC | Book Value in Position Currency | FTI_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_IDXCL_PC | Book Value, Index-Clean, in Position Currency | FTI_BOOK_VAL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_VC | Book Value in Valuation Currency | FTI_BOOK_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_PC | Book Value Excluding Costs in Position Currency | FTI_BOOK_VAL_EX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_IDXCL_PC | Book Value Excluding Costs, Index-Clean, in Position Crcy | FTI_BOOK_VAL_EX_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
BOOK_VAL_EX_VC | Book Value Excluding Costs in Valuation Currency | FTI_BOOK_VAL_EX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in Position Currency | FTI_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_IDXCL_PC | Security Valuation, Not Affecting P/L, Index-Clean, in PC | FTI_VAL_TI_NPL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_TI_NPL_VC | Security Valuation, Not Affecting P/L, in Valuation Currency | FTI_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_FX_NPL_VC | Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy | FTI_VAL_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_NPL_PC | Index Valuation, Not Affecting P/L, in Position Currency | FTI_VAL_IDX_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_IDX_NPL_VC | Index Valuation, Not Affecting P/L, in Valuation Currency | FTI_VAL_IDX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy | FTI_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_IDXCL_PC | Val.of Cap.Costs, SE, Not Aff.P/L, Index-Clean, in Pos.Crcy | FTI_VAL_CH_TI_NPL_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_TI_NPL_VC | Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy | FTI_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAL_CH_FX_NPL_VC | Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy | FTI_VAL_CH_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
COMP_ACC_INTEREST_PC | Accrued Interest (Position Component) in Position Currency | FTI_COMP_ACC_INTEREST_PC | CURR | 21(2) | TPM_AMOUNT | ||||
COMP_ACC_INTEREST_VC | Accrued Interest in Valuation Currency | FTI_COMP_ACC_INTEREST_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VARMAR_PC | Variation Margin in Position Currency | FTI_VARMAR_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VARMAR_VC | Variation Margin in Valuation Currency | FTI_VARMAR_VC | CURR | 21(2) | TPM_AMOUNT | ||||
DEF_ITEM_PV_PC | Deferral Item for Purchase Value in PC | FTI_DEFERRAL_ITEM_PV_PC | CURR | 21(2) | TPM_AMOUNT | ||||
DEF_ITEM_PV_IDXCL_PC | Deferral Item for Purchase Value in Pos.Crcy, Index-Clean | FTI_DEFERRAL_ITEM_PV_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
DEF_ITEM_PV_VC | Deferral Item for Purchase Value in Valuation Currency | FTI_DEFERRAL_ITEM_PV_VC | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CLEARING_PC | Clearing Component in Position Currency (Internal) | FTI_INTERNAL_CLEARING_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CLEARING_IDXCL_PC | Clearing Component in Position Crcy, Index Clean (Internal) | FTI_INTERNAL_CLEARING_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INT_CLEARING_VC | Clearing Component in Valuation Currency | FTI_INTERNAL_CLEARING_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_PC | Consolidated Security Gains in Position Currency | FTI_CONS_GAINS_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_TI_VC | Consolidated Security Gains in Valuation Currency | FTI_CONS_GAINS_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_TI_PC | Consolidated Security Losses in Position Currency | FTI_CONS_LOSSES_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_TI_VC | Consolidated Security Losses in Valuation Currency | FTI_CONS_LOSSES_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_GAINS_FX_VC | Consolidated FX Gains in Valuation Currency | FTI_CONS_GAINS_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
CONS_LOSSES_FX_VC | Consolidated FX Losses in Valuation Currency | FTI_CONS_LOSSES_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_PC | Value Adjustment of Gains in Position Currency | FTI_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_GAIN_VC | Value Adjustment of Gains in Valuation Currency | FTI_VAD_GAIN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_PC | Value Adjustment of Losses in Position Currency | FTI_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
VAD_LOSS_VC | Value Adjustment of Losses in Valuation Currency | FTI_VAD_LOSS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_PC | Original Value Adjustment in Position Currency | FTI_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
ORIG_VAD_VC | Original Value Adjustment in Valuation Currency | FTI_ORIG_VAD_VC | CURR | 21(2) | TPM_AMOUNT | ||||
INT_INCOME_PC | Interest Income in Position Currency | FTI_INT_INCOME_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INT_INCOME_INDX_PC | Interest Income, Index-Clean, in Position Currency | FTI_INT_INCOME_INDX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
INT_INCOME_VC | Interest Income in Valuation Currency | FTI_INT_INCOME_VC | CURR | 21(2) | TPM_AMOUNT | ||||
ZERO_POSITION | Zero Position on Key Date | FTI_ZERO_POSITION | DEC | 1 | FTI_ZERO_POSITION | ||||
AMORT_PROC | Procedure for a Step | TPM_STEP_PROCEDURE | CHAR | 4 | Assigned to domain | TPM_STEP_PROCEDURE | |||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
PORTFOLIO_TM | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
PORTFOLIO_TM_T | Portfolio name | VVXPORTB | CHAR | 30 | TEXT30 | ||||
POS_MAN_PROC | Position Management Procedure | TPM_POS_MAN_PROC | CHAR | 4 | Assigned to domain | TPM_POS_MAN_PROC | |||
ACC_ASS_REFERENCE | Account Assignment Reference of Position Management | TPM_AA_REF | CHAR | 12 | Assigned to domain | TPM_AA_REF | TRAC_AA_REF | ||
STOCK_TYPE | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
TRADABLE | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
BPARTNER | Partner with Whom Commitment Exists | FTI_LDB_RISK_COUNTERPARTY | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
BPARTNER_NAME | Name and address of business partner | TB_XKONTRH | CHAR | 80 | TEXT80 | ||||
BPARTNER_ROLE | Character field of length 6 | CHAR6 | CHAR | 6 | CHAR6 | ||||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | Assigned to domain | BU_LEGAL_ORG | |||
COUNTRY | Nationality | BU_NATIO | CHAR | 3 | Assigned to domain | LAND1 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | Assigned to domain | BU_INDSECT | H_TB023 | ||
CONSOLIDATION | Balance Sheet Display | BP_BAL_FLG | CHAR | 1 | BP_BAL_FLG | ||||
MAT_TERM_BEGIN | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
MAT_TERM_END | End of Loan Term | DENDLFZ | DATS | 8 | DATUM | ||||
MARKET_PRICE_DATE | Rate/Price Date | DKURS | DATS | 8 | DATUM | ||||
MARKET_PRICE_TYPE | Security Price Type | VVSKURSART | CHAR | 2 | Assigned to domain | VVSKURSART | |||
MARKET_PLACE | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
MARKET_RATE | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
MARKET_VALUE | Market Value in Mkt Curr. | FTI_MARKET_MC | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 21(2) | TPM_AMOUNT | ||||
MARKET_VALUE_VAL | Market Value (SE Only) in Valuation Currency | FTI_MARKET_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AVERAGE_RATE_ACQU | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
AVERAGE_RATE_BOOK | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
AVERAGE_RATE_QUOT | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
AVERAGE_RATE_ACQU_VAL | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
AVERAGE_RATE_BOOK_VAL | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
FX_BOOK_EXCHANGE_RATE | Book Exchange Rate | TPM_FX_BOOK_EXCHANGE_RATE | DEC | 9(5) | EXCRT | UKURS | |||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | TPM_ACTIVE_PASSIVE | CHAR | 1 | TPM_ACTIVE_PASSIVE | ||||
MARKET_CURR | Position Currency | TPM_POSITION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
POS_ATTRIB_S1 | Short Position Attribute | TPM_POS_ATTRIB_SHORT | CHAR | 4 | TRLTC_ATTRVAL_S | CHAR4 | |||
POS_ATTRIB_S2 | Short Position Attribute | TPM_POS_ATTRIB_SHORT | CHAR | 4 | TRLTC_ATTRVAL_S | CHAR4 | |||
POS_ATTRIB_S3 | Short Position Attribute | TPM_POS_ATTRIB_SHORT | CHAR | 4 | TRLTC_ATTRVAL_S | CHAR4 | |||
POS_ATTRIB_M1 | Medium Position Attribute | TPM_POS_ATTRIB_MEDIUM | CHAR | 10 | TRLTC_ATTRVAL_M | CHAR10 | |||
POS_ATTRIB_M2 | Medium Position Attribute | TPM_POS_ATTRIB_MEDIUM | CHAR | 10 | TRLTC_ATTRVAL_M | CHAR10 | |||
POS_ATTRIB_M3 | Medium Position Attribute | TPM_POS_ATTRIB_MEDIUM | CHAR | 10 | TRLTC_ATTRVAL_M | CHAR10 | |||
POS_ATTRIB_L1 | Long Position Attribute | TPM_POS_ATTRIB_LONG | CHAR | 30 | CHAR30 | ||||
POS_ATTRIB_L2 | Long Position Attribute | TPM_POS_ATTRIB_LONG | CHAR | 30 | CHAR30 | ||||
POS_ATTRIB_L3 | Long Position Attribute | TPM_POS_ATTRIB_LONG | CHAR | 30 | CHAR30 | ||||
RMAID | Master Agreement | TB_RMAID | CHAR | 10 | Assigned to domain | ALPHA | T_RMAID | TMA | VTMA |
POS_ATTRIB_S1_TXT | Description | TPM_DESCRIPTION30 | CHAR | 30 | TPM_DESCRIPTION30 | ||||
POS_ATTRIB_S2_TXT | Description | TPM_DESCRIPTION30 | CHAR | 30 | TPM_DESCRIPTION30 | ||||
POS_ATTRIB_S3_TXT | Description | TPM_DESCRIPTION30 | CHAR | 30 | TPM_DESCRIPTION30 | ||||
POS_ATTRIB_M1_TXT | Description | TPM_DESCRIPTION30 | CHAR | 30 | TPM_DESCRIPTION30 | ||||
POS_ATTRIB_M2_TXT | Description | TPM_DESCRIPTION30 | CHAR | 30 | TPM_DESCRIPTION30 | ||||
POS_ATTRIB_M3_TXT | Description | TPM_DESCRIPTION30 | CHAR | 30 | TPM_DESCRIPTION30 | ||||
TRL_POSITION_STATUS_T | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
VALUATION_AREA_T | Name of the Valuation Area | TPM_VAL_AREA_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
VALUATION_CLASS_T | Description of valuation class | TPM_VAL_CLASS_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
ACCOUNTING_CODE_T | Name of Accounting Code | TPM_TR_ACC_CODE_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
SECURITY_ID_T | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
SECURITY_ID_TL | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ACCOUNT_GROUP_T | Name of Securities Account Group | TPM_SEC_ACCT_GRP_NAME | CHAR | 60 | TPM_DESCRIPTION | ||||
LOANS_CONTRACT_T | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
FLAG_LONG_SHORT_T | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
AMORT_PROC_T | Name of Procedure for a Step | TPM_STEP_PROCEDURE_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
GSART_T | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
SFHAART_T | Name of Transaction Type | TB_FATEXT | CHAR | 30 | T_XTEXT30 | ||||
POS_MAN_PROC_T | Position Management Procedure Text | TPM_POS_MAN_PROC_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
ACC_ASS_REFERENCE_T | Name of Account Assignment Reference | TPM_ACC_ASS_REF_TEXT | CHAR | 60 | TPM_DESCRIPTION | ||||
STOCK_TYPE_T | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
LEGAL_ORG_T | Char 15 | CHAR15 | CHAR | 15 | CHAR15 | ||||
COUNTRY_T | Char 15 | CHAR15 | CHAR | 15 | CHAR15 | ||||
IND_SECTOR_T | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
CONSOLIDATION_T | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
EXTACC_DEAL | External Account (Transaction) | TPM_EXT_ACCOUNT_DEAL | CHAR | 10 | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT |
Key field | Non-key field |
How do I retrieve data from SAP structure TRLS_POSITION_VALUE_ATTR_TXT using ABAP code?
As TRLS_POSITION_VALUE_ATTR_TXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TRLS_POSITION_VALUE_ATTR_TXT as there is no data to select.How to access SAP table TRLS_POSITION_VALUE_ATTR_TXT
Within an ECC or HANA version of SAP you can also view further information about TRLS_POSITION_VALUE_ATTR_TXT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects