Sunday, May 19, 2024

SAP Table ATCVO – Exchange Rate Volatilities

ATCVO is a standard SAP table in SAP ERP (or) S/4HANA which stores Exchange Rate Volatilities data. There are total 8 fields in ATCVO table.This blog post provides key technical details of SAP table ATCVO, including its availability across SAP S/4HANA versions and the list of CDS views for ATCVO table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package TR-CORE: Former Objects from FTA (Applic. Dev. TR General) (FTA_CORE)
Technical Component Treasury and Risk Management (FIN-FSCM-TRM)

SAP ATCVO Table Fields

The following is the list of fields that are available in SAP ATCVO table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT T000 CLNT (3)
VOLART Volatility Type TB_VOLART T_VOLART ATVO1 CHAR (3)
FCURR From currency FCURR WAERS TCURC CUKY (5)
TCURR To Currency TCURR_D WAERS TCURC CUKY (5)
DATAB Effective From TB_DATAB DATUM DATS (8)
LFZEIT Term in Days TB_LFZEIT TV_LFZN NUMC (10)
DATABS Absolute date (not used initially) TB_DATABS DATUM DATS (8)
VOLA Volatility TB_VOLA T_VOLA DEC (11)

Availability

The SAP table ATCVO is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ATCVO table

The following is the list of ATCVO CDS views, which can also be used instead of ATCVO table based on your business requirements.

CDS View CDS View Type Description
I_EXCHANGERATEVOLATILITY BASIC Historical Exchange Rate Volatility
I_EXCHANGERATEVOLATILITYCUBE COMPOSITE Historic Exchange Rate Volatility Cube
C_HISEXCHRATEVOLATILITYQRY CONSUMPTION Historic Exchange Rate Volatility Query