SAP ABAP Table FIWTIN_TAN_EXEM (Table for mapping TAN and Exemption Number)

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	FIWTIN_TAN_EXEM	Table Relationship Diagram
Short Description	Table for mapping TAN and Exemption Number

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	KOART	☑	KOART	KOART	CHAR	1	0	Account type
4	ACCNO	☑	WT_ACNO	CHAR10	CHAR	10	0	Vendor/customer account number
5	FIWTIN_TANEX_SUB	☑	FIWTIN_TANEX_SUB	XFELD	CHAR	1	0	Indicator: Subject to TAN exemption?
6	SECCODE	☑	SECCO	SECCO	CHAR	4	0	Section Code	SECCODE
7	WITHT	☑	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	T059P
8	WT_WITHCD	☑	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	T059Z
9	WT_EXNR	☐	WT_EXNR	CHAR15	CHAR	15	0	Exemption certificate number
10	WT_EXRT	☐	WT_EXRT	PRZ32	DEC	5	2	Exemption rate
11	WT_EXDF	☐	WT_EXDF	WT_START	DATS	8	0	Date on which exemption begins
12	WT_EXDT	☐	WT_EXDT	WT_END	DATS	8	0	Date on which exemption ends
13	WT_WTEXRS	☐	WT_WTEXRS	WT_WTEXRS	CHAR	2	0	Reason for exemption	*
14	FIWTIN_EXEM_THR	☐	FIWTIN_EXEM_THR	WERTV8	CURR	15	2	Threshold amount for Exemption (India)
15	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIWTIN_TAN_EXEM	BUKRS	T001	BUKRS
2	FIWTIN_TAN_EXEM	MANDT	T000	MANDT
3	FIWTIN_TAN_EXEM	SECCODE	SECCODE	SECCODE
4	FIWTIN_TAN_EXEM	WITHT	T059P	WITHT
5	FIWTIN_TAN_EXEM	WT_WITHCD	T059Z	WT_WITHCD

History

Last changed by/on	SAP	20130529
SAP Release Created in