SAP MWSTB Table in S/4 HANA - Internal Table for Taxes on Sales and Purchases
MWSTB is a standard SAP Table which is used to store Internal Table for Taxes on Sales and Purchases data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MWSTB table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Structure
Database Table: MWSTB
MWSTB table structure field list
Below is the full MWSTB field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | MWSKZ | |||||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
HWBAS | Tax Base Amount in Local Currency | HWBAS_BSES | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
FWBAS | Tax base amount in document currency | FWBAS_BSES | CURR | 23(2) | AC152 | AFLE15D2O21S_TO_23D2O31S | ||||
HWBAD | Tax Base Amount in Local Currency (Tax Line Items) | HWBAD_MWST | CURR | 23(2) | AU152 | AFLE15D2O20N_TO_23D2O30N | ||||
FWBAD | Tax Base Amount in Document Currency (Tax Line Items) | FWBAD_MWST | CURR | 23(2) | AU152 | AFLE15D2O20N_TO_23D2O30N | ||||
HWSKB | Cash Discount Base Amount (Local Currency) | HWSKB | CURR | 23(2) | AU152 | AFLE15D2O20N_TO_23D2O30N | ||||
HWSTE | Tax Amount in Local Currency | HWSTE | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
FWSTE | Tax Amount in Document Currency | FWSTE | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
HWSTD | Tax Amount in Local Currency (Tax Line Items) | HWSTD_MWST | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
FWSTD | Tax Amount in Foreign Currency (Tax Line Items) | FWSTD_MWST | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
HWNAF | Non-Deductible Input Tax in Local Currency | HWNAF | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
FWNAF | Non-Deductible Input Tax in Document Currency | FWNAF | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
HWNAD | Non-Deductible Tax (Local Currency Tax Line Items) | HWNAD_MWST | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
FWNAD | Foreign Currency Non-Deductible Tax (Tax Line Items) | FWNAD_MWST | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
HWNAG | Non-Deductible Tax in Loc.Curr. Already Posted (in CDC Item) | HWNAG_BSEZ | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
FWNAG | Non-Deductible Tax in For.Curr.Already Posted (in DiCl.Line) | FWNAG_BSEZ | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
HWZUZ | Provision Amount in Local Currency | HWZUZ | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
FWZUZ | Additional Tax in Document Currency | FWZUZ | CURR | 23(2) | AU132 | AFLE13D2O16N_TO_23D2O30N | ||||
HWZBA | Additional Tax Base Amount in Local Currency | HWZBA_MWST | CURR | 23(2) | AU152 | AFLE15D2O20N_TO_23D2O30N | ||||
FWZBA | Additional Tax Base Amount in Foreign Currency | FWZBA_MWST | CURR | 23(2) | AU152 | AFLE15D2O20N_TO_23D2O30N | ||||
ANZPO | Number of Line Items for this Tax Code | ANZPO_MWST | DEC | 5(0) | DEC5 | |||||
MSATZ | Tax Rate | MSATZ_MWST | NUMC | 5(0) | NUM5 | |||||
PRUEF | Indicator: Error Message for Invalid Tax Amount ? | PRUEF_007 | CHAR | 1(0) | XFELD | |||||
REART | Calculation Method for Taxes on Sales/Purchases | REART_007 | CHAR | 1(0) | REART | |||||
RUNKZ | Taxes on Sales/Purchases Rounding Indicator | RUNKZ_007 | CHAR | 1(0) | RUNKZ | |||||
MWART | Tax Type | MWART | CHAR | 1(0) | MWART | |||||
NAFPZ | Non-Deductible Portion of Input Tax ( in % ) | NAFPZ_MWST | NUMC | 5(0) | NUM5 | |||||
NAFVT | Indicator: Distribute Non-Deductible Tax ? | NAFVT_007 | CHAR | 1(0) | XFELD | |||||
ZKOVT | Additional Tax Cost Distribution | DZKOVT_007 | CHAR | 1(0) | ZKOVT | |||||
ZSABF | Indicator: Postponed Accounting System | DZSABF_007 | CHAR | 1(0) | XFELD |
Search for further information about these or an SAP related objects