ROXPLN0003 SAP (ROXPLN0003) Structure details
Description: ROXPLN0003
Structure field list including key, data, relationships and ABAP select examples
ROXPLN0003 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 "ROXPLN0003" 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_ROXPLN0003 TYPE ROXPLN0003.
The ROXPLN0003 table consists of various fields, each holding specific information or linking keys about ROXPLN0003 data available in SAP. These include TR_ACC_CODE (Accounting Code), VALUATION_AREA (Valuation Area), VALUATION_CLASS (Valuation Class), GSART (Product Type).. 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: Cannot Be Enhanced
SAP ROXPLN0003 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 |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
TR_ACC_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | Assigned to domain | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | Assigned to domain | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | Assigned to domain | TPM_VAL_CLASS | |||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | Assigned to domain | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
SECURITY_ACCOUNT | Securities Account | RLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ACC_CCD_CORE | |
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 | |
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_US | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_CT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | Assigned to domain | TPM_BUSTRANSCAT | |||
STICHTAG | Key date | VVSTDAT | DATS | 8 | VVSTDAT | KEYDATE | |||
PEFFZINS | Effective Interest Rate | FTI_EFFZINS | DEC | 10(7) | DEC3_7 | ||||
NOMINAL_AMT_O_PC | Nominal Value, Outgoing Side, in Position Crcy (Outg. Side) | FTI_NOMINAL_OUT_PCOUT | CURR | 21(2) | TPM_AMOUNT | ||||
WVERB1 | Nominal currency borrowing/sale/outgoing side/short | FTI_WHR_SHORT | CUKY | 5 | Assigned to domain | WAERS | |||
NOMINAL_AMT_I_PC | Nominal Value, Incoming Side, in Position Crcy (Inc. Side) | FTI_NOMINAL_IN_PCIN | CURR | 21(2) | TPM_AMOUNT | ||||
WFORD1 | Nominal currency investment/purchase incoming side/long | FTI_WHR_LONG | CUKY | 5 | Assigned to domain | WAERS | |||
MARKET_PC | Market Value in Position Currency | FTI_MARKET_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
SBWHR001 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
CLEAN_PRICE_PC | Clean Price in Position Currency | TV_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
SBWHR002 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BPVALUE_PC | Basis Point Value in Position Currency | TV_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
SBWHR003 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
MAC_DURATION | Macaulay Duration | TV_MAC_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
MOD_DURATION | Fisher/Weil Duration | TV_FISHER_WEIL_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
S_VAL_TI_PC | Security Valuation in Position Currency (Simulation) | FTI_S_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR004 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_TI_LC | Security Valuation in Local Currency (Simulation) | FTI_S_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_TI_VC | Security Valuation in Valuation Currency (Simulation) | FTI_S_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_FX_LC | Foreign Currency Valuation in Local Currency (Simulation) | FTI_S_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR001 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_FX_VC | Foreign Currency Valuation in Valuation Crcy (Simulation) | FTI_S_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR001 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_TI_PC | Valuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.) | FTI_S_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR005 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_TI_LC | Valuation of Capitalized Costs, Sec., in Local Crcy (Simul.) | FTI_S_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR002 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_TI_VC | Valuation of Capitalized Costs, Sec., in Val. Crcy (Simul.) | FTI_S_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR002 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_FX_LC | Valuation of Capitalized Costs, FX, in Local Crcy (Simul.) | FTI_S_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR003 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Val. Crcy (Simul.) | FTI_S_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR003 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_AMORT_PC | Amortization in Position Currency (Simulation) | FTI_S_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR006 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_AMORT_LC | Amortization in Local Currency (Simulation) | FTI_S_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR004 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_AMORT_VC | Amortization in Valuation Currency (Simulation) | FTI_S_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR004 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_TI_NPL_PC | Security Valuation, Not Affecting P/L, in PC (Simulation) | FTI_S_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR007 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_TI_NPL_LC | Security Valuation, Not Affecting P/L, in LC (Simulation) | FTI_S_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR005 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_TI_NPL_VC | Security Valuation, Not Affecting P/L, in VC (Simulation) | FTI_S_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR005 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_FX_NPL_LC | Foreign Currency Valuation, Not Aff. P/L, in LC (Simulation) | FTI_S_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR006 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_FX_NPL_VC | Foreign Currency Valuation, Not Aff. P/L, in VC (Simulation) | FTI_S_VAL_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR006 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_TI_N_PC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.) | FTI_S_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
SBWHR008 | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_TI_N_LC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.) | FTI_S_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR007 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_TI_N_VC | Valuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.) | FTI_S_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR007 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_FX_N_LC | Valuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.) | FTI_S_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR008 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VAL_CH_FX_N_VC | Valuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.) | FTI_S_VAL_CH_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR008 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SPOTVALP_LC | Spot Valuation, Purchase Currency, in Local Crcy: Simulation | FTI_S_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR009 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SPOTVALP_VC | Spot Valuation, Purchase Currency, in Val. Crcy: Simulation | FTI_S_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR009 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SPOTVALS_LC | Spot Valuation, Sale Currency, in Local Crcy: Simulation | FTI_S_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR010 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SPOTVALS_VC | Spot Valuation, Sale Currency, in Valuation Crcy: Simulation | FTI_S_SPOTVALS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR010 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SWAPACC_LC | Swap/Margin Accrual/Deferral in Local Currency: Simulation | FTI_S_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR011 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SWAPACC_VC | Swap/Margin Accrual/Deferral in Valuation Crcy: Simulation | FTI_S_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR011 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SWAPVAL_LC | Swap Valuation in Local Currency: Simulation | FTI_S_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
SHWHR012 | Local Currency | TB_SHWHR | CUKY | 5 | Assigned to domain | WAERS | |||
S_SWAPVAL_VC | Swap Valuation in Valuation Currency: Simulation | FTI_S_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
SVWHR012 | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
S_VALID_DATE | Date of Found Rate or Present Value | TPM_VALID_DATE | DATS | 8 | DATS | ||||
S_VALID_RATE_DAT | Date of Exchange Rate Found | TPM_VALID_RATE_DATE | DATS | 8 | DATS | ||||
S_MAP | Market Price | TPM_MAP | DEC | 15(6) | VVPKTKUR | ||||
S_MAR_FE | Exchange Rate - Position/Valuation Currency on Market | TPM_MAR_FE | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_P | Spot Rate Purchase Currency/Valuation Currency in the Market | TPM_SPOT_RATE_P | DEC | 9(5) | EXCRT | UKURS | |||
S_SPOT_RATE_S | Spot Rate Sales Currency/Valuation Currency in the Market | TPM_SPOT_RATE_S | DEC | 9(5) | EXCRT | UKURS | |||
S_SWAP_RATE_P | Swap Rate Purchase Currency/Valuation Currency in the Market | TPM_SWAP_RATE_P | DEC | 9(5) | TB_DEVSWSA | ||||
S_SWAP_RATE_S | Swap Rate Sales Currency/Valuation Currency in the Market | TPM_SWAP_RATE_S | DEC | 9(5) | TB_DEVSWSA |
Key field | Non-key field |
How do I retrieve data from SAP structure ROXPLN0003 using ABAP code?
As ROXPLN0003 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 ROXPLN0003 as there is no data to select.How to access SAP table ROXPLN0003
Within an ECC or HANA version of SAP you can also view further information about ROXPLN0003 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