AT10 SAP (Transaction Types) Table details
Dictionary Type: Table
Description: Transaction Types
Description: Transaction Types
Table field list including key, data, relationships and ABAP select examples
AT10 is a standard SAP Table which is used to store Transaction Types data and is available within R/3 SAP systems depending on the version and release level.
The AT10 table consists of various fields, each holding specific information or linking keys about Transaction Types data available in SAP. These include SGSART (Product Type), SFHAART (Financial Transaction Type), SFGTYP (Transaction Category), NUMKR (Number Range for Transactions).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = AT10T
SAP AT10 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SGSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | T_SFHAART | T02 | C_AT10 | ||
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | AT01 | T_SFGTYP | |||
NUMKR | Number Range for Transactions | TB_NUMKRG | CHAR | 2 | CHAR2 | ||||
NUMKRANG | Number Range for Offers/Quotations | NUMKRANG | CHAR | 2 | CHAR2 | ||||
NUMKRSIM | Number Range for Simulated Transactions | NUMKRSIM | CHAR | 2 | CHAR2 | ||||
ABWTYP | Processing Category | TB_ABWTYP | CHAR | 5 | AT05 | T_ABWTYP | |||
SAUTOBUCH | Automatic Posting Release | TB_SAUTOB | CHAR | 1 | XFELD | ||||
UNUMKR | Number Range for Underlying | TB_UNUMKR | CHAR | 2 | CHAR2 | ||||
SLPG | Limit Product Group | TB_SLPG | CHAR | 3 | ATLPG | T_SLPG | TB_SLPG | ||
SROUND | Rounding Type | TB_SROUND | CHAR | 1 | T_SROUND | ||||
RROUND | Rounding unit | TB_RROUND | INT1 | 3 | T_RROUND | ||||
SBSTDCP | Basic Principle of Commercial Paper Position | TM_SBSTDCP | CHAR | 1 | T_SBSTDCP | ||||
SCOMPCP | Exponential discounting for term over 1 year | TM_SCOMPCP | CHAR | 1 | XFELD | ||||
AHJFA | Number of Half-Years for Generating Cash Flow | TB_AHJFA | NUMC | 2 | NUMC2 | ||||
SREALGE | Treasury: Flow Type for Realized Gains | TB_SREALGE | CHAR | 4 | TZB0A | SBEWART | |||
SREALVE | Treasury: Flow Type for Realized Losses | TB_SREALVE | CHAR | 4 | TZB0A | SBEWART | |||
SBESTABT | Treasury: Flow type for position writedowns | TB_SBESTAB | CHAR | 4 | TZB0A | SBEWART | |||
SBESTZUT | Treasury: Flow type for position writeups | TB_SBESTZU | CHAR | 4 | TZB0A | SBEWART | |||
SBESTAB | Treasury: Flow type for position writedowns | TB_SBESTAB | CHAR | 4 | TZB0A | SBEWART | |||
SBESTZU | Treasury: Flow type for position writeups | TB_SBESTZU | CHAR | 4 | TZB0A | SBEWART | |||
SRUEBIL | Treasury: Flow type for provisions to be created | TB_SRUEBIL | CHAR | 4 | TZB0A | SBEWART | |||
SRUEAUF | Treasury: Flow type for reversing provisions | TB_SRUEAUF | CHAR | 4 | TZB0A | SBEWART | |||
SGEWBIL | Treasury: Flow type for unrealized gains to be disclosed | TB_SGEWBIL | CHAR | 4 | TZB0A | SBEWART | |||
SGEWAUF | Treasury: Flow type for writing back unrealized gains | TB_SGEWAUF | CHAR | 4 | TZB0A | SBEWART | |||
SSWAPERT | Treasury: flow type for accrued/deferred forex swap revenue | TB_SWAPERT | CHAR | 4 | TZB0A | SBEWART | |||
SSWAPERAUF | Treasury: Flow type for writing back accrd/defd fx swap rev. | TB_SWPERAU | CHAR | 4 | TZB0A | SBEWART | |||
SSWAPAUF | Treasury: flow type for accrued/deferred forex swap expenses | TB_SWAPAUF | CHAR | 4 | TZB0A | SBEWART | |||
SSWAPAUAUF | Treasury: Flow type f. writing back accrd/defrd fx swap exp. | TB_SWPAUAU | CHAR | 4 | TZB0A | SBEWART | |||
SRUESWP | Treasury: Flow type for creating provisions - swap | TB_SWRUEBI | CHAR | 4 | TZB0A | SBEWART | |||
SRUEAUFSWP | Treasury: Flow type for writing back provisons - swap | TB_SWRUEAU | CHAR | 4 | TZB0A | SBEWART | |||
SGEWSWP | Treasury: Flow type for disclosing unrealized gains - swap | TB_SWGWBIL | CHAR | 4 | TZB0A | SBEWART | |||
SGEWAUFSWP | Treasury: Flow type for writing back unrealized swap gains | TB_SWGWAUF | CHAR | 4 | TZB0A | SBEWART | |||
SSWPUMBAUF | Treasury: Transfer flow for forex swap expenses | TB_SSWPUMB | CHAR | 4 | TZB0A | SBEWART | |||
SSWPUMBERT | Treasury: Transfer flow for foreign exchange swap revenue | TB_SSWPUER | CHAR | 4 | TZB0A | SBEWART | |||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
STSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
DATE_RULE | Date Rule to Determine Due Date | TB_DATE_RULE | CHAR | 10 | ATDR | TB_DATE_RULE | |||
SREALGET | Treasury: Flow Type for Realized Gains | TB_SREALGE | CHAR | 4 | TZB0A | SBEWART | |||
SREALVET | Treasury: Flow Type for Realized Losses | TB_SREALVE | CHAR | 4 | TZB0A | SBEWART | |||
FLAG_FLAT | Indicator: Traded Flat | TB_FLAG_FLAT | CHAR | 1 | XFELD | ||||
SNOMPAY | Difference Between Payment Amount and Nominal Amount | TM_SNOMPAY | CHAR | 1 | T_SNOMPAY | ||||
FLG_INIT_MARGIN | Indicator: Generate Initial Margin Flow | TB_INIT_MARGIN | CHAR | 1 | XFELD | ||||
POS_LOCK_CAT | Type of Position Lock | TB_POS_LOCK | NUMC | 1 | T_POS_LOCK | ||||
USGSART | Product type of underlying | TB_USGSART | CHAR | 3 | Assigned to domain | VVSART | |||
USFHAART | Transaction Type of Underlying | TB_USFHAAR | CHAR | 3 | Assigned to domain | T_SFHAART | |||
LOCK_REASON | Block type for restraint on disposal | SSPERR | CHAR | 3 | TW17 | SSPERR | |||
AUTOSETTLE | Automatic Settlement on Counterconfirmation | FTR_SETLMNT_FLG | CHAR | 1 | XFELD | ||||
PHYSICALDEL | Consider physical delivery | FTR_PHYDEL_FLG | CHAR | 1 | XFELD | ||||
USENETTING | Use Netting | FTR_USENETTING | CHAR | 1 | XFELD | ||||
LOC_CURR_RULE | Exchange rate for translation to local currency | TB_EXTRANSLOC | CHAR | 1 | T_EXTRANSLOC | ||||
SIDE_CAT_IN | Side Category for the Incoming Side of a Swap | FTR_SWAP_SIDE_CAT_INCOMING | NUMC | 1 | FTR_SWAP_SIDE_CATEGORY | ||||
SIDE_CAT_OUT | Side Category for the Outgoing Side of a Swap | FTR_SWAP_SIDE_CAT_OUTGOING | NUMC | 1 | FTR_SWAP_SIDE_CATEGORY | ||||
SWAP_SYMMETRY | Indicates How Swap Symmetry Is Handled | FTR_SWAP_SYMMETRY | NUMC | 1 | FTR_SWAP_SYMMETRY_DOMAIN | ||||
SWAP_CAPTURE_BEH | Activates Multiple Flow Generation for Commodity Swaps | FTR_COMS_MULTPLE_FLOW_GEN | CHAR | 1 | FTR_COMS_MULTPLE_FLOW_GEN | ||||
COM_PRICE_DETERM | Determination of Commodity Price | FTR_COM_PRICE_DETERM | CHAR | 1 | FTR_COM_PRICE_DETERM | ||||
COM_AVG_CAPT_CAT | Average Price Capture Category for Commodity Forward | FTR_COMF_AVG_CAPTURE_CAT | CHAR | 1 | FTR_COMF_AVG_CAPTURE_CAT |
Key field | Non-key field |
How do I retrieve data from SAP table AT10 using ABAP code
The following ABAP code Example will allow you to do a basic selection on AT10 to SELECT all data from the tableDATA: WA_AT10 TYPE AT10.
SELECT SINGLE *
FROM AT10
INTO CORRESPONDING FIELDS OF WA_AT10
WHERE...
How to access SAP table AT10
Within an ECC or HANA version of SAP you can also view further information about AT10 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects