SAP ABAP Table QSTRMAIN (Line Item Data Structure for Extended W/holding Tax Report.)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-WT (Package) Withholding Tax reporting

Basic Data

Table Category	INTTAB	Structure
Structure	QSTRMAIN	Table Relationship Diagram
Short Description	Line Item Data Structure for Extended W/holding Tax Report.

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
3	PARTNO_TYPE	☐	WT_PARTNO_TYPE	WT_PARNO_TYPE	CHAR	1	0	Type of partner number
4	PARTNERNO	☐	PARTNERNO		CHAR	35	0	Partner ID
5	WT_REVERSED	☐	REVERSED	XFELD	CHAR	1	0	Indicator: Document reversed?
6	WT_PERIOD	☐	WT_REPPERIOD		NUMC	2	0	Reporting Period
7	MONA	☐	BUMON	MONAT	NUMC	2	0	Posting date calendar month
8	WITHT	☐	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	*
9	WT_WITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
10	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
11	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
13	ITEM_SOURCE	☐	WT_ITEM_SOURCE	WT_ITEM_SOURCE	CHAR	1	0	Data source of item
14	ITEM_REF	☐	WT_ITEM_REF	WT_ITEM_REF	CHAR	24	0	Reference to WT item
15	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
17	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
18	KOART	☐	KOART	KOART	CHAR	1	0	Account type
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
20	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
21	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
22	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
23	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
24	WT_PAYDT	☐	WT_PAYDT	DATE	DATS	8	0	Payment date
25	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
26	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
27	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	*
28	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
29	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
30	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
31	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
32	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
33	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
34	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
35	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
36	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
37	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
38	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
39	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
40	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
41	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
42	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
43	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
44	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
45	WT_QSSHH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
46	WT_QSSHB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
47	WT_QBSHH	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
48	WT_QBSHB	☐	WT_WT1	WERTV8	CURR	15	2	Withholding tax amount in document currency
49	WT_QSFHH	☐	WT_EXMP	WERTV8	CURR	15	2	Amount exempt from withholding tax in local currency
50	WT_QSFHB	☐	WT_EXMP1	WERTV8	CURR	15	2	Amount exempt from withholding tax in document currency
51	WT_NETHH	☐	WT_NET	WERTV8	CURR	15	2	Net amount = Invoice amount - withholding tax amount in LC
52	WT_NETHB	☐	WT_NET1	WERTV8	CURR	15	2	Net amount = Invoice amount - w/hold.tax amount in doc.crcy
53	WT_TAXHH	☐	HWSTE	WERT7	CURR	13	2	Tax Amount in Local Currency
54	WT_TAXHB	☐	FWSTE	WERT7	CURR	13	2	Tax Amount in Document Currency
55	WT_PAYBH	☐	WT_PAYBH	WERT8	CURR	15	2	Payment amount in local currency
56	WT_PAYBB	☐	WT_PAYBB	WERT8	CURR	15	2	Payment amount in document currency
57	WT_XDMBTR	☐	WT_FREE_DMBTR	WERT8	CURR	15	2	Free amount field for country specific
58	WT_XWRBTR	☐	WT_FREE_DMBTR	WERT8	CURR	15	2	Free amount field for country specific
59	WT_XDMBTR1	☐	WT_FREE_DMBTR	WERT8	CURR	15	2	Free amount field for country specific
60	WT_XWRBTR1	☐	WT_FREE_DMBTR	WERT8	CURR	15	2	Free amount field for country specific
61	WT_XDMBTR2	☐	WT_FREE_DMBTR	WERT8	CURR	15	2	Free amount field for country specific
62	WT_XWRBTR2	☐	WT_FREE_DMBTR	WERT8	CURR	15	2	Free amount field for country specific
63	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
64	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
65	QSREC	☐	QSREC	QSREC	CHAR	2	0	Vendor Recipient Type	*
66	RCTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
67	QSREP	☐	QSREP	QSREP	CHAR	3	0	Recipient Code for Recipient Type
68	QSCOD	☐	QSCOD	CHAR4	CHAR	4	0	Official Withholding Tax Code
69	RPTXT	☐	TXT50	TEXT50	CHAR	50	0	Text
70	QSATZ	☐	QSATZ	PRZ22	DEC	4	2	Withholding Tax Rate
71	WT_SLFWTPD	☐	WT_SLFWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as self-withholding tax
72	WT_GRUWTPD	☐	WT_GRUWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as "Grossing up"
73	WT_OPOWTPD	☐	WT_OPOWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as a debit/credit
74	CTNUMBER	☐	CTNUMBER	CHAR10	CHAR	10	0	Withholding Tax Certificate Number
75	WT_WTEXMN	☐	WT_EXNR	CHAR15	CHAR	15	0	Exemption certificate number
76	WT_QSZRT	☐	WT_EXRT	PRZ32	DEC	5	2	Exemption rate
77	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
78	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
79	WT_POSIN	☐	WT_POSIN	WT_POSIN	CHAR	1	0	Posting indicator
80	WT_BASMAN	☐	WT_BASMAN	XFELD	CHAR	1	0	Indicator: Withholding tax base amount entered manually
81	WT_AMNMAN	☐	WT_AMNMAN	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually
82	WT_OPEN_ITEM	☐	WT_OPEN_ITEM		CHAR	4	0	Item status ( open, paid ...)
83	WT_NEWWT	☐	WT_NEWWT	XFELD	CHAR	1	0	Indicator: Extended withholding tax active
84	WT_POSTM	☐	WT_POSTM	WT_POSTM	CHAR	1	0	Posting time
85	WT_TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
86	WT_MWSK1	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
87	WT_ISSDT	☐	CTISSUEDATE	DATUM	DATS	8	0	Issue or Print Date of Withholding Tax Certificate
88	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
89	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
90	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
91	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
92	BUKRS_ORG	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
93	LIFNR_ORG	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
94	KUNNR_ORG	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
95	.INCLUDE	☐				0	0
96	STENR	☐	STENR	CHAR18	CHAR	18	0	Tax Number at Responsible Tax Authority

History

Last changed by/on	SAP	20130529
SAP Release Created in