SAP ABAP View TXW_J_WITH (Join of BSAK and WITH_ITEM for DART)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

View Type	D	Database View
Database View	TXW_J_WITH
Short Description	Join of BSAK and WITH_ITEM for DART
Root table	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BSAK	BSAK
2	WITH_ITEM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BSAK	MANDT	JL	EQ				0	0
2	WITH_ITEM	MANDT	JR	EQ			AND	0	0
3	BSAK	BUKRS	JL	EQ				0	0
4	WITH_ITEM	BUKRS	JR	EQ			AND	0	0
5	BSAK	BELNR	JL	EQ				0	0
6	WITH_ITEM	BELNR	JR	EQ			AND	0	0
7	BSAK	GJAHR	JL	EQ				0	0
8	WITH_ITEM	GJAHR	JR	EQ			AND	0	0
9	BSAK	BUZEI	JL	EQ				0	0
10	WITH_ITEM	BUZEI	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	WITH_ITEM	*		☐		☐
2	MANDT	WITH_ITEM	MANDT		☐	MANDT	☐	Client
3	BUKRS	WITH_ITEM	BUKRS		☐	BUKRS	☐	Company Code
4	BELNR	WITH_ITEM	BELNR		☐	BELNR_D	☐	Accounting Document Number
5	GJAHR	WITH_ITEM	GJAHR		☐	GJAHR	☐	Fiscal Year
6	BUZEI	WITH_ITEM	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
7	WITHT	WITH_ITEM	WITHT		☐	WITHT	☐	Indicator for withholding tax type
8	WT_WITHCD	WITH_ITEM	WT_WITHCD		☐	WT_WITHCD	☐	Withholding tax code
9	WT_QSSHH	WITH_ITEM	WT_QSSHH		☐	WT_BS	☐	Withholding tax base amount (local currency)
10	WT_QSSHB	WITH_ITEM	WT_QSSHB		☐	WT_BS1	☐	Withholding tax base amount in document currency
11	WT_QSSH2	WITH_ITEM	WT_QSSH2		☐	WT_BS2	☐	Withholding tax base amount in 2nd local currency
12	WT_QSSH3	WITH_ITEM	WT_QSSH3		☐	WT_BS3	☐	Withholding tax base amount in 3rd local currency
13	WT_BASMAN	WITH_ITEM	WT_BASMAN		☐	WT_BASMAN	☐	Indicator: Withholding tax base amount entered manually
14	WT_QSSHHC	WITH_ITEM	WT_QSSHHC		☐	WT_BSC	☐	Withholding tax base amount in LC for calculation
15	WT_QSSHBC	WITH_ITEM	WT_QSSHBC		☐	WT_BS1C	☐	Withholding tax base amount in doc. currency for calculation
16	WT_QSSH2C	WITH_ITEM	WT_QSSH2C		☐	WT_BS2C	☐	With/tax base amount in 2nd local currency for calculation
17	WT_QSSH3C	WITH_ITEM	WT_QSSH3C		☐	WT_BS3C	☐	Withholding tax base amount in 3rd local currency for calc.
18	WT_QBSHH	WITH_ITEM	WT_QBSHH		☐	WT_WT	☐	Withholding tax amount (in local currency)
19	WT_QBSHB	WITH_ITEM	WT_QBSHB		☐	WT_WT1	☐	Withholding tax amount in document currency
20	WT_QBSH2	WITH_ITEM	WT_QBSH2		☐	WT_WT2	☐	Withholding tax amount in 2nd local currency
21	WT_QBSH3	WITH_ITEM	WT_QBSH3		☐	WT_WT3	☐	Withholding tax amount in 3rd local currency
22	WT_AMNMAN	WITH_ITEM	WT_AMNMAN		☐	WT_AMNMAN	☐	Indicator: Withholding tax amount entered manually
23	WT_QBSHHA	WITH_ITEM	WT_QBSHHA		☐	WT_WTA	☐	W/tax auxiliary amount for reversal (in local currency)
24	WT_QBSHHB	WITH_ITEM	WT_QBSHHB		☐	WT_WTB	☐	W/tax auxiliary amount 2 in local currency for reversal
25	WT_STAT	WITH_ITEM	WT_STAT		☐	WT_STAT	☐	Line item status
26	WT_QSFHH	WITH_ITEM	WT_QSFHH		☐	WT_EXMP	☐	Amount exempt from withholding tax in local currency
27	WT_QSFHB	WITH_ITEM	WT_QSFHB		☐	WT_EXMP1	☐	Amount exempt from withholding tax in document currency
28	WT_QSFH2	WITH_ITEM	WT_QSFH2		☐	WT_EXMP2	☐	Withholding tax exempt amount in 2nd local currency
29	WT_QSFH3	WITH_ITEM	WT_QSFH3		☐	WT_EXMP3	☐	Withholding tax exempt amount in 3rd local currency
30	WT_WTEXMN	WITH_ITEM	WT_WTEXMN		☐	WT_EXNR	☐	Exemption certificate number
31	KOART	WITH_ITEM	KOART		☐	KOART	☐	Account type
32	WT_ACCO	WITH_ITEM	WT_ACCO		☐	WT_ACNO	☐	Vendor/customer account number
33	HKONT	WITH_ITEM	HKONT		☐	HKONT	☐	General Ledger Account
34	HKONT_OPP	WITH_ITEM	HKONT_OPP		☐	HKONT	☐	General Ledger Account
35	QSREC	WITH_ITEM	QSREC		☐	WT_QSREC	☐	Type of recipient
36	AUGBL	WITH_ITEM	AUGBL		☐	AUGBL	☐	Document Number of the Clearing Document
37	AUGDT	WITH_ITEM	AUGDT		☐	AUGDT	☐	Clearing Date
38	WT_QSZRT	WITH_ITEM	WT_QSZRT		☐	WT_EXRT	☐	Exemption rate
39	WT_WDMBTR	WITH_ITEM	WT_WDMBTR		☐	WT_AWT	☐	Withholding tax amount (in local currency) already withheld
40	WT_WWRBTR	WITH_ITEM	WT_WWRBTR		☐	WT_AWT1	☐	Withholding tax amount already withheld in document currency
41	WT_WDMBT2	WITH_ITEM	WT_WDMBT2		☐	WT_AWT2	☐	Withholding tax amount already withheld in 2nd local curr.
42	WT_WDMBT3	WITH_ITEM	WT_WDMBT3		☐	WT_AWT3	☐	With/tax amount already withheld in 3rd local currency
43	TEXT15	WITH_ITEM	TEXT15		☐	TEXT15	☐	Text (15 characters)
44	WT_QBUIHH	WITH_ITEM	WT_QBUIHH		☐	WT_QBUIHH	☐	Enter withholding tax amount in local currency manually
45	WT_QBUIHB	WITH_ITEM	WT_QBUIHB		☐	WT_QBUIHB	☐	Enter withholding tax amount in document currency manually
46	WT_QBUIH2	WITH_ITEM	WT_QBUIH2		☐	WT_QBUIH2	☐	Manually entered with/tax amount in 2nd local currency
47	WT_QBUIH3	WITH_ITEM	WT_QBUIH3		☐	WT_QBUIH3	☐	With/tax amount in 3rd local currency entered manually
48	WT_ACCBS	WITH_ITEM	WT_ACCBS		☐	WT_ACCBS	☐	Accumulated withholding tax base amount in local currency
49	WT_ACCWT	WITH_ITEM	WT_ACCWT		☐	WT_ACCWT	☐	Accumulated withholding tax amount in local currency
50	WT_ACCWTA	WITH_ITEM	WT_ACCWTA		☐	WT_ACCWTA	☐	Accumulated auxiliary with/tax amount in local currency
51	WT_ACCWTHA	WITH_ITEM	WT_ACCWTHA		☐	WT_ACCWTHA	☐	Accumulated auxiliary with/tax amount in local currency
52	WT_ACCBS1	WITH_ITEM	WT_ACCBS1		☐	WT_ACCBS	☐	Accumulated withholding tax base amount in local currency
53	WT_ACCWT1	WITH_ITEM	WT_ACCWT1		☐	WT_ACCWT	☐	Accumulated withholding tax amount in local currency
54	WT_ACCWTA1	WITH_ITEM	WT_ACCWTA1		☐	WT_ACCWTA	☐	Accumulated auxiliary with/tax amount in local currency
55	WT_ACCWTHA1	WITH_ITEM	WT_ACCWTHA1		☐	WT_ACCWTHA	☐	Accumulated auxiliary with/tax amount in local currency
56	WT_ACCBS2	WITH_ITEM	WT_ACCBS2		☐	WT_ACCBS	☐	Accumulated withholding tax base amount in local currency
57	WT_ACCWT2	WITH_ITEM	WT_ACCWT2		☐	WT_ACCWT	☐	Accumulated withholding tax amount in local currency
58	WT_ACCWTA2	WITH_ITEM	WT_ACCWTA2		☐	WT_ACCWTA	☐	Accumulated auxiliary with/tax amount in local currency
59	WT_ACCWTHA2	WITH_ITEM	WT_ACCWTHA2		☐	WT_ACCWTHA	☐	Accumulated auxiliary with/tax amount in local currency
60	QSATZ	WITH_ITEM	QSATZ		☐	WT_QSATZ	☐	Withholding tax rate
61	WT_SLFWTPD	WITH_ITEM	WT_SLFWTPD		☐	WT_SLFWTPD	☐	Indicator: Entry posted as self-withholding tax
62	WT_GRUWTPD	WITH_ITEM	WT_GRUWTPD		☐	WT_GRUWTPD	☐	Indicator: Entry posted as "Grossing up"
63	WT_OPOWTPD	WITH_ITEM	WT_OPOWTPD		☐	WT_OPOWTPD	☐	Indicator: Entry posted as a debit/credit
64	WT_GIVENPD	WITH_ITEM	WT_GIVENPD		☐	WT_GIVENPD	☐	Indicator: Withholding tax amount entered manually with pmnt
65	CTNUMBER	WITH_ITEM	CTNUMBER		☐	CTNUMBER	☐	Withholding Tax Certificate Number
66	WT_DOWNC	WITH_ITEM	WT_DOWNC		☐	WT_DOWNC	☐	Indicator: Entry belongs to a down payment clearing item
67	WT_RESITEM	WITH_ITEM	WT_RESITEM		☐	WT_RESITEM	☐	Indicator: Entry belongs to a residual item
68	CTISSUEDATE	WITH_ITEM	CTISSUEDATE		☐	CTISSUEDATE	☐	Issue or Print Date of Withholding Tax Certificate
69	J_1AF_WT_REPBS	WITH_ITEM	J_1AF_WT_REPBS		☐	J_1AF_WT_REPBS	☐	Withholding tax base amount in local currency for reporting
70	WT_CALC	WITH_ITEM	WT_CALC		☐	WT_CALC	☐	Withholding Tax Already Calculated/Determined?
71	WT_LOGSYS	WITH_ITEM	WT_LOGSYS		☐	WT_LOGSYS	☐	Logical System in Which the Withholding Tax Was Calculated
72	J_1BWHTCOLLCODE	WITH_ITEM	J_1BWHTCOLLCODE		☐	J_1BWHTCOLL	☐	Official Withholding Tax Collection Code
73	J_1BWHTRATE	WITH_ITEM	J_1BWHTRATE		☐	J_1BTXRATE	☐	Tax Rate
74	J_1BWHT_BS	WITH_ITEM	J_1BWHT_BS		☐	J_1BWHT_BS	☐	Withholding Tax Base Amount from Nota Fiscal
75	J_1BWHTACCBS	WITH_ITEM	J_1BWHTACCBS		☐	J_1BWHT_ACCRB	☐	Accumulated withholding tax real base amount(local currency)
76	J_1BWHTACCBS1	WITH_ITEM	J_1BWHTACCBS1		☐	J_1BWHT_ACCRB	☐	Accumulated withholding tax real base amount(local currency)
77	J_1BWHTACCBS2	WITH_ITEM	J_1BWHTACCBS2		☐	J_1BWHT_ACCRB	☐	Accumulated withholding tax real base amount(local currency)
78	J_1IINTCHLN	WITH_ITEM	J_1IINTCHLN		☐	J_1IINTCHLN	☐	Challan Number
79	J_1IINTCHDT	WITH_ITEM	J_1IINTCHDT		☐	J_1IINTCHDT	☐	Challan Date
80	J_1IEWTREC	WITH_ITEM	J_1IEWTREC		☐	J_1IEWTREC	☐	Record type for EWT transactions-India
81	J_1IBUZEI	WITH_ITEM	J_1IBUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
82	J_1ICERTDT	WITH_ITEM	J_1ICERTDT		☐	J_1ICERTDT	☐	Certificate Date
83	J_1ICLRAMT	WITH_ITEM	J_1ICLRAMT		☐	J_1ICLRAMT	☐	Amount of EWT for which certificate is received from Custome
84	J_1IREBZG	WITH_ITEM	J_1IREBZG		☐	REBZG	☐	Number of the Invoice the Transaction Belongs to
85	J_1ISURAMT	WITH_ITEM	J_1ISURAMT		☐	J_1ISURAMT	☐	Surcharge amount
86	BS_BUKRS	BSAK	BUKRS		☐	BUKRS	☐	Company Code
87	BS_AUGDT	BSAK	AUGDT		☐	AUGDT	☐	Clearing Date
88	BS_AUGBL	BSAK	AUGBL		☐	AUGBL	☐	Document Number of the Clearing Document
89	BS_LIFNR	BSAK	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
90	BS_GJAHR	BSAK	GJAHR		☐	GJAHR	☐	Fiscal Year
91	BS_XZAHL	BSAK	XZAHL		☐	XZAHL	☐	Indicator: Is Posting Key Used in a Payment Transaction?
92	BS_WAERS	BSAK	WAERS		☐	WAERS	☐	Currency Key

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C