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
MWSKZTax on sales/purchases codeMWSKZCHAR2(0) MWSKZ
BUKRSCompany CodeBUKRSCHAR4(0) BUKRSBUKC_T001BUKRS
HWBASTax Base Amount in Local CurrencyHWBAS_BSESCURR23(2) AC152AFLE15D2O21S_TO_23D2O31S
FWBASTax base amount in document currencyFWBAS_BSESCURR23(2) AC152AFLE15D2O21S_TO_23D2O31S
HWBADTax Base Amount in Local Currency (Tax Line Items)HWBAD_MWSTCURR23(2) AU152AFLE15D2O20N_TO_23D2O30N
FWBADTax Base Amount in Document Currency (Tax Line Items)FWBAD_MWSTCURR23(2) AU152AFLE15D2O20N_TO_23D2O30N
HWSKBCash Discount Base Amount (Local Currency)HWSKBCURR23(2) AU152AFLE15D2O20N_TO_23D2O30N
HWSTETax Amount in Local CurrencyHWSTECURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
FWSTETax Amount in Document CurrencyFWSTECURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
HWSTDTax Amount in Local Currency (Tax Line Items)HWSTD_MWSTCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
FWSTDTax Amount in Foreign Currency (Tax Line Items)FWSTD_MWSTCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
HWNAFNon-Deductible Input Tax in Local CurrencyHWNAFCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
FWNAFNon-Deductible Input Tax in Document CurrencyFWNAFCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
HWNADNon-Deductible Tax (Local Currency Tax Line Items)HWNAD_MWSTCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
FWNADForeign Currency Non-Deductible Tax (Tax Line Items)FWNAD_MWSTCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
HWNAGNon-Deductible Tax in Loc.Curr. Already Posted (in CDC Item)HWNAG_BSEZCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
FWNAGNon-Deductible Tax in For.Curr.Already Posted (in DiCl.Line)FWNAG_BSEZCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
HWZUZProvision Amount in Local CurrencyHWZUZCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
FWZUZAdditional Tax in Document CurrencyFWZUZCURR23(2) AU132AFLE13D2O16N_TO_23D2O30N
HWZBAAdditional Tax Base Amount in Local CurrencyHWZBA_MWSTCURR23(2) AU152AFLE15D2O20N_TO_23D2O30N
FWZBAAdditional Tax Base Amount in Foreign CurrencyFWZBA_MWSTCURR23(2) AU152AFLE15D2O20N_TO_23D2O30N
ANZPONumber of Line Items for this Tax CodeANZPO_MWSTDEC5(0) DEC5
MSATZTax RateMSATZ_MWSTNUMC5(0) NUM5
PRUEFIndicator: Error Message for Invalid Tax Amount ?PRUEF_007CHAR1(0) XFELD
REARTCalculation Method for Taxes on Sales/PurchasesREART_007CHAR1(0) REART
RUNKZTaxes on Sales/Purchases Rounding IndicatorRUNKZ_007CHAR1(0) RUNKZ
MWARTTax TypeMWARTCHAR1(0) MWART
NAFPZNon-Deductible Portion of Input Tax ( in % )NAFPZ_MWSTNUMC5(0) NUM5
NAFVTIndicator: Distribute Non-Deductible Tax ?NAFVT_007CHAR1(0) XFELD
ZKOVTAdditional Tax Cost DistributionDZKOVT_007CHAR1(0) ZKOVT
ZSABFIndicator: Postponed Accounting SystemDZSABF_007CHAR1(0) XFELD




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!