1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to ETXDCI 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). ETXDCI is a SAP standard transp table used for storing External tax document: line item info related data in SAP. It comes under the package FYTX/ETXDC.

SAP ETXDCI table

Table ETXDCI technical data

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

SAP ETXDCI 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 ETXDCI 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
  • .INCLUDE : tax line secondary key
  • TAXPS : Tax document item number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • SHPTO : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • .INCLUDE : external document item input data
  • .INCLUDE : External Tax document substructure: material info
  • POS_NO : Tax document item number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • GROUP_ID : Grouping code for components that are part of the same set
    Its data type is CHAR (Character String) with field length 18
  • COUNTRY : Tax Departure Country
    Its data type is CHAR (Character String) with field length 3
  • DIVISION : Business area/division code
    Its data type is CHAR (Character String) with field length 4
  • MATNR : Material number for taxes
    Its data type is CHAR (Character String) with field length 18
  • PROD_CODE : SAP internal product code (external interface)
    Its data type is CHAR (Character String) with field length 10
  • GROUP_PROD_CODE : Group product code
    Its data type is CHAR (Character String) with field length 10
  • QUANTITY : Material quantity (internal representation – KOMP-MENGE)
    Its data type is QUAN (Quantity field) with field length 13
  • UNIT : Unit for quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UPMAT : Pricing reference material of main item
    Its data type is CHAR (Character String) with field length 18
  • .INCLUDE : Tax substructure: tax code info.
  • APAR_IND : Indicator for A/P or A/R
    Its data type is CHAR (Character String) with field length 1
  • TAX_TYPE : Indicator: Sales/use/rental/service/tax
    Its data type is CHAR (Character String) with field length 1
  • EXEMP_IND : Indicator: Transaction is tax exempt/taxable
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Tax substructure: Transaction Info
  • TAX_DATE : Tax date (internal representation)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TXJCD_ST : Jurisdiction code “Ship-to”
    Its data type is CHAR (Character String) with field length 15
  • TXJCD_SF : Jurisdiction code “Ship-from”
    Its data type is CHAR (Character String) with field length 15
  • TXJCD_POA : Jurisdiction code “Point of order acceptance”
    Its data type is CHAR (Character String) with field length 15
  • TXJCD_POO : Jurisdiction code “Point of order origin”
    Its data type is CHAR (Character String) with field length 15
  • AMOUNT : Tax base amount
    Its data type is CURR (Currency Field) with field length 13
  • GROSS_AMOUNT : Tax base amount gross.
    Its data type is CURR (Currency Field) with field length 13
  • FREIGHT_AM : Freight Amount (internal representation)
    Its data type is CURR (Currency Field) with field length 13
  • EXEMPT_AMT : Exempt amount (internal representation)
    Its data type is CURR (Currency Field) with field length 13
  • .INCLUDE : Tax substructure: Info about how material is used
  • ACCNT_NO : Vendor or ship-to customer account number
    Its data type is CHAR (Character String) with field length 16
  • ACCNT_CLS : Classification item of an account (Customer/vendor)
    Its data type is CHAR (Character String) with field length 10
  • COST_OBJECT : Cost object where the goods are consumed
    Its data type is CHAR (Character String) with field length 18
  • PTP_IND : Indicator: Point of Title Passage
    Its data type is CHAR (Character String) with field length 1
  • EXCERTIF : Customer tax exemption certificate number defined in SAP
    Its data type is CHAR (Character String) with field length 25
  • EXREASON : Tax Exemption Reason Code
    Its data type is CHAR (Character String) with field length 2
  • USER_DATA : User-specific field
    Its data type is CHAR (Character String) with field length 50
  • .INCLUDE : Tax substructure: Reporting Info
  • STORE_CODE : Store Code
    Its data type is CHAR (Character String) with field length 10
  • USER_REPT_DATA : User specific reporting data
    Its data type is CHAR (Character String) with field length 50
  • .INCLUDE : external document item output data
  • DEFAULT_REASON : Tax Default Reason
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Tax Interface: document item output.
  • TXJCD_IND : Indicator: Jurisdiction code used for tax calculation
    Its data type is CHAR (Character String) with field length 1
  • TAXPCOV : Total tax rate (internal representation – KBETR)
    Its data type is CURR (Currency Field) with field length 11
  • TAXAMOV : Total tax amount (internal representation – HWSTE)
    Its data type is CURR (Currency Field) with field length 13
  • EXMATFLAG : Code for material tax exemption
    Its data type is CHAR (Character String) with field length 2
  • EXCUSFLG : Code for customer tax exemption
    Its data type is CHAR (Character String) with field length 2
  • EXT_EXCERTIF : Customer exempt certificate as returned by tax system
    Its data type is CHAR (Character String) with field length 25
  • EXT_EXREASON : Tax Exemption Reason Code as returned by tax system
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : GL tax results at item level
  • GL_TAXPCOV : G/L tax rate (KBETR)
    Its data type is CURR (Currency Field) with field length 11
  • GL_TAXAMOV : G/L tax amount (HWSTE)
    Its data type is CURR (Currency Field) with field length 13
  • .INCLUDE : External tax document item posting info
  • .INCLUDE : Tax substructure: Posting Info
  • REP_DATE : Posting date (internal format)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREDIT_IND : Indicator: Tax credit
    Its data type is CHAR (Character String) with field length 1

    • ETXDCI related tables

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

    ETXDCI related transaction codes under SAP package FYTX/ETXDC

    • OBETX : Number Assignment for Ext. Tax Docum

    Related References

    Related Tutorials

    ETXDCH SAP table for – External tax document: header info

    ETXDCH 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....

    J_3RFTAXRVP SAP table for – Tax Accounting: Plan line item table

    J_3RFTAXRVP table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Plan...

    J_3RFTAXRP SAP table for – Tax Accounting: Plan line item table

    J_3RFTAXRP table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Plan...

    J_3RFTAXRVA SAP table for – Tax Accounting: Actual line item table

    J_3RFTAXRVA table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Actual...

    J_3RFTAXRA SAP table for – Tax Accounting: Actual line item table

    J_3RFTAXRA table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Accounting: Actual...

    VIITTAXDSBASE SAP table for – Tax Document Item to Be Broken Down (VIITTAXDSBASE)

    VIITTAXDSBASE table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »