- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- 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)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- ACR Activities (FI-LOC-VAT)
- Audit Reporting (FI-LOC-AUR)
- Cash Flow Localization (FI-LOC-CF)
- Cash Management (FI-LOC-CM)
- Contract Accounts Receivable and Payable (FI-LOC-CA)
- Corporate Income Tax Framework (FI-LOC-CIT)
- Globalization Service: Business Place (FI-LOC-BUP)
- Golden Audit Interface (FI-LOC-GAI)
- Localization Asset Accounting (FI-LOC-AA)
- Localization E-Payment Integration (FI-LOC-EPI)
- Localization Financials (FI-LOC-FI)
- Localization Financials (generic parts) (FI-LOC-GEN)
- Localization Financials EC Sales List (FI-LOC-ECS)
- Localization Financials Statements (FI-LOC-FS)
- Localization Funds Management (FI-LOC-FM)
- Localization Logistics (FI-LOC-LO)
- Localization for Utilities Industry (FI-LOC-UT)
- Payment Receipt (FI-LOC-PR)
- SAF-T Reporting (Generic Part) (FI-LOC-SAF)
- Statutory Reporting (FI-LOC-IS)
- Statutory Reporting Framework (FI-LOC-SRF)
- Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- 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 Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_OM_StRpTaxItemQuery
Tax Items With Tax Box Grouping - Query
| view: COMSRTAXITEMQ
| Extraction:
Not supported
| Component: Localization
Tables used:
VBAP, VBRK, VBRP, CFIN_AV_SO_BIZ, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, VBAK, VBAP, VBKD, VEDA, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, CFIN_AV_CI_ITEM, CFIN_AV_CI_ROOT, CFIN_AV_SO_ITEM, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, FIVATGENC_T007L, T007A, FIVATGENC_T007K, T001, T014, T007B, T007L, T007K
| Column Name | Description | |
|---|---|---|
| CompanyCode | Company Code | |
| AccountingDocument | Document Number of an Accounting Document | |
| FiscalYear | Fiscal Year | |
| TaxItem | Number of Line Item Within Accounting Document | |
| StatryRptgEntity FK | Reporting Entity | |
| StatryRptCategory FK | Report Category ID | |
| StatryRptRunID | Report Run ID | |
| DebitCreditCode | Debit/Credit Indicator | Show values |
| TaxBox | Tax Box | |
| TaxCode | Tax on sales/purchases code | |
| TransactionTypeDetermination | Transaction Key | |
| TaxDeclnAmountType | Amount Type for Statutory Reporting | Show values |
| TaxItemGroupingVersion | Grouping Version for Advance Return for Tax on Sales/Purch. | |
| SupplierAccountGroup FK | Vendor account group |
| Column Name | Description | |
|---|---|---|
| 💲 Reporting Currency (ReportingCurrency): | ||
| TaxBaseAmountInRptgCrcy | Tax Base Amount in Reporting Currency | |
| TaxAmountInRptgCrcy | Tax Amount in Reporting Currency | |
| AmountInReportingCurrency | null | |
| 💲 Company Code Currency (CompanyCodeCurrency): | ||
| TaxBaseAmountInCoCodeCrcy | Tax Base Amount in Document Currency | |
| TaxAmountInCoCodeCrcy | Tax Amount in Local Currency | |
| 💲 Currency Key (DocumentCurrency): | ||
| TaxBaseAmountInTransCrcy | Tax Amount in Document Currency | |
| TaxAmount | Tax Amount in Document Currency | |
| 💲 Currency Key (CountryCurrency): | ||
| TaxBaseAmountInCountryCrcy | Tax Base in Reporting Currency | |
| TaxAmountInCountryCrcy | Tax Amount in Reporting Currency | |
| 💲 Additional Currency 1 (AdditionalCurrency1): | ||
| TaxBaseAmtInAdditionalCrcy1 | Tax Base Amount in Local Currency 2 | |
| TaxAmountInAdditionalCurrency1 | Tax Amount in Local Currency 2 | |
| 💲 Additional Currency 2 (AdditionalCurrency2): | ||
| TaxBaseAmtInAdditionalCrcy2 | Tax Base Amount in Local Currency 3 | |
| TaxAmountInAdditionalCurrency2 | Tax Amount in Local Currency 3 | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PostingDate | Posting Date in the Document | |
| DocumentDate | Journal Entry Date | |
| TaxReportingDate | Tax Reporting Date | |
| ReportingDate | Reporting Date | |
| TaxRateValidityStartDate | Valid-From Date of the Tax Rate |
| Column Name | Description | |
|---|---|---|
| DebitCreditCode | Debit/Credit Indicator | Show values |
| TaxDeclnAmountType | Amount Type for Statutory Reporting | Show values |
| TaxType | Tax Type | Show values |
| FinancialAccountType | Account Type | Show values |
| IsReversal | Indicator: Item is Reversing Another Item | Show values |
| IsReversed | Indicator: Item is Reversed | Show values |
| EUTaxClassification | EU Code/Code | Show values |
| TaxIsNotDeductible | Indicator: Tax not deductible | Show values |
| DebitCreditCodeIsChanged | DebitCreditCode Changed Indicator | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| TaxRate | TaxRate (Percentage) | ||
| GLAccount | General Ledger Account | SAKNR | |
| TaxItemGroup | Group Indicator for Tax Line Items | NUM03 | |
| BusinessPlace | Business Place | J_1BBRANCH | |
| TaxJurisdiction | Tax Jurisdiction | TXJCD | |
| AccountingDocumentType | Document Type | BLART | |
| ReferenceDocumentType | Reference Document Type | AWTYP | |
| ReverseDocument | Reverse Document Number | BELNR | |
| ReverseDocumentFiscalYear | Fiscal Year of Reversal Document | GJAHR | |
| DocumentReferenceID | Document Reference ID | XBLNR1 | |
| FiscalPeriod | Fiscal Period | POPER | |
| AccountingDocumentHeaderText | Document Header Text | TEXT25 | |
| CompanyCodeCountry | Country/Region Key | LAND1 | |
| ReportingCountry | Reporting Country/Region | LAND1 | |
| TaxReturnCountry | Country/Region for Tax Report | LAND1 | |
| TaxNumber1 | Tax Number 1 | STCD1 | |
| TaxNumber2 | Tax Number 2 | STCD2 | |
| TaxNumber3 | Tax Number 3 | CHAR18 | |
| BusinessPartner | Business Partner Number | BU_PARTNER | |
| BusinessPartnerName | Business Partner Name | TEXT80 | |
| MiniOneStopShopTxRptgCntry | OSS Tax Reporting Country/Region | LAND1 | |
| RefAccountingDocument | Invoice Reference | BELNR | |
| TaxCountry | Tax Reporting Country/Region | LAND1 |
| Master Data Relations | Join Conditions |
|---|---|
Reporting Entity
|
|
Vendor account group
| |
Tax Code
| |
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
|