The ETXDCH table in SAP ERP or S/4HANA stores External tax document: header info data. There are total 46 fields in ETXDCH table. The External tax document: header info table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ETXDCH table. It is in External Tax document (FYTX/ETXDC) ABAP package and is part of the Basic Functions (FI-GL-GL) module.
SAP ETXDCH Table Fields
Following is the list of fields that are available in SAP ETXDCH table. The primary key fields of the table are MANDT (Client), DOCNR (External-tax document number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DOCNR | External-tax document number | XTAX_DOCUMENT_NUMBER | CHAR (12) | |
| AWTYP | Reference procedure | AWTYP | * | CHAR (5) |
| AWREF | Reference document number | AWREF | CHAR (10) | |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) | |
| AWSYS | Logical system of source document | AWSYS | * | CHAR (10) |
| DOCSTATUS | Current status of the external tax document | ETXDC_STATUS_CUR | CHAR (10) | |
| DOCSTATUSCHANGED | Last date that the status of the document changed | ETXDC_STATUS_CHANGED | DATS (8) | |
| CREATEDON | Date on which the the external tax document was created | TAX_CREATEDON | DATS (8) | |
| CREATEDBY | Name of person who created the external tax document | TAX_CREATEDBY | CHAR (12) | |
| TID | Transaction ID for updating external tax system | TAX_TID | CHAR (24) | |
| GLTAX | G/L tax data transferred to external tax document? | TAX_GLTAX_ADDED | CHAR (1) | |
| TXDEF | Defaulted tax amounts | TAX_DEFAULTED | CHAR (1) | |
| DEFAULT_REASON | Tax Default Reason | TAX_DEFAULT_REASON | CHAR (1) | |
| INCON | Internal consistency check with tax data in G/L failed | TAX_INCONS_INT | CHAR (1) | |
| EXCON | External consistency check with tax data recalculated failed | TAX_INCONS_EXT | CHAR (1) | |
| UFLAG | Audit File Update Indicator (External Interface) | UPDATE_FLG | CHAR (1) | |
| UDATE | Audit File Update Date (External Interface) | UPDATE_DAT | DATS (8) | |
| USNAM | user who updated external tax document into external system | UPDATE_USER | CHAR (12) | |
| SYST_NAME | Logical system using tax interface | TAX_LOGSYS | * | CHAR (10) |
| CLIENT | Client using tax interface | TAX_CLIENT | * | CLNT (3) |
| COMP_CODE | Company code using tax interface | TAX_COMP_CODE | CHAR (4) | |
| DOC_NUMBER | Tax document number | TAX_DOC_NUMBER | CHAR (12) | |
| CURRENCY | Document currency when calculating taxes | TAX_CURRENCY | * | CUKY (5) |
| CURR_DEC | Number of Decimal Places for Currency (Characters) | CURDECCHAR | CHAR (3) | |
| TXJCD_L1 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC (2) | |
| TXJCD_L2 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC (2) | |
| TXJCD_L3 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC (2) | |
| TXJCD_L4 | Length of the Nth Part of the Tax Jurisdiction Code | LENGX_TXD | NUMC (2) | |
| TAX_PER_ITEM | Tax per Item flag: Tax calculation is done by line item | TAX_PER_ITEM | CHAR (1) | |
| NR_LINE_ITEMS | Number of lines in external tax document | TAX_NR_LINES | NUMC (6) | |
| IS_UJCS_ACTIVE | Indicator:Unified Jurisdiction Code Structure | TAX_IND_UNI | CHAR (1) | |
| API_VERSION | API Version | TAX_API_VER | CHAR (10) | |
| GL_CURRENCY | Currency of the taxes stored in G/L (local currency) | TAX_GLCURRENCY | * | CUKY (5) |
| GL_CURR_DEC | Number of decimal places for local (G/L) currency | GL_CURDECCHAR | CHAR (3) | |
| REP_DATE | Posting date (internal format) | EXTREPDATE | DATS (8) | |
| RATEDEC | Number of decimals used in the rate (%) | TAX_RATEDECCHAR | CHAR (1) | |
| XEXTN | Indicator: External tax calculation | XEXTN_TXP | * | CHAR (1) |
| INTERF_VERSION | Tax interface version | TAX_INT_VERSION | CHAR (10) | |
| TAX_PROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,…) | KALSM_D | * | CHAR (6) |
| ERRCODE | Output: Error number | ERRNUM | NUMC (4) | |
| ERROR_LINE | Line number causing the error in the tax calculation | TAX_ERROR_LINE | CHAR (6) | |
| ERRMSG | Error messages returned by external tax system | TAX_ERROR_MSG | CHAR (200) | |
| REC_STATUS | Activity | FIS_ETXDC_ACTION | CHAR (20) | |
| FEED_COUNT | Count of Comments | FIS_ETXDC_FEEDCOUNT | INT4 (10) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) |
