ROXPLN0002 SAP (ROXPLN0002) Structure details

Dictionary Type: Structure
Description: ROXPLN0002




ABAP Code to SELECT data from ROXPLN0002
Related tables to ROXPLN0002
Access table ROXPLN0002




Structure field list including key, data, relationships and ABAP select examples

ROXPLN0002 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 "ROXPLN0002" 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_ROXPLN0002 TYPE ROXPLN0002.

The ROXPLN0002 table consists of various fields, each holding specific information or linking keys about ROXPLN0002 data available in SAP. These include TEXT_BW_CFM_VALU (Name of Company Code or Company), TR_ACC_CODE (Accounting Code), SPECNAME00000001 (Name of Accounting Code), VALUATION_AREA (Valuation Area).. 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 ROXPLN0002 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
TEXT_BW_CFM_VALUName of Company Code or Company BUTXTCHAR25TEXT25
TR_ACC_CODEAccounting Code TPM_ACC_CODECHAR4Assigned to domainTPM_ACC_CODETPM_TACTRG_ACC_CODE
SPECNAME00000001Name of Accounting Code TPM_TR_ACC_CODE_NAMECHAR60TPM_DESCRIPTION
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3Assigned to domainTPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
SPECNAME00000002Name of the Valuation Area TPM_VAL_AREA_NAMECHAR60TPM_DESCRIPTION
VALUATION_CLASSValuation Class TPM_VAL_CLASSNUMC4Assigned to domainTPM_VAL_CLASS
SPECNAME00000003Description of valuation class TPM_VAL_CLASS_NAMECHAR60TPM_DESCRIPTION
GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SPECNAME00000004Text (30 Characters) TEXT30CHAR30TEXT30
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
SPECNAME00000005Portfolio name VVXPORTBCHAR30TEXT30
SECURITY_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SPECNAME00000006Long name XALLBCHAR60XLBEZ
LOANS_CONTRACTContract Number RANLCHAR13ALPHARANLRAN
SPECNAME00000007Long name XALLBCHAR60XLBEZ
DEAL_NUMBERPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SPECNAME00000008Assignment TB_ZUONDCHAR18TEXT18
ACCOUNT_GROUPSecurities Account Group TPM_SEC_ACCT_GRPCHAR10Assigned to domainTPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRP
SPECNAME00000009Name of Securities Account Group TPM_SEC_ACCT_GRP_NAMECHAR60TPM_DESCRIPTION
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
SPECNAME00000010Securities account ID XLDEPOCHAR30XLDEPO
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
SPECNAME00000011Futures Account Text TPM_POS_ACC_FUT_TEXTCHAR30TPM_POS_ACC_FUT_TEXT
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
SPECNAME00000012Name of Business Transaction Category TPM_BUSTRANSCAT_TEXTCHAR60TPM_DESCRIPTION
STICHTAGKey date VVSTDATDATS8VVSTDATKEYDATE
SPECNAME00000013Long Text LTEXTCHAR40TEXT40
SPECNAME00000014Long Text LTEXTCHAR40TEXT40
SPECNAME00000015Long Text LTEXTCHAR40TEXT40
PEFFZINSEffective Interest Rate FTI_EFFZINSDEC10(7) DEC3_7
SPECNAME00000016Long Text LTEXTCHAR40TEXT40
SPECNAME00000017Long Text LTEXTCHAR40TEXT40
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 ROXPLN0002 using ABAP code?

As ROXPLN0002 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 ROXPLN0002 as there is no data to select.

How to access SAP table ROXPLN0002

Within an ECC or HANA version of SAP you can also view further information about ROXPLN0002 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!