The AT100 table in SAP ERP or S/4HANA stores Treasury Additions to User Master data. There are total 8 fields in AT100 table. The Treasury Additions to User Master table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AT100 table. It is in R/3 appl. development for Treasury money,forex,forward gen (FTA) ABAP package and is part of the Transaction Manager (FIN-FSCM-TRM-TM) module.
SAP AT100 Table Fields
Following is the list of fields that are available in SAP AT100 table. The primary key fields of the table are MANDT (Client), BNAME (User Name in User Master Record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BNAME | User Name in User Master Record | XUBNAME | USR02 | CHAR (12) |
| XMIO | Abbreviation for One Million | TB_XMIO | CHAR (1) | |
| XTSD | Abbreviation for One Thousand | TB_XTSD | CHAR (1) | |
| SGTGPRF | Working Day Check Indicator | TB_SGTGPRF | NUMC (1) | |
| RDEALER | Trader | RDEALER | TZDEA | CHAR (12) |
| SKEGPRF | Control Flag for Rate Entry Check | TB_SKEGPRF | NUMC (1) | |
| SFXDATSTR | Foreign Exchange: Date String from Spot Value Date | TX_DATSTR | CHAR (1) |
