SAP ABAP Table TCJ_WTAX_ITEMS (Withholding Tax Items for Cash Journal Document Items)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-GL-AP (Application Component) G/L Account Posting
     ⤷ CAJO (Package) Cash Journal Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCJ_WTAX_ITEMS	Table Relationship Diagram
Short Description	Withholding Tax Items for Cash Journal Document Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	COMP_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	CAJO_NUMBER	☑	CJNR	CJNR	CHAR	4	0	Cash Journal Number	TCJ_C_JOURNALS
4	FISC_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	POSTING_NUMBER	☑	CJBELNR	BELNR	CHAR	10	0	Cash Journal Document Number	TCJ_DOCUMENTS
6	POSITION_NUMBER	☑	CJBUZEI	BUZEI	NUMC	3	0	Number of Line Item within Cash Journal Document
7	WTAXTYPE	☑	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	T059P
8	STATUS	☐	CJWT_ITEM_STATUS	CJITSTATUS	CHAR	2	0	Status of withholding tax items for cash journal doc. item
9	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFB1
10	.INCLUDE	☐				0	0	Withholding tax information for FI Interface
11	WT_KEY	☐	WT_KEY	NUMC06	NUMC	6	0	Grouping key for withholding tax information
12	WITHT	☐	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	*
13	WT_WITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
14	WT_QSSHH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
15	WT_QSSHB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
16	WT_QSSH2	☐	WT_BS2	WERTV8	CURR	15	2	Withholding tax base amount in 2nd local currency
17	WT_QSSH3	☐	WT_BS3	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency
18	WT_QBUIHH	☐	WT_QBUIHH	WERTV8	CURR	15	2	Enter withholding tax amount in local currency manually
19	WT_QBUIHB	☐	WT_QBUIHB	WERTV8	CURR	15	2	Enter withholding tax amount in document currency manually
20	WT_QBUIH2	☐	WT_QBUIH2	WERTV8	CURR	15	2	Manually entered with/tax amount in 2nd local currency
21	WT_QBUIH3	☐	WT_QBUIH3	WERTV8	CURR	15	2	With/tax amount in 3rd local currency entered manually
22	WT_WDMBTR	☐	WT_AWT	WERTV8	CURR	15	2	Withholding tax amount (in local currency) already withheld
23	WT_WWRBTR	☐	WT_AWT1	WERTV8	CURR	15	2	Withholding tax amount already withheld in document currency
24	WT_WDMBT2	☐	WT_AWT2	WERTV8	CURR	15	2	Withholding tax amount already withheld in 2nd local curr.
25	WT_WDMBT3	☐	WT_AWT3	WERTV8	CURR	15	2	With/tax amount already withheld in 3rd local currency
26	WT_BASMAN	☐	WT_BASMAN	XFELD	CHAR	1	0	Indicator: Withholding tax base amount entered manually
27	WT_AMNMAN	☐	WT_AMNMAN	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually
28	WT_QBSHH	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
29	WT_QBSHB	☐	WT_WT1	WERTV8	CURR	15	2	Withholding tax amount in document currency
30	WT_QBSH2	☐	WT_WT2	WERTV8	CURR	15	2	Withholding tax amount in 2nd local currency
31	WT_QBSH3	☐	WT_WT3	WERTV8	CURR	15	2	Withholding tax amount in 3rd local currency
32	WT_QBSHHA	☐	WT_WTA	WERTV8	CURR	15	2	W/tax auxiliary amount for reversal (in local currency)
33	WT_QBSHHB	☐	WT_WTB	WERTV8	CURR	15	2	W/tax auxiliary amount 2 in local currency for reversal
34	WT_STAT	☐	WT_STAT	WT_STAT	CHAR	1	0	Line item status
35	WT_QSFHH	☐	WT_EXMP	WERTV8	CURR	15	2	Amount exempt from withholding tax in local currency
36	WT_QSFHB	☐	WT_EXMP1	WERTV8	CURR	15	2	Amount exempt from withholding tax in document currency
37	WT_QSFH2	☐	WT_EXMP2	WERTV8	CURR	15	2	Withholding tax exempt amount in 2nd local currency
38	WT_QSFH3	☐	WT_EXMP3	WERTV8	CURR	15	2	Withholding tax exempt amount in 3rd local currency
39	WT_WTEXMN	☐	WT_EXNR	CHAR15	CHAR	15	0	Exemption certificate number
40	KOART	☐	KOART	KOART	CHAR	1	0	Account type
41	WT_ACCO	☐	WT_ACNO	CHAR10	CHAR	10	0	Vendor/customer account number
42	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
43	HKONT_OPP	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
44	QSREC	☐	WT_QSREC	WT_QSREC	CHAR	2	0	Type of recipient	*
45	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
46	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
47	WT_QSZRT	☐	WT_EXRT	PRZ32	DEC	5	2	Exemption rate
48	TEXT15	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
49	QSATZ	☐	WT_QSATZ	PRZ34	DEC	7	4	Withholding tax rate
50	WT_SLFWTPD	☐	WT_SLFWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as self-withholding tax
51	WT_GRUWTPD	☐	WT_GRUWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as "Grossing up"
52	WT_OPOWTPD	☐	WT_OPOWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as a debit/credit
53	WT_GIVENPD	☐	WT_GIVENPD	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually with pmnt
54	CTNUMBER	☐	CTNUMBER	CHAR10	CHAR	10	0	Withholding Tax Certificate Number
55	WT_DOWNC	☐	WT_DOWNC	XFELD	CHAR	1	0	Indicator: Entry belongs to a down payment clearing item
56	WT_RESITEM	☐	WT_RESITEM	XFELD	CHAR	1	0	Indicator: Entry belongs to a residual item
57	CTISSUEDATE	☐	CTISSUEDATE	DATUM	DATS	8	0	Issue or Print Date of Withholding Tax Certificate
58	WT_CALC	☐	WT_CALC	WT_CALC	CHAR	2	0	Withholding Tax Already Calculated/Determined?
59	WT_LOGSYS	☐	WT_LOGSYS	LOGSYS	CHAR	10	0	Logical System in Which the Withholding Tax Was Calculated	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCJ_WTAX_ITEMS	CAJO_NUMBER	TCJ_C_JOURNALS	CAJO_NUMBER
2	TCJ_WTAX_ITEMS	COMP_CODE	T001	BUKRS
3	TCJ_WTAX_ITEMS	MANDT	T000	MANDT
4	TCJ_WTAX_ITEMS	POSTING_NUMBER	TCJ_DOCUMENTS	POSTING_NUMBER
5	TCJ_WTAX_ITEMS	VENDOR_NO	LFB1	LIFNR
6	TCJ_WTAX_ITEMS	WTAXTYPE	T059P	WITHT

History

Last changed by/on	SAP	20130529
SAP Release Created in