ROXPLN0003 SAP (ROXPLN0003) Structure details

Dictionary Type: Structure
Description: ROXPLN0003




ABAP Code to SELECT data from ROXPLN0003
Related tables to ROXPLN0003
Access table 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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
TR_ACC_CODEAccounting Code TPM_ACC_CODECHAR4Assigned to domainTPM_ACC_CODETPM_TACTRG_ACC_CODE
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3Assigned to domainTPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
VALUATION_CLASSValuation Class TPM_VAL_CLASSNUMC4Assigned to domainTPM_VAL_CLASS
GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
SECURITY_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
LOANS_CONTRACTContract Number RANLCHAR13ALPHARANLRAN
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
ACCOUNT_GROUPSecurities Account Group TPM_SEC_ACCT_GRPCHAR10Assigned to domainTPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRP
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
LOT_IDIdentifier of the Lot TPM_LOT_IDRAW16SYSUUID
DLOTGENERATIONDate On Which Lot Was Generated DLOTGENERATIONDATS8DATUM
TLOTGENERATIONLot Generation Time TLOTGENERATIONTIMS6UZEIT
LOTGENERATION_USLot Entered By FTI_LOTGENERATIONUSERCHAR12SYCHAR12
LOTGENERATION_CTBusiness Transaction Category Which Generated the Lot FTI_LOTGENERATION_BUSTRANSCATNUMC4Assigned to domainTPM_BUSTRANSCAT
STICHTAGKey date VVSTDATDATS8VVSTDATKEYDATE
PEFFZINSEffective Interest Rate FTI_EFFZINSDEC10(7) DEC3_7
NOMINAL_AMT_O_PCNominal Value, Outgoing Side, in Position Crcy (Outg. Side) FTI_NOMINAL_OUT_PCOUTCURR21(2) TPM_AMOUNT
WVERB1Nominal currency borrowing/sale/outgoing side/short FTI_WHR_SHORTCUKY5Assigned to domainWAERS
NOMINAL_AMT_I_PCNominal Value, Incoming Side, in Position Crcy (Inc. Side) FTI_NOMINAL_IN_PCINCURR21(2) TPM_AMOUNT
WFORD1Nominal currency investment/purchase incoming side/long FTI_WHR_LONGCUKY5Assigned to domainWAERS
MARKET_PCMarket Value in Position Currency FTI_MARKET_PCCURR21(2) TPM_AMOUNT
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
NPV_PCRM Net Present Value in Position Currency TV_NPV_PCCURR15(2) WERTV8_TR
SBWHR001Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
CLEAN_PRICE_PCClean Price in Position Currency TV_CLEAN_PRICE_PCCURR17(2) T_PRESVAL
SBWHR002Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
BPVALUE_PCBasis Point Value in Position Currency TV_VALBP_PCCURR17(2) T_PRESVAL
SBWHR003Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
MAC_DURATIONMacaulay Duration TV_MAC_DURATIONDEC12(3) DEC9_3SIGN
MOD_DURATIONFisher/Weil Duration TV_FISHER_WEIL_DURATIONDEC12(3) DEC9_3SIGN
S_VAL_TI_PCSecurity Valuation in Position Currency (Simulation) FTI_S_VAL_TI_PCCURR21(2) TPM_AMOUNT
SBWHR004Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_VAL_TI_LCSecurity Valuation in Local Currency (Simulation) FTI_S_VAL_TI_LCCURR21(2) TPM_AMOUNT
SHWHRLocal Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_TI_VCSecurity Valuation in Valuation Currency (Simulation) FTI_S_VAL_TI_VCCURR21(2) TPM_AMOUNT
SVWHRValuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_FX_LCForeign Currency Valuation in Local Currency (Simulation) FTI_S_VAL_FX_LCCURR21(2) TPM_AMOUNT
SHWHR001Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_FX_VCForeign Currency Valuation in Valuation Crcy (Simulation) FTI_S_VAL_FX_VCCURR21(2) TPM_AMOUNT
SVWHR001Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_CH_TI_PCValuation of Capitalized Costs, Sec., in Pos. Crcy (Simul.) FTI_S_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
SBWHR005Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_VAL_CH_TI_LCValuation of Capitalized Costs, Sec., in Local Crcy (Simul.) FTI_S_VAL_CH_TI_LCCURR21(2) TPM_AMOUNT
SHWHR002Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_CH_TI_VCValuation of Capitalized Costs, Sec., in Val. Crcy (Simul.) FTI_S_VAL_CH_TI_VCCURR21(2) TPM_AMOUNT
SVWHR002Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_CH_FX_LCValuation of Capitalized Costs, FX, in Local Crcy (Simul.) FTI_S_VAL_CH_FX_LCCURR21(2) TPM_AMOUNT
SHWHR003Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_CH_FX_VCValuation of Capitalized Costs, FX, in Val. Crcy (Simul.) FTI_S_VAL_CH_FX_VCCURR21(2) TPM_AMOUNT
SVWHR003Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_AMORT_PCAmortization in Position Currency (Simulation) FTI_S_AMORT_PCCURR21(2) TPM_AMOUNT
SBWHR006Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_AMORT_LCAmortization in Local Currency (Simulation) FTI_S_AMORT_LCCURR21(2) TPM_AMOUNT
SHWHR004Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_AMORT_VCAmortization in Valuation Currency (Simulation) FTI_S_AMORT_VCCURR21(2) TPM_AMOUNT
SVWHR004Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_TI_NPL_PCSecurity Valuation, Not Affecting P/L, in PC (Simulation) FTI_S_VAL_TI_NPL_PCCURR21(2) TPM_AMOUNT
SBWHR007Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_VAL_TI_NPL_LCSecurity Valuation, Not Affecting P/L, in LC (Simulation) FTI_S_VAL_TI_NPL_LCCURR21(2) TPM_AMOUNT
SHWHR005Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_TI_NPL_VCSecurity Valuation, Not Affecting P/L, in VC (Simulation) FTI_S_VAL_TI_NPL_VCCURR21(2) TPM_AMOUNT
SVWHR005Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_FX_NPL_LCForeign Currency Valuation, Not Aff. P/L, in LC (Simulation) FTI_S_VAL_FX_NPL_LCCURR21(2) TPM_AMOUNT
SHWHR006Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_FX_NPL_VCForeign Currency Valuation, Not Aff. P/L, in VC (Simulation) FTI_S_VAL_FX_NPL_VCCURR21(2) TPM_AMOUNT
SVWHR006Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_CH_TI_N_PCValuation of Cap. Costs, Sec., Not Aff. P/L, in PC (Sim.) FTI_S_VAL_CH_TI_NPL_PCCURR21(2) TPM_AMOUNT
SBWHR008Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_VAL_CH_TI_N_LCValuation of Cap. Costs, Sec., Not Aff. P/L, in LC (Sim.) FTI_S_VAL_CH_TI_NPL_LCCURR21(2) TPM_AMOUNT
SHWHR007Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_CH_TI_N_VCValuation of Cap. Costs, Sec., Not Aff. P/L, in VC (Sim.) FTI_S_VAL_CH_TI_NPL_VCCURR21(2) TPM_AMOUNT
SVWHR007Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_CH_FX_N_LCValuation of Cap. Costs, FX, Not Affecting P/L, in LC (Sim.) FTI_S_VAL_CH_FX_NPL_LCCURR21(2) TPM_AMOUNT
SHWHR008Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_CH_FX_N_VCValuation of Cap. Costs, FX, Not Affecting P/L, in VC (Sim.) FTI_S_VAL_CH_FX_NPL_VCCURR21(2) TPM_AMOUNT
SVWHR008Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SPOTVALP_LCSpot Valuation, Purchase Currency, in Local Crcy: Simulation FTI_S_SPOTVALP_LCCURR21(2) TPM_AMOUNT
SHWHR009Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SPOTVALP_VCSpot Valuation, Purchase Currency, in Val. Crcy: Simulation FTI_S_SPOTVALP_VCCURR21(2) TPM_AMOUNT
SVWHR009Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SPOTVALS_LCSpot Valuation, Sale Currency, in Local Crcy: Simulation FTI_S_SPOTVALS_LCCURR21(2) TPM_AMOUNT
SHWHR010Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SPOTVALS_VCSpot Valuation, Sale Currency, in Valuation Crcy: Simulation FTI_S_SPOTVALS_VCCURR21(2) TPM_AMOUNT
SVWHR010Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SWAPACC_LCSwap/Margin Accrual/Deferral in Local Currency: Simulation FTI_S_SWAPACC_LCCURR21(2) TPM_AMOUNT
SHWHR011Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SWAPACC_VCSwap/Margin Accrual/Deferral in Valuation Crcy: Simulation FTI_S_SWAPACC_VCCURR21(2) TPM_AMOUNT
SVWHR011Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SWAPVAL_LCSwap Valuation in Local Currency: Simulation FTI_S_SWAPVAL_LCCURR21(2) TPM_AMOUNT
SHWHR012Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SWAPVAL_VCSwap Valuation in Valuation Currency: Simulation FTI_S_SWAPVAL_VCCURR21(2) TPM_AMOUNT
SVWHR012Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VALID_DATEDate of Found Rate or Present Value TPM_VALID_DATEDATS8DATS
S_VALID_RATE_DATDate of Exchange Rate Found TPM_VALID_RATE_DATEDATS8DATS
S_MAPMarket Price TPM_MAPDEC15(6) VVPKTKUR
S_MAR_FEExchange Rate - Position/Valuation Currency on Market TPM_MAR_FEDEC9(5) EXCRTUKURS
S_SPOT_RATE_PSpot Rate Purchase Currency/Valuation Currency in the Market TPM_SPOT_RATE_PDEC9(5) EXCRTUKURS
S_SPOT_RATE_SSpot Rate Sales Currency/Valuation Currency in the Market TPM_SPOT_RATE_SDEC9(5) EXCRTUKURS
S_SWAP_RATE_PSwap Rate Purchase Currency/Valuation Currency in the Market TPM_SWAP_RATE_PDEC9(5) TB_DEVSWSA
S_SWAP_RATE_SSwap Rate Sales Currency/Valuation Currency in the Market TPM_SWAP_RATE_SDEC9(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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!