ETXDCI SAP (External tax document: line item info) Table details
Dictionary Type: Table
Description: External tax document: line item info
Description: External tax document: line item info
Table field list including key, data, relationships and ABAP select examples
ETXDCI is a standard SAP Table which is used to store External tax document: line item info data and is available within R/3 SAP systems depending on the version and release level.
The ETXDCI table consists of various fields, each holding specific information or linking keys about External tax document: line item info data available in SAP. These include DOCNR (External-tax document number), ITEMNR (External-tax document item number), TAXPS (Tax document item number), MWSKZ (Tax on sales/purchases code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ETXDCI table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DOCNR | External-tax document number | XTAX_DOCUMENT_NUMBER | CHAR | 12 | ETXDCH | CHAR12 | |||
ITEMNR | External-tax document item number | XTAX_DOC_ITEM_NUMBER | NUMC | 6 | NUM6 | ||||
TAXPS | Tax document item number | TAX_POSNR | NUMC | 6 | NUM6 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
SHPTO | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
POS_NO | Tax document item number | TAX_POSNR | NUMC | 6 | NUM6 | ||||
GROUP_ID | Grouping code for components that are part of the same set | TAX_GROUP_ID | CHAR | 18 | CHAR18 | ||||
COUNTRY | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
DIVISION | Business area/division code | DIVISION | CHAR | 4 | CHAR4 | GSB | |||
MATNR | Material number for taxes | TAX_MATNR | CHAR | 18 | CHAR18 | ||||
PROD_CODE | SAP internal product code (external interface) | PROCD_TTXP | CHAR | 10 | CHAR10 | ||||
GROUP_PROD_CODE | Group product code | GRP_PROCD | CHAR | 10 | CHAR10 | ||||
QUANTITY | Material quantity (internal representation - KOMP-MENGE) | ETD_QUANTITY | QUAN | 13(3) | MENG13 | ||||
UNIT | Unit for quantity | TAX_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UPMAT | Pricing reference material of main item | UPMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
APAR_IND | Indicator for A/P or A/R | APAR_IND | CHAR | 1 | CHAR1 | ||||
TAX_TYPE | Indicator: Sales/use/rental/service/tax | TAXTYPEXT | CHAR | 1 | CHAR1 | ||||
EXEMP_IND | Indicator: Transaction is tax exempt/taxable | EXTEXMTFLG | CHAR | 1 | CHAR1 | ||||
TAX_DATE | Tax date (internal representation) | ETDTXDAT | DATS | 8 | DATUM | ||||
TXJCD_ST | Jurisdiction code 'Ship-to' | TXJCD_ST | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXJCD_SF | Jurisdiction code 'Ship-from' | TXJCD_SF | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXJCD_POA | Jurisdiction code 'Point of order acceptance' | TXJCD_POA | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXJCD_POO | Jurisdiction code 'Point of order origin' | TXJCD_POO | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
AMOUNT | Tax base amount | ETDTAXBASE | CURR | 13(2) | WERT7 | ||||
GROSS_AMOUNT | Tax base amount gross. | ETDGROSS_AMOUNT | CURR | 13(2) | WERT7 | ||||
FREIGHT_AM | Freight Amount (internal representation) | ETDFRTAMOUNT | CURR | 13(2) | WERT7 | ||||
EXEMPT_AMT | Exempt amount (internal representation) | ETDEXMTAMOUNT | CURR | 13(2) | WERT7 | ||||
ACCNT_NO | Vendor or ship-to customer account number | TAX_ACCNT_NO | CHAR | 16 | ALPHA | KTO16 | |||
ACCNT_CLS | Classification item of an account (Customer/vendor) | TAX_ACCNT_CLS | CHAR | 10 | CHAR10 | ||||
COST_OBJECT | Cost object where the goods are consumed | TAX_COST_OBJECT | CHAR | 18 | CHAR18 | ||||
PTP_IND | Indicator: Point of Title Passage | PTP_IND | CHAR | 1 | CHAR1 | ||||
EXCERTIF | Customer tax exemption certificate number defined in SAP | EXCERTIF | CHAR | 25 | CHAR25 | ||||
EXREASON | Tax Exemption Reason Code | EXDETCODE | CHAR | 2 | CHAR2 | ||||
USER_DATA | User-specific field | USER_DATA | CHAR | 50 | TEXT50 | ||||
STORE_CODE | Store Code | STORE_CODE | CHAR | 10 | CHAR10 | ||||
USER_REPT_DATA | User specific reporting data | USER_REPT_DATA | CHAR | 50 | TEXT50 | ||||
DEFAULT_REASON | Tax Default Reason | TAX_DEFAULT_REASON | CHAR | 1 | TAX_DEFAULTED | ||||
TXJCD_IND | Indicator: Jurisdiction code used for tax calculation | TXJCDIND | CHAR | 1 | CHAR1 | ||||
TAXPCOV | Total tax rate (internal representation - KBETR) | ETDTAXPERCNTG | CURR | 11(2) | WERTV6 | ||||
TAXAMOV | Total tax amount (internal representation - HWSTE) | ETDTAXAMOUNTG | CURR | 13(2) | WERT7 | ||||
EXMATFLAG | Code for material tax exemption | EXMATCODE | CHAR | 2 | CHAR2 | ||||
EXCUSFLG | Code for customer tax exemption | EXCUSCODE | CHAR | 2 | CHAR2 | ||||
EXT_EXCERTIF | Customer exempt certificate as returned by tax system | EXT_EXCERTIF | CHAR | 25 | CHAR25 | ||||
EXT_EXREASON | Tax Exemption Reason Code as returned by tax system | EXT_DETCODE | CHAR | 2 | CHAR2 | ||||
GL_TAXPCOV | G/L tax rate (KBETR) | GL_TAXPERCNT | CURR | 11(2) | WERTV6 | ||||
GL_TAXAMOV | G/L tax amount (HWSTE) | GL_TAXAMOUNT | CURR | 13(2) | WERT7 | ||||
REP_DATE | Posting date (internal format) | EXTREPDATE | DATS | 8 | DATUM | ||||
CREDIT_IND | Indicator: Tax credit | EXTCREDFLG | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table ETXDCI using ABAP code
The following ABAP code Example will allow you to do a basic selection on ETXDCI to SELECT all data from the tableDATA: WA_ETXDCI TYPE ETXDCI.
SELECT SINGLE *
FROM ETXDCI
INTO CORRESPONDING FIELDS OF WA_ETXDCI
WHERE...
How to access SAP table ETXDCI
Within an ECC or HANA version of SAP you can also view further information about ETXDCI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects