TTXY SAP (External tax interface: tax information) Table details

Dictionary Type: Table
Description: External tax interface: tax information




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




Table field list including key, data, relationships and ABAP select examples

TTXY is a standard SAP Table which is used to store External tax interface: tax information data and is available within R/3 SAP systems depending on the version and release level.

The TTXY table consists of various fields, each holding specific information or linking keys about External tax interface: tax information data available in SAP. These include MANDT (Client), AWTYP (Reference Transaction), AWREF (Reference Document Number), AWORG (Reference Organizational Units).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP TTXY 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 MANDTCLNT3Assigned to domainMANDT
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWREFReference Document Number AWREFCHAR10ALPHAAWREF
AWORGReference Organizational Units AWORGCHAR10AWORG
KPOSNCondition item number KPOSNNUMC6NUM6
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
SHPTOTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
CLIENTClient MANDTCLNT3Assigned to domainMANDT
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
DIVISIONBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
COUNTRYTax departure country LANDTXCHAR3Assigned to domainLAND1LND
DOC_NUMBERAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
POS_NOSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
ACCNT_NOAccount number KONTOCHAR16ALPHAKTO16
ACCNT_CLSClassification item of an account (Customer/vendor) KONTOCLASSCHAR10CHAR10
TAX_DATEDate in CHAR format DATECHAR8CHAR8
REP_DATEDate in CHAR format DATECHAR8CHAR8
TXJCD_STTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TXJCD_SFTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TXJCD_POATax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TXJCD_POOTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TXJCD_INDIndicator: Jurisdiction code used for tax calculation TXJCDINDCHAR1CHAR1
PTP_INDIndicator: Point of Title Passage PTP_INDCHAR1CHAR1
APAR_INDIndicator for A/P or A/R APAR_INDCHAR1CHAR1
TXJCD_L1Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXDNUMC2NUM02
TXJCD_L2Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXDNUMC2NUM02
TXJCD_L3Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXDNUMC2NUM02
TXJCD_L4Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXDNUMC2NUM02
TAX_TYPEIndicator: Sales/use/rental/service/tax TAXTYPEXTCHAR1CHAR1
MATNRMaterial number with 18 characters TAXMATNR18CHAR18CHAR18
PROD_CODESAP internal product code (external interface) PROCD_TTXPCHAR10CHAR10
QUANTITYQuantity QUANT_13CHAR13CHAR13
UNITUnit UNIT_3CHAR3CHAR3
AMOUNTTax base amount BASAMOUNTCHAR15CHAR15
CURRENCYCurrency Key CURR_5CHAR5CHAR5
CURR_DECNumber of decimal places for currency (characters) CURDECCHARCHAR3CHAR3
FREIGHT_AMFreight Amount FRTAMOUNTCHAR15CHAR15
EXEMPT_AMTExempt amount EXMTAMOUNTCHAR15CHAR15
EXEMPT_INDIndicator: Transaction is tax exempt/taxable EXTEXMTFLGCHAR1CHAR1
CREDIT_INDIndicator: Tax credit EXTCREDFLGCHAR1CHAR1
UPDATE_INDAudit file update indicator (external interface) UPDATE_FLGCHAR1CHAR1
OVWRT_INDOverwrite indicator EXTOVRFLGCHAR1CHAR1
TAXPCT0Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT1Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT2Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT3Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT4Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT5Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT6Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT7Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT8Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCT9Level n tax rate TAXPERCNTCHAR15CHAR15
TAXPCOVTotal tax rate TAXPERCNTGCHAR15CHAR15
TAXAMT0Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT1Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT2Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT3Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT4Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT5Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT6Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT7Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT8Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMT9Level n tax amount TAXAMOUNTCHAR15CHAR15
TAXAMOVTotal tax amount TAXAMOUNTGCHAR15CHAR15
TAXBAS0Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS1Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS2Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS3Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS4Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS5Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS6Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS7Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS8Tax base amount level n TAXBASECHAR15CHAR15
TAXBAS9Tax base amount level n TAXBASECHAR15CHAR15
EXMATFLGCode for material tax exemption EXMATCODECHAR2CHAR2
EXCUSFLGCode for customer tax exemption EXCUSCODECHAR2CHAR2
EXAMT0Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT1Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT2Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT3Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT4Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT5Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT6Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT7Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT8Exempt amount EXMTAMOUNTCHAR15CHAR15
EXAMT9Exempt amount EXMTAMOUNTCHAR15CHAR15
EXCODE0Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE1Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE2Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE3Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE4Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE5Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE6Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE7Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE8Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCODE9Tax Exemption Reason Code EXDETCODECHAR2CHAR2
EXCERTIFCustomer tax exemption certificate number defined in SAP EXCERTIFCHAR25CHAR25
EXREASONTax Exemption Reason Code EXDETCODECHAR2CHAR2
USER_DATAUser-specific field USER_DATACHAR50TEXT50

Key field Non-key field



How do I retrieve data from SAP table TTXY using ABAP code

The following ABAP code Example will allow you to do a basic selection on TTXY to SELECT all data from the table
DATA: WA_TTXY TYPE TTXY.

SELECT SINGLE *
FROM TTXY
INTO CORRESPONDING FIELDS OF WA_TTXY
WHERE...

How to access SAP table TTXY

Within an ECC or HANA version of SAP you can also view further information about TTXY 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!