ETXDCH SAP (External tax document: header info) Table details
Dictionary Type: Table
Description: External tax document: header info
Description: External tax document: header info
Table field list including key, data, relationships and ABAP select examples
ETXDCH is a standard SAP Table which is used to store External tax document: header info data and is available within R/3 SAP systems depending on the version and release level.
The ETXDCH table consists of various fields, each holding specific information or linking keys about External tax document: header info data available in SAP. These include DOCNR (External-tax document number), 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: Not classified
SAP ETXDCH 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DOCNR | External-tax document number | XTAX_DOCUMENT_NUMBER | CHAR | 12 | CHAR12 | ||||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
AWREF | Reference Document Number | AWREF | CHAR | 10 | ALPHA | AWREF | |||
AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
AWSYS | Logical system of source document | AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
DOCSTATUS | Current status of the external tax document | ETXDC_STATUS_CUR | CHAR | 10 | ETXDC_STATUS | ||||
DOCSTATUSCHANGED | Last date that the status of the document changed | ETXDC_STATUS_CHANGED | DATS | 8 | DATE | ||||
CREATEDON | Date on which the the external tax document was created | TAX_CREATEDON | DATS | 8 | DATUM | ||||
CREATEDBY | Name of person who created the external tax document | TAX_CREATEDBY | CHAR | 12 | USNAM | ||||
TID | Transaction ID for updating external tax system | TAX_TID | CHAR | 24 | CHAR24 | ||||
GLTAX | G/L tax data transferred to external tax document? | TAX_GLTAX_ADDED | CHAR | 1 | CHAR1 | ||||
TXDEF | Defaulted tax amounts | TAX_DEFAULTED | CHAR | 1 | CHAR1 | ||||
DEFAULT_REASON | Tax Default Reason | TAX_DEFAULT_REASON | CHAR | 1 | TAX_DEFAULTED | ||||
INCON | Internal consistency check with tax data in G/L failed | TAX_INCONS_INT | CHAR | 1 | CHAR1 | ||||
EXCON | External consistency check with tax data recalculated failed | TAX_INCONS_EXT | CHAR | 1 | CHAR1 | ||||
UFLAG | Audit file update indicator (external interface) | UPDATE_FLG | CHAR | 1 | CHAR1 | ||||
UDATE | Audit file update date (external interface) | UPDATE_DAT | DATS | 8 | DATUM | ||||
USNAM | user who updated external tax document into external system | UPDATE_USER | CHAR | 12 | UNAME | ||||
SYST_NAME | Logical system using tax interface | TAX_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
CLIENT | Client using tax interface | TAX_CLIENT | CLNT | 3 | Assigned to domain | MANDT | |||
COMP_CODE | Company code using tax interface | TAX_COMP_CODE | CHAR | 4 | Assigned to domain | BUKRS | BUK | H_T001 | |
DOC_NUMBER | Tax document number | TAX_DOC_NUMBER | CHAR | 12 | CHAR12 | ||||
CURRENCY | Document currency when calculating taxes | TAX_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
CURR_DEC | Number of decimal places for currency (characters) | CURDECCHAR | CHAR | 3 | CHAR3 | ||||
TXJCD_L1 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC | 2 | NUM02 | ||||
TXJCD_L2 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC | 2 | NUM02 | ||||
TXJCD_L3 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC | 2 | NUM02 | ||||
TXJCD_L4 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC | 2 | NUM02 | ||||
TAX_PER_ITEM | Tax per Item flag: Tax calculation is done by line item | TAX_PER_ITEM | CHAR | 1 | CHAR1 | ||||
NR_LINE_ITEMS | Number of lines in external tax document | TAX_NR_LINES | NUMC | 6 | NUM06 | ||||
GL_CURRENCY | Currency of the taxes stored in G/L (local currency) | TAX_GLCURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
GL_CURR_DEC | Number of decimal places for local (G/L) currency | GL_CURDECCHAR | CHAR | 3 | CHAR3 | ||||
REP_DATE | Posting date (internal format) | EXTREPDATE | DATS | 8 | DATUM | ||||
RATEDEC | Number of decimals used in the rate (%) | TAX_RATEDECCHAR | CHAR | 1 | CHAR1 | ||||
XEXTN | Indicator: External tax calculation | XEXTN_TXP | CHAR | 1 | Assigned to domain | XEXTN | |||
INTERF_VERSION | Tax interface version | TAX_INT_VERSION | CHAR | 10 | TAX_INT_VERSION | ||||
TAX_PROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | Assigned to domain | KALSM |
Key field | Non-key field |
How do I retrieve data from SAP table ETXDCH using ABAP code
The following ABAP code Example will allow you to do a basic selection on ETXDCH to SELECT all data from the tableDATA: WA_ETXDCH TYPE ETXDCH.
SELECT SINGLE *
FROM ETXDCH
INTO CORRESPONDING FIELDS OF WA_ETXDCH
WHERE...
How to access SAP table ETXDCH
Within an ECC or HANA version of SAP you can also view further information about ETXDCH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects