SAP TTEC_SPREG_JSD Determine Exempted Region from Tax Jurisdiction Code Table data and field list

TTEC_SPREG_JSD is a standard SAP Table which is used to store Determine Exempted Region from Tax Jurisdiction Code data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TTEC_SPREG_JSD table consists of various fields, each holding specific information or linking keys about Determine Exempted Region from Tax Jurisdiction Code data available in SAP. These include COUNTRYISO (Country), JSDCODE (Tax Jurisdiction Code), RETURNLVL (Jurisdiction Level), SPTXREG (Exempted Region)... 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. .

TTEC_SPREG_JSD table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP TTEC_SPREG_JSD table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TTEC_SPREG_JSD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
COUNTRYISOCountry TTET_COUNTRYCHAR2TTEC_COUNTRIESTTE_COUNTRYTTET_COUNTRY
JSDCODETax Jurisdiction Code TTET_JURISD_CODECHAR15TTE_JURISD_CODE
RETURNLVLJurisdiction Level TTET_RETURN_LEVNUMC2TTE2C_RETLVLTTE_RETURN_LEV
SPTXREGExempted Region TTET_SPECIAL_TAX_REGIONCHAR4TTEC_SPREGTTE_SPECIAL_TAX_REGION

Key field Non-key field



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

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

SELECT SINGLE *
FROM TTEC_SPREG_JSD
INTO CORRESPONDING FIELDS OF WA_TTEC_SPREG_JSD
WHERE...

How to access SAP table TTEC_SPREG_JSD

Within an ECC or HANA version of SAP you can also view further information about TTEC_SPREG_JSD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).