SAP table AT10 (Transaction Types)

SAP table AT10 has 3 primary key fields being MANDT,SGSART,SFHAART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SGSART Product Type CHAR 3 0 TZPA VVSART
SFHAART Financial Transaction Type CHAR 3 0 TB_SFHAART
SFGTYP Transaction Category NUMC 3 0 AT01 TB_SFGTYP
NUMKR Number Range for Transactions CHAR 2 0 TB_NUMKRG
NUMKRANG Number Range for Offers/Quotations CHAR 2 0 NUMKRANG
NUMKRSIM Number Range for Simulated Transactions CHAR 2 0 NUMKRSIM
ABWTYP Processing Category CHAR 5 0 AT05 TB_ABWTYP
SAUTOBUCH Automatic Posting Release CHAR 1 0 TB_SAUTOB
UNUMKR Number Range for Underlying CHAR 2 0 TB_UNUMKR
SLPG Limit Product Group CHAR 3 0 ATLPG TB_SLPG
SROUND Rounding Type CHAR 1 0 TB_SROUND
RROUND Rounding unit INT1 3 0 TB_RROUND
SBSTDCP Basic Principle of Commercial Paper Position CHAR 1 0 TM_SBSTDCP
SCOMPCP Exponential Discounting for Terms over 1 Year CHAR 1 0 TM_SCOMPCP
AHJFA Number of Half-Years for Generating Cash Flow NUMC 2 0 TB_AHJFA
SREALGE Treasury: Flow Type for Realized Gains CHAR 4 0 TZB0A TB_SREALGE
SREALVE Treasury: Flow Type for Realized Losses CHAR 4 0 TZB0A TB_SREALVE
SBESTABT Treasury: Flow Type for Position Write-Downs CHAR 4 0 TZB0A TB_SBESTAB
SBESTZUT Treasury: Flow Type for Position Write-Ups CHAR 4 0 TZB0A TB_SBESTZU
SBESTAB Treasury: Flow Type for Position Write-Downs CHAR 4 0 TZB0A TB_SBESTAB
SBESTZU Treasury: Flow Type for Position Write-Ups CHAR 4 0 TZB0A TB_SBESTZU
SRUEBIL Treasury: Flow Type for Provisions to Be Created CHAR 4 0 TZB0A TB_SRUEBIL
SRUEAUF Treasury: Flow Type for Reversing Provisions CHAR 4 0 TZB0A TB_SRUEAUF
SGEWBIL Treasury: Flow Type for Unrealized Gains to Be Disclosed CHAR 4 0 TZB0A TB_SGEWBIL
SGEWAUF Treasury: Flow Type for Writing Back Unrealized Gains CHAR 4 0 TZB0A TB_SGEWAUF
SSWAPERT Treasury: Flow Type for Accrued/Deferred Forex Swap Revenue CHAR 4 0 TZB0A TB_SWAPERT
SSWAPERAUF Treasury: Flow Type for Writing Back Accrd/Defd Fx Swap Rev. CHAR 4 0 TZB0A TB_SWPERAU
SSWAPAUF Treasury: Flow Type for Accrued/Deferred Forex Swap Expenses CHAR 4 0 TZB0A TB_SWAPAUF
SSWAPAUAUF Treasury: Flow Type f. Writing Back Accrd/Defrd Fx Swap Exp. CHAR 4 0 TZB0A TB_SWPAUAU
SRUESWP Treasury: Flow Type for Creating Provisions - Swap CHAR 4 0 TZB0A TB_SWRUEBI
SRUEAUFSWP Treasury: Flow Type for Clearing Provisons - Swap CHAR 4 0 TZB0A TB_SWRUEAU
SGEWSWP Treasury: Flow Type for Disclosing Unrealized Gains - Swap CHAR 4 0 TZB0A TB_SWGWBIL
SGEWAUFSWP Treasury: Flow Type for Clearing Unrealized Swap Gains CHAR 4 0 TZB0A TB_SWGWAUF
SSWPUMBAUF Treasury: Transfer Flow for Forex Swap Expenses CHAR 4 0 TZB0A TB_SSWPUMB
SSWPUMBERT Treasury: Transfer Flow for Foreign Exchange Swap Revenue CHAR 4 0 TZB0A TB_SSWPUER
RANTYP Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
DATE_RULE Date Rule to Determine Due Date CHAR 10 0 ATDR TB_DATE_RULE
SREALGET Treasury: Flow Type for Realized Gains CHAR 4 0 TZB0A TB_SREALGE
SREALVET Treasury: Flow Type for Realized Losses CHAR 4 0 TZB0A TB_SREALVE
FLAG_FLAT Indicator: Traded Flat CHAR 1 0 TB_FLAG_FLAT
SNOMPAY Difference Between Payment Amount and Nominal Amount CHAR 1 0 TM_SNOMPAY
FLG_INIT_MARGIN Indicator: Generate Initial Margin Flow CHAR 1 0 TB_INIT_MARGIN
POS_LOCK_CAT Type of Position Lock NUMC 1 0 TB_POS_LOCK
USGSART Product Type of Underlying CHAR 3 0 TB_USGSART
USFHAART Transaction Type of Underlying CHAR 3 0 TB_USFHAAR
LOCK_REASON Block type for restraint on disposal CHAR 3 0 TW17 SSPERR
AUTOSETTLE Automatic Settlement After Counterconfirmation CHAR 1 0 FTR_SETLMNT_FLG
PHYSICALDEL Consider physical delivery CHAR 1 0 FTR_PHYDEL_FLG
USENETTING Use Netting CHAR 1 0 FTR_USENETTING
LOC_CURR_RULE Exchange rate for translation to local currency CHAR 1 0 TB_EXTRANSLOC
SIDE_CAT_IN Side Category for the Incoming Side of a Swap NUMC 1 0 FTR_SWAP_SIDE_CAT_INCOMING
SIDE_CAT_OUT Side Category for the Outgoing Side of a Swap NUMC 1 0 FTR_SWAP_SIDE_CAT_OUTGOING
SWAP_SYMMETRY Indicates How Swap Symmetry Is Handled NUMC 1 0 FTR_SWAP_SYMMETRY
SWAP_CAPTURE_BEH Activates Multiple Flow Generation for Commodity Swaps CHAR 1 0 FTR_COMS_MULTPLE_FLOW_GEN
Not Available
1 To Be Activated for Each Transaction
2 Activated by Default
COM_PRICE_DETERM Determination of Commodity Price CHAR 1 0 FTR_COM_PRICE_DETERM
Not Specified
0 Fixed Price
1 Average Price
COM_AVG_CAPT_CAT Average Price Capture Category for Commodity Forward CHAR 1 0 FTR_COMF_AVG_CAPTURE_CAT
Not Specified
1 Single Price Index
2 Multiple Price Indexes
AUTOEXECUTE Automatic Order Execution After Counterconfirmation CHAR 1 0 FTR_ORDEXEC_FLG
SPOT_INDICATOR Indicator for Spot Transaction CHAR 1 0 FTR_SPOT_IND
SPOT_MATYPE Price Type of Spot Rate at Maturity CHAR 2 0 FTR_SPOT_MATYPE
SPOT_RATE_STRATEGY Define Spot Rate Determination CHAR 1 0 TTM_FX_RATE_STRATEGY
Spot Reference as Spot Rate
1 Strike Rate as Spot Rate

