ETXDCI is a SAP table coming under FI module and SAP_FIN component.View details, Fields & related tables of ETXDCI in SAP.
- Table description : External tax document: line item info
- Module : FI-GL-GL
- Parent Module : FI
- Package : FYTX/ETXDC
- Software Component : SAP_FIN
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP ETXDCI Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| DOCNR | External-tax document number | XTAX_DOCUMENT_NUMBER | CHAR12 |
| ITEMNR | External-tax document item number | XTAX_DOC_ITEM_NUMBER | NUM6 |
| .INCLUDE | tax line secondary key | ||
| TAXPS | Tax document item number | TAX_POSNR | NUM6 |
| MWSKZ | Tax on sales/purchases code | MWSKZ | MWSKZ |
| SHPTO | Tax Jurisdiction | TXJCD | TXJCD |
| .INCLUDE | external document item input data | ||
| .INCLUDE | External Tax document substructure: material info | ||
| POS_NO | Tax document item number | TAX_POSNR | NUM6 |
| GROUP_ID | Grouping code for components that are part of the same set | TAX_GROUP_ID | CHAR18 |
| COUNTRY | Tax Departure Country | LANDTX | LAND1 |
| DIVISION | Business area/division code | DIVISION | CHAR4 |
| MATNR | Material number for taxes | TAX_MATNR | CHAR18 |
| PROD_CODE | SAP internal product code (external interface) | PROCD_TTXP | CHAR10 |
| GROUP_PROD_CODE | Group product code | GRP_PROCD | CHAR10 |
| QUANTITY | Material quantity (internal representation - KOMP-MENGE) | ETD_QUANTITY | MENG13 |
| UNIT | Unit for quantity | TAX_UNIT | MEINS |
| UPMAT | Pricing reference material of main item | UPMAT | MATNR |
| .INCLUDE | Tax substructure: tax code info. | ||
| APAR_IND | Indicator for A/P or A/R | APAR_IND | CHAR1 |
| TAX_TYPE | Indicator: Sales/use/rental/service/tax | TAXTYPEXT | CHAR1 |
| EXEMP_IND | Indicator: Transaction is tax exempt/taxable | EXTEXMTFLG | CHAR1 |
| .INCLUDE | Tax substructure: Transaction Info | ||
| TAX_DATE | Tax date (internal representation) | ETDTXDAT | DATUM |
| TXJCD_ST | Jurisdiction code "Ship-to" | TXJCD_ST | TXJCD |
| TXJCD_SF | Jurisdiction code "Ship-from" | TXJCD_SF | TXJCD |
| TXJCD_POA | Jurisdiction code "Point of order acceptance" | TXJCD_POA | TXJCD |
| TXJCD_POO | Jurisdiction code "Point of order origin" | TXJCD_POO | TXJCD |
| AMOUNT | Tax base amount | ETDTAXBASE | WERT7 |
| GROSS_AMOUNT | Tax base amount gross. | ETDGROSS_AMOUNT | WERT7 |
| FREIGHT_AM | Freight Amount (internal representation) | ETDFRTAMOUNT | WERT7 |
| EXEMPT_AMT | Exempt amount (internal representation) | ETDEXMTAMOUNT | WERT7 |
| .INCLUDE | Tax substructure: Info about how material is used | ||
| ACCNT_NO | Vendor or ship-to customer account number | TAX_ACCNT_NO | KTO16 |
| ACCNT_CLS | Classification item of an account (Customer/vendor) | TAX_ACCNT_CLS | CHAR10 |
| COST_OBJECT | Cost object where the goods are consumed | TAX_COST_OBJECT | CHAR18 |
| PTP_IND | Indicator: Point of Title Passage | PTP_IND | CHAR1 |
| EXCERTIF | Customer tax exemption certificate number defined in SAP | EXCERTIF | CHAR25 |
| EXREASON | Tax Exemption Reason Code | EXDETCODE | CHAR2 |
| USER_DATA | User-specific field | USER_DATA | TEXT50 |
| .INCLUDE | Tax substructure: Reporting Info | ||
| STORE_CODE | Store Code | STORE_CODE | CHAR10 |
| USER_REPT_DATA | User specific reporting data | USER_REPT_DATA | TEXT50 |
| .INCLUDE | external document item output data | ||
| DEFAULT_REASON | Tax Default Reason | TAX_DEFAULT_REASON | TAX_DEFAULTED |
| .INCLUDE | Tax Interface: document item output. | ||
| TXJCD_IND | Indicator: Jurisdiction code used for tax calculation | TXJCDIND | CHAR1 |
| TAXPCOV | Total tax rate (internal representation - KBETR) | ETDTAXPERCNTG | WERTV6 |
| TAXAMOV | Total tax amount (internal representation - HWSTE) | ETDTAXAMOUNTG | WERT7 |
| EXMATFLAG | Code for material tax exemption | EXMATCODE | CHAR2 |
| EXCUSFLG | Code for customer tax exemption | EXCUSCODE | CHAR2 |
| EXT_EXCERTIF | Customer exempt certificate as returned by tax system | EXT_EXCERTIF | CHAR25 |
| EXT_EXREASON | Tax Exemption Reason Code as returned by tax system | EXT_DETCODE | CHAR2 |
| .INCLUDE | GL tax results at item level | ||
| GL_TAXPCOV | G/L tax rate (KBETR) | GL_TAXPERCNT | WERTV6 |
| GL_TAXAMOV | G/L tax amount (HWSTE) | GL_TAXAMOUNT | WERT7 |
| .INCLUDE | External tax document item posting info | ||
| .INCLUDE | Tax substructure: Posting Info | ||
| REP_DATE | Posting date (internal format) | EXTREPDATE | DATUM |
| CREDIT_IND | Indicator: Tax credit | EXTCREDFLG | CHAR1 |
ETXDCI related tables
| Table | Note |
|---|---|
| ETXDCI | External tax document: line item info |
| WITH_ITEM | Witholding tax info per W/tax type and FI line item |
| DBERDLB | Reference of a Print Doc. Line Item to a Bill.Doc. Line Item |
| T021 | Fields for Line Item and Document Line Layout |
| ETXDCH | External tax document: header info |
| REGUPW | W/tax information per w/tax type/FI line item in pmnt run |
| CACS00_DOCSEDT | Line Item Detail Line |
| GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) |
| J_3RFTAXRA | Tax Accounting: Actual line item table |
| J_3RFTAXRP | Tax Accounting: Plan line item table |
| J_3RFTAXRVA | Tax Accounting: Actual line item table |
| J_3RFTAXRVP | Tax Accounting: Plan line item table |
| VIITTCCALCRES | Input Tax Correction: Line Item |
| ERCHZ_RIVA | Billing Document Individual Line Item Extract (RIVA) |
| FMALE_SETNUM | FM Document Numbers to be Converted FI Line Item Table FM |
Billing document line item TablesSap billing document line item report TablesSales document line item data in sap TablesBilling document line item table TablesBilling document line item table in sap TablesSap billing document line item table TablesBilling document partner function by line item TablesLine item Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP