EXTAX_ITEM_AUDIT_DATA SAP (xtax item data to update the external system) Structure details
Description: xtax item data to update the external system
Related tables to EXTAX_ITEM_AUDIT_DATA
Access table EXTAX_ITEM_AUDIT_DATA
Structure field list including key, data, relationships and ABAP select examples
EXTAX_ITEM_AUDIT_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 "xtax item data to update 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_AUDIT_DATA TYPE EXTAX_ITEM_AUDIT_DATA.
The EXTAX_ITEM_AUDIT_DATA table consists of various fields, each holding specific information or linking keys about xtax item data to update the external system data available in SAP. These include REF_ITEM_KEY (), TAXPS (Tax document item number), MWSKZ (Tax on sales/purchases code), SHPTO (Tax Jurisdiction).. 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_AUDIT_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 |
TXJLV_AUDIT_DATA | 0 | ||||||||
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 | |||
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 | ||||
REP_DATE | Posting date (internal format) | EXTREPDATE | DATS | 8 | DATUM | ||||
CREDIT_IND | Indicator: Tax credit | EXTCREDFLG | CHAR | 1 | CHAR1 | ||||
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 | ||||
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure EXTAX_ITEM_AUDIT_DATA using ABAP code?
As EXTAX_ITEM_AUDIT_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_AUDIT_DATA as there is no data to select.How to access SAP table EXTAX_ITEM_AUDIT_DATA
Within an ECC or HANA version of SAP you can also view further information about EXTAX_ITEM_AUDIT_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