AT10 SAP (Transaction Types) Table details

Dictionary Type: Table
Description: Transaction Types




ABAP Code to SELECT data from AT10
Related tables to AT10
Access table AT10




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 cust
Display/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
MANDTClient MANDTCLNT3T000MANDT
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
SFHAARTFinancial Transaction Type TB_SFHAARTCHAR3T_SFHAARTT02C_AT10
SFGTYPTransaction Category TB_SFGTYPNUMC3AT01T_SFGTYP
NUMKRNumber Range for Transactions TB_NUMKRGCHAR2CHAR2
NUMKRANGNumber Range for Offers/Quotations NUMKRANGCHAR2CHAR2
NUMKRSIMNumber Range for Simulated Transactions NUMKRSIMCHAR2CHAR2
ABWTYPProcessing Category TB_ABWTYPCHAR5AT05T_ABWTYP
SAUTOBUCHAutomatic Posting Release TB_SAUTOBCHAR1XFELD
UNUMKRNumber Range for Underlying TB_UNUMKRCHAR2CHAR2
SLPGLimit Product Group TB_SLPGCHAR3ATLPGT_SLPGTB_SLPG
SROUNDRounding Type TB_SROUNDCHAR1T_SROUND
RROUNDRounding unit TB_RROUNDINT13T_RROUND
SBSTDCPBasic Principle of Commercial Paper Position TM_SBSTDCPCHAR1T_SBSTDCP
SCOMPCPExponential discounting for term over 1 year TM_SCOMPCPCHAR1XFELD
AHJFANumber of Half-Years for Generating Cash Flow TB_AHJFANUMC2NUMC2
SREALGETreasury: Flow Type for Realized Gains TB_SREALGECHAR4TZB0ASBEWART
SREALVETreasury: Flow Type for Realized Losses TB_SREALVECHAR4TZB0ASBEWART
SBESTABTTreasury: Flow type for position writedowns TB_SBESTABCHAR4TZB0ASBEWART
SBESTZUTTreasury: Flow type for position writeups TB_SBESTZUCHAR4TZB0ASBEWART
SBESTABTreasury: Flow type for position writedowns TB_SBESTABCHAR4TZB0ASBEWART
SBESTZUTreasury: Flow type for position writeups TB_SBESTZUCHAR4TZB0ASBEWART
SRUEBILTreasury: Flow type for provisions to be created TB_SRUEBILCHAR4TZB0ASBEWART
SRUEAUFTreasury: Flow type for reversing provisions TB_SRUEAUFCHAR4TZB0ASBEWART
SGEWBILTreasury: Flow type for unrealized gains to be disclosed TB_SGEWBILCHAR4TZB0ASBEWART
SGEWAUFTreasury: Flow type for writing back unrealized gains TB_SGEWAUFCHAR4TZB0ASBEWART
SSWAPERTTreasury: flow type for accrued/deferred forex swap revenue TB_SWAPERTCHAR4TZB0ASBEWART
SSWAPERAUFTreasury: Flow type for writing back accrd/defd fx swap rev. TB_SWPERAUCHAR4TZB0ASBEWART
SSWAPAUFTreasury: flow type for accrued/deferred forex swap expenses TB_SWAPAUFCHAR4TZB0ASBEWART
SSWAPAUAUFTreasury: Flow type f. writing back accrd/defrd fx swap exp. TB_SWPAUAUCHAR4TZB0ASBEWART
SRUESWPTreasury: Flow type for creating provisions - swap TB_SWRUEBICHAR4TZB0ASBEWART
SRUEAUFSWPTreasury: Flow type for writing back provisons - swap TB_SWRUEAUCHAR4TZB0ASBEWART
SGEWSWPTreasury: Flow type for disclosing unrealized gains - swap TB_SWGWBILCHAR4TZB0ASBEWART
SGEWAUFSWPTreasury: Flow type for writing back unrealized swap gains TB_SWGWAUFCHAR4TZB0ASBEWART
SSWPUMBAUFTreasury: Transfer flow for forex swap expenses TB_SSWPUMBCHAR4TZB0ASBEWART
SSWPUMBERTTreasury: Transfer flow for foreign exchange swap revenue TB_SSWPUERCHAR4TZB0ASBEWART
RANTYPContract Type RANTYPCHAR1RANTYP
STSMAStatus Profile J_STSMACHAR8TJ20J_STSMA
DATE_RULEDate Rule to Determine Due Date TB_DATE_RULECHAR10ATDRTB_DATE_RULE
SREALGETTreasury: Flow Type for Realized Gains TB_SREALGECHAR4TZB0ASBEWART
SREALVETTreasury: Flow Type for Realized Losses TB_SREALVECHAR4TZB0ASBEWART
FLAG_FLATIndicator: Traded Flat TB_FLAG_FLATCHAR1XFELD
SNOMPAYDifference Between Payment Amount and Nominal Amount TM_SNOMPAYCHAR1T_SNOMPAY
FLG_INIT_MARGINIndicator: Generate Initial Margin Flow TB_INIT_MARGINCHAR1XFELD
POS_LOCK_CATType of Position Lock TB_POS_LOCKNUMC1T_POS_LOCK
USGSARTProduct type of underlying TB_USGSARTCHAR3Assigned to domainVVSART
USFHAARTTransaction Type of Underlying TB_USFHAARCHAR3Assigned to domainT_SFHAART
LOCK_REASONBlock type for restraint on disposal SSPERRCHAR3TW17SSPERR
AUTOSETTLEAutomatic Settlement on Counterconfirmation FTR_SETLMNT_FLGCHAR1XFELD
PHYSICALDELConsider physical delivery FTR_PHYDEL_FLGCHAR1XFELD
USENETTINGUse Netting FTR_USENETTINGCHAR1XFELD
LOC_CURR_RULEExchange rate for translation to local currency TB_EXTRANSLOCCHAR1T_EXTRANSLOC
SIDE_CAT_INSide Category for the Incoming Side of a Swap FTR_SWAP_SIDE_CAT_INCOMINGNUMC1FTR_SWAP_SIDE_CATEGORY
SIDE_CAT_OUTSide Category for the Outgoing Side of a Swap FTR_SWAP_SIDE_CAT_OUTGOINGNUMC1FTR_SWAP_SIDE_CATEGORY
SWAP_SYMMETRYIndicates How Swap Symmetry Is Handled FTR_SWAP_SYMMETRYNUMC1FTR_SWAP_SYMMETRY_DOMAIN
SWAP_CAPTURE_BEHActivates Multiple Flow Generation for Commodity Swaps FTR_COMS_MULTPLE_FLOW_GENCHAR1FTR_COMS_MULTPLE_FLOW_GEN
COM_PRICE_DETERMDetermination of Commodity Price FTR_COM_PRICE_DETERMCHAR1FTR_COM_PRICE_DETERM
COM_AVG_CAPT_CATAverage Price Capture Category for Commodity Forward FTR_COMF_AVG_CAPTURE_CATCHAR1FTR_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!