SAP ATRMO Valuation control Table data and field list

ATRMO is a standard SAP Table which is used to store Valuation control data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ATRMO table consists of various fields, each holding specific information or linking keys about Valuation control data available in SAP. These include RMBEWREG (Valuation Rule), AUSWT (Evaluation type in Risk Management), KURSTG (Exchange rate type bid), KURSTB (Exchange rate type ask)... 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. .

ATRMO table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ATRMO table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ATRMO table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
RMBEWREGValuation Rule JBRBEWREG_CHAR8JBRBEWREGJBRBEWREG
AUSWTEvaluation type in Risk Management TV_AUSWTCHAR4JBREVALJBREVAL
KURSTGExchange rate type bid TB_KURSTGCHAR4TCURVKURST
KURSTBExchange rate type ask TB_KURSTBCHAR4TCURVKURST
BCURVEBid valuation curve type for mark-to-market TB_BCURVENUMC4JBD14JBSZKART
BCURVEBAsk Valuation Curve: Mark-to-Market TB_BCURVEBNUMC4JBD14JBSZKART
WPKURSARTSecurity price type for evaluations TB_WKURSACHAR2TW56VVSKURSART
IDXARTIndex Type IDXARTCHAR2INDEXACHAR2
DVOLARTGVolatility Type 'Bid Rates' for Foreign Exchange TB_VOLARTGCHAR3ATVO1T_VOLART
DVOLARTBVolatility Type 'Ask Rates' for Foreign Exchange TB_VOLARTBCHAR3ATVO1T_VOLART
ZVOLARTGVolatility Type 'Bid' for Interest Rates TB_ZVOLARGCHAR3ATVO1T_VOLART
ZVOLARTBVolatility Type 'Ask' for Interest Rates TB_ZVOLARBCHAR3ATVO1T_VOLART
WVOLARTGVolatility Type 'Bid' for Securities TB_WVOLARGCHAR3ATVO1T_VOLART
WVOLARTBVolatility Type 'Ask' for Securities TB_WVOLARBCHAR3ATVO1T_VOLART
IXVOLARTGVolatility Type for Security Indexes; Bid Rates TV_IXVOLGCHAR3ATVO1T_VOLART
IXVOLARTBVolatility Type for Security Indexes; Ask Rates TV_IXVOLBCHAR3ATVO1T_VOLART
HWVOLARTGVolatility Type for Yield Curve Model, Bid Rate TV_HWVOLAGCHAR3ATVO1T_VOLART
HWVOLARTBVolatility Type for Yield Curve Model, Ask Rate TV_HWVOLABCHAR3ATVO1T_VOLART
KORRARTG'Bid' Correlation Type TV_KORRARTGCHAR3ATKO1T_KORART
KORRARTB'Ask' Correlation Type TV_KORRARTBCHAR3ATKO1T_KORART
VNAMEVolatility Name TV_VNAMECHAR15ATVO0TV_VNAME
COVOLTYPBVolitility Type 'Bid' for Commodity Transactions TB_COVOTYPBCHAR3ATVO1T_VOLART
COVOLTYPAVolitility Type 'Ask' for Commodity Transactions TB_COVOTYPACHAR3ATVO1T_VOLART
COPRTYPECommodity Quotation Type TCR_CTY_QUOTTYPECHAR5TRCOCC_QUOTTYPETCR_CTY_QUOTTYPE
BCURVE_RFBid Valuation Curve : Risk Free TB_BCURVE_RFNUMC4JBD14JBSZKART
BCURVEB_RFAsk Valuation Curve : Risk Free TB_BCURVEB_RFNUMC4JBD14JBSZKART
BSP_CURVE_BBasis Spread Curve Type FTBB_YC_BSCTCHAR4FTBB_YCBSCURVEFTBB_YC_BSCT
BSP_CURVE_ABasis Spread Curve Type FTBB_YC_BSCTCHAR4FTBB_YCBSCURVEFTBB_YC_BSCT
KURSTMExchange rate type middle TB_KURSTMCHAR4TCURVKURST
BCURVEMMiddle valuation curve: Mark-to-market TB_BCURVEMNUMC4JBD14JBSZKART
DVOLARTMVolatility Type Middle Rates for Foreign Exchange TB_VOLARTMCHAR3ATVO1T_VOLART
ZVOLARTMVolatility Type Middle Rates for Interest TB_ZVOLARMCHAR3ATVO1T_VOLART
WVOLARTMVolatility Type Middle Rates for Securities TB_WVOLARMCHAR3ATVO1T_VOLART
IXVOLARTMVolatility Type for Security Indexes; Middle Rates TV_IXVOLMCHAR3ATVO1T_VOLART
HWVOLARTMVolatility Type for Yield Curve Model, Middle Rate TV_HWVOLAMCHAR3ATVO1T_VOLART
KORRARTM'Middle' Correlation Type TV_KORRARTMCHAR3ATKO1T_KORART
COVOLTYPMVolatility Type 'Middle Rate' for Commodities TB_COVOTYPMCHAR3ATVO1T_VOLART
BCURVEM_RFMiddle Valuation Curve : Risk Free TB_BCURVEM_RFNUMC4JBD14JBSZKART
BSP_CURVE_MBasis Spread Curve Type FTBB_YC_BSCTCHAR4FTBB_YCBSCURVEFTBB_YC_BSCT
XREAL_CASHFInclude Real Cash Flows TV_REAL_CFCHAR1XFELD
CALCVERFCalculation Routines TV_CALCVCHAR4ATVC1T_CALCV
WPPVARTCalculate Theoretical NPV TV_WPVARTCHAR1XFELD
WKTAGEMaximum age of historical price in days TV_WKTAGEDEC3TV_ALTER
SVOLARTVolatility Type for Convexity Adjustment TB_SVOLARTCHAR3ATVO1T_VOLART
XHOR_CASHFIs cash flow at horizon included in NPV? TV_XHOR_CFCHAR1XFELD
XINTOPTValue Swaptions as Interest Rate Options TV_XINTOPTCHAR1XFELD
XIMPLOPTBreak Down Implied Options TV_XIMPLOPTCHAR1XFELD
NAMEAUSDisbursement Procedure (Loan) JBRNAMEAUSCHAR10JBTAUSVERJBRNAMEAUS
SET_NAMERedemption Schedule Set RDPT_SET_NAMECHAR15Assigned to domainRDPT_SET_NAMERDPT_SET_NAMERDPT_F4_SET
STUECKZINSInclude the Horizon when Calculating Accrued Interest JBR_X_STUECKZINSCHAR1XFELD
FLG_ACCR_INTCalculate Accrued Interest JBR_FLG_ACCR_INTCHAR1FLAG
DISB_STARTStart of Disbursement Procedure JBR_DISB_STARTCHAR1JBR_DISB_START
DISB_CALCalendar for Disbursement Procedure JBR_DISB_CALCHAR2TFACDWFCID
VALUATION_MODELValuation Model for Financial Transactions JBR_VALUATION_MODELCHAR4JBR_VALUATION_MODEL
NUMBER_OF_STEPSDefault Number of Steps for Discretization Method JBR_NUMBER_OF_STEPSINT410
MAX_STEPLENGTHMaximum Permitted Time Step for Discretization Method JBR_MAXIMUM_STEPLENGTHDEC12(6)
PREPAYMENTPrepayment JBR_PREPAYMENTCHAR1JBR_PREPAYMENT
X_PREPAYMENTIndicator for Prepayment - Point Effect JBR_X_PREPAYMENTCHAR1XFELD
FLG_WITH_COMPENSSelect FX Offsetting Transactions JBR_FLG_WITH_COMPENSCHAR1FLAG
FLG_TERMINATED_DSelect Transaction on Day of Cancellation/Settlement JBR_FLG_TERMINATED_DEALCHAR1FLAG
COMAXAGEPRMaximum Age of Historical Commodity Price in Days JBRCOMAXAGEPRDEC3TV_ALTER
X_INTVALIntrinsic Value Indicator JBR_INT_VALCHAR1XFELD
COEXPVALTYPCommodity Exposure - NPV Valuation Type TV_COEXPVALTYPNUMC1TV_COEXPVALTYP
XCREDITSPREADUse Credit Spreads at Discounting TV_XCSPREADCHAR1XFELD
CSPREAD_TYPECredit Spread Type TCR_CSPREAD_TYPECHAR2TCRC_CSPR_TYPETCR_CSPREAD_TYPE
CTY_CURVE_BCommodity Curve Type Bid TB_CTY_CURVE_BNUMC3JBC_CCURVE_TYPETB_CTY_CURVE_TYPE
CTY_CURVE_MCommodity Curve Type Middle TB_CTY_CURVE_MNUMC3JBC_CCURVE_TYPETB_CTY_CURVE_TYPE
CTY_CURVE_ACommodity Curve Type Ask TB_CTY_CURVE_ANUMC3JBC_CCURVE_TYPETB_CTY_CURVE_TYPE
XDDELIVERYDelayed Delivery Option Usage Flag TV_DDELIVERYCHAR1XFELD
DD_DAYSNumber of Days to consider for Delayed Delivery TV_DD_DAYSDEC3TV_ALTER
XCSP_USE_VAR_RTUse Credit Spread when Calculating Forward Interest Rates TV_CSPRD_USE_VAR_RTCHAR1XFELD
CSP_FWD_RT_TYPECredit Spread Type TCR_CSPREAD_TYPECHAR2TCRC_CSPR_TYPETCR_CSPREAD_TYPE
DISPUOMDisplay Unit of Measure JBRDISPUOMCHAR1JBRDISPUOM
QTYCALMETHQuantity Calculation Method JBRQTYCALMETHCHAR1JBRQTYCALMETH
FUTCALMETHCalculation Method for Futures JBRFUTCALMETHCHAR1JBRFUTCALMETH
BSP_DERI_EVALBasis Spread Curve Derivation for Evaluation Curves FTBB_YC_BSC_DERIVE_EVALCHAR4FTBB_YCBSC_DREVLFTBB_YC_BSC_DERIVE_EVAL
BSP_DERI_FWDBasis Spread Curve Derivation ID for Forward Curves FTBB_YC_BSC_DERIVE_FWDCHAR4FTBB_YCBSC_DRFWDFTBB_YC_BSC_DERIVE_FWD
XEXTBWIndicator for External Valuation TV_XEXTBWCHAR1TV_XEXTBW
XDEST_T1RM RFC: Destination in SAP Banking RM TV_RFCDESTCHAR32Assigned to domainRFCDEST
XFUNC_T1RM RFC: Function Name in SAP Banking RM TV_RFCFNAMECHAR30Assigned to domainFUNCNAME
XDEST_T2RM RFC: Destination in SAP Banking RM TV_RFCDESTCHAR32Assigned to domainRFCDEST
XFUNC_T2RM RFC: Function Name in SAP Banking RM TV_RFCFNAMECHAR30Assigned to domainFUNCNAME
CONVADJ_VRControl convexity adjustment valuation rule specific JBR_CONVADJ_VRCHAR1JBR_VALRULE_ACTIVATE

Key field Non-key field



How do I retrieve data from SAP table ATRMO using ABAP code

The following ABAP code Example will allow you to do a basic selection on ATRMO to SELECT all data from the table
DATA: WA_ATRMO TYPE ATRMO.

SELECT SINGLE *
FROM ATRMO
INTO CORRESPONDING FIELDS OF WA_ATRMO
WHERE...

How to access SAP table ATRMO

Within an ECC or HANA version of SAP you can also view further information about ATRMO and the data within it using relevant transactions such as

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