TTESDT_EXEMPT SAP (Output Exemptions) Table details

Dictionary Type: Table
Description: Output Exemptions




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




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

TTESDT_EXEMPT is a standard SAP Table which is used to store Output Exemptions data and is available within R/3 SAP systems depending on the version and release level.

The TTESDT_EXEMPT table consists of various fields, each holding specific information or linking keys about Output Exemptions data available in SAP. These include TTEDOCUMENTID (TTE Document ID), EXEMPTIONID (Exemption Identifier), TAXTYPE (Tax Type), EXEMPTIONTYPE (Exemption Type).. 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_EXEMPT 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
EXEMPTIONIDExemption Identifier TTET_EXEMPTIONID_PDRAW16SYSUUID
TAXTYPETax Type TTET_TAXTYPE_PDCHAR4TTET_CHAR4_PD
EXEMPTIONTYPEExemption Type TTET_EXEMPTIONTYPE_PDCHAR4TTET_CHAR4_PD
EXEMPTIONCLASSExemption Classification TTET_EXPTCLASS_PDCHAR2TTET_CHAR2_PD
LICENSEExemption License ID TTET_LICENSE_PDCHAR30TTET_CHAR30_PD
OWNERSPARTNERIDLicensee ID TTET_OWNERPARTNERID_PDCHAR32TTET_CHAR32_PD
ISSUINGAUTHORITYIssuing Authority TTET_ISSUINGAUTHORITY_PDCHAR8TTET_CHAR8_PD
ISSUINGDATEIssuing Date TTET_ISSUINGDATE_PDDATS8TTET_DATE_PD
REASONCODEReason Code TTET_REASONCODE_PDCHAR6TTET_CHAR6_PD
TRANSPORTMODETransportation Mode TTET_TRMODE_PDCHAR2TTET_CHAR2_PD
VALIDFROMValid From TTET_VALIDFROM_PDDATS8TTET_DATE_PD
VALIDTOValid To TTET_VALIDTO_PDDATS8TTET_DATE_PD
FOLLOWONLICENSEFollow On License TTET_FOLLOWONLIC_PDCHAR20TTET_CHAR20_PD
CALCULATIONTYPECalculation Type TTET_CALCTYPE_PDCHAR1TTET_CHAR1_PD
EXEMPTIONRATEExemption Rate TTET_EXEMPRATE_PDDEC10(5) TTET_DEC10_5_PD
CURRENCYUNITCurrency Unit TTET_CURRENCYUNIT_PDCHAR5TTET_CHAR5_PD
BASEQUANTITYBase Quantity Amount TTET_BASEQUANTITY_PDDEC20(5) TTET_DEC20_5_PD
BASEQUANTITYUNITBase Quantity Unit TTET_BASEQUANUNIT_PDCHAR5TTET_CHAR5_PD
CUMULATEDAMOUNTCumulated Amount TTET_CUMULATEDAMOUNT_PDDEC20(5) TTET_DEC20_5_PD
CUMMAXAMOUNTMax Cumulated Exempt Amount TTET_CUMULATIONMAX_PDDEC20(5) TTET_DEC20_5_PD
TOPUPAMOUNTTop Up Amount TTET_TOPUPAMOUNT_PDDEC20(5) TTET_DEC20_5_PD
CUMLATIONCURUNITCumulation Currency Unit TTET_CUMCURRUNIT_PDCHAR5TTET_CHAR5_PD
EXEMPTQUANTITYExempted Quantity TTET_EXEMPQUANTITY_PDDEC20(5) TTET_DEC20_5_PD
CUMULATEDQTYCumulated Quantity TTET_CUMQUANTITY_PDDEC20(5) TTET_DEC20_5_PD
CUMMAXQUANTITYCumulation Maximum Quantity TTET_CUMMAXQUANTITY_PDDEC20(5) TTET_DEC20_5_PD
TOPUPQUANTITYTop Up Quantity TTET_TOPUPQUANTITY_PDDEC20(5) TTET_DEC20_5_PD
QUANTITYUNITQuantity Unit TTET_QUANUNIT_PDCHAR5TTET_CHAR5_PD

Key field Non-key field



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

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

SELECT SINGLE *
FROM TTESDT_EXEMPT
INTO CORRESPONDING FIELDS OF WA_TTESDT_EXEMPT
WHERE...

How to access SAP table TTESDT_EXEMPT

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