1. SAP Tutorial
  2. FI Module

ETXDCH SAP table for – External tax document: header info

Here we would like to draw your attention to ETXDCH table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). ETXDCH is a SAP standard transp table used for storing External tax document: header info related data in SAP. It comes under the package FYTX/ETXDC.

SAP ETXDCH table

Table ETXDCH technical data

TableETXDCH
Data storingExternal tax document: header info
ModuleFI
Sub ModuleFI-GL-GL
SAP PackageFYTX/ETXDC
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP ETXDCH Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ETXDCH table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DOCNR : External-tax document number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Reference document key
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWREF : Reference document number
    Its data type is CHAR (Character String) with field length 10
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • AWSYS : Logical system of source document
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Structure containing info on the status of the ext. tax doc
  • DOCSTATUS : Current status of the external tax document
    Its data type is CHAR (Character String) with field length 10
  • DOCSTATUSCHANGED : Last date that the status of the document changed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : update info on external tax document
  • CREATEDON : Date on which the the external tax document was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATEDBY : Name of person who created the external tax document
    Its data type is CHAR (Character String) with field length 12
  • TID : Transaction ID for updating external tax system
    Its data type is CHAR (Character String) with field length 24
  • GLTAX : G/L tax data transferred to external tax document?
    Its data type is CHAR (Character String) with field length 1
  • TXDEF : Defaulted tax amounts
    Its data type is CHAR (Character String) with field length 1
  • DEFAULT_REASON : Tax Default Reason
    Its data type is CHAR (Character String) with field length 1
  • INCON : Internal consistency check with tax data in G/L failed
    Its data type is CHAR (Character String) with field length 1
  • EXCON : External consistency check with tax data recalculated failed
    Its data type is CHAR (Character String) with field length 1
  • UFLAG : Audit file update indicator (external interface)
    Its data type is CHAR (Character String) with field length 1
  • UDATE : Audit file update date (external interface)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USNAM : user who updated external tax document into external system
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : external tax document header input data
  • .INCLUDE : external tax document header input data
  • .INCLUDE : Tax substructure: document header key.
  • SYST_NAME : Logical system using tax interface
    Its data type is CHAR (Character String) with field length 10
  • CLIENT : Client using tax interface
    Its data type is CLNT (Character with length 3) with field length 3
  • COMP_CODE : Company code using tax interface
    Its data type is CHAR (Character String) with field length 4
  • DOC_NUMBER : Tax document number
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Tax substructure: document info
  • CURRENCY : Document currency when calculating taxes
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CURR_DEC : Number of decimal places for currency (characters)
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Tax substructure: Tax Jurisdiction Code structure
  • TXJCD_L1 : Length of the Nth Part of the Tax Jurisdiction Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TXJCD_L2 : Length of the Nth Part of the Tax Jurisdiction Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TXJCD_L3 : Length of the Nth Part of the Tax Jurisdiction Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TXJCD_L4 : Length of the Nth Part of the Tax Jurisdiction Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TAX_PER_ITEM : Tax per Item flag: Tax calculation is done by line item
    Its data type is CHAR (Character String) with field length 1
  • NR_LINE_ITEMS : Number of lines in external tax document
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : Tax substructure: G/L info on document level
  • GL_CURRENCY : Currency of the taxes stored in G/L (local currency)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GL_CURR_DEC : Number of decimal places for local (G/L) currency
    Its data type is CHAR (Character String) with field length 3
  • REP_DATE : Posting date (internal format)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RATEDEC : Number of decimals used in the rate (%)
    Its data type is CHAR (Character String) with field length 1
  • XEXTN : Indicator: External tax calculation
    Its data type is CHAR (Character String) with field length 1
  • INTERF_VERSION : Tax interface version
    Its data type is CHAR (Character String) with field length 10
  • TAX_PROCEDURE : Procedure (Pricing, Output Control, Acct. Det., Costing,…)
    Its data type is CHAR (Character String) with field length 6

    • ETXDCH related tables

    • ETXDCI : External tax document: line item info
    • ETXDCJ : Ext. tax document: tax rates and amounts by Jurisdict. level
    • ETXDCH : External tax document: header info

    ETXDCH related transaction codes under SAP package FYTX/ETXDC

    • OBETX : Number Assignment for Ext. Tax Docum

    Related References

    Related Tutorials

    ETXDCI SAP table for – External tax document: line item info

    ETXDCI table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of External...

    ETXDCJ SAP table for – Ext. tax document: tax rates and amounts by Jurisdict. level

    ETXDCJ table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Ext....

    IDGT_GTDH SAP table for – GT Document Header

    IDGT_GTDH table in SAP FI (Localization in FI) module. This table is used for storing data of GT Document Header....

    KBLK SAP table for – Document Header: Manual Document Entry

    KBLK table in SAP FI (Funds Management in FI) module. This table is used for storing data of Document Header:...

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

    TCJ_WTAX_ITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Withholding...

    FKK_VBRK_SHORT SAP table for – Header Data for SD Billing Document – Extracts

    FKK_VBRK_SHORT table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    TAXMSD SAP table for – Tax Interface Manager Status Diagram “Tax Per document”

    TAXMSD table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Tax...

    «
    »