V_ATSYCII SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
V_ATSYCII is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_ATSYCII table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AUSWERTUNG (ID of Risk Management Evaluation), BCURVE (Bid valuation curve type for mark-to-market), BCURVEB (Ask Valuation Curve: Mark-to-Market), BCURVEM (Middle 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP V_ATSYCII table view 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 | |||
AUSWERTUNG | ID of Risk Management Evaluation | JBREVAL_D | CHAR | 4 | JBREVAL | ||||
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 | |||
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 | |||
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 | |||
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 | |||
KBEZ | Short Name | JBXKBEZ | CHAR | 30 | JBXKBEZ | ||||
LBEZ | Long Name | JBXLBEZ | CHAR | 60 | JBXLBEZ | ||||
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 | ||
IDXART | Index Type | IDXART | CHAR | 2 | INDEXA | CHAR2 | |||
KURSTM | Exchange rate type middle | TB_KURSTM | CHAR | 4 | TCURV | KURST | |||
BFART | Beta Factor Type | JBRBFART_D | CHAR | 3 | JBRBFART | JBRBFART | |||
DVOLARTM | Volatility Type Middle Rates for Foreign Exchange | TB_VOLARTM | CHAR | 3 | ATVO1 | T_VOLART | |||
ZVOLARTM | Volatility Type Middle Rates for Interest | TB_ZVOLARM | CHAR | 3 | ATVO1 | T_VOLART | |||
WVOLARTM | Volatility Type Middle Rates for Securities | TB_WVOLARM | CHAR | 3 | ATVO1 | T_VOLART | |||
SVOLART | Volatility Type for Convexity Adjustment | TB_SVOLART | CHAR | 3 | ATVO1 | T_VOLART | |||
XCONVADJ | Calculate convexity adjustment? | TV_XCONV | CHAR | 1 | CHAR001 | ||||
DEFIDX | Standard Security Index | TV_IDX | CHAR | 10 | INDEXD | CHAR10 | |||
DEFBETAF | Standard Beta Factor | TV_BETAF | DEC | 10(6) | JBFBFAKTOR | ||||
IXVOLARTG | Volatility Type for Security Indexes; Bid Rates | TV_IXVOLG | CHAR | 3 | ATVO1 | T_VOLART | |||
IXVOLARTB | Volatility Type for Security Indexes; Ask Rates | TV_IXVOLB | CHAR | 3 | ATVO1 | T_VOLART | |||
IXVOLARTM | Volatility Type for Security Indexes; Middle Rates | TV_IXVOLM | CHAR | 3 | ATVO1 | T_VOLART | |||
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 | |||
KORRARTG | 'Bid' Correlation Type | TV_CORRTYPEG | CHAR | 3 | ATKO1 | T_KORART | |||
KORRARTB | 'Ask' Correlation Type | TV_CORRTYPEB | CHAR | 3 | ATKO1 | T_KORART | |||
KORRARTM | 'Middle' Correlation Type | TV_CORRTYPEM | CHAR | 3 | ATKO1 | T_KORART | |||
XKOMPRESS | Activate Presummarization | TV_KOMPR | CHAR | 1 | T_KOMPR | ||||
XHOR_CASHF | Is cash flow at horizon included in NPV? | TV_XHOR_CF | CHAR | 1 | XFELD | ||||
AUTGR | Authorization Group | TV_AUTGR | CHAR | 4 | VTVAUTGR | TV_AUTGR | |||
LZB | Maturity Band | JBRLZB_D | CHAR | 4 | ALPHA | JBRLZB | LZB | S_JBRLZB_LZBID | |
NAMEAUS | Disbursement Procedure (Loan) | JBRNAMEAUS | CHAR | 10 | JBTAUSVER | JBRNAMEAUS | |||
STUECKZINS | Include the Horizon when Calculating Accrued Interest | JBR_X_STUECKZINS | CHAR | 1 | XFELD | ||||
PREPAYMENT | Prepayment | JBR_PREPAYMENT | CHAR | 1 | JBR_PREPAYMENT | ||||
X_PREPAYMENT | Indicator for Prepayment - Point Effect | JBR_X_PREPAYMENT | CHAR | 1 | XFELD | ||||
FLG_WITH_COMPENS | Select FX Offsetting Transactions | JBR_FLG_WITH_COMPENS | CHAR | 1 | FLAG | ||||
FLG_TERMINATED_D | Select Transaction on Day of Cancellation/Settlement | JBR_FLG_TERMINATED_DEAL | CHAR | 1 | FLAG | ||||
XEXTBW | Indicator for External Valuation | TV_XEXTBW | CHAR | 1 | TV_XEXTBW | ||||
XDEST_T1 | RM RFC: Destination in SAP Banking RM | TV_RFCDEST | CHAR | 32 | RFCDEST | ||||
XFUNC_T1 | RM RFC: Function Name in SAP Banking RM | TV_RFCFNAME | CHAR | 30 | FUNCNAME | ||||
XDEST_T2 | RM RFC: Destination in SAP Banking RM | TV_RFCDEST | CHAR | 32 | RFCDEST | ||||
XFUNC_T2 | RM RFC: Function Name in SAP Banking RM | TV_RFCFNAME | CHAR | 30 | FUNCNAME | ||||
XREAL_CASHF | Include Real Cash Flows | TV_REAL_CF | CHAR | 1 | XFELD | ||||
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 | |||
COMAXAGEPR | Maximum age of historical price in days | TV_WKTAGE | DEC | 3 | TV_ALTER | ||||
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 | |||
DISPUOM | Display Unit of Measure | JBRDISPUOM | CHAR | 1 | JBRDISPUOM | ||||
QTYCALMETH | Quantity Calculation Method | JBRQTYCALMETH | CHAR | 1 | JBRQTYCALMETH | ||||
FUTCALMETH | Calculation Method for Futures | JBRFUTCALMETH | CHAR | 1 | JBRFUTCALMETH | ||||
BSP_CURVE_B | Basis Spread Curve Type | FTBB_YC_BSCT | CHAR | 4 | FTBB_YCBSCURVE | FTBB_YC_BSCT | |||
BSP_CURVE_A | Basis Spread Curve Type | FTBB_YC_BSCT | CHAR | 4 | FTBB_YCBSCURVE | FTBB_YC_BSCT | |||
BSP_CURVE_M | Basis Spread Curve Type | FTBB_YC_BSCT | CHAR | 4 | FTBB_YCBSCURVE | FTBB_YC_BSCT | |||
BSP_DERI_EVAL | Basis Spread Curve Derivation for Evaluation Curves | FTBB_YC_BSC_DERIVE_EVAL | CHAR | 4 | FTBB_YCBSC_DREVL | FTBB_YC_BSC_DERIVE_EVAL | |||
BSP_DERI_FWD | Basis Spread Curve Derivation ID for Forward Curves | FTBB_YC_BSC_DERIVE_FWD | CHAR | 4 | FTBB_YCBSC_DRFWD | FTBB_YC_BSC_DERIVE_FWD |
Key field | Non-key field |
How do I retrieve data from SAP table V_ATSYCII using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_ATSYCII to SELECT all data from the tableDATA: WA_V_ATSYCII TYPE V_ATSYCII.
SELECT SINGLE *
FROM V_ATSYCII
INTO CORRESPONDING FIELDS OF WA_V_ATSYCII
WHERE...
How to access SAP table V_ATSYCII
Within an ECC or HANA version of SAP you can also view further information about V_ATSYCII 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