AT10 foreign key relationships

Table Field Check Table Check Field
0 AT10 ABWTYP AT05 Processing Categories SANLF
0 AT10 ABWTYP AT05 Processing Categories SFGTYP
0 AT10 ABWTYP AT05 Processing Categories ABWTYP
1 AT10 DATE_RULE ATDR Date Rule DATE_RULE
0 AT10 LOCK_REASON TW17 Blocking flag MANDT
1 AT10 MANDT T000 Clients MANDT
0 AT10 SBESTAB TZB0A Definition of flow types MANDT
0 AT10 SBESTAB TZB0A Definition of flow types SBEWART
1 AT10 SBESTABT TZB0A Definition of flow types MANDT
1 AT10 SBESTABT TZB0A Definition of flow types SBEWART
0 AT10 SBESTZU TZB0A Definition of flow types MANDT
0 AT10 SBESTZU TZB0A Definition of flow types SBEWART
1 AT10 SBESTZUT TZB0A Definition of flow types MANDT
1 AT10 SBESTZUT TZB0A Definition of flow types SBEWART
0 AT10 SFGTYP AT01 Transaction Category SANLFOR
1 AT10 SGEWAUF TZB0A Definition of flow types MANDT
1 AT10 SGEWAUF TZB0A Definition of flow types SBEWART
0 AT10 SGEWAUFSWP TZB0A Definition of flow types MANDT
0 AT10 SGEWAUFSWP TZB0A Definition of flow types SBEWART
1 AT10 SGEWBIL TZB0A Definition of flow types MANDT
1 AT10 SGEWBIL TZB0A Definition of flow types SBEWART
0 AT10 SGEWSWP TZB0A Definition of flow types MANDT
0 AT10 SGEWSWP TZB0A Definition of flow types SBEWART
1 AT10 SGSART TZPA Financial Assets Management Product Types MANDT
1 AT10 SGSART TZPA Financial Assets Management Product Types GSART
0 AT10 SREALGE TZB0A Definition of flow types MANDT
0 AT10 SREALGE TZB0A Definition of flow types SBEWART
1 AT10 SREALGET TZB0A Definition of flow types MANDT
1 AT10 SREALGET TZB0A Definition of flow types SBEWART
0 AT10 SREALVE TZB0A Definition of flow types MANDT
0 AT10 SREALVE TZB0A Definition of flow types SBEWART
1 AT10 SREALVET TZB0A Definition of flow types MANDT
1 AT10 SREALVET TZB0A Definition of flow types SBEWART
0 AT10 SRUEAUF TZB0A Definition of flow types MANDT
0 AT10 SRUEAUF TZB0A Definition of flow types SBEWART
1 AT10 SRUEAUFSWP TZB0A Definition of flow types MANDT
1 AT10 SRUEAUFSWP TZB0A Definition of flow types SBEWART
0 AT10 SRUEBIL TZB0A Definition of flow types MANDT
0 AT10 SRUEBIL TZB0A Definition of flow types SBEWART
1 AT10 SRUESWP TZB0A Definition of flow types MANDT
1 AT10 SRUESWP TZB0A Definition of flow types SBEWART
0 AT10 SSWAPAUAUF TZB0A Definition of flow types MANDT
0 AT10 SSWAPAUAUF TZB0A Definition of flow types SBEWART
1 AT10 SSWAPAUF TZB0A Definition of flow types MANDT
1 AT10 SSWAPAUF TZB0A Definition of flow types SBEWART
0 AT10 SSWAPERAUF TZB0A Definition of flow types MANDT
0 AT10 SSWAPERAUF TZB0A Definition of flow types SBEWART
1 AT10 SSWAPERT TZB0A Definition of flow types MANDT
1 AT10 SSWAPERT TZB0A Definition of flow types SBEWART
0 AT10 SSWPUMBAUF TZB0A Definition of flow types MANDT
0 AT10 SSWPUMBAUF TZB0A Definition of flow types SBEWART
1 AT10 SSWPUMBERT TZB0A Definition of flow types MANDT
1 AT10 SSWPUMBERT TZB0A Definition of flow types SBEWART
0 AT10 STSMA TJ20 Status profiles MANDT
0 AT10 STSMA TJ20 Status profiles STSMA