SAP Table AT10
Transaction Types
AT10 (Transaction Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AT10 to other SAP tables.
AT10 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
SGSART
Product Type
|
VVSART | TZPA |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
SFHAART
Financial Transaction Type
|
TB_SFHAART |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||||||||
|
SFGTYP
Transaction Category
|
TB_SFGTYP | AT01 |
NUMC
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
NUMKR
Number Range for Transactions
|
TB_NUMKRG |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
NUMKRANG
Number Range for Offers/Quotations
|
NUMKRANG |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
NUMKRSIM
Number Range for Simulated Transactions
|
NUMKRSIM |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
ABWTYP
Processing Category
|
TB_ABWTYP | AT05 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||||||||
|
SAUTOBUCH
Automatic Posting Release
|
TB_SAUTOB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
UNUMKR
Number Range for Underlying
|
TB_UNUMKR |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
SLPG
Limit Product Group
|
TB_SLPG | ATLPG |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
SROUND
Rounding Type
|
TB_SROUND |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
RROUND
Rounding unit
|
TB_RROUND |
INT1
|
3 | 0 | ||||||||||||||||||||||||||||||||||
|
SBSTDCP
Basic Principle of Commercial Paper Position
|
TM_SBSTDCP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SCOMPCP
Exponential discounting for term over 1 year
|
TM_SCOMPCP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
AHJFA
Number of Half-Years for Generating Cash Flow
|
TB_AHJFA |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||||||||
|
SREALGE
Treasury: Flow Type for Realized Gains
|
TB_SREALGE | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SREALVE
Treasury: Flow Type for Realized Losses
|
TB_SREALVE | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SBESTABT
Treasury: Flow type for position writedowns
|
TB_SBESTAB | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SBESTZUT
Treasury: Flow type for position writeups
|
TB_SBESTZU | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SBESTAB
Treasury: Flow type for position writedowns
|
TB_SBESTAB | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SBESTZU
Treasury: Flow type for position writeups
|
TB_SBESTZU | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SRUEBIL
Treasury: Flow type for provisions to be created
|
TB_SRUEBIL | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SRUEAUF
Treasury: Flow type for reversing provisions
|
TB_SRUEAUF | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SGEWBIL
Treasury: Flow type for unrealized gains to be disclosed
|
TB_SGEWBIL | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SGEWAUF
Treasury: Flow type for writing back unrealized gains
|
TB_SGEWAUF | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SSWAPERT
Treasury: flow type for accrued/deferred forex swap revenue
|
TB_SWAPERT | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SSWAPERAUF
Treasury: Flow type for writing back accrd/defd fx swap rev.
|
TB_SWPERAU | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SSWAPAUF
Treasury: flow type for accrued/deferred forex swap expenses
|
TB_SWAPAUF | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SSWAPAUAUF
Treasury: Flow type f. writing back accrd/defrd fx swap exp.
|
TB_SWPAUAU | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SRUESWP
Treasury: Flow type for creating provisions - swap
|
TB_SWRUEBI | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SRUEAUFSWP
Treasury: Flow type for writing back provisons - swap
|
TB_SWRUEAU | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SGEWSWP
Treasury: Flow type for disclosing unrealized gains - swap
|
TB_SWGWBIL | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SGEWAUFSWP
Treasury: Flow type for writing back unrealized swap gains
|
TB_SWGWAUF | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SSWPUMBAUF
Treasury: Transfer flow for forex swap expenses
|
TB_SSWPUMB | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SSWPUMBERT
Treasury: Transfer flow for foreign exchange swap revenue
|
TB_SSWPUER | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
RANTYP
Contract Type
|
RANTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
STSMA
Status Profile
|
J_STSMA | TJ20 |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||||||||
|
DATE_RULE
Date Rule to Determine Due Date
|
TB_DATE_RULE | ATDR |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||||||||
|
SREALGET
Treasury: Flow Type for Realized Gains
|
TB_SREALGE | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
SREALVET
Treasury: Flow Type for Realized Losses
|
TB_SREALVE | TZB0A |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||
|
FLAG_FLAT
Indicator: Traded Flat
|
TB_FLAG_FLAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SNOMPAY
Difference Between Payment Amount and Nominal Amount
|
TM_SNOMPAY |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
FLG_INIT_MARGIN
Indicator: Generate Initial Margin Flow
|
TB_INIT_MARGIN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
POS_LOCK_CAT
Type of Position Lock
|
TB_POS_LOCK |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
USGSART
Product type of underlying
|
TB_USGSART |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||||||||
|
USFHAART
Transaction Type of Underlying
|
TB_USFHAAR |
CHAR
|
3 | 0 | ||||||||||||||||||||||||||||||||||
|
LOCK_REASON
Block type for restraint on disposal
|
SSPERR | TW17 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||
|
AUTOSETTLE
Automatic Settlement on Counterconfirmation
|
FTR_SETLMNT_FLG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
PHYSICALDEL
Consider physical delivery
|
FTR_PHYDEL_FLG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
USENETTING
Use Netting
|
FTR_USENETTING |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
LOC_CURR_RULE
Exchange rate for translation to local currency
|
TB_EXTRANSLOC |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SIDE_CAT_IN
Side Category for the Incoming Side of a Swap
|
FTR_SWAP_SIDE_CAT_INCOMING |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SIDE_CAT_OUT
Side Category for the Outgoing Side of a Swap
|
FTR_SWAP_SIDE_CAT_OUTGOING |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SWAP_SYMMETRY
Indicates How Swap Symmetry Is Handled
|
FTR_SWAP_SYMMETRY |
NUMC
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
SWAP_CAPTURE_BEH
Activates Multiple Flow Generation for Commodity Swaps
|
FTR_COMS_MULTPLE_FLOW_GEN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
COM_PRICE_DETERM
Determination of Commodity Price
|
FTR_COM_PRICE_DETERM |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
COM_AVG_CAPT_CAT
Average Price Capture Category for Commodity Forward
|
FTR_COMF_AVG_CAPTURE_CAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
AT10 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AT10 | ABWTYP | * |
AT05
Processing Categories
|
SANLF | |
| AT10 | ABWTYP | AT10 | SFGTYP |
AT05
Processing Categories
|
SFGTYP |
| AT10 | ABWTYP | AT10 | ABWTYP |
AT05
Processing Categories
|
ABWTYP |
| AT10 | DATE_RULE | AT10 | DATE_RULE |
ATDR
Date Rule
|
DATE_RULE |
| AT10 | DATE_RULE | AT10 | MANDT |
ATDR
Date Rule
|
MANDT |
| AT10 | LOCK_REASON | AT10 | MANDT |
TW17
Blocking flag
|
MANDT |
| AT10 | LOCK_REASON | AT10 | LOCK_REASON |
TW17
Blocking flag
|
SSPERR |
| AT10 | MANDT | AT10 | MANDT |
T000
Clients
|
MANDT |
| AT10 | SBESTAB | AT10 | SBESTAB |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SBESTAB | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SBESTAB | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SBESTABT | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SBESTABT | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SBESTABT | AT10 | SBESTABT |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SBESTZU | AT10 | SBESTZU |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SBESTZU | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SBESTZU | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SBESTZUT | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SBESTZUT | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SBESTZUT | AT10 | SBESTZUT |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SFGTYP | * |
AT01
Transaction Category
|
SANLFOR | |
| AT10 | SFGTYP | AT10 | SFGTYP |
AT01
Transaction Category
|
SFGTYP |
| AT10 | SGEWAUF | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SGEWAUF | AT10 | SGEWAUF |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SGEWAUF | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SGEWAUFSWP | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SGEWAUFSWP | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SGEWAUFSWP | AT10 | SGEWAUFSWP |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SGEWBIL | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SGEWBIL | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SGEWBIL | AT10 | SGEWBIL |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SGEWSWP | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SGEWSWP | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SGEWSWP | AT10 | SGEWSWP |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SGSART | AT10 | MANDT |
TZPA
Financial Assets Management Product Types
|
MANDT |
| AT10 | SGSART | AT10 | SGSART |
TZPA
Financial Assets Management Product Types
|
GSART |
| AT10 | SLPG | AT10 | MANDT |
ATLPG
Limit Product Group
|
MANDT |
| AT10 | SLPG | AT10 | SLPG |
ATLPG
Limit Product Group
|
SLPG |
| AT10 | SREALGE | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SREALGE | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SREALGE | AT10 | SREALGE |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SREALGET | AT10 | SREALGET |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SREALGET | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SREALGET | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SREALVE | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SREALVE | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SREALVE | AT10 | SREALVE |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SREALVET | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SREALVET | AT10 | SREALVET |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SREALVET | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SRUEAUF | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SRUEAUF | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SRUEAUF | AT10 | SRUEAUF |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SRUEAUFSWP | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SRUEAUFSWP | AT10 | SRUEAUFSWP |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SRUEAUFSWP | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SRUEBIL | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SRUEBIL | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SRUEBIL | AT10 | SRUEBIL |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SRUESWP | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SRUESWP | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SRUESWP | AT10 | SRUESWP |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SSWAPAUAUF | AT10 | SSWAPAUAUF |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SSWAPAUAUF | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SSWAPAUAUF | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SSWAPAUF | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SSWAPAUF | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SSWAPAUF | AT10 | SSWAPAUF |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SSWAPERAUF | AT10 | SSWAPERAUF |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SSWAPERAUF | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SSWAPERAUF | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SSWAPERT | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SSWAPERT | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SSWAPERT | AT10 | SSWAPERT |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SSWPUMBAUF | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SSWPUMBAUF | AT10 | SSWPUMBAUF |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | SSWPUMBAUF | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SSWPUMBERT | AT10 | MANDT |
TZB0A
Definition of flow types
|
MANDT |
| AT10 | SSWPUMBERT | AT10 | RANTYP |
TZB0A
Definition of flow types
|
RANTYP |
| AT10 | SSWPUMBERT | AT10 | SSWPUMBERT |
TZB0A
Definition of flow types
|
SBEWART |
| AT10 | STSMA | AT10 | STSMA |
TJ20
Status profiles
|
STSMA |
| AT10 | STSMA | AT10 | MANDT |
TJ20
Status profiles
|
MANDT |