ATSYC SAP (Default Settings for Risk Evaluations) Table details
Dictionary Type: Table
Description: Default Settings for Risk Evaluations
Description: Default Settings for Risk Evaluations
Table field list including key, data, relationships and ABAP select examples
ATSYC is a standard SAP Table which is used to store Default Settings for Risk Evaluations data and is available within R/3 SAP systems depending on the version and release level.
The ATSYC table consists of various fields, each holding specific information or linking keys about Default Settings for Risk Evaluations data available in SAP. These include AUSWT (Evaluation type in Risk Management), AUTGR (Authorization Group), BCURVE (Bid valuation curve type for mark-to-market), BCURVEB (Ask Valuation Curve: Mark-to-Market).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ATSYC table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AUSWT | Evaluation type in Risk Management | TV_AUSWT | CHAR | 4 | JBREVAL | JBREVAL | |||
AUTGR | Authorization Group | TV_AUTGR | CHAR | 4 | VTVAUTGR | TV_AUTGR | |||
BCURVE | Bid valuation curve type for mark-to-market | TB_BCURVE | NUMC | 4 | JBD14 | JBSZKART | |||
BCURVEB | Ask Valuation Curve: Mark-to-Market | TB_BCURVEB | NUMC | 4 | JBD14 | JBSZKART | |||
BCURVEM | Middle valuation curve: Mark-to-market | TB_BCURVEM | NUMC | 4 | JBD14 | JBSZKART | |||
DVOLARTB | Volatility Type 'Ask Rates' for Foreign Exchange | TB_VOLARTB | CHAR | 3 | ATVO1 | T_VOLART | |||
DVOLARTG | Volatility Type 'Bid Rates' for Foreign Exchange | TB_VOLARTG | CHAR | 3 | ATVO1 | T_VOLART | |||
DVOLARTM | Volatility Type Middle Rates for Foreign Exchange | TB_VOLARTM | CHAR | 3 | ATVO1 | T_VOLART | |||
ZVOLARTG | Volatility Type 'Bid' for Interest Rates | TB_ZVOLARG | CHAR | 3 | ATVO1 | T_VOLART | |||
ZVOLARTB | Volatility Type 'Ask' for Interest Rates | TB_ZVOLARB | CHAR | 3 | ATVO1 | T_VOLART | |||
ZVOLARTM | Volatility Type Middle Rates for Interest | TB_ZVOLARM | CHAR | 3 | ATVO1 | T_VOLART | |||
WVOLARTG | Volatility Type 'Bid' for Securities | TB_WVOLARG | CHAR | 3 | ATVO1 | T_VOLART | |||
WVOLARTB | Volatility Type 'Ask' for Securities | TB_WVOLARB | CHAR | 3 | ATVO1 | T_VOLART | |||
WVOLARTM | Volatility Type Middle Rates for Securities | TB_WVOLARM | CHAR | 3 | ATVO1 | T_VOLART | |||
KORRARTM | 'Middle' Correlation Type | TV_CORRTYPEM | CHAR | 3 | ATKO1 | T_KORART | |||
KORRARTG | 'Bid' Correlation Type | TV_CORRTYPEG | CHAR | 3 | ATKO1 | T_KORART | |||
KORRARTB | 'Ask' Correlation Type | TV_CORRTYPEB | CHAR | 3 | ATKO1 | T_KORART | |||
SVOLART | Volatility Type for Convexity Adjustment | TB_SVOLART | CHAR | 3 | ATVO1 | T_VOLART | |||
XCONVADJ | Calculate convexity adjustment? | TV_XCONV | CHAR | 1 | CHAR001 | ||||
XDFCURR | X - Import exchange rates from datafeed | TV_XDFCURR | CHAR | 1 | XFELD | ||||
XDFINTE | X - Import interest rates from datafeed | TV_XDFINTE | CHAR | 1 | XFELD | ||||
XDFIVOL | Import interest volatilities from datafeed | TV_XDFIVOL | CHAR | 1 | XFELD | ||||
XDFCVOL | Import exchange rate volatilities from datafeed | TV_XDFCVOL | CHAR | 1 | XFELD | ||||
XDFWERT | Import security prices from datafeed | TV_XDFWERT | CHAR | 1 | XFELD | ||||
WPKURSART | Security price type for evaluations | TB_WKURSA | CHAR | 2 | TW56 | VVSKURSART | |||
KURSTG | Exchange rate type bid | TB_KURSTG | CHAR | 4 | TCURV | KURST | |||
KURSTB | Exchange rate type ask | TB_KURSTB | CHAR | 4 | TCURV | KURST | |||
KURSTM | Exchange rate type middle | TB_KURSTM | CHAR | 4 | TCURV | KURST | |||
WKTAGE | Maximum age of historical price in days | TV_WKTAGE | DEC | 3 | TV_ALTER | ||||
RWORKMODUS | Datafeed: Operating mode function module | TB_MODUS | CHAR | 1 | T_BUFMODUS | ||||
FEEDNAME | Market Data: Data Provider | TB_DFNAME | CHAR | 10 | VTBDFF | T_DFCHAR10 | DLNAME | ||
XHOR_CASHF | Is cash flow at horizon included in NPV? | TV_XHOR_CF | CHAR | 1 | XFELD | ||||
IDXART | Index Type | IDXART | CHAR | 2 | INDEXA | CHAR2 | |||
BFART | Beta Factor Type | JBRBFART_D | CHAR | 3 | JBRBFART | JBRBFART | |||
XREAL_CASHF | Include Real Cash Flows | TV_REAL_CF | CHAR | 1 | XFELD | ||||
COMAXAGEPR | Maximum age of historical price in days | TV_WKTAGE | DEC | 3 | TV_ALTER | ||||
COPRTYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | CHAR | 5 | TRCOCC_QUOTTYPE | TCR_CTY_QUOTTYPE | |||
COVOLTYPB | Volitility Type 'Bid' for Commodity Transactions | TB_COVOTYPB | CHAR | 3 | ATVO1 | T_VOLART | |||
COVOLTYPA | Volitility Type 'Ask' for Commodity Transactions | TB_COVOTYPA | CHAR | 3 | ATVO1 | T_VOLART | |||
COVOLTYPM | Volatility Type 'Middle Rate' for Commodities | TB_COVOTYPM | CHAR | 3 | ATVO1 | T_VOLART | |||
X_INTVAL | Intrinsic Value Indicator | JBR_INT_VAL | CHAR | 1 | XFELD | ||||
COEXPVALTYP | Commodity Exposure - NPV Valuation Type | TV_COEXPVALTYP | NUMC | 1 | TV_COEXPVALTYP | ||||
BCURVEB_RF | Ask Valuation Curve : Risk Free | TB_BCURVEB_RF | NUMC | 4 | JBD14 | JBSZKART | |||
BCURVEM_RF | Middle Valuation Curve : Risk Free | TB_BCURVEM_RF | NUMC | 4 | JBD14 | JBSZKART | |||
BCURVE_RF | Bid Valuation Curve : Risk Free | TB_BCURVE_RF | NUMC | 4 | JBD14 | JBSZKART | |||
XCREDITSPREAD | Use Credit Spreads at Discounting | TV_XCSPREAD | CHAR | 1 | XFELD | ||||
CSPREAD_TYPE | Credit Spread Type | TCR_CSPREAD_TYPE | CHAR | 2 | TCRC_CSPR_TYPE | TCR_CSPREAD_TYPE | |||
CTY_CURVE_B | Commodity Curve Type Bid | TB_CTY_CURVE_B | NUMC | 3 | JBC_CCURVE_TYPE | TB_CTY_CURVE_TYPE | |||
CTY_CURVE_M | Commodity Curve Type Middle | TB_CTY_CURVE_M | NUMC | 3 | JBC_CCURVE_TYPE | TB_CTY_CURVE_TYPE | |||
CTY_CURVE_A | Commodity Curve Type Ask | TB_CTY_CURVE_A | NUMC | 3 | JBC_CCURVE_TYPE | TB_CTY_CURVE_TYPE | |||
XDDELIVERY | Delayed Delivery Option Usage Flag | TV_DDELIVERY | CHAR | 1 | XFELD | ||||
DD_DAYS | Number of Days to consider for Delayed Delivery | TV_DD_DAYS | DEC | 3 | TV_ALTER | ||||
XCSP_USE_VAR_RT | Use Credit Spread when Calculating Forward Interest Rates | TV_CSPRD_USE_VAR_RT | CHAR | 1 | XFELD | ||||
CSP_FWD_RT_TYPE | Credit Spread Type | TCR_CSPREAD_TYPE | CHAR | 2 | TCRC_CSPR_TYPE | TCR_CSPREAD_TYPE | |||
POS23_PRIO | Financial Objects for Positions in Futures Accounts | TV_POS23_PRIO | CHAR | 1 | TV_POS23_PRIO | ||||
.INCLU--AP | 0 | ||||||||
HWVOLARTG | Volatility Type for Yield Curve Model, Bid Rate | TV_HWVOLAG | CHAR | 3 | ATVO1 | T_VOLART | |||
HWVOLARTB | Volatility Type for Yield Curve Model, Ask Rate | TV_HWVOLAB | CHAR | 3 | ATVO1 | T_VOLART | |||
HWVOLARTM | Volatility Type for Yield Curve Model, Middle Rate | TV_HWVOLAM | CHAR | 3 | ATVO1 | T_VOLART | |||
.INCLU--AP | 0 | ||||||||
XEXTBW | Indicator for External Valuation | TV_XEXTBW | CHAR | 1 | TV_XEXTBW | ||||
XDEST_T1 | RM RFC: Destination in SAP Banking RM | TV_RFCDEST | CHAR | 32 | Assigned to domain | RFCDEST | |||
XFUNC_T1 | RM RFC: Function Name in SAP Banking RM | TV_RFCFNAME | CHAR | 30 | Assigned to domain | FUNCNAME | |||
XDEST_T2 | RM RFC: Destination in SAP Banking RM | TV_RFCDEST | CHAR | 32 | Assigned to domain | RFCDEST | |||
XFUNC_T2 | RM RFC: Function Name in SAP Banking RM | TV_RFCFNAME | CHAR | 30 | Assigned to domain | FUNCNAME |
Key field | Non-key field |
How do I retrieve data from SAP table ATSYC using ABAP code
The following ABAP code Example will allow you to do a basic selection on ATSYC to SELECT all data from the tableDATA: WA_ATSYC TYPE ATSYC.
SELECT SINGLE *
FROM ATSYC
INTO CORRESPONDING FIELDS OF WA_ATSYC
WHERE...
How to access SAP table ATSYC
Within an ECC or HANA version of SAP you can also view further information about ATSYC 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