SAP Transaction Tax Engine Tables

Are you looking for the right table related to SAP Transaction Tax Engine Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Transaction Tax Engine (AP-TTE) module.

Top 10 tables in Transaction Tax Engine

TableDescription
TTEC_DT_FLDCAT_CDecision Tree Field Catalog: Context Fields
TTESDT_TRANPROPDocument transaction property
TTEPD3_TAXVALTaxValue
TTEPD3_USITEMPersistency TTE Document UsItem
TTEC_SPREG_JSDDetermine Exempted Region from Tax Jurisdiction Code
TTEPDT_PRODUCTPersitency TTE Document product
TTEC_AUTHORITYTax Authority
TTEPD3_HEADERHeader
TTEPDT_PAPROPPersistency TTE Document business partner property
TTE2C_BPPRPVALBusiness Partner Properties

List of tables in Transaction Tax Engine

TableDescription
TTEC_DT_FLDCAT_CDecision Tree Field Catalog: Context Fields
TTESDT_TRANPROPDocument transaction property
TTEPD3_TAXVALTaxValue
TTEPD3_USITEMPersistency TTE Document UsItem
TTEC_SPREG_JSDDetermine Exempted Region from Tax Jurisdiction Code
TTEPDT_PRODUCTPersitency TTE Document product
TTEC_AUTHORITYTax Authority
TTEPD3_HEADERHeader
TTEPDT_PAPROPPersistency TTE Document business partner property
TTE2C_BPPRPVALBusiness Partner Properties
TTEC_CHECKINGTTE Entity Checking Master Table
TTEPDT_CURRCONVDocument curruncy conversion
TTEC_AUTHORITY_TTax Authority
TTEPDT_PATAXNUMPersistency TTE Document business partner tax number
TTEPDT_ITEMPersistency TTE Document Item
TTE2C_TAXTYP_TTax Type Description
TTEC_EXEMPREAS_TExemption reason
TTEPDT_PRICELPersistency TTE Document / Item pricing element
TTEC_ORG_TYPE_TOrg Unit Type
TTE2C_USAGEProduct Usage Indicator
TTED_REPFLDS_COMInput document reporting fields information
TTEC_EXPIND_TLocation Relationship (Description)
TTED_OCURCON_COMOutput CurrencyConversions
TTEM_TAXTYPE[Obsolete] Mapping: Tax Type
TTEC_INCOTERMS_TDescription for Incoterms
TTEM_TAXTYPE2Mapping: Tax Type
TTEPDT_TAXCODVADocument / Item TaxCode Value
TTEM_TAXCODEMapping: Tax Code
TTEC_DT_FCVAR_FDecision Tree Field Catalog Variant: Fields
TTE2C_FISCCDFiscal Code
TTEC_DT_TYPEDecision Tree Type
TTEC_ACCKEYAccounting Key
TTEC_ORG_TYPEOrg Unit Type
TTE2C_PRPRPVAL_TProduct Properties
TTEC_COUNTRIES_TCountry Text Table
TTEC_LEGTXTLegal Text
TTEPD3_EXEMPExemptions
TTED_TRACE_COMOutput Trace
TTEC_AGGREG[Obsolete] Aggregation Rule For Tax Amounts
TTED_OEXEMP_COMOutput Exemptions
TTEC_TAXNUMTYPTax Registration Number Type
TTEC_DT_FLDCATDecision Tree Field Catalog
TTEC_PRTXTYP_TProduct Taxability Description
TTEPD3_REPFLDSReporting Field
TTEC_TAXCATAGGRAggregation rules
TTE2C_PRPRPTYPProduct Property Type
TTE2C_AUTHIDTax Authority
TTEC_TAXCODE_3Assign TTE Entities to Tax Code
TTEC_TAXTYP_EXTTPartner Role Description
TTEC_ROLE_TPartner Role Description
TTED_PRIELES_COMInput document pricing elements information
TTEM_PRODUCTID[TTE 3.0 only] Mapping: Product Id
TTEC_FISCOVERSFiscal Code Version
TTED_ANALYS_COMOutput Trace
TTEC_ORIGINProduct Origin
TTED_ATAXELE_COMAcquisition: TaxElement
TTEC_DECTR_DETDecision Tree Determination
TTEC_INCOTERMSInco terms
TTEC_TAXTYP_DET[Obsolete] Tax Types by Tax Event
TTE_WT_ACCUMVALUAP-TTE accumulated base amounts and withholding tax amounts
TTEPDT_PRPROPPersistency TTE Document product property
TTED_ATAXVAL_COMAcquisition:TaxValue
TTEC_BUSTRAN_TBusiness Transaction
TTED_CURRCON_COMCurrencyConversions
TTEPD3_PRODUCTProduct
TTEPDT_TAXVALUEPersistency TTE Document / Item tax value
TTE2C_TAPRPVAL_TTransaction Property Description
TTEM_TAXTYPEC[TTE 3.0 only] Mapping: Tax Type
TTEC_USREXIT_REGTTE user exit registration
TTEC_SPREG_TExempted Region Description
TTESDT_HEADERDocument header
TTEC_TAXTYPTax Type
TTEC_USED_TABLESused Tables for TTE Kernel
TTEC_CHECK_LEVELTTE Check levels
TTEC_PRC_TAX_MAP[3.x only] Mapping between Tax Type and Procedure
TTEC_TAXCOMP_TTax Component Description
TTEM_ACCKEYMapping: Account Determination Key
TTEC_TAXCOMPTax Component
TTEC_TAXNUMTYP_TTax Registration Number Type
TTESDT_TAXDATEDocument tax date
TTEC_BUSTRANBusiness Transaction
TTEC_ORIGIN_TDescription for Tax Origin
TTEC_TAXTYP_T[Obsolete] Tax Type Description
TTEM_PRTXGRP2Mapping: Product Tax Group
TTEC_SYS_SRCTTE Customizing Client
TTESDT_TEXTDocument document textes
TTEC_TRACE_SEGTrace segment
TTED_OUTHEAD_COMOutput document header data
TTEC_INCIDENCE_TTax Incidence in Tax Transaction Engine
TTED_TAXSITU_COMTaxSituation
TTEC_ROLEDETPartner Role Replacements
TTEC_RNDRULESRounding Rules
TTEC_TAXCATPARTax Category Parameters
TTEPD3_PATAXNOPartnerTaxNumber
TTEC_TAXFRTO_DETPartner Role determination: Tax from/Tax to
TTEPD3_TAXSITUTaxSituation
TTE2C_TAXEVENTTax Event
TTEC_AGGR_RULE_TAggregation Rule For Tax Amounts
TTEC_DIST_RULEDistribution Rule for Tax Amount Differences
TTESDT_TAXELDocument / Item tax element
TTED_TAXCLAO_COMTaxClassification in OutputDocument
TTEPDC_GLPARAMTTE global parameters
TTED_INHEAD_COMInput document header data
TTEC_SYS_REGTTE Calling System Registry
TTED_INDOC_COMInput Document
TTEC_RNDRULES_TRounding Rules
TTEC_RATES_CNDCondition type for tax rates
TTEC_DTDecision Tree
TTEC_CONDCOMP_TComponents of a Condition Record
TTEC_TAXCODETax Code
TTEC_FIELDNAMETTE Entity Fieldnames
TTEC_FISCCODEFiscal Code
TTEC_IV_LAYOUTInvoice Verification Parameter Layout
TTEC_TAX_TCODE_TTax Tariff Code Description
TTEC_PRTXGRP_TProduct Tax Group Description
TTEC_TRANSPMOD_TTransportation mode for exemption handling in TTE
TTESDT_USITEMOutput Exemptions
TTEPD3_TRACEOutput Trace Entries
TTEM_PATXGRP[Obsolete] Mapping: Partner Taxability Group
TTEM_USAGE[Not used] Mapping: Usage Indicator
TTEC_DT_DATA_CDecision Tree Data - XML document in fixed-length characters
TTEC_FISCCODE_TDescription Fiscal Code
TTE2C_AUTHID_TTax Authority Description
TTEC_RNDRULERounding Rules
TTED_OTAXSIT_COMOutput TaxSituation
TTED_ACQUISI_COMAcquisition
TTEM_PARTNERID[TTE 3.0 only] Mapping: Partner Id
TTEC_XTAXINTFTTE Tax Interface
TTED_TAXCLAS_COMTaxClassification
TTE_CLNT_LOGLog table for Client Copy Utility
TTEC_DEDREAS[Obsolete] Deductibility Reason
TTEC_PROCEDURETax Procedure
TTED_TAXELES_COMInput document tax elements information
TTESDT_EXEMPVALUDocument business partner exemption values for with. tax.
TTEPDT_TRANPROPPersistency TTE Document transaction property
TTE2C_BPPRPTYPBusiness Partner Property Type
TTESDT_PRPROPDocument product property
TTEC_DATETYPDate Types in the Tax Transaction Engine
TTEC_PRELEM_TY_TPricing Element Type Description
TTEC_DT_DATADecision Tree Data
TTEPDT_ORGUNITPersistency TTE Document org unit
TTEC_COMMUNITYCommunity
TTEC_USAGE_T[Obsolete] Usage Description
TTESDT_PATAXNUMDocument business partner tax number
TTEM_PRTXTYP[Not used] Mapping: Product Taxability Type
TTEC_TAXEVTYPTax Event Type
TTESDT_TAXCODVADocument / Item pricing element
TTE2C_PROCEDValid Tax Calculation Procedures for Country
TTED_PRODUCT_COMProduct
TTEM_PARTNERID2Mapping: Business Partner Id
TTED_INEXEMP_COMExemptions
TTEC_ACCUM_PERAccumulation Period
TTEPD3_DOCCLfor 3.0 TTE Document Clustering
TTEC_CBPTTE: Calling Business Partner
TTED_TAXLOC_COMTaxlocation
TTEC_DEDREAS_T[Obsolete] Description for Deductibility Reason
TTEC_POSTIND_TPosting Indicator for Non-Deductible Taxes: Descriptions
TTEC_XTAXSYS_TExternal Tax System
TTEC_TAX_TCODETax Tariff Code
TTEPDT_HEADERPersistency TTE Document Header
TTESDT_PAPROPDocument business partner property
TTEC_GLPARMTTE Global Settings
TTEC_EXEMP_CNDExemption condition types for tax types
TTE2C_TAPRPTYPTransaction Property Type
TTE2C_TAX_MAPMapping between Tax Type and Procedure
TTEC_DIRECIND_TDescription for Direction Indicator
TTEPDT_DOCCLfor 4.0 TTE Document Clustering
TTEPD3_PRIELESPricing Element
TTEC_BUSTRANS_T[Obsolete] Business Transactions
TTESDT_TRACEOutput Trace Entries
TTEC_CBP_TTTE: Calling Business Partner
TTEC_NEXUSTTE: Nexus Data
TTEC_SPREG_REGDetermine Exempted Region from Region
TTEC_SPREG_PCDDetermine Exempted Region from Postal Code
TTEC_DT_TYPE_TDecision Tree Type
TTEC_PRELEM_TYPPricing Element
TTEPD3_TAXDETETaxDetermination
TTEC_TAXCODE_TTax Code
TTEC_PATXGRP_TDescription for Partner Tax Group
TTEC_EDI5153_TUN/EDIFACT 5152 Tax Type Name
TTESDT_PATAXCLDocument business partner tax class.
TTEC_SPREGExempted Region
TTEC_TRACEMODE_TTrace Mode Description
TTEPDT_TAXEVENTPersistency TTE Document / Item tax event
TTEM_PRTXGRP[Obsolete] Mapping: Product taxability group
TTEC_ORG_TYP_TOrganisation Unit Type Description
TTEPD3_TAXCLASTaxClassification
TTESDT_PRTAXCLDocument product tax class.
TTEPDT_EXEMPVALUPersistency TTE Document Item Exemption Value
TTEC_PATXGRPPartner Tax Group
TTEC_EXEMPREASExemption reason
TTE2C_USAGE_TProduct Usage Indicator Description
TTEC_CURRTax Currencies per Country
TTEC_TAXDET_EUTax Determination Intra-EU
TTEPD3_PARTNERPartner
TTED_OTAXVAL_COMOutput TaxElement
TTE2C_DEDREAS_TDescription for Deductibility Reason
TTESDT_PARTNERDocument business partner
TTEPDT_COUNTRIESPersistency TTE Document COUNTRY spez.
TTEC_CURR_HDLTax Currency Handling
TTE2C_BPTXGRP_TDescription for Business Partner Tax Group
TTED_OUTDOC_COMOutput Document
TTEC_PATXTYPPartner Taxability
TTEC_TAXCAT_TDescription for Tax Category
TTEC_DT_FCVAR_TText Table for Decision Tree Field Catalog Variant
TTEC_GROSSPROCAssign Gross Tax Calculation Procedure
TTEC_IV_LAYOUT_TInvoice Verification Parameter Layout
TTEC_PROCMODEProcess Mode
TTEC_RATE_IDRate IDs
TTE2C_ROUNDINGRounding Decimals: Exceptions
TTESDT_TAXEVENTDocument / Item tax event
TTEPDT_USITEMPersistency TTE Document UsItem
TTESDT_CURRCONVDocument curruncy conversion
TTEC_TAX_REGTax Region
TTE2C_FISCCD_TFiscal Code Description
TTEC_NONDD_CNDCondition Type for Non-deductibility
TTEC_ROLEPartner Role
TTEC_LEGTXT_TLegal Text
TTE_CONFIG_TABLEConfiguration table used for copy
TTED_PATXNOO_COMPartnerTaxNumbers in OutputDocument
TTED_PROUSAG_COMProductUsage
TTEC_DT_TDecision Tree
TTESDT_ITEMItem
TTEC_TRACE_LOC_TTrace Location
TTED_INITEM_COMInput item
TTEC_SYS_REG2TTE Calling System Registry
TTEC_AGGR_RULEAggregation Rule For Tax Amounts
TTESDT_DOCUMENTTTE Simulaton Document
TTE2C_EXPREA_TExemption Reason Description
TTEM_BUSPRTYP[Not used] Mapping: Business Process Type
TTEC_TAXBASECALAggregation rules
TTEC_DT_TGTCTXDecision Tree: Target Context
TTEM_TAXTYP_EXTMapping TTE Tax Types to External Tax Types
TTEC_TAXEVENT_T[Obsolete] Tax Event Description
TTEC_DT_FC_VAR_FDecision Tree Field Catalog Variant: Parameters
TTESDT_TAXVALUEDocument / Item tax value
TTEC_TAXDETTax Determination Default
TTEM_BPTXGRP2Mapping: Business Partner Tax Group
TTEC_USAGE[Obsolete] Usage
TTE2C_TAPRPVALTransaction Property
TTE2C_RETLVLJurisdiction Level
TTED_TAXDETE_COMInput item
TTEPDT_TAXDATEPersistemcy TTE Document tax date
TTEC_TRACE_LOCTrace Location
TTEM_PRODUCTID2Mapping: Product Id
TTE2C_PRTXGRPProduct Tax Group
TTEPDT_PATAXCLPersistency TTE Document business partner tax class.
TTED_PARTNER_COMPartner
TTE2C_PRPRPVALProduct Properties
TTE2C_RETLVL_TJurisdiction Level Description
TTEC_TRACESTAT_TTrace Status Description
TTEC_EXEMP_CLA_TExemption Class
TTEPDT_PRTAXCLPersistency TTE Document product tax class.
TTEC_INCIDENCETax Incidence
TTE_COPY_CONFIGConfiguration table used for copy
TTEC_BUSTRANS[Obsolete] Business Transactions
TTEC_ORGUNIT_TYPOrg Unit Type
TTE2C_PRTXGRP_TProduct Tax Group Description
TTESDT_COUNTRIESDocument COUNTRY spez.
TTED_PATAXNO_COMPartnerTaxNumbers
TTEM_ROLE[Not used] Mapping: Partner Roles
TTESDT_EXEMPTOutput Exemptions
TTEPD3_PROUSAGProductUsage
TTEC_PATXTYP_TDescription for Partner Tax Type
TTEC_TAXTYP_EXTTax Types for External Tax Calculation
TTEC_DT_FCVARDecision Tree Field Catalog Variant
TTEC_CONDCOMPComponents of a Condition Record
TTEC_XTAXSYSExternal Tax System
TTEPD3_ITEMItem
TTESDT_ORGUNITDocument org unit
TTEC_BUSPRTYP_TDescription of Business Process Type
TTEPDT_TAXELPersistency TTE Document / Item tax element
TTE2C_PROCED_DETTax Calculation Procedure Determination
TTEPD3_TAXELETaxElement
TTED_PARTN_O_COMPartner in OutputDocument
TTEC_PROCMODE_TProcess Mode Description
TTEPDT_ITEMPARTPersistency TTE Document item partner
TTEC_EXEMP_CLASSExemption Class
TTE2C_EXPREAExemption Reason
TTED_OUTITEM_COMOutput Item
TTEC_TRACEMODETrace Mode
TTEC_ROUNDINGRounding Decimals: Exceptions
TTEPDT_OTRACEOutput Trace Entries
TTEC_TAX_REG_TTax Region Name
TTEPD3_DOCUMENT3.0 TTE Persistency Document
TTEM_PATXTYP[Not used] Mapping: Partner Taxability Type
TTEPDT_TEXTPersistency TTE Document document textes
TTEPDT_EXEMPTPersistency TTE Document Output Exemptions
TTED_OTAXELE_COMOutput TaxElement
TTEPDT_PARTNERPersistency TTE Document business partner
TTE2C_AGGREGCountry Specific Rule Assignments
TTEC_TAXCATTax Category
TTEC_BUSPRTYPBusiness Process Type
TTESDT_PRODUCTDocument product
TTEC_DATETYP_TDate Type Description
TTEC_TAXEVENT[Obsolete] Tax Event
TTEPD3_CURRCONCurrencyConversions
TTEC_TAXEVTYP_TTax Event Type
TTEC_COMMUNITY_TDecription for Tax Community
TTEC_TRACE_STATTrace Status
TTEC_CALC_TYPExemption calculation type in TTE
TTE2C_PRPRPTYP_TProduct Property Type Description
TTEC_CURR_HDL3Tax Currency Handling
TTEC_XPRA30Log Table for TTE Data Migration
TTE2C_TAPRPTYP_TTransaction Property Type Description
TTESDT_ACCUMVALUDocument business partner accum. values of with. tax.
TTESDT_PRICELDocument / Item pricing element
TTEC_CALC_TYP_TExemption calculation type in TTE
TTEC_TRACE_SEG_TTrace segment
TTEC_EDI5153UN/EDIFACT 5153 Tax Type Name Code
TTEC_TRANSPMODTransportation mode for exemption handling in TTE
TTESDT_ANALYSYSPricing Trace from Tax Calculation
TTEC_COMMANDTTE Command
TTEC_COUNTRYCountry to Community Assignment
TTEPDT_DOCUMENTTTE Persistency Document
TTEC_XTAXINTF_TTTE Tax Interface Description
TTE2C_DEDREASDeductibility Reason
TTESDT_ITEMPARTDocument item partner
TTEC_RATE_ID_TRate IDs
TTEC_COUNTRY_TCountry name
TTEC_EXEMPT_TYPExemption type
TTEC_DT_TEXTSDecision Tree Texts
TTE2C_TAXTYP_DETTax Type Determination
TTEC_POSTINDPosting Indicator for Non-Deductible Taxes
TTEC_DIRECINDDirection Indicator
TTEC_COMMAND_TDescription for TTE Command
TTE2C_BPPRPTYP_TProduct Property Type Description
TTEC_ACCKEY_TAccounting Key
TTEC_EXEMPTTYP_TExemption type description
TTEC_EXPINDLocation Relationship
TTEC_COUNTRIESCountry codes (2 char ISO codes)
TTEC_DIST_RULE_TDistribution Rule For Tax Amounts
TTEC_CHECK_LVL_TTTE Check level Description
TTEC_FISCOVERS_TFiscal Code Version Description
TTE2C_TAXEVENT_TTax Event Description
TTE2C_BPTXGRPBusiness Partner Tax Group
TTEC_MAPACCVALMapping Accumulated Values
TTE2C_CNTY_COMMCountry / Community Assignment
TTE2C_BPPRPVAL_TBusiness Partner Properties
TTE2C_CHECKTTE Entity Checking Master Table
TTEC_PRTXGRPProduct Tax Group
TTEC_PRTXTYPProduct Taxability
TTEC_TAXCODE_2Assign Tax Events to Tax Code