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
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
X Yes
NULL No
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
NULL No rounding
A Rounding to defined number of places after decimal
B Rounding to the defined denominator
RROUND Rounding unit TB_RROUND INT1 3 0
SBSTDCP Basic Principle of Commercial Paper Position TM_SBSTDCP CHAR 1 0
NULL Net Present Value
X Nominal Value
Y Nominal Value Without Interest Flow
SCOMPCP Exponential discounting for term over 1 year TM_SCOMPCP CHAR 1 0
X Yes
NULL No
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
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
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
X Yes
NULL No
SNOMPAY Difference Between Payment Amount and Nominal Amount TM_SNOMPAY CHAR 1 0
NULL No Difference
X Possible Difference
FLG_INIT_MARGIN Indicator: Generate Initial Margin Flow TB_INIT_MARGIN CHAR 1 0
X Yes
NULL No
POS_LOCK_CAT Type of Position Lock TB_POS_LOCK NUMC 1 0
1 No Lock
2 Lock Generates Warning
3 Lock Generates Error Message
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
X Yes
NULL No
PHYSICALDEL Consider physical delivery FTR_PHYDEL_FLG CHAR 1 0
X Yes
NULL No
USENETTING Use Netting FTR_USENETTING CHAR 1 0
X Yes
NULL No
LOC_CURR_RULE Exchange rate for translation to local currency TB_EXTRANSLOC CHAR 1 0
1 Current Rate
2 Exchange Rate Fixed
3 Fixed Amount
SIDE_CAT_IN Side Category for the Incoming Side of a Swap FTR_SWAP_SIDE_CAT_INCOMING NUMC 1 0
0 Not Specified
1 Fixed Side
2 Floating Side
3 Floating Side with Average Pricing
SIDE_CAT_OUT Side Category for the Outgoing Side of a Swap FTR_SWAP_SIDE_CAT_OUTGOING NUMC 1 0
0 Not Specified
1 Fixed Side
2 Floating Side
3 Floating Side with Average Pricing
SWAP_SYMMETRY Indicates How Swap Symmetry Is Handled FTR_SWAP_SYMMETRY NUMC 1 0
0 No Symmetry
1 Proposed Symmetry
2 Forced Symmetry
SWAP_CAPTURE_BEH Activates Multiple Flow Generation for Commodity Swaps FTR_COMS_MULTPLE_FLOW_GEN CHAR 1 0
NULL Not Available
1 To Be Activated for Each Transaction
2 Activated by Default
COM_PRICE_DETERM Determination of Commodity Price FTR_COM_PRICE_DETERM CHAR 1 0
NULL Not Specified
0 Fixed Price
1 Average Price
COM_AVG_CAPT_CAT Average Price Capture Category for Commodity Forward FTR_COMF_AVG_CAPTURE_CAT CHAR 1 0
NULL Not Specified
1 Single Price Index
2 Multiple Price Indexes

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 MANDT ATDR Date Rule MANDT
AT10 DATE_RULE AT10 DATE_RULE ATDR Date Rule DATE_RULE
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 MANDT TZB0A Definition of flow types MANDT
AT10 SBESTAB AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SBESTAB AT10 SBESTAB TZB0A Definition of flow types SBEWART
AT10 SBESTABT AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SBESTABT AT10 SBESTABT TZB0A Definition of flow types SBEWART
AT10 SBESTABT AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SBESTZU AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SBESTZU AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SBESTZU AT10 SBESTZU TZB0A Definition of flow types SBEWART
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 SGEWAUF TZB0A Definition of flow types SBEWART
AT10 SGEWAUF AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SGEWAUF AT10 RANTYP TZB0A Definition of flow types RANTYP
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 SGEWBIL 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 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 RANTYP TZB0A Definition of flow types RANTYP
AT10 SREALGE AT10 SREALGE TZB0A Definition of flow types SBEWART
AT10 SREALGE AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SREALGET AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SREALGET AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SREALGET AT10 SREALGET TZB0A Definition of flow types SBEWART
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 MANDT TZB0A Definition of flow types MANDT
AT10 SREALVET AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SREALVET AT10 SREALVET TZB0A Definition of flow types SBEWART
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 SRUEAUFSWP TZB0A Definition of flow types SBEWART
AT10 SRUEAUFSWP AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SRUEAUFSWP AT10 RANTYP TZB0A Definition of flow types RANTYP
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 RANTYP TZB0A Definition of flow types RANTYP
AT10 SRUESWP AT10 SRUESWP TZB0A Definition of flow types SBEWART
AT10 SRUESWP AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SSWAPAUAUF AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SSWAPAUAUF AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SSWAPAUAUF AT10 SSWAPAUAUF TZB0A Definition of flow types SBEWART
AT10 SSWAPAUF AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SSWAPAUF AT10 SSWAPAUF TZB0A Definition of flow types SBEWART
AT10 SSWAPAUF AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SSWAPERAUF AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SSWAPERAUF AT10 RANTYP TZB0A Definition of flow types RANTYP
AT10 SSWAPERAUF AT10 SSWAPERAUF TZB0A Definition of flow types SBEWART
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 SSWPUMBAUF TZB0A Definition of flow types SBEWART
AT10 SSWPUMBAUF AT10 MANDT TZB0A Definition of flow types MANDT
AT10 SSWPUMBAUF AT10 RANTYP TZB0A Definition of flow types RANTYP
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 MANDT TJ20 Status profiles MANDT
AT10 STSMA AT10 STSMA TJ20 Status profiles STSMA