ATRAS is a standard SAP table in SAP ERP (or) S/4HANA which stores Treasury Rates Table data. There are total 19 fields in ATRAS table.This blog post provides key technical details of SAP table ATRAS, including its availability across SAP S/4HANA versions and the list of CDS views for ATRAS 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 ATRAS Table Fields
The following is the list of fields that are available in SAP ATRAS 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) |
| RANTYP | Contract Type | RANTYP | RANTYP | VWPBONO | CHAR (1) |
| RANL | Treasury ID number | VVRANLWTR | WP_RANL | VWPBONO | CHAR (13) |
| RHANDPL | Exchange | VVRHANDPL | VVRHANDPL | VWPBONO | CHAR (10) |
| SKURSART | Rate/Price Type – Treasury Instruments | TI_KURSART | VVSKURSART | TW56 | CHAR (2) |
| DKURS | Rate/Price Date | DKURS | DATUM | DATS (8) | |
| WAERS | Quotation currency (which prices are in) | VVNOTWAERS | WAERS | TCURC | CUKY (5) |
| PKUR | Price in Percent | PKUR | DEC3_7 | DEC (10) | |
| PKTKUR | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | VVPKTKUR | DEC (15) | |
| SKHERK | Source | WHERK | CHAR10 | THERK | CHAR (10) |
| SOBJEKT | Internal key for object | VVKEYOBJ | VVKEY | CHAR (10) | |
| RBEAR | Employee ID | RBEAR | SYCHAR12 | CHAR (12) | |
| DBEAR | Last Edited On | DBEAR | DATUM | DATS (8) | |
| TBEAR | Last Edited At | TBEAR | TIMES | TIMS (6) | |
| RFGEB | Releaser of master record (person) | RFGEB_NEW | BU_PARTNER | CHAR (10) | |
| DFREI | Date of release | DFREI | DATUM | DATS (8) | |
| TFREI | Time of release | TFREI | TIMES | TIMS (6) | |
| SKZUSA | Price notation | SKZUSA | CHARX6 | TZUSA | CHAR (6) |
| SKABSCH | Price markdown | VVSKABSCH | VVSKABSCH | CHAR (2) |
Availability
The SAP table ATRAS 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 ATRAS table
The following is the list of ATRAS CDS views, which can also be used instead of ATRAS table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_SECURITYPRICE | BASIC | Security Price |
| I_SECURITYPRICECUBE | COMPOSITE | Market Data: Security Price Cube View |
| I_SECURITYPRICEDEVIATION | COMPOSITE | Security Price Deviation |
| I_SECURITYPRICEREPORTING | COMPOSITE | Security Price in Reporting Period |
| P_SECURITYPRICEDATE | COMPOSITE | Security Price Date |
| P_SECURITYPRICEKEYDATE | COMPOSITE | Security Price on Key Date |
| C_SECURITYPRICEQUERY | CONSUMPTION | Market Data Query for Security Price |
| C_SECURITYPRICEREPORTING | CONSUMPTION | Security Price in Reporting Period |
