SAP ATSYC Default Settings for Risk Evaluations Table
Overview
ATSYC is a standard SAP S/4HANA table that stores Default Settings for Risk Evaluations data. There are total 65 fields in the ATSYC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ATSYC belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package FTB Core (FTB_CORE).
In addition, following links provide an overview of foreign key relationships, if any, that link ATSYC to other SAP tables and standard CDS views available based on ATSYC table in S/4HANA 2020.
Techincal Settings of ATSYC
Below are technical details of the table ATSYC
- Buffering switched on
- Full table is passed to buffer
- Storage type is Column Store
List of ATSYC Fields
The following table gives you an overview of the fields available in ATSYC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUSWT | Evaluation type in Risk Management | TV_AUSWT | JBREVAL | CHAR | 4 |
| AUTGR | Authorization Group | TV_AUTGR | VTVAUTGR | CHAR | 4 |
| BCURVE | Bid valuation curve type for mark-to-market | TB_BCURVE | JBD14 | NUMC | 4 |
| BCURVEB | Ask Valuation Curve: Mark-to-Market | TB_BCURVEB | JBD14 | NUMC | 4 |
| BCURVEM | Middle valuation curve: Mark-to-market | TB_BCURVEM | JBD14 | NUMC | 4 |
| DVOLARTB | Volatility Type "Ask Rates" for Foreign Exchange | TB_VOLARTB | ATVO1 | CHAR | 3 |
| DVOLARTG | Volatility Type "Bid Rates" for Foreign Exchange | TB_VOLARTG | ATVO1 | CHAR | 3 |
| DVOLARTM | Volatility Type Middle Rates for Foreign Exchange | TB_VOLARTM | ATVO1 | CHAR | 3 |
| ZVOLARTG | Volatility Type 'Bid' for Interest Rates | TB_ZVOLARG | ATVO1 | CHAR | 3 |
| ZVOLARTB | Volatility Type 'Ask' for Interest Rates | TB_ZVOLARB | ATVO1 | CHAR | 3 |
| ZVOLARTM | Volatility Type Middle Rates for Interest | TB_ZVOLARM | ATVO1 | CHAR | 3 |
| WVOLARTG | Volatility Type 'Bid' for Securities | TB_WVOLARG | ATVO1 | CHAR | 3 |
| WVOLARTB | Volatility Type 'Ask' for Securities | TB_WVOLARB | ATVO1 | CHAR | 3 |
| WVOLARTM | Volatility Type Middle Rates for Securities | TB_WVOLARM | ATVO1 | CHAR | 3 |
| KORRARTM | 'Middle' Correlation Type | TV_CORRTYPEM | ATKO1 | CHAR | 3 |
| KORRARTG | 'Bid' Correlation Type | TV_CORRTYPEG | ATKO1 | CHAR | 3 |
| KORRARTB | 'Ask' Correlation Type | TV_CORRTYPEB | ATKO1 | CHAR | 3 |
| SVOLART | Volatility Type for Convexity Adjustment | TB_SVOLART | ATVO1 | CHAR | 3 |
| XCONVADJ | Calculate convexity adjustment? | TV_XCONV | CHAR | 1 | |
| XDFCURR | X - Import exchange rates from datafeed | TV_XDFCURR | CHAR | 1 | |
| XDFINTE | Import Interest Rates from Datafeed | TV_XDFINTE | CHAR | 1 | |
| XDFIVOL | Import interest volatilities from datafeed | TV_XDFIVOL | CHAR | 1 | |
| XDFCVOL | Import exchange rate volatilities from datafeed | TV_XDFCVOL | CHAR | 1 | |
| XDFWERT | Import security prices from datafeed | TV_XDFWERT | CHAR | 1 | |
| WPKURSART | Security price type for evaluations | TB_WKURSA | TW56 | CHAR | 2 |
| KURSTG | Exchange rate type bid | TB_KURSTG | TCURV | CHAR | 4 |
| KURSTB | Exchange rate type ask | TB_KURSTB | TCURV | CHAR | 4 |
| KURSTM | Exchange rate type middle | TB_KURSTM | TCURV | CHAR | 4 |
| WKTAGE | Maximum age of historical price in days | TV_WKTAGE | DEC | 3 | |
| RWORKMODUS | Datafeed: Operating mode function module | TB_MODUS | CHAR | 1 | |
| FEEDNAME | Market Data: Data Provider | TB_DFNAME | VTBDFF | CHAR | 10 |
| XHOR_CASHF | Is cash flow at horizon included in NPV? | TV_XHOR_CF | CHAR | 1 | |
| IDXART | Index Type | IDXART | INDEXA | CHAR | 2 |
| BFART | Beta Factor Type | JBRBFART_D | JBRBFART | CHAR | 3 |
| XREAL_CASHF | Include Real Cash Flows | TV_REAL_CF | CHAR | 1 | |
| COMAXAGEPR | Maximum age of historical price in days | TV_WKTAGE | DEC | 3 | |
| COPRTYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | TRCOCC_QUOTTYPE | CHAR | 5 |
| COVOLTYPB | Volitility Type "Bid" for Commodity Transactions | TB_COVOTYPB | ATVO1 | CHAR | 3 |
| COVOLTYPA | Volitility Type "Ask" for Commodity Transactions | TB_COVOTYPA | ATVO1 | CHAR | 3 |
| COVOLTYPM | Volatility Type 'Middle Rate' for Commodities | TB_COVOTYPM | ATVO1 | CHAR | 3 |
| X_INTVAL | Intrinsic Value Indicator | JBR_INT_VAL | CHAR | 1 | |
| COEXPVALTYP | Commodity Exposure - NPV Valuation Type | TV_COEXPVALTYP | NUMC | 1 | |
| BCURVEB_RF | Ask Valuation Curve : Risk Free | TB_BCURVEB_RF | JBD14 | NUMC | 4 |
| BCURVEM_RF | Middle Valuation Curve : Risk Free | TB_BCURVEM_RF | JBD14 | NUMC | 4 |
| BCURVE_RF | Bid Valuation Curve : Risk Free | TB_BCURVE_RF | JBD14 | NUMC | 4 |
| XCREDITSPREAD | Use Credit Spreads at Discounting | TV_XCSPREAD | CHAR | 1 | |
| CSPREAD_TYPE | Credit Spread Type | TCR_CSPREAD_TYPE | TCRC_CSPR_TYPE | CHAR | 2 |
| CTY_CURVE_B | Commodity Curve Type Bid | TB_CTY_CURVE_B | JBC_CCURVE_TYPE | NUMC | 3 |
| CTY_CURVE_M | Commodity Curve Type Middle | TB_CTY_CURVE_M | JBC_CCURVE_TYPE | NUMC | 3 |
| CTY_CURVE_A | Commodity Curve Type Ask | TB_CTY_CURVE_A | JBC_CCURVE_TYPE | NUMC | 3 |
| XDDELIVERY | Delayed Delivery Option Usage Flag | TV_DDELIVERY | CHAR | 1 | |
| DD_DAYS | Number of Days to consider for Delayed Delivery | TV_DD_DAYS | DEC | 3 | |
| XCSP_USE_VAR_RT | Use Credit Spread when Calculating Forward Interest Rates | TV_CSPRD_USE_VAR_RT | CHAR | 1 | |
| CSP_FWD_RT_TYPE | Credit Spread Type | TCR_CSPREAD_TYPE | TCRC_CSPR_TYPE | CHAR | 2 |
| POS23_PRIO | Financial Objects for Positions in Futures Accounts | TV_POS23_PRIO | CHAR | 1 | |
| OPEX_PRIO | Financial Objects for Operating Exposures | TV_OPEX_PRIO | CHAR | 1 | |
| HWVOLARTG | Volatility Type for Yield Curve Model, Bid Rate | TV_HWVOLAG | ATVO1 | CHAR | 3 |
| HWVOLARTB | Volatility Type for Yield Curve Model, Ask Rate | TV_HWVOLAB | ATVO1 | CHAR | 3 |
| HWVOLARTM | Volatility Type for Yield Curve Model, Middle Rate | TV_HWVOLAM | ATVO1 | CHAR | 3 |
| XEXTBW | Indicator for External Valuation | TV_XEXTBW | CHAR | 1 | |
| XDEST_T1 | RM RFC: Destination in SAP Banking RM | TV_RFCDEST | * | CHAR | 32 |
| XFUNC_T1 | RM RFC: Function Name in SAP Banking RM | TV_RFCFNAME | * | CHAR | 30 |
| XDEST_T2 | RM RFC: Destination in SAP Banking RM | TV_RFCDEST | * | CHAR | 32 |
| XFUNC_T2 | RM RFC: Function Name in SAP Banking RM | TV_RFCFNAME | * | CHAR | 30 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ATSYC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ATSYC | AUSWT | 1: 1 | JBREVAL |
| ATSYC | AUTGR | : | VTVAUTGR |
| ATSYC | BCURVE | : | JBD14 |
| ATSYC | BCURVEB | : | JBD14 |
| ATSYC | BCURVEB_RF | : | JBD14 |
| ATSYC | BCURVEM | : | JBD14 |
| ATSYC | BCURVEM_RF | : | JBD14 |
| ATSYC | BCURVE_RF | : | JBD14 |
| ATSYC | BFART | 1: CN | JBRBFART |
| ATSYC | COPRTYPE | : | TRCOCC_QUOTTYPE |
| ATSYC | COVOLTYPA | : | ATVO1 |
| ATSYC | COVOLTYPB | : | ATVO1 |
| ATSYC | COVOLTYPM | : | ATVO1 |
| ATSYC | CSPREAD_TYPE | : | TCRC_CSPR_TYPE |
| ATSYC | CSP_FWD_RT_TYPE | 1: CN | TCRC_CSPR_TYPE |
| ATSYC | CTY_CURVE_A | : | JBC_CCURVE_TYPE |
| ATSYC | CTY_CURVE_B | : | JBC_CCURVE_TYPE |
| ATSYC | CTY_CURVE_M | : | JBC_CCURVE_TYPE |
| ATSYC | DVOLARTB | : | ATVO1 |
| ATSYC | DVOLARTG | : | ATVO1 |
| ATSYC | DVOLARTM | 1: CN | ATVO1 |
| ATSYC | FEEDNAME | 1: CN | VTBDFF |
| ATSYC | HWVOLARTB | : | ATVO1 |
| ATSYC | HWVOLARTG | : | ATVO1 |
| ATSYC | HWVOLARTM | : | ATVO1 |
| ATSYC | IDXART | 1: CN | INDEXA |
| ATSYC | KORRARTB | 1: CN | ATKO1 |
| ATSYC | KORRARTG | 1: CN | ATKO1 |
| ATSYC | KORRARTM | : | ATKO1 |
| ATSYC | KURSTB | 1: CN | TCURV |
| ATSYC | KURSTG | 1: CN | TCURV |
| ATSYC | KURSTM | 1: CN | TCURV |
| ATSYC | MANDT | 1: CN | T000 |
| ATSYC | SVOLART | : | ATVO1 |
| ATSYC | WPKURSART | 1: CN | TW56 |
| ATSYC | WVOLARTB | : | ATVO1 |
| ATSYC | WVOLARTG | : | ATVO1 |
| ATSYC | WVOLARTM | 1: CN | ATVO1 |
| ATSYC | ZVOLARTB | : | ATVO1 |
| ATSYC | ZVOLARTG | : | ATVO1 |
| ATSYC | ZVOLARTM | 1: CN | ATVO1 |