1. Home
  2. Resources
  3. SAP Tables
  4. ETXDCH - External tax document: header info

SAP Table ETXDCH

External tax document: header info

ETXDCH (External tax document: header info) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ETXDCH to other SAP tables.

ETXDCH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
DOCNR External-tax document number XTAX_DOCUMENT_NUMBER CHAR 12 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWREF Reference Document Number AWREF CHAR 10 0
AWORG Reference Organizational Units AWORG CHAR 10 0
AWSYS Logical system of source document AWSYS CHAR 10 0
DOCSTATUS Current status of the external tax document ETXDC_STATUS_CUR CHAR 10 0
NULL Initial status, document contains no data
HASINPUT At least one item with input data but tax not yet calculated
CALCULATED All items have their taxes calculated
HASGLDATA All items have the actually posted G/L tax data
UPDATED Update info for audit file already sent to external system
DOCSTATUSCHANGED Last date that the status of the document changed ETXDC_STATUS_CHANGED DATS 8 0
CREATEDON Date on which the the external tax document was created TAX_CREATEDON DATS 8 0
CREATEDBY Name of person who created the external tax document TAX_CREATEDBY CHAR 12 0
TID Transaction ID for updating external tax system TAX_TID CHAR 24 0
GLTAX G/L tax data transferred to external tax document? TAX_GLTAX_ADDED CHAR 1 0
TXDEF Defaulted tax amounts TAX_DEFAULTED CHAR 1 0
DEFAULT_REASON Tax Default Reason TAX_DEFAULT_REASON CHAR 1 0
NULL no taxes defaulted
1 taxes copied from reference document (pricing)
2 taxes set to zero because tax code has tax relevancy '2'
3 taxes set to zero because tax base amount is zero
4 taxes manually set to zero and/or tax code configured as 0
5 taxes set to zero because of company code jurisd.code (OBCL)
6 taxes set externally in accounting interface
INCON Internal consistency check with tax data in G/L failed TAX_INCONS_INT CHAR 1 0
EXCON External consistency check with tax data recalculated failed TAX_INCONS_EXT CHAR 1 0
UFLAG Audit file update indicator (external interface) UPDATE_FLG CHAR 1 0
UDATE Audit file update date (external interface) UPDATE_DAT DATS 8 0
USNAM user who updated external tax document into external system UPDATE_USER CHAR 12 0
SYST_NAME Logical system using tax interface TAX_LOGSYS CHAR 10 0
CLIENT Client using tax interface TAX_CLIENT CLNT 3 0
COMP_CODE Company code using tax interface TAX_COMP_CODE CHAR 4 0
DOC_NUMBER Tax document number TAX_DOC_NUMBER CHAR 12 0
CURRENCY Document currency when calculating taxes TAX_CURRENCY CUKY 5 0
CURR_DEC Number of decimal places for currency (characters) CURDECCHAR CHAR 3 0
TXJCD_L1 Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXD NUMC 2 0
TXJCD_L2 Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXD NUMC 2 0
TXJCD_L3 Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXD NUMC 2 0
TXJCD_L4 Length of the Nth Part of the Tax Jurisdiction Code LENGX_TXD NUMC 2 0
TAX_PER_ITEM Tax per Item flag: Tax calculation is done by line item TAX_PER_ITEM CHAR 1 0
NR_LINE_ITEMS Number of lines in external tax document TAX_NR_LINES NUMC 6 0
GL_CURRENCY Currency of the taxes stored in G/L (local currency) TAX_GLCURRENCY CUKY 5 0
GL_CURR_DEC Number of decimal places for local (G/L) currency GL_CURDECCHAR CHAR 3 0
REP_DATE Posting date (internal format) EXTREPDATE DATS 8 0
RATEDEC Number of decimals used in the rate (%) TAX_RATEDECCHAR CHAR 1 0
XEXTN Indicator: External tax calculation XEXTN_TXP CHAR 1 0
INTERF_VERSION Tax interface version TAX_INT_VERSION CHAR 10 0
NULL Taxes processed by external system per LINE ITEM
TAXDOC00 Taxes processed by external system per DOCUMENT
TAX_____ (For internal purposes only)
TAX_PROCEDURE Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0