SAP ABAP View J_1I_EWT_RETURN (Annual returns - Documemnt View)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1ICIN40A (Package) CIN40A developments

Basic Data

View Type	D	Database View
Database View	J_1I_EWT_RETURN
Short Description	Annual returns - Documemnt View
Root table	BKPF	Accounting Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BKPF	BKPF
2	WITH_ITEM
3	J_1IEWT_CERTIF
4	J_1IEWTCHLN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BKPF	MANDT	JL	EQ				0	0
2	WITH_ITEM	MANDT	JR	EQ			AND	0	0
3	BKPF	BUKRS	JL	EQ				0	0
4	WITH_ITEM	BUKRS	JR	EQ			AND	0	0
5	BKPF	BELNR	JL	EQ				0	0
6	WITH_ITEM	BELNR	JR	EQ			AND	0	0
7	BKPF	GJAHR	JL	EQ				0	0
8	WITH_ITEM	GJAHR	JR	EQ			AND	0	0
9	WITH_ITEM	MANDT	JL	EQ				0	0
10	J_1IEWT_CERTIF	MANDT	JR	EQ			AND	0	0
11	WITH_ITEM	BUKRS	JL	EQ				0	0
12	J_1IEWT_CERTIF	BUKRS	JR	EQ			AND	0	0
13	WITH_ITEM	GJAHR	JL	EQ				0	0
14	J_1IEWT_CERTIF	GJAHR	JR	EQ			AND	0	0
15	WITH_ITEM	CTNUMBER	JL	EQ				0	0
16	J_1IEWT_CERTIF	CTNUMBER	JR	EQ			AND	0	0
17	J_1IEWTCHLN	MANDT	JL	EQ				0	0
18	WITH_ITEM	MANDT	JR	EQ			AND	0	0
19	J_1IEWTCHLN	BUKRS	JL	EQ				0	0
20	WITH_ITEM	BUKRS	JR	EQ			AND	0	0
21	J_1IEWTCHLN	GJAHR	JL	EQ				0	0
22	WITH_ITEM	GJAHR	JR	EQ			AND	0	0
23	J_1IEWTCHLN	J_1IINTCHLN	JL	EQ				0	0
24	WITH_ITEM	J_1IINTCHLN	JR	EQ			AND	0	0
25	J_1IEWTCHLN	J_1IINTCHDT	JL	EQ				0	0
26	WITH_ITEM	J_1IINTCHDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	J_1IEWT_CERTIF	MANDT		☐	MANDT	☐	Client
2	BUKRS	J_1IEWT_CERTIF	BUKRS		☐	BUKRS	☐	Company Code
3	GJAHR	J_1IEWT_CERTIF	GJAHR		☐	GJAHR	☐	Fiscal Year
4	BUPLA	J_1IEWT_CERTIF	BUPLA		☐	J_1BBRANC_	☐	Business Place
5	QSCOD	J_1IEWT_CERTIF	QSCOD		☐	WT_OWTCD	☐	Official Withholding Tax Key
6	CTNUMBER	J_1IEWT_CERTIF	CTNUMBER		☐	CTNUMBER	☐	Withholding Tax Certificate Number
7	BUDAT	BKPF	BUDAT		☐	BUDAT	☐	Posting Date in the Document
8	BELNR	WITH_ITEM	BELNR		☐	BELNR_D	☐	Accounting Document Number
9	BUZEI	WITH_ITEM	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
10	WITHT	WITH_ITEM	WITHT		☐	WITHT	☐	Indicator for withholding tax type
11	WT_WITHCD	WITH_ITEM	WT_WITHCD		☐	WT_WITHCD	☐	Withholding tax code
12	J_1IINTCHLN	WITH_ITEM	J_1IINTCHLN		☐	J_1IINTCHLN	☐	Challan Number
13	J_1IINTCHDT	WITH_ITEM	J_1IINTCHDT		☐	J_1IINTCHDT	☐	Challan Date
14	QSATZ	WITH_ITEM	QSATZ		☐	WT_QSATZ	☐	Withholding tax rate
15	WT_WTEXMN	WITH_ITEM	WT_WTEXMN		☐	WT_EXNR	☐	Exemption certificate number
16	WT_QSZRT	WITH_ITEM	WT_QSZRT		☐	WT_EXRT	☐	Exemption rate
17	J_1ICERTDT	J_1IEWT_CERTIF	J_1ICERTDT		☐	J_1ICERTDT	☐	Certificate Date
18	WT_QSSHH	WITH_ITEM	WT_QSSHH		☐	WT_BS	☐	Withholding tax base amount (local currency)
19	WT_QBSHH	WITH_ITEM	WT_QBSHH		☐	WT_WT	☐	Withholding tax amount (in local currency)
20	J_1ISURAMT	WITH_ITEM	J_1ISURAMT		☐	J_1ISURAMT	☐	Surcharge amount
21	KOART	WITH_ITEM	KOART		☐	KOART	☐	Account type
22	WT_ACCO	WITH_ITEM	WT_ACCO		☐	WT_ACNO	☐	Vendor/customer account number
23	QSREC	WITH_ITEM	QSREC		☐	WT_QSREC	☐	Type of recipient
24	WT_DOWNC	WITH_ITEM	WT_DOWNC		☐	WT_DOWNC	☐	Indicator: Entry belongs to a down payment clearing item
25	J_1IEWTREC	WITH_ITEM	J_1IEWTREC		☐	J_1IEWTREC	☐	Record type for EWT transactions-India
26	J_1IBUZEI	WITH_ITEM	J_1IBUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
27	J_1IEXTCHLN	J_1IEWTCHLN	J_1IEXTCHLN		☐	J_1IEXTCHLN	☐	Challan Numbers- External
28	J_1IEXTCHDT	J_1IEWTCHLN	J_1IEXTCHDT		☐	J_1IEXTCHDT	☐	Challan Date - External
29	BANKL	J_1IEWTCHLN	BANKL		☐	HBKID	☐	Short key for a house bank

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	20140121
SAP Release Created in	40A