SAP AT10 Transaction Types Table

Overview

AT10 is a standard SAP S/4HANA table that stores Transaction Types data. There are total 62 fields in the AT10 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AT10 belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).

In addition, following links provide an overview of foreign key relationships, if any, that link AT10 to other SAP tables and standard CDS views available based on AT10 table in S/4HANA 2020.

Techincal Settings of AT10

Below are technical details of the table AT10

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of AT10 Fields

The following table gives you an overview of the fields available in AT10

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
SGSARTProduct TypeVVSARTTZPACHAR3
SFHAARTFinancial Transaction TypeTB_SFHAARTCHAR3
SFGTYPTransaction CategoryTB_SFGTYPAT01NUMC3
NUMKRNumber Range for TransactionsTB_NUMKRGCHAR2
NUMKRANGNumber Range for Offers/QuotationsNUMKRANGCHAR2
NUMKRSIMNumber Range for Simulated TransactionsNUMKRSIMCHAR2
ABWTYPProcessing CategoryTB_ABWTYPAT05CHAR5
SAUTOBUCHAutomatic Posting ReleaseTB_SAUTOBCHAR1
UNUMKRNumber Range for UnderlyingTB_UNUMKRCHAR2
SLPGLimit Product GroupTB_SLPGATLPGCHAR3
SROUNDRounding TypeTB_SROUNDCHAR1
RROUNDRounding unitTB_RROUNDINT13
SBSTDCPBasic Principle of Commercial Paper PositionTM_SBSTDCPCHAR1
SCOMPCPExponential Discounting for Terms over 1 YearTM_SCOMPCPCHAR1
AHJFANumber of Half-Years for Generating Cash FlowTB_AHJFANUMC2
SREALGETreasury: Flow Type for Realized GainsTB_SREALGETZB0ACHAR4
SREALVETreasury: Flow Type for Realized LossesTB_SREALVETZB0ACHAR4
SBESTABTTreasury: Flow Type for Position Write-DownsTB_SBESTABTZB0ACHAR4
SBESTZUTTreasury: Flow Type for Position Write-UpsTB_SBESTZUTZB0ACHAR4
SBESTABTreasury: Flow Type for Position Write-DownsTB_SBESTABTZB0ACHAR4
SBESTZUTreasury: Flow Type for Position Write-UpsTB_SBESTZUTZB0ACHAR4
SRUEBILTreasury: Flow Type for Provisions to Be CreatedTB_SRUEBILTZB0ACHAR4
SRUEAUFTreasury: Flow Type for Reversing ProvisionsTB_SRUEAUFTZB0ACHAR4
SGEWBILTreasury: Flow Type for Unrealized Gains to Be DisclosedTB_SGEWBILTZB0ACHAR4
SGEWAUFTreasury: Flow Type for Writing Back Unrealized GainsTB_SGEWAUFTZB0ACHAR4
SSWAPERTTreasury: Flow Type for Accrued/Deferred Forex Swap RevenueTB_SWAPERTTZB0ACHAR4
SSWAPERAUFTreasury: Flow Type for Writing Back Accrd/Defd Fx Swap Rev.TB_SWPERAUTZB0ACHAR4
SSWAPAUFTreasury: Flow Type for Accrued/Deferred Forex Swap ExpensesTB_SWAPAUFTZB0ACHAR4
SSWAPAUAUFTreasury: Flow Type f. Writing Back Accrd/Defrd Fx Swap Exp.TB_SWPAUAUTZB0ACHAR4
SRUESWPTreasury: Flow Type for Creating Provisions - SwapTB_SWRUEBITZB0ACHAR4
SRUEAUFSWPTreasury: Flow Type for Clearing Provisons - SwapTB_SWRUEAUTZB0ACHAR4
SGEWSWPTreasury: Flow Type for Disclosing Unrealized Gains - SwapTB_SWGWBILTZB0ACHAR4
SGEWAUFSWPTreasury: Flow Type for Clearing Unrealized Swap GainsTB_SWGWAUFTZB0ACHAR4
SSWPUMBAUFTreasury: Transfer Flow for Forex Swap ExpensesTB_SSWPUMBTZB0ACHAR4
SSWPUMBERTTreasury: Transfer Flow for Foreign Exchange Swap RevenueTB_SSWPUERTZB0ACHAR4
RANTYPContract TypeRANTYPCHAR1
STSMAStatus ProfileJ_STSMATJ20CHAR8
DATE_RULEDate Rule to Determine Due DateTB_DATE_RULEATDRCHAR10
SREALGETTreasury: Flow Type for Realized GainsTB_SREALGETZB0ACHAR4
SREALVETTreasury: Flow Type for Realized LossesTB_SREALVETZB0ACHAR4
FLAG_FLATIndicator: Traded FlatTB_FLAG_FLATCHAR1
SNOMPAYDifference Between Payment Amount and Nominal AmountTM_SNOMPAYCHAR1
FLG_INIT_MARGINIndicator: Generate Initial Margin FlowTB_INIT_MARGINCHAR1
POS_LOCK_CATType of Position LockTB_POS_LOCKNUMC1
USGSARTProduct type of underlyingTB_USGSARTCHAR3
USFHAARTTransaction Type of UnderlyingTB_USFHAARCHAR3
LOCK_REASONBlock type for restraint on disposalSSPERRTW17CHAR3
AUTOSETTLEAutomatic Settlement on CounterconfirmationFTR_SETLMNT_FLGCHAR1
PHYSICALDELConsider physical deliveryFTR_PHYDEL_FLGCHAR1
USENETTINGUse NettingFTR_USENETTINGCHAR1
LOC_CURR_RULEExchange rate for translation to local currencyTB_EXTRANSLOCCHAR1
SIDE_CAT_INSide Category for the Incoming Side of a SwapFTR_SWAP_SIDE_CAT_INCOMINGNUMC1
SIDE_CAT_OUTSide Category for the Outgoing Side of a SwapFTR_SWAP_SIDE_CAT_OUTGOINGNUMC1
SWAP_SYMMETRYIndicates How Swap Symmetry Is HandledFTR_SWAP_SYMMETRYNUMC1
SWAP_CAPTURE_BEHActivates Multiple Flow Generation for Commodity SwapsFTR_COMS_MULTPLE_FLOW_GENCHAR1
COM_PRICE_DETERMDetermination of Commodity PriceFTR_COM_PRICE_DETERMCHAR1
COM_AVG_CAPT_CATAverage Price Capture Category for Commodity ForwardFTR_COMF_AVG_CAPTURE_CATCHAR1
AUTOEXECUTEAutomatic Order execute on CounterconfirmationFTR_ORDEXEC_FLGCHAR1
SPOT_INDICATORIndicator for Spot TransactionFTR_SPOT_INDCHAR1
SPOT_MATYPEPrice Type of Spot Rate at MaturityFTR_SPOT_MATYPECHAR2
SPOT_RATE_STRATEGYDefine Spot Rate DeterminationTTM_FX_RATE_STRATEGYCHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AT10

Table NameFieldCardinalityCheck Table
AT10ABWTYP:AT05
AT10DATE_RULE1: CNATDR
AT10LOCK_REASON1: CNTW17
AT10MANDT1: CNT000
AT10SBESTABC: CNTZB0A
AT10SBESTABTC: CNTZB0A
AT10SBESTZUC: CNTZB0A
AT10SBESTZUTC: CNTZB0A
AT10SFGTYP1: CNAT01
AT10SGEWAUFC: CNTZB0A
AT10SGEWAUFSWPC: CNTZB0A
AT10SGEWBILC: CNTZB0A
AT10SGEWSWPC: CNTZB0A
AT10SGSART1: CNTZPA
AT10SLPG:ATLPG
AT10SREALGEC: CNTZB0A
AT10SREALGETC: CNTZB0A
AT10SREALVEC: CNTZB0A
AT10SREALVETC: CNTZB0A
AT10SRUEAUFC: CNTZB0A
AT10SRUEAUFSWPC: CNTZB0A
AT10SRUEBILC: CNTZB0A
AT10SRUESWPC: CNTZB0A
AT10SSWAPAUAUF:TZB0A
AT10SSWAPAUFC: CNTZB0A
AT10SSWAPERAUF:TZB0A
AT10SSWAPERTC: CNTZB0A
AT10SSWPUMBAUFC: CNTZB0A
AT10SSWPUMBERTC: CNTZB0A
AT10STSMA:TJ20

Other References