- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Business Accounting (FIN-BAC)
- Business Analytics (FIN-BA)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Corporate Governance (FIN-CGV)
- Financial Shared Service Center (FIN-SSC)
- Financial Supply Chain Management (FIN-FSCM)
- Financials Basis (FIN-FB)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Basic Functions (FI-GL-GL)
- Accrual Engine (FI-GL-GL-ACE)
- Archiving (FI-GL-GL-E)
- Average Daily Balance (FI-GL-GL-ADB)
- CRM Accruals (FI-GL-GL-CAE)
- Closing Operations (FI-GL-GL-CL)
- Closing Operations / Period-End (FI-GL-GL-G)
- Ext. Interfaces/BAPIs/ALE (FI-GL-GL-M)
- Manual Accruals (FI-GL-GL-AAC)
- Planning (FI-GL-GL-PL)
- Posting/Clearing (FI-GL-GL-A)
- Provisions for Awards (FI-GL-GL-SOA)
- Purchase Order Accruals (FI-GL-GL-POA)
- Reporting/Analysis/Display (FI-GL-GL-D)
- Value Added Tax (VAT) (FI-GL-GL-F)
- Flexible Structures (FI-GL-FL)
- Foreign Currency Accounting (FI-GL-CU)
- General Ledger Migration (FI-GL-MIG)
- General Ledger Reorganization (FI-GL-REO)
- Information System (FI-GL-IS)
- Basic Functions (FI-GL-GL)
- Generic Contract Accounts Receivable and Payable (FI-CAX)
- Lease Accounting (FI-LA)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4H Best Practices - Content and Content Activation (FI-CNT)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Strategic Enterprise Management (FIN-SEM)
- Tax Management Framework (FIN-TMF)
- Tax Subledger (FI-TXL)
- Travel Management (FI-TV)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
ETXDCI
External tax document: line item info
|
#transactional
|
Component: Basic Functions
- 🔑 Keys (3)
- 💰 Amounts (10)
- ∑ Quantities (1)
- 📅 Dates (6)
- ☰ Categorical (2)
- Other (98)
- 🔗 Relations (1)
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| DOCNR FK | External-tax document number | |
| ITEMNR | External-tax document item number |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (T001.WAERS): | ||
| AMOUNT | Tax base amount | |
| GROSS_AMOUNT | Tax base amount gross. | |
| FREIGHT_AM | Freight Amount (internal representation) | |
| EXEMPT_AMT | Exempt amount (internal representation) | |
| BILLED_AMOUNT | Billed amount (in currency format) | |
| TAXPCOV | Total tax rate (internal representation - KBETR) | |
| TAXAMOV | Total tax amount (internal representation - HWSTE) | |
| GL_TAXPCOV | G/L tax rate (KBETR) | |
| GL_TAXAMOV | G/L tax amount (HWSTE) | |
| GL_TAXBAS | G/L Tax base amount (HWBAS) | |
| Column Name | Description | |
|---|---|---|
| QUANTITY | Material quantity (internal representation - KOMP-MENGE) |
| Column Name | Description | |
|---|---|---|
| TAX_DATE | Tax date (internal representation) | |
| DOC_DATE | Document Date in Document | |
| POST_DATE | Posting Date in the Document | |
| SR_DATE | Service Render Date | |
| REP_DATE | Posting date (internal format) | |
| _DATAAGING | Data Filter Value for Data Aging |
| Column Name | Description | |
|---|---|---|
| VBTYP | SD Document Category | Show values |
| DEFAULT_REASON | Tax Default Reason | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| TAXPS | Tax document item number | NUM6 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | |
| SHPTO | Tax Jurisdiction | TXJCD | |
| POS_NO | Tax document item number | NUM6 | |
| GROUP_ID | Grouping code for components that are part of the same set | CHAR18 | |
| COUNTRY | Tax Departure Country/Region | LAND1 | |
| DIVISION | Business area/division code | CHAR4 | |
| MATNR | Material number for taxes | CHAR18 | |
| PROD_CODE | SAP Internal Product Code (External Interface) | CHAR10 | |
| GROUP_PROD_CODE | Group product code | CHAR10 | |
| UPMAT | Pricing reference material of main item | MATNR | |
| MATKL | Material Group | MATKL | |
| APAR_IND | Indicator for A/P or A/R | CHAR1 | |
| TAX_TYPE | Indicator: Sales/Use/Rental/Service/... Tax | CHAR1 | |
| EXEMP_IND | Indicator: Transaction Is Tax Exempt/Taxable | CHAR1 | |
| TXJCD_ST | Jurisdiction code "Ship-to" | TXJCD | |
| TXJCD_SF | Jurisdiction code "Ship-from" | TXJCD | |
| TXJCD_POA | Jurisdiction code "Point of order acceptance" | TXJCD | |
| TXJCD_POO | Jurisdiction code "Point of order origin" | TXJCD | |
| ACCNT_NO | Vendor or ship-to customer account number | KTO16 | |
| ACCNT_CLS | Classification item of an account (Customer/vendor) | CHAR10 | |
| COST_OBJECT | Cost object where the goods are consumed | CHAR18 | |
| PTP_IND | Indicator: Point of Title Passage | CHAR1 | |
| EXCERTIF | Customer tax exemption certificate number defined in SAP | CHAR25 | |
| EXREASON | Tax Exemption Reason Code | CHAR2 | |
| USER_DATA | User-Specific Field | TEXT50 | |
| SOLDTO | Sold-to Party | KUNNR | |
| SHIPTO | Ship-to Party | KUNNR | |
| GL_ACCOUNT | G/L Account Number, Significant Length | CHAR10 | |
| KOSTL | Cost Center | KOSTL | |
| EBELN | Purchasing Document Number | EBELN | |
| EBELP | Item Number of Purchasing Document | EBELP | |
| VBELN | Sales and Distribution Document Number | VBELN | |
| CONT_VAL | Total Contract Value | CHAR25 | |
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSNR | |
| BTT_CODE | Business Transaction Type(Do not use! Will be overwrited) | FOT_TDT_TXDAT_DET_BTT_CODE | |
| BILLTO | Bill-to Party | KUNNR | |
| SUPPLIER | Account Number of Supplier | LIFNR | |
| EXTENSION_FIELD001 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD002 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD003 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD004 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD005 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD006 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD007 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD008 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD009 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD010 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD011 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD012 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD013 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD014 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD015 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD016 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD017 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD018 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD019 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD020 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD021 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD022 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD023 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD024 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD025 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD026 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD027 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD028 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD029 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD030 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD031 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD032 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD033 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD034 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD035 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD036 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD037 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD038 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD039 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD040 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD041 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD042 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD043 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD044 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD045 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD046 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD047 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD048 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD049 | Text (100 characters) | TEXT100 | |
| EXTENSION_FIELD050 | Text (100 characters) | TEXT100 | |
| STORE_CODE | Store Code | CHAR10 | |
| USER_REPT_DATA | User specific reporting data | TEXT50 | |
| TXJCD_IND | Indicator: Jurisdiction Code Used for Tax Calculation | CHAR1 | |
| TAX_DATE_RETURN | Date for tax calculation (format YYYYMMDD). | CHAR8 | |
| EXMATFLAG | Code for Material Tax Exemption | CHAR2 | |
| EXCUSFLG | Code for Customer Tax Exemption | CHAR2 | |
| EXT_EXCERTIF | Customer exempt certificate as returned by tax system | CHAR25 | |
| EXT_EXREASON | Tax Exemption Reason Code as returned by tax system | CHAR2 | |
| TAX_STATE | Tax State | ||
| CREDIT_IND | Indicator: Tax Credit | CHAR1 |