ROXALN0067 SAP (Structure for Position Currency Upload of Market Data) Structure details

Dictionary Type: Structure
Description: Structure for Position Currency Upload of Market Data




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




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

ROXALN0067 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 for Position Currency Upload of Market Data" 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_ROXALN0067 TYPE ROXALN0067.

The ROXALN0067 table consists of various fields, each holding specific information or linking keys about Structure for Position Currency Upload of Market Data 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: Can be enhanced (character-type or numeric)


SAP ROXALN0067 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 as Differentiation Characteristic TPM_PORTFOLIO_DIFFCHAR10Assigned to domainRPORTB
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
FLAG_LONG_SHORTIndicator: Long or Short Position TPM_FLAG_LONG_SHORTCHAR1TPM_FLAG_LONG_SHORT
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
LOTPOS_INIT_DATEPosition Acquisition Date of a Lot FTI_LOTPOSITION_INIT_DATEDATS8TPM_POSITION_DATE
LOTPOS_ORG_DATEOriginal Position Acquisition Date of a Lot FTI_LOTPOSITION_ORG_DATEDATS8TPM_POSITION_DATE
LOTGEN_DEALNRLot-Generating Transaction Number (Listed Derivatives) FTI_LOTGENERATION_DEALNRCHAR13Assigned to domainALPHAT_RFHAF4_TRANS_NO
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_DISAGIO_PCCleared PD Def./Tax Compensation in Pos. Crcy: Simulation FTI_S_DISAGIO_PCCURR21(2) TPM_AMOUNT
SBWHR004Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_DISAGIO_LCCleared PD Def./Tax Compensation in Local Crcy: Simulation FTI_S_DISAGIO_LCCURR21(2) TPM_AMOUNT
SHWHRLocal Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_DISAGIO_VCCleared PD Def./Tax Compensation in Val. Crcy: Simulation FTI_S_DISAGIO_VCCURR21(2) TPM_AMOUNT
SVWHRValuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_TI_PCSecurity Valuation in Position Currency (Simulation) FTI_S_VAL_TI_PCCURR21(2) TPM_AMOUNT
SBWHR005Position 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
SHWHR011Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_TI_VCSecurity Valuation in Valuation Currency (Simulation) FTI_S_VAL_TI_VCCURR21(2) TPM_AMOUNT
SVWHR024Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_VAL_FX_LCForeign Currency Valuation in Local Currency (Simulation) FTI_S_VAL_FX_LCCURR21(2) TPM_AMOUNT
SHWHR012Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_VAL_FX_VCForeign Currency Valuation in Valuation Crcy (Simulation) FTI_S_VAL_FX_VCCURR21(2) TPM_AMOUNT
SVWHR025Valuation 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
SBWHR006Position 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
SHWHR013Local 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
SVWHR026Valuation 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
SHWHR014Local 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
SVWHR027Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_AMORT_PCAmortization in Position Currency (Simulation) FTI_S_AMORT_PCCURR21(2) TPM_AMOUNT
SBWHR007Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_AMORT_LCAmortization in Local Currency (Simulation) FTI_S_AMORT_LCCURR21(2) TPM_AMOUNT
SHWHR015Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_AMORT_VCAmortization in Valuation Currency (Simulation) FTI_S_AMORT_VCCURR21(2) TPM_AMOUNT
SVWHR028Valuation 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
SBWHR008Position 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
SHWHR016Local 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
SVWHR029Valuation 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
SHWHR017Local 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
SVWHR030Valuation 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
SBWHR009Position 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
SHWHR018Local 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
SVWHR031Valuation 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
SHWHR019Local 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
SVWHR032Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SPOTVALP_LCSpot Valuation, Purchase Currency, in Local Crcy: Simulation FTI_S_SPOTVALP_LCCURR21(2) TPM_AMOUNT
SHWHR020Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SPOTVALP_VCSpot Valuation, Purchase Currency, in Val. Crcy: Simulation FTI_S_SPOTVALP_VCCURR21(2) TPM_AMOUNT
SVWHR033Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SPOTVALS_LCSpot Valuation, Sale Currency, in Local Crcy: Simulation FTI_S_SPOTVALS_LCCURR21(2) TPM_AMOUNT
SHWHR021Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SPOTVALS_VCSpot Valuation, Sale Currency, in Valuation Crcy: Simulation FTI_S_SPOTVALS_VCCURR21(2) TPM_AMOUNT
SVWHR034Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SWAPACC_PCSwap/Margin Accrual/Deferral in Position Crcy (Simulation) FTI_S_SWAPACC_PCCURR21(2) TPM_AMOUNT
SBWHR010Position Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
S_SWAPACC_LCSwap/Margin Accrual/Deferral in Local Currency: Simulation FTI_S_SWAPACC_LCCURR21(2) TPM_AMOUNT
SHWHR022Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SWAPACC_VCSwap/Margin Accrual/Deferral in Valuation Crcy: Simulation FTI_S_SWAPACC_VCCURR21(2) TPM_AMOUNT
SVWHR035Valuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
S_SWAPVAL_LCSwap Valuation in Local Currency: Simulation FTI_S_SWAPVAL_LCCURR21(2) TPM_AMOUNT
SHWHR023Local Currency TB_SHWHRCUKY5Assigned to domainWAERS
S_SWAPVAL_VCSwap Valuation in Valuation Currency: Simulation FTI_S_SWAPVAL_VCCURR21(2) TPM_AMOUNT
SVWHR036Valuation 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
PARAM_P_ANZGWDisplay Currency FTI_ANZGWCUKY5Assigned to domainWAERSFFZ
PARAM_P_AUSWTEvaluation Type (Risk Management) FTI_EVALTYPECHAR4Assigned to domainJBREVALFTI_EVALTYPE
PARAM_P_DATSystem Date SYDATUMDATS8SYDATS
PARAM_P_HISTKRIndicator: Historical Account Assignment Reference FTI_LDB_FLG_HISTORIC_ACCASSREFCHAR1XFELDFTI_FLG_HISTKR
PARAM_P_KURSAPrice type for evaluations VVKURSAUSWCHAR2Assigned to domainVVSKURSART
PARAM_P_LOGSAVSave Application Log (CFM)? - Yes/No FTI_FLG_BALLOG_DB_SAVE_CFMCHAR1XFELDFTI_FLG_LOF
PARAM_P_RSTICHKey date reference RSTICHCHAR1RSTICH
PARAM_P_RST_PBKey Date Reference for Parallel Books FTI_RSTICH_PBCHAR1RSTICH_PB
PARAM_P_SACCCPInterpret Assignment of Sec. Account to Sec. Account Group FTI_LDB_FLG_COUPLING_SECACCGRPCHAR1XFELDFTI_FLG_SECACCGRP
SELECT_S_ACCGRPSecurities Account Group TPM_SEC_ACCT_GRPCHAR10Assigned to domainTPM_SEC_ACCT_GRPTPM_SHPL_SEC_ACC_GRP
SELECT_S_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SELECT_S_GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SELECT_S_PERIODKey date VVSTDATDATS8VVSTDATKEYDATE
SELECT_S_POSACCFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
SELECT_S_RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SELECT_S_RANLOFSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SELECT_S_RANLSESecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SELECT_S_RANLVDContract Number RANLCHAR13ALPHARANLRAN
SELECT_S_RFHAPosition-Generating Financial Transaction FTI_POSRFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
SELECT_S_RLDEPOSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
SELECT_S_RPORTBPortfolio as Differentiation Characteristic TPM_PORTFOLIO_DIFFCHAR10Assigned to domainRPORTB
SELECT_S_TRACAccounting Code TPM_ACC_CODECHAR4Assigned to domainTPM_ACC_CODETPM_TACTRG_ACC_CODE
SELECT_S_VALCLSValuation Class TPM_VAL_CLASSNUMC4Assigned to domainTPM_VAL_CLASS
SELECT_S_VLAREAValuation Area TPM_VAL_AREACHAR3Assigned to domainTPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
PARAM_P_CALCCYEvaluation Currency AFW_EVAL_CURRENCYCUKY5Assigned to domainWAERS
PARAM_P_CDENSESummarize Results (for Query) FTI_CONDENSECHAR1XFELDFTI_CONDENSE_ID
PARAM_P_EXPLANExclude Plan Data (for Query) FTI_EXCL_PLANCHAR1XFELDFTI_CONDENSE_ID
PARAM_P_ISTYPEIndustry System BU_ISTYPECHAR4Assigned to domainBU_ISTYPE
PARAM_P_LCYINTInterpret. Leading/Following Currency for Exchange Transact. FTI_LEAD_FOLLOW_CCY_LOGICCHAR1XFELDFTI_CONDENSE_ID
PARAM_P_NONULLHide Zero Records FTI_NO_NULLCHAR1XFELDFTI_NO_NULL_ID
SELECT_S_PARTNRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
SELECT_S_POSCCYPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
PARAM_P_KURSBRate Calculation FTI_RKURSBERCHAR2Assigned to domainRKURSBERH_KURSBER
PARAM_P_MARKETControl Risk Mgmt Buffer for Logical Database Reporting FTI_MARKETDATA_BUFFER_CTRLCHAR1FTI_MARKETDATA_BUFFER_CTRL
PARAM_P_NOFLOWIndicator: Only Positions With Flows in Selection Period FTI_FLG_ONLY_POS_WITH_FLOWSCHAR1XFELD
PARAM_P_REVFLWProcess Reversed Flows (for Query) FTI_REVERSED_FLOWSCHAR1XFELDFTI_CONDENSE_ID
SELECT_S_FINPROFinance Project TB_TFPROJCHAR13T_TFPROJ
SELECT_S_MERKMCharacteristics TB_MERKMCHAR25CHAR25
SELECT_S_PORTTMPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
SELECT_S_REFERInternal Reference TB_REFERCHAR16CHAR16
SELECT_S_RMAIDMaster Agreement TB_RMAIDCHAR10Assigned to domainALPHAT_RMAIDTMAVTMA
SELECT_S_SFHARTFinancial Transaction Type TB_SFHAARTCHAR3Assigned to domainT_SFHAARTT02C_AT10
SELECT_S_ZUONDAssignment TB_ZUONDCHAR18TEXT18
PARAM_P_CFSIGNIndicator: Plus/Minus Sign for Payment Amount FTI_LDB_FLG_CF_SIGNCHAR1XFELD
PARAM_P_GRDMTHValuation Procedure FTI_BP_GRADE_METHODCHAR10Assigned to domainBP_GRADE_METHOD
SELECT_S_ACCTYPSecurities Account Type TPM_SECACC_TYPECHAR3Assigned to domainTPM_SECACC_TYPE
SELECT_S_FUNDCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SELECT_S_GRANTCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001

Key field Non-key field



How do I retrieve data from SAP structure ROXALN0067 using ABAP code?

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

How to access SAP table ROXALN0067

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