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

Here we would like to draw your attention to ETXDCJ 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). ETXDCJ is a SAP standard transp table used for storing Ext. tax document: tax rates and amounts by Jurisdict. level related data in SAP. It comes under the package FYTX/ETXDC.

SAP ETXDCJ table

Table ETXDCJ technical data

TableETXDCJ
Data storingExt. tax document: tax rates and amounts by Jurisdict. level
ModuleFI
Sub ModuleFI-GL-GL
SAP PackageFYTX/ETXDC
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP ETXDCJ 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 ETXDCJ 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
  • ITEMNR : External-tax document item number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • TXJLV : Tax jurisdiction code level
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : external document tax output data
  • TAXPCT : Tax rate (KBETR)
    Its data type is CURR (Currency Field) with field length 11
  • TAXAMT : Tax amount (FWSTE)
    Its data type is CURR (Currency Field) with field length 13
  • TAXBAS : Tax base amount
    Its data type is CURR (Currency Field) with field length 13
  • EXAMT : Exempt amount (internal representation)
    Its data type is CURR (Currency Field) with field length 13
  • EXCODE : Tax Exemption Reason Code
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : General Ledger Tax results in local currency
  • GL_TAXPCT : G/L tax rate (KBETR)
    Its data type is CURR (Currency Field) with field length 11
  • GL_TAXAMT : G/L tax amount (HWSTE)
    Its data type is CURR (Currency Field) with field length 13
  • GL_TAXBAS : G/L Tax base amount (HWBAS)
    Its data type is CURR (Currency Field) with field length 13
  • GL_SHKZG : G/L Debit/credit indicator
    Its data type is CHAR (Character String) with field length 1
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10