The AT10 table in SAP ERP or S/4HANA stores Transaction Types data. There are total 62 fields in AT10 table. The Transaction Types 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 AT10 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 AT10 Table Fields
Following is the list of fields that are available in SAP AT10 table. The primary key fields of the table are MANDT (Client), SGSART (Product Type), SFHAART (Financial Transaction Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| SGSART | Product Type | VVSART | TZPA | CHAR (3) |
| SFHAART | Financial Transaction Type | TB_SFHAART | CHAR (3) | |
| SFGTYP | Transaction Category | TB_SFGTYP | AT01 | NUMC (3) |
| NUMKR | Number Range for Transactions | TB_NUMKRG | CHAR (2) | |
| NUMKRANG | Number Range for Offers/Quotations | NUMKRANG | CHAR (2) | |
| NUMKRSIM | Number Range for Simulated Transactions | NUMKRSIM | CHAR (2) | |
| ABWTYP | Processing Category | TB_ABWTYP | AT05 | CHAR (5) |
| SAUTOBUCH | Automatic Posting Release | TB_SAUTOB | CHAR (1) | |
| UNUMKR | Number Range for Underlying | TB_UNUMKR | CHAR (2) | |
| SLPG | Limit Product Group | TB_SLPG | ATLPG | CHAR (3) |
| SROUND | Rounding Type | TB_SROUND | CHAR (1) | |
| RROUND | Rounding unit | TB_RROUND | INT1 (3) | |
| SBSTDCP | Basic Principle of Commercial Paper Position | TM_SBSTDCP | CHAR (1) | |
| SCOMPCP | Exponential Discounting for Terms over 1 Year | TM_SCOMPCP | CHAR (1) | |
| AHJFA | Number of Half-Years for Generating Cash Flow | TB_AHJFA | NUMC (2) | |
| SREALGE | Treasury: Flow Type for Realized Gains | TB_SREALGE | TZB0A | CHAR (4) |
| SREALVE | Treasury: Flow Type for Realized Losses | TB_SREALVE | TZB0A | CHAR (4) |
| SBESTABT | Treasury: Flow Type for Position Write-Downs | TB_SBESTAB | TZB0A | CHAR (4) |
| SBESTZUT | Treasury: Flow Type for Position Write-Ups | TB_SBESTZU | TZB0A | CHAR (4) |
| SBESTAB | Treasury: Flow Type for Position Write-Downs | TB_SBESTAB | TZB0A | CHAR (4) |
| SBESTZU | Treasury: Flow Type for Position Write-Ups | TB_SBESTZU | TZB0A | CHAR (4) |
| SRUEBIL | Treasury: Flow Type for Provisions to Be Created | TB_SRUEBIL | TZB0A | CHAR (4) |
| SRUEAUF | Treasury: Flow Type for Reversing Provisions | TB_SRUEAUF | TZB0A | CHAR (4) |
| SGEWBIL | Treasury: Flow Type for Unrealized Gains to Be Disclosed | TB_SGEWBIL | TZB0A | CHAR (4) |
| SGEWAUF | Treasury: Flow Type for Writing Back Unrealized Gains | TB_SGEWAUF | TZB0A | CHAR (4) |
| SSWAPERT | Treasury: Flow Type for Accrued/Deferred Forex Swap Revenue | TB_SWAPERT | TZB0A | CHAR (4) |
| SSWAPERAUF | Treasury: Flow Type for Writing Back Accrd/Defd Fx Swap Rev. | TB_SWPERAU | TZB0A | CHAR (4) |
| SSWAPAUF | Treasury: Flow Type for Accrued/Deferred Forex Swap Expenses | TB_SWAPAUF | TZB0A | CHAR (4) |
| SSWAPAUAUF | Treasury: Flow Type f. Writing Back Accrd/Defrd Fx Swap Exp. | TB_SWPAUAU | TZB0A | CHAR (4) |
| SRUESWP | Treasury: Flow Type for Creating Provisions – Swap | TB_SWRUEBI | TZB0A | CHAR (4) |
| SRUEAUFSWP | Treasury: Flow Type for Clearing Provisons – Swap | TB_SWRUEAU | TZB0A | CHAR (4) |
| SGEWSWP | Treasury: Flow Type for Disclosing Unrealized Gains – Swap | TB_SWGWBIL | TZB0A | CHAR (4) |
| SGEWAUFSWP | Treasury: Flow Type for Clearing Unrealized Swap Gains | TB_SWGWAUF | TZB0A | CHAR (4) |
| SSWPUMBAUF | Treasury: Transfer Flow for Forex Swap Expenses | TB_SSWPUMB | TZB0A | CHAR (4) |
| SSWPUMBERT | Treasury: Transfer Flow for Foreign Exchange Swap Revenue | TB_SSWPUER | TZB0A | CHAR (4) |
| RANTYP | Contract Type | RANTYP | CHAR (1) | |
| STSMA | Status Profile | J_STSMA | TJ20 | CHAR (8) |
| DATE_RULE | Date Rule to Determine Due Date | TB_DATE_RULE | ATDR | CHAR (10) |
| SREALGET | Treasury: Flow Type for Realized Gains | TB_SREALGE | TZB0A | CHAR (4) |
| SREALVET | Treasury: Flow Type for Realized Losses | TB_SREALVE | TZB0A | CHAR (4) |
| FLAG_FLAT | Indicator: Traded Flat | TB_FLAG_FLAT | CHAR (1) | |
| SNOMPAY | Difference Between Payment Amount and Nominal Amount | TM_SNOMPAY | CHAR (1) | |
| FLG_INIT_MARGIN | Indicator: Generate Initial Margin Flow | TB_INIT_MARGIN | CHAR (1) | |
| POS_LOCK_CAT | Type of Position Lock | TB_POS_LOCK | NUMC (1) | |
| USGSART | Product type of underlying | TB_USGSART | CHAR (3) | |
| USFHAART | Transaction Type of Underlying | TB_USFHAAR | CHAR (3) | |
| LOCK_REASON | Block type for restraint on disposal | SSPERR | TW17 | CHAR (3) |
| AUTOSETTLE | Automatic Settlement on Counterconfirmation | FTR_SETLMNT_FLG | CHAR (1) | |
| PHYSICALDEL | Consider physical delivery | FTR_PHYDEL_FLG | CHAR (1) | |
| USENETTING | Use Netting | FTR_USENETTING | CHAR (1) | |
| LOC_CURR_RULE | Exchange rate for translation to local currency | TB_EXTRANSLOC | CHAR (1) | |
| SIDE_CAT_IN | Side Category for the Incoming Side of a Swap | FTR_SWAP_SIDE_CAT_INCOMING | NUMC (1) | |
| SIDE_CAT_OUT | Side Category for the Outgoing Side of a Swap | FTR_SWAP_SIDE_CAT_OUTGOING | NUMC (1) | |
| SWAP_SYMMETRY | Indicates How Swap Symmetry Is Handled | FTR_SWAP_SYMMETRY | NUMC (1) | |
| SWAP_CAPTURE_BEH | Activates Multiple Flow Generation for Commodity Swaps | FTR_COMS_MULTPLE_FLOW_GEN | CHAR (1) | |
| COM_PRICE_DETERM | Determination of Commodity Price | FTR_COM_PRICE_DETERM | CHAR (1) | |
| COM_AVG_CAPT_CAT | Average Price Capture Category for Commodity Forward | FTR_COMF_AVG_CAPTURE_CAT | CHAR (1) | |
| AUTOEXECUTE | Automatic Order execute on Counterconfirmation | FTR_ORDEXEC_FLG | CHAR (1) | |
| SPOT_INDICATOR | Indicator for Spot Transaction | FTR_SPOT_IND | CHAR (1) | |
| SPOT_MATYPE | Price Type of Spot Rate at Maturity | FTR_SPOT_MATYPE | CHAR (2) | |
| SPOT_RATE_STRATEGY | Define Spot Rate Determination | TTM_FX_RATE_STRATEGY | CHAR (1) |
