EXTAX_ITEM_CALC_DATA SAP (item data containing tax calculation by the external system) Structure details
Description: item data containing tax calculation by the external system
Related tables to EXTAX_ITEM_CALC_DATA
Access table EXTAX_ITEM_CALC_DATA
Structure field list including key, data, relationships and ABAP select examples
EXTAX_ITEM_CALC_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "item data containing tax calculation by the external system" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_EXTAX_ITEM_CALC_DATA TYPE EXTAX_ITEM_CALC_DATA.
The EXTAX_ITEM_CALC_DATA table consists of various fields, each holding specific information or linking keys about item data containing tax calculation by the external system data available in SAP. These include TAXPS (Tax document item number), MWSKZ (Tax on sales/purchases code), SHPTO (Tax Jurisdiction), ITEM_CALC_IN ().. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP EXTAX_ITEM_CALC_DATA structure 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 |
REF_ITEM_KEY | 0 | ||||||||
TAXPS | Tax document item number | TAX_POSNR | NUMC | 6 | NUM6 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | MWSKZ | ||||
SHPTO | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
ITEM_CALC_IN | 0 | ||||||||
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 | 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 | CUNIT | MEINS | |||
UPMAT | Pricing reference material of main item | UPMAT | CHAR | 18 | 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 | TXJCD | TXJ | |||
TXJCD_SF | Jurisdiction code 'Ship-from' | TXJCD_SF | CHAR | 15 | TXJCD | TXJ | |||
TXJCD_POA | Jurisdiction code 'Point of order acceptance' | TXJCD_POA | CHAR | 15 | TXJCD | TXJ | |||
TXJCD_POO | Jurisdiction code 'Point of order origin' | TXJCD_POO | CHAR | 15 | 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 | ||||
ITEM_CALC_OUT | 0 | ||||||||
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 | ||||
TAX_CALC_RESULTS | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure EXTAX_ITEM_CALC_DATA using ABAP code?
As EXTAX_ITEM_CALC_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EXTAX_ITEM_CALC_DATA as there is no data to select.How to access SAP table EXTAX_ITEM_CALC_DATA
Within an ECC or HANA version of SAP you can also view further information about EXTAX_ITEM_CALC_DATA 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