1. Home
  2. Resources
  3. SAP Tables
  4. MWSTB - Internal Table for Taxes on Sales and Purchases

SAP Table MWSTB

Internal Table for Taxes on Sales and Purchases

MWSTB (Internal Table for Taxes on Sales and Purchases) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MWSTB to other SAP tables.

MWSTB table fields

Field Data element Checktable Datatype Length Decimals
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
BUKRS Company Code BUKRS CHAR 4 0
HWBAS Tax Base Amount in Local Currency HWBAS_BSES CURR 15 2
FWBAS Tax base amount in document currency FWBAS_BSES CURR 15 2
HWBAD Tax Base Amount in Local Currency (Tax Line Items) HWBAD_MWST CURR 15 2
FWBAD Tax Base Amount in Document Currency (Tax Line Items) FWBAD_MWST CURR 15 2
HWSKB Cash Discount Base Amount (Local Currency) HWSKB CURR 15 2
HWSTE Tax Amount in Local Currency HWSTE CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
HWSTD Tax Amount in Local Currency (Tax Line Items) HWSTD_MWST CURR 13 2
FWSTD Tax Amount in Foreign Currency (Tax Line Items) FWSTD_MWST CURR 13 2
HWNAF Non-Deductible Input Tax in Local Currency HWNAF CURR 13 2
FWNAF Non-Deductible Input Tax in Document Currency FWNAF CURR 13 2
HWNAD Non-Deductible Tax (Local Currency Tax Line Items) HWNAD_MWST CURR 13 2
FWNAD Foreign Currency Non-Deductible Tax (Tax Line Items) FWNAD_MWST CURR 13 2
HWNAG Non-Deductible Tax in Loc.Curr. Already Posted (in CDC Item) HWNAG_BSEZ CURR 13 2
FWNAG Non-Deductible Tax in For.Curr.Already Posted (in DiCl.Line) FWNAG_BSEZ CURR 13 2
HWZUZ Provision Amount in Local Currency HWZUZ CURR 13 2
FWZUZ Additional Tax in Document Currency FWZUZ CURR 13 2
HWZBA Additional Tax Base Amount in Local Currency HWZBA_MWST CURR 15 2
FWZBA Additional Tax Base Amount in Foreign Currency FWZBA_MWST CURR 15 2
ANZPO Number of Line Items for this Tax Code ANZPO_MWST DEC 5 0
MSATZ Tax Rate MSATZ_MWST NUMC 5 0
PRUEF Indicator: Error Message for Invalid Tax Amount ? PRUEF_007 CHAR 1 0
X Yes
NULL No
REART Calculation Method for Taxes on Sales/Purchases REART_007 CHAR 1 0
I Percentage included
V Percentage separate
RUNKZ Taxes on Sales/Purchases Rounding Indicator RUNKZ_007 CHAR 1 0
NULL Round up or down one place
A Always round up
B Always round down
MWART Tax Type MWART CHAR 1 0
A Output tax
V Input tax
NAFPZ Non-Deductible Portion of Input Tax ( in % ) NAFPZ_MWST NUMC 5 0
NAFVT Indicator: Distribute Non-Deductible Tax ? NAFVT_007 CHAR 1 0
X Yes
NULL No
ZKOVT Additional Tax Cost Distribution DZKOVT_007 CHAR 1 0
1 No offsetting entry for add.tax (contained in open items)
2 Additional tax posting, fixed offsetting account
3 Additional tax posting, expense/revenue adjustment
ZSABF Indicator: Postponed accounting system DZSABF_007 CHAR 1 0
X Yes
NULL No