SAP AT16 Treasury: Fixing Settings for Forex Transactions Table
Overview
AT16 is a standard SAP S/4HANA table that stores Treasury: Fixing Settings for Forex Transactions data. There are total 9 fields in the AT16 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AT16 belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).
In addition, following links provide an overview of foreign key relationships, if any, that link AT16 to other SAP tables and standard CDS views available based on AT16 table in S/4HANA 2020.
Techincal Settings of AT16
Below are technical details of the table AT16
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of AT16 Fields
The following table gives you an overview of the fields available in AT16
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| SFHAART | Financial Transaction Type | TB_SFHAART | AT10 | CHAR | 3 |
| WLWAERS | Leading Currency | TB_WLWAERS | TCURC | CUKY | 5 |
| WFWAERS | Following Currency | TB_WFWAERS | TCURC | CUKY | 5 |
| KONTRH | Business Partner Number | TB_KUNNR_NEW | BUT000 | CHAR | 10 |
| SEITE | Fixing Transaction Purchase/Sale | TB_SEITE | CHAR | 1 | |
| KURSTYP | Exchange rate type | KURST_CURR | TCURV | CHAR | 4 |
| MARGE | Spread for Forex Fixing | TB_MARGE | DEC | 13 |
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 AT16
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AT16 | KONTRH | : | BUT000 |
| AT16 | KURSTYP | 1: CN | TCURV |
| AT16 | MANDT | : | T000 |
| AT16 | SFHAART | : | AT10 |
| AT16 | SGSART | : | TZPA |
| AT16 | WFWAERS | : | TCURC |
| AT16 | WLWAERS | : | TCURC |