SAP Table TAX_ITEM_DETAIL
Detail tax informationfor a line item
TAX_ITEM_DETAIL (Detail tax informationfor a line item) 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 TAX_ITEM_DETAIL to other SAP tables.
TAX_ITEM_DETAIL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TAX_DATA | EXTAX_JUR_LEVEL_TABLE | TTYP | 0 | 0 | ||||||||||||||||||
| REF_ITEM_KEY | TAX_LINE_KEY | STRU | 0 | 0 | ||||||||||||||||||
| TAXPS | Tax document item number | TAX_POSNR | NUMC | 6 | 0 | |||||||||||||||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | 0 | |||||||||||||||||
| SHPTO | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||||||||||||||||
| ITEMNR | External-tax document item number | XTAX_DOC_ITEM_NUMBER | NUMC | 6 | 0 | |||||||||||||||||
| INPUT_DATA | EXTAX_ITEM_IN | STRU | 0 | 0 | ||||||||||||||||||
| POS_NO | Tax document item number | TAX_POSNR | NUMC | 6 | 0 | |||||||||||||||||
| GROUP_ID | Grouping code for components that are part of the same set | TAX_GROUP_ID | CHAR | 18 | 0 | |||||||||||||||||
| COUNTRY | Tax departure country | LANDTX | CHAR | 3 | 0 | |||||||||||||||||
| DIVISION | Business area/division code | DIVISION | CHAR | 4 | 0 | |||||||||||||||||
| MATNR | Material number for taxes | TAX_MATNR | CHAR | 18 | 0 | |||||||||||||||||
| PROD_CODE | SAP internal product code (external interface) | PROCD_TTXP | CHAR | 10 | 0 | |||||||||||||||||
| GROUP_PROD_CODE | Group product code | GRP_PROCD | CHAR | 10 | 0 | |||||||||||||||||
| QUANTITY | Material quantity (internal representation - KOMP-MENGE) | ETD_QUANTITY | QUAN | 13 | 3 | |||||||||||||||||
| UNIT | Unit for quantity | TAX_UNIT | UNIT | 3 | 0 | |||||||||||||||||
| UPMAT | Pricing reference material of main item | UPMAT | CHAR | 18 | 0 | |||||||||||||||||
| APAR_IND | Indicator for A/P or A/R | APAR_IND | CHAR | 1 | 0 | |||||||||||||||||
| TAX_TYPE | Indicator: Sales/use/rental/service/tax | TAXTYPEXT | CHAR | 1 | 0 | |||||||||||||||||
| EXEMP_IND | Indicator: Transaction is tax exempt/taxable | EXTEXMTFLG | CHAR | 1 | 0 | |||||||||||||||||
| TAX_DATE | Tax date (internal representation) | ETDTXDAT | DATS | 8 | 0 | |||||||||||||||||
| TXJCD_ST | Jurisdiction code "Ship-to" | TXJCD_ST | CHAR | 15 | 0 | |||||||||||||||||
| TXJCD_SF | Jurisdiction code "Ship-from" | TXJCD_SF | CHAR | 15 | 0 | |||||||||||||||||
| TXJCD_POA | Jurisdiction code "Point of order acceptance" | TXJCD_POA | CHAR | 15 | 0 | |||||||||||||||||
| TXJCD_POO | Jurisdiction code "Point of order origin" | TXJCD_POO | CHAR | 15 | 0 | |||||||||||||||||
| AMOUNT | Tax base amount | ETDTAXBASE | CURR | 13 | 2 | |||||||||||||||||
| GROSS_AMOUNT | Tax base amount gross. | ETDGROSS_AMOUNT | CURR | 13 | 2 | |||||||||||||||||
| FREIGHT_AM | Freight Amount (internal representation) | ETDFRTAMOUNT | CURR | 13 | 2 | |||||||||||||||||
| EXEMPT_AMT | Exempt amount (internal representation) | ETDEXMTAMOUNT | CURR | 13 | 2 | |||||||||||||||||
| ACCNT_NO | Vendor or ship-to customer account number | TAX_ACCNT_NO | CHAR | 16 | 0 | |||||||||||||||||
| ACCNT_CLS | Classification item of an account (Customer/vendor) | TAX_ACCNT_CLS | CHAR | 10 | 0 | |||||||||||||||||
| COST_OBJECT | Cost object where the goods are consumed | TAX_COST_OBJECT | CHAR | 18 | 0 | |||||||||||||||||
| PTP_IND | Indicator: Point of Title Passage | PTP_IND | CHAR | 1 | 0 | |||||||||||||||||
| EXCERTIF | Customer tax exemption certificate number defined in SAP | EXCERTIF | CHAR | 25 | 0 | |||||||||||||||||
| EXREASON | Tax Exemption Reason Code | EXDETCODE | CHAR | 2 | 0 | |||||||||||||||||
| USER_DATA | User-specific field | USER_DATA | CHAR | 50 | 0 | |||||||||||||||||
| STORE_CODE | Store Code | STORE_CODE | CHAR | 10 | 0 | |||||||||||||||||
| USER_REPT_DATA | User specific reporting data | USER_REPT_DATA | CHAR | 50 | 0 | |||||||||||||||||
| OUTPUT_DATA | EXTAX_ITEM_OUT | STRU | 0 | 0 | ||||||||||||||||||
| DEFAULT_REASON | Tax Default Reason | TAX_DEFAULT_REASON | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| TXJCD_IND | Indicator: Jurisdiction code used for tax calculation | TXJCDIND | CHAR | 1 | 0 | |||||||||||||||||
| TAXPCOV | Total tax rate (internal representation - KBETR) | ETDTAXPERCNTG | CURR | 11 | 2 | |||||||||||||||||
| TAXAMOV | Total tax amount (internal representation - HWSTE) | ETDTAXAMOUNTG | CURR | 13 | 2 | |||||||||||||||||
| EXMATFLAG | Code for material tax exemption | EXMATCODE | CHAR | 2 | 0 | |||||||||||||||||
| EXCUSFLG | Code for customer tax exemption | EXCUSCODE | CHAR | 2 | 0 | |||||||||||||||||
| EXT_EXCERTIF | Customer exempt certificate as returned by tax system | EXT_EXCERTIF | CHAR | 25 | 0 | |||||||||||||||||
| EXT_EXREASON | Tax Exemption Reason Code as returned by tax system | EXT_DETCODE | CHAR | 2 | 0 | |||||||||||||||||
| GL_TAXPCOV | G/L tax rate (KBETR) | GL_TAXPERCNT | CURR | 11 | 2 | |||||||||||||||||
| GL_TAXAMOV | G/L tax amount (HWSTE) | GL_TAXAMOUNT | CURR | 13 | 2 | |||||||||||||||||
| POSTING_DATA | EXTAX_POST_INFO | STRU | 0 | 0 | ||||||||||||||||||
| REP_DATE | Posting date (internal format) | EXTREPDATE | DATS | 8 | 0 | |||||||||||||||||
| CREDIT_IND | Indicator: Tax credit | EXTCREDFLG | CHAR | 1 | 0 | |||||||||||||||||
