TTESDT_TAXEL SAP (Document / Item tax element) Table details

Dictionary Type: Table
Description: Document / Item tax element




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




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

TTESDT_TAXEL is a standard SAP Table which is used to store Document / Item tax element data and is available within R/3 SAP systems depending on the version and release level.

The TTESDT_TAXEL table consists of various fields, each holding specific information or linking keys about Document / Item tax element data available in SAP. These include TTEDOCUMENTID (TTE Document ID), IOFLAG (Flag für Input = X / Output Document ( = space )), ITEMID (Item Identifier), COUNTRYISO (Country).. 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: Not classified


SAP TTESDT_TAXEL 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
TTEDOCUMENTIDTTE Document ID TTET_TTEDOCUMENTID_PDRAW16SYSUUID
IOFLAGFlag für Input = X / Output Document ( = space ) TTET_IOFLAG_PDCHAR1TTET_CHAR1_PD
ITEMIDItem Identifier TTET_ITEMID_PDRAW16SYSUUID
COUNTRYISOCountry TTET_COUNTRY_PDCHAR2TTET_CHAR2_PDTTET_COUNTRY_PD
TAXEVENTTax Event TTET_TAXEVENT_PDNUMC3TTET_NUMC3_PD
TAXTYPTax Type TTET_TAXTYPE_PDCHAR4TTET_CHAR4_PD
RATE_IDTax Rate ID TTET_TAXRATEID_PDCHAR4TTET_CHAR4_PD
JURISDICTIONCODEJurisdiction Code TTET_JURISDICTIONCODE_PDCHAR15TTET_CHAR15_PD
JURISDICTLEVELJurisdiction Level TTET_JURISDICTIONLEVEL_PDCHAR2TTET_CHAR2_PD
EDI5153EDI5153 TTET_EDI5153_PDCHAR3TTET_CHAR3_PD
TAXINCIDENCETax Incidence TTET_TAXINCIDENCE_PDCHAR3TTET_CHAR3_PD
TAXCATEGORYTax Category TTET_TAXCATEGORY_PDNUMC2TTET_NUMC2_PD
TAXDATETYPETax Date Type TTET_TAXDATETYPE_PDNUMC2TTET_NUMC2_PD
ACCORDINGTODATETax Date TTET_TAXDATE_PDDATS8SYDATS
EXEMPTIONIDExemption Identifier TTET_EXEMPTIONID_PDRAW16SYSUUID
DEDUCTIONREASONDeductibility Reason TTET_DEDUCTREASON_PDNUMC3TTET_NUMC3_PD
POSTINGINDICATORPosting Indicator TTET_POSTINGIND_PDNUMC2TTET_NUMC2_PD
LOWESTJURISDICTLowest Jurisdiction TTET_DEEPESTJL_PDCHAR3TTET_CHAR3_PD
SOURCEINDICATORSourceIndicator TTET_SOURCEINDICATOR_PDCHAR1TTET_CHAR1_PD
LEGALTEXTIDLegal Text ID TTET_LEGALTEXTID_PDCHAR4TTET_CHAR4_PD
TAXTYPELABELLabel for TaxType Description TTET_TAXTYPELABEL_PDCHAR32TTET_CHAR32_PD
TAXRATEIDLABELLabel for Tax Rate ID Description TTET_TAXRATEIDLABEL_PDCHAR32TTET_CHAR32_PD
LEGALTEXTIDLABELLabel for LegalTextID Description TTET_LEGALTEXTIDLABEL_PDCHAR32TTET_CHAR32_PD
TAXCODETaxCode TTET_TAXCODE_PDCHAR4TTET_CHAR4_PD
TAXRATEIDNONDEDTax Rate ID Non Ded. TTET_TAXRATEIDNONDED_PDCHAR4TTET_CHAR4_PD
TAXRATEIDNDLABELLabel for TaxRateID Non Ded. Description TTET_TAXRATEIDNDLABEL_PDCHAR32TTET_CHAR32_PD
EX_LICENSEIDExemption License ID TTET_LICENSE_PDCHAR30TTET_CHAR30_PD
EX_VALID_FROMValid From TTET_VALIDFROM_PDDATS8TTET_DATE_PD
EX_VALID_TOValid To TTET_VALIDTO_PDDATS8TTET_DATE_PD
EX_REASON_CODEReason Code TTET_REASONCODE_PDCHAR6TTET_CHAR6_PD

Key field Non-key field



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

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

SELECT SINGLE *
FROM TTESDT_TAXEL
INTO CORRESPONDING FIELDS OF WA_TTESDT_TAXEL
WHERE...

How to access SAP table TTESDT_TAXEL

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