SAP Table QSTRMAIN

Line Item Data Structure for Extended W/holding Tax Report.

QSTRMAIN (Line Item Data Structure for Extended W/holding Tax Report.) 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 QSTRMAIN to other SAP tables.

QSTRMAIN table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
BUPLA Business Place BUPLA CHAR 4 0
PARTNO_TYPE Type of partner number WT_PARTNO_TYPE CHAR 1 0
NULL Vendor/Customer (FI-AP/AR)
1 Business Partner (FI-CA)
PARTNERNO Partner ID PARTNERNO CHAR 35 0
WT_REVERSED Indicator: Document reversed? REVERSED CHAR 1 0
X Yes
NULL No
WT_PERIOD Reporting Period WT_REPPERIOD NUMC 2 0
MONA Posting date calendar month BUMON NUMC 2 0
WITHT Indicator for withholding tax type WITHT CHAR 2 0
WT_WITHCD Withholding tax code WT_WITHCD CHAR 2 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
ITEM_SOURCE Data source of item WT_ITEM_SOURCE CHAR 1 0
NULL FI-AP/AR
1 FI-CA
ITEM_REF Reference to WT item WT_ITEM_REF CHAR 24 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
GSBER Business Area GSBER CHAR 4 0
BLDAT Document Date in Document BLDAT DATS 8 0
SGTXT Item Text SGTXT CHAR 50 0
AUGDT Clearing Date AUGDT DATS 8 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
WT_PAYDT Payment date WT_PAYDT DATS 8 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
ZUMSK Target Special G/L Indicator DZUMSK CHAR 1 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART CHAR 2 0
BSCHL Posting Key BSCHL CHAR 2 0
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
XCPDD Indicator: Address and bank data set individually XCPDD CHAR 1 0
X Yes
NULL No
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
REBZT Follow-On Document Type REBZT CHAR 1 0
XREF2 Business partner reference key XREF2 CHAR 12 0
XREF3 Reference key for line item XREF3 CHAR 20 0
HWAER Local Currency HWAER CUKY 5 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
WRBTR Amount in document currency WRBTR CURR 13 2
WT_QSSHH Withholding tax base amount (local currency) WT_BS CURR 15 2
WT_QSSHB Withholding tax base amount in document currency WT_BS1 CURR 15 2
WT_QBSHH Withholding tax amount (in local currency) WT_WT CURR 15 2
WT_QBSHB Withholding tax amount in document currency WT_WT1 CURR 15 2
WT_QSFHH Amount exempt from withholding tax in local currency WT_EXMP CURR 15 2
WT_QSFHB Amount exempt from withholding tax in document currency WT_EXMP1 CURR 15 2
WT_NETHH Net amount = Invoice amount - withholding tax amount in LC WT_NET CURR 15 2
WT_NETHB Net amount = Invoice amount - w/hold.tax amount in doc.crcy WT_NET1 CURR 15 2
WT_TAXHH Tax Amount in Local Currency HWSTE CURR 13 2
WT_TAXHB Tax Amount in Document Currency FWSTE CURR 13 2
WT_PAYBH Payment amount in local currency WT_PAYBH CURR 15 2
WT_PAYBB Payment amount in document currency WT_PAYBB CURR 15 2
WT_XDMBTR Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XWRBTR Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XDMBTR1 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XWRBTR1 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XDMBTR2 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XWRBTR2 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
QSREC Vendor Recipient Type QSREC CHAR 2 0
RCTXT Text (30 Characters) TEXT30 CHAR 30 0
QSREP Recipient Code for Recipient Type QSREP CHAR 3 0
QSCOD Official Withholding Tax Code QSCOD CHAR 4 0
RPTXT Text TXT50 CHAR 50 0
QSATZ Withholding Tax Rate QSATZ DEC 4 2
WT_SLFWTPD Indicator: Entry posted as self-withholding tax WT_SLFWTPD CHAR 1 0
X Yes
NULL No
WT_GRUWTPD Indicator: Entry posted as "Grossing up" WT_GRUWTPD CHAR 1 0
X Yes
NULL No
WT_OPOWTPD Indicator: Entry posted as a debit/credit WT_OPOWTPD CHAR 1 0
X Yes
NULL No
CTNUMBER Withholding Tax Certificate Number CTNUMBER CHAR 10 0
WT_WTEXMN Exemption certificate number WT_EXNR CHAR 15 0
WT_QSZRT Exemption rate WT_EXRT DEC 5 2
LAND1 Country Key LAND1 CHAR 3 0
SECCO Section Code SECCO CHAR 4 0
WT_POSIN Posting indicator WT_POSIN CHAR 1 0
1 Standard posting: Bank/vendor/customer line item reduced
2 Offsetting entry to G/L account ("grossing up")
3 Offsetting entry to G/L account
WT_BASMAN Indicator: Withholding tax base amount entered manually WT_BASMAN CHAR 1 0
X Yes
NULL No
WT_AMNMAN Indicator: Withholding tax amount entered manually WT_AMNMAN CHAR 1 0
X Yes
NULL No
WT_OPEN_ITEM Item status ( open, paid ...) WT_OPEN_ITEM CHAR 4 0
WT_NEWWT Indicator: Extended withholding tax active WT_NEWWT CHAR 1 0
X Yes
NULL No
WT_POSTM Posting time WT_POSTM CHAR 1 0
1 Posting at time of invoice entry
2 Posting at time of payment
WT_TCODE Transaction Code TCODE CHAR 20 0
WT_MWSK1 Tax Code for Distribution MWSKX CHAR 2 0
WT_ISSDT Issue or Print Date of Withholding Tax Certificate CTISSUEDATE DATS 8 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
EMPFB Payee/Payer EMPFB CHAR 10 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
BUKRS_ORG Company Code BUKRS CHAR 4 0
LIFNR_ORG Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR_ORG Customer Number KUNNR CHAR 10 0
STENR Tax Number at Responsible Tax Authority STENR CHAR 18 0