SAP ABAP Table J_1IEWTPROV (Table for TDS provisions)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1ICIN30A (Package) Development class for cin30a

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1IEWTPROV	Table Relationship Diagram
Short Description	Table for TDS provisions

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	RECTYP	☑	J_1IRECTYP	J_1IRECTYP	CHAR	1	0	Record type for TDS / Service tax
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number	BKPF
5	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
7	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
8	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
9	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
10	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
11	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
12	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
13	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
14	DMBTR_TOTAL	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
15	DMBTR_UTIL	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	INDI	☐	J_1ITDSIND	J_1ITDSIND	CHAR	1	0	TDS update indicator
18	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
19	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
20	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
21	WITHT	☐	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	T059P
22	WT_WITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	T059Z
23	QSCOD	☐	WT_OWTCD	WT_OWTCD	CHAR	4	0	Official Withholding Tax Key	*
24	J_1ISESN	☐	J_1ISESN	J_1ISESN	CHAR	10	0	Service entry sheet number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IEWTPROV	BELNR	BKPF	BELNR	KEY	1	1
2	J_1IEWTPROV	BUKRS	T001	BUKRS
3	J_1IEWTPROV	EBELN	EKKO	EBELN		1	CN
4	J_1IEWTPROV	EBELP	EKPO	EBELP		1	CN
5	J_1IEWTPROV	LIFNR	LFA1	LIFNR		1	CN
6	J_1IEWTPROV	MANDT	T000	MANDT
7	J_1IEWTPROV	WITHT	T059P	WITHT
8	J_1IEWTPROV	WT_WITHCD	T059Z	WT_WITHCD	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in