AT10 is a standard SAP table in SAP ERP (or) S/4HANA which stores Transaction Types data. There are total 62 fields in AT10 table.This blog post provides key technical details of SAP table AT10, including its availability across SAP S/4HANA versions and the list of CDS views for AT10 table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
| Package | R/3 appl. development for Treasury money,forex,forward gen (FTA) |
| Technical Component | Transaction Manager (FIN-FSCM-TRM-TM) |
SAP AT10 Table Fields
The following is the list of fields that are available in SAP AT10 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) |
| SGSART | Product Type | VVSART | VVSART | TZPA | CHAR (3) |
| SFHAART | Financial Transaction Type | TB_SFHAART | T_SFHAART | CHAR (3) | |
| SFGTYP | Transaction Category | TB_SFGTYP | T_SFGTYP | AT01 | NUMC (3) |
| NUMKR | Number Range for Transactions | TB_NUMKRG | CHAR2 | CHAR (2) | |
| NUMKRANG | Number Range for Offers/Quotations | NUMKRANG | CHAR2 | CHAR (2) | |
| NUMKRSIM | Number Range for Simulated Transactions | NUMKRSIM | CHAR2 | CHAR (2) | |
| ABWTYP | Processing Category | TB_ABWTYP | T_ABWTYP | AT05 | CHAR (5) |
| SAUTOBUCH | Automatic Posting Release | TB_SAUTOB | XFELD | CHAR (1) | |
| UNUMKR | Number Range for Underlying | TB_UNUMKR | CHAR2 | CHAR (2) | |
| SLPG | Limit Product Group | TB_SLPG | T_SLPG | ATLPG | CHAR (3) |
| SROUND | Rounding Type | TB_SROUND | T_SROUND | CHAR (1) | |
| RROUND | Rounding unit | TB_RROUND | T_RROUND | INT1 (3) | |
| SBSTDCP | Basic Principle of Commercial Paper Position | TM_SBSTDCP | T_SBSTDCP | CHAR (1) | |
| SCOMPCP | Exponential Discounting for Terms over 1 Year | TM_SCOMPCP | XFELD | CHAR (1) | |
| AHJFA | Number of Half-Years for Generating Cash Flow | TB_AHJFA | NUMC2 | NUMC (2) | |
| SREALGE | Treasury: Flow Type for Realized Gains | TB_SREALGE | SBEWART | TZB0A | CHAR (4) |
| SREALVE | Treasury: Flow Type for Realized Losses | TB_SREALVE | SBEWART | TZB0A | CHAR (4) |
| SBESTABT | Treasury: Flow Type for Position Write-Downs | TB_SBESTAB | SBEWART | TZB0A | CHAR (4) |
| SBESTZUT | Treasury: Flow Type for Position Write-Ups | TB_SBESTZU | SBEWART | TZB0A | CHAR (4) |
| SBESTAB | Treasury: Flow Type for Position Write-Downs | TB_SBESTAB | SBEWART | TZB0A | CHAR (4) |
| SBESTZU | Treasury: Flow Type for Position Write-Ups | TB_SBESTZU | SBEWART | TZB0A | CHAR (4) |
| SRUEBIL | Treasury: Flow Type for Provisions to Be Created | TB_SRUEBIL | SBEWART | TZB0A | CHAR (4) |
| SRUEAUF | Treasury: Flow Type for Reversing Provisions | TB_SRUEAUF | SBEWART | TZB0A | CHAR (4) |
| SGEWBIL | Treasury: Flow Type for Unrealized Gains to Be Disclosed | TB_SGEWBIL | SBEWART | TZB0A | CHAR (4) |
| SGEWAUF | Treasury: Flow Type for Writing Back Unrealized Gains | TB_SGEWAUF | SBEWART | TZB0A | CHAR (4) |
| SSWAPERT | Treasury: Flow Type for Accrued/Deferred Forex Swap Revenue | TB_SWAPERT | SBEWART | TZB0A | CHAR (4) |
| SSWAPERAUF | Treasury: Flow Type for Writing Back Accrd/Defd Fx Swap Rev. | TB_SWPERAU | SBEWART | TZB0A | CHAR (4) |
| SSWAPAUF | Treasury: Flow Type for Accrued/Deferred Forex Swap Expenses | TB_SWAPAUF | SBEWART | TZB0A | CHAR (4) |
| SSWAPAUAUF | Treasury: Flow Type f. Writing Back Accrd/Defrd Fx Swap Exp. | TB_SWPAUAU | SBEWART | TZB0A | CHAR (4) |
| SRUESWP | Treasury: Flow Type for Creating Provisions – Swap | TB_SWRUEBI | SBEWART | TZB0A | CHAR (4) |
| SRUEAUFSWP | Treasury: Flow Type for Clearing Provisons – Swap | TB_SWRUEAU | SBEWART | TZB0A | CHAR (4) |
| SGEWSWP | Treasury: Flow Type for Disclosing Unrealized Gains – Swap | TB_SWGWBIL | SBEWART | TZB0A | CHAR (4) |
| SGEWAUFSWP | Treasury: Flow Type for Clearing Unrealized Swap Gains | TB_SWGWAUF | SBEWART | TZB0A | CHAR (4) |
| SSWPUMBAUF | Treasury: Transfer Flow for Forex Swap Expenses | TB_SSWPUMB | SBEWART | TZB0A | CHAR (4) |
| SSWPUMBERT | Treasury: Transfer Flow for Foreign Exchange Swap Revenue | TB_SSWPUER | SBEWART | TZB0A | CHAR (4) |
| RANTYP | Contract Type | RANTYP | RANTYP | CHAR (1) | |
| STSMA | Status Profile | J_STSMA | J_STSMA | TJ20 | CHAR (8) |
| DATE_RULE | Date Rule to Determine Due Date | TB_DATE_RULE | TB_DATE_RULE | ATDR | CHAR (10) |
| SREALGET | Treasury: Flow Type for Realized Gains | TB_SREALGE | SBEWART | TZB0A | CHAR (4) |
| SREALVET | Treasury: Flow Type for Realized Losses | TB_SREALVE | SBEWART | TZB0A | CHAR (4) |
| FLAG_FLAT | Indicator: Traded Flat | TB_FLAG_FLAT | XFELD | CHAR (1) | |
| SNOMPAY | Difference Between Payment Amount and Nominal Amount | TM_SNOMPAY | T_SNOMPAY | CHAR (1) | |
| FLG_INIT_MARGIN | Indicator: Generate Initial Margin Flow | TB_INIT_MARGIN | XFELD | CHAR (1) | |
| POS_LOCK_CAT | Type of Position Lock | TB_POS_LOCK | T_POS_LOCK | NUMC (1) | |
| USGSART | Product type of underlying | TB_USGSART | VVSART | CHAR (3) | |
| USFHAART | Transaction Type of Underlying | TB_USFHAAR | T_SFHAART | CHAR (3) | |
| LOCK_REASON | Block type for restraint on disposal | SSPERR | SSPERR | TW17 | CHAR (3) |
| AUTOSETTLE | Automatic Settlement on Counterconfirmation | FTR_SETLMNT_FLG | XFELD | CHAR (1) | |
| PHYSICALDEL | Consider physical delivery | FTR_PHYDEL_FLG | XFELD | CHAR (1) | |
| USENETTING | Use Netting | FTR_USENETTING | XFELD | CHAR (1) | |
| LOC_CURR_RULE | Exchange rate for translation to local currency | TB_EXTRANSLOC | T_EXTRANSLOC | CHAR (1) | |
| SIDE_CAT_IN | Side Category for the Incoming Side of a Swap | FTR_SWAP_SIDE_CAT_INCOMING | FTR_SWAP_SIDE_CATEGORY | NUMC (1) | |
| SIDE_CAT_OUT | Side Category for the Outgoing Side of a Swap | FTR_SWAP_SIDE_CAT_OUTGOING | FTR_SWAP_SIDE_CATEGORY | NUMC (1) | |
| SWAP_SYMMETRY | Indicates How Swap Symmetry Is Handled | FTR_SWAP_SYMMETRY | FTR_SWAP_SYMMETRY_DOMAIN | NUMC (1) | |
| SWAP_CAPTURE_BEH | Activates Multiple Flow Generation for Commodity Swaps | FTR_COMS_MULTPLE_FLOW_GEN | FTR_COMS_MULTPLE_FLOW_GEN | CHAR (1) | |
| COM_PRICE_DETERM | Determination of Commodity Price | FTR_COM_PRICE_DETERM | FTR_COM_PRICE_DETERM | CHAR (1) | |
| COM_AVG_CAPT_CAT | Average Price Capture Category for Commodity Forward | FTR_COMF_AVG_CAPTURE_CAT | FTR_COMF_AVG_CAPTURE_CAT | CHAR (1) | |
| AUTOEXECUTE | Automatic Order execute on Counterconfirmation | FTR_ORDEXEC_FLG | XFELD | CHAR (1) | |
| SPOT_INDICATOR | Indicator for Spot Transaction | FTR_SPOT_IND | FLAG | CHAR (1) | |
| SPOT_MATYPE | Price Type of Spot Rate at Maturity | FTR_SPOT_MATYPE | VVSKURSART | CHAR (2) | |
| SPOT_RATE_STRATEGY | Define Spot Rate Determination | TTM_FX_RATE_STRATEGY | TTM_FX_RATE_STRATEGY | CHAR (1) |
Availability
The SAP table AT10 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 AT10 table
The following is the list of AT10 CDS views, which can also be used instead of AT10 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_FINANCIALINSTRTRANSTYPE | BASIC | Transaction Type |
| I_FINANCIALTRANSACCASHFLOW | BASIC | Financial Transaction Cash Flows |
| I_FTR_FAC_TRANS_CAT | BASIC | Facility Related Transaction Category |
| P_POSTINGJOURNAL | BASIC | Posting Journal |
| A_TRSYPOSTGJRNLENTRITM | COMPOSITE | Treasury Posting Journal Entry |
| I_BANKGUARANTEEOVERVIEW | COMPOSITE | Cube View for Bank Guarantee Overview |
| I_FINTRANSMATURITYCASHFLOW | COMPOSITE | Transaction Maturity Cash Flow in DC |
| I_FTR_CL_UTILIZE | COMPOSITE | Facility Utilization With Contract Info |
| I_FTR_CL_UTIL_CUBE | COMPOSITE | Facility Utilization Data Cube |
| I_FTR_CL_UTIL_WITH_RATIO | COMPOSITE | Facility Utilization With Ratio |
| I_MATURITYPROFILE | COMPOSITE | Financial Transaction Maturity Profile |
| I_MATURITYPROFILECASHFLOW | COMPOSITE | Maturity Profile Cash Flow Data – Cube |
| P_DEBTINVESTMENTMATURITYFLOW | COMPOSITE | Flows For Debt and Investment Maturity |
| P_FINTRANSMATCSHFLWWTHCNDN | COMPOSITE | Maturity Cash Flow with Condition |
| P_FINTRANSNOMINTRATE | COMPOSITE | Nominal Flows with Applied Int.Rate |
| P_IRM_CA_POS_FLOW_ABS_STATUS | COMPOSITE | CA Style Transaction Position Flow |
| P_IRM_CA_POS_FLOW_WITH_STATUS | COMPOSITE | CA Style Trans. Pos With Prev. Status |
| P_IRM_CA_TRANS_POS_FLOW | COMPOSITE | CA Style Transaction Position Flow |
| P_IRM_TRANS_POS | COMPOSITE | Financial Transaction Position |
| P_IRM_UNIFIED_POS_FLOW | COMPOSITE | Unified Transaction Position Flow |
| P_MATURITYCSHFLWWPREVIOUSTOT | COMPOSITE | Maturity Cash Flow With Previous Total nominal amount |
| P_MATURITYPROFCSHFLWINDISPCRCY | COMPOSITE | Maturity Profile Cash Flow in Display Currency |
| P_MATURITYPROFILECASHFLOW | COMPOSITE | Maturity Profile Cash Flow |
| P_MMNOMINALCHANGEFLOW | COMPOSITE | MM nominal change flow |
| P_SECCLASSNORMFLOWINTRATE | COMPOSITE | Nominal Flows with Sec. Class |
| P_TFTRANSCASHFLOW | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| P_TFTRANSFEECASHFLOW | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| P_TFTRANSFEECASHFLOWTC | COMPOSITE | Fee Flow in transaction currency |
| P_TFTRANSOVERVIEW | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| P_TFTRANSVOLCASHFLOW | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| P_TFTRANSVOLUMEFEEAMT | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| P_TFTRANSVOLUMEFEEAMT2 | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| C_BANKGUARANTEEOVERVIEWQRY | CONSUMPTION | Query for Bank Guarantee Overview |
| C_DEBTANDINVESTMENTANALYSIS | CONSUMPTION | Debt and Investment Analysis |
| C_DEBTINVESTMENTNOMINAL | CONSUMPTION | IR OVP Debt and Investment Nominal |
| C_DEBTINVMTREFINTEREST | CONSUMPTION | Debt/Invest in Reference Interest Rate |
| C_FTR_CL_UTILIZE_QUERY | CONSUMPTION | Credit Line Analysis |
| C_FTR_CL_UTIL_ANALYTICS | CONSUMPTION | Facility Utilization Analytics |
| C_FTR_POSITION_VALUES | CONSUMPTION | Position Values |
| C_INTERESTRATEOVERVIEWSEL | CONSUMPTION | Interest Rate Overview Filters |
| C_INTRSTRATESWAPNOMINAL | CONSUMPTION | Nominal on the IRS out/in. legs |
| C_MATURITYPROFILE | CONSUMPTION | Financial Transaction Maturity Profile |
| C_MATURITYPROFILEQUERY | CONSUMPTION | Query View for Maturity Profile |
| C_POSITIONVALUESEXPDLOSSES | CONSUMPTION | Position Values for Expected Losses |
