SAP ABAP Table FIWTFORM_01 (Structure for SAPscript)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FI-AP-AP (Application Component) Basic Functions
     ⤷ FQST (Package) Infrastructure for withholding tax

Basic Data

Table Category	INTTAB	Structure
Structure	FIWTFORM_01	Table Relationship Diagram
Short Description	Structure for SAPscript

Delivery and Maintenance

Pool/cluster
Delivery Class
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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	ANRED_1	☐	ANRED	TEXT15	CHAR	15	0	Title
3	NAME1_1	☐	NAME1	TEXT30	CHAR	30	0	Name
4	STRAS_1	☐	STRAS	TEXT30	CHAR	30	0	House number and street
5	PSTLZ_1	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
6	ORT01_1	☐	ORT01	TEXT25	CHAR	25	0	City
7	PFACH_1	☐	PFACH	PFACH	CHAR	10	0	PO Box
8	STCDT_1	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
9	STCD1_1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
10	STCD2_1	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
11	STCD3_1	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
12	ANRED_2	☐	ANRED	TEXT15	CHAR	15	0	Title
13	NAME1_2	☐	NAME1	TEXT30	CHAR	30	0	Name
14	STRAS_2	☐	STRAS	TEXT30	CHAR	30	0	House number and street
15	PSTLZ_2	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	ORT01_2	☐	ORT01	TEXT25	CHAR	25	0	City
17	PFACH_2	☐	PFACH	PFACH	CHAR	10	0	PO Box
18	STCDT_2	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
19	STCD1_2	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
20	STCD2_2	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
21	STCD3_2	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
22	FNDDATE	☐	J_1AFNDDAT	CHAR10	CHAR	10	0	Foundation date of the company
23	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
24	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
25	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
26	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
27	BUDAT2	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
28	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
29	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
30	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
31	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
32	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
33	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
34	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
35	GICODE	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	*
36	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
37	WAERS2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
38	WAERS3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	ALTWR	☐	ALTWR	CHAR3	CHAR	3	0	Alternative key for currencies
40	DMBTR	☐	J_1ADMBTR	WERTV7	CURR	13	2	Amount in local currency with sign
41	WRBTR	☐	J_1AWRBTR	WERTV7	CURR	13	2	Amount in document currency with sign
42	WRBTR2	☐	J_1AWRBTR	WERTV7	CURR	13	2	Amount in document currency with sign
43	WRBTR3	☐	J_1AWRBTR	WERTV7	CURR	13	2	Amount in document currency with sign
44	HWBAS	☐	J_1AHWBAS	WERTV7	CURR	13	2	Tax base amount in local currency with sign
45	FWBAS	☐	J_1AFWBAS	WERTV7	CURR	13	2	Tax base amount in document currency with sign
46	HWSTE	☐	J_1AHWSTE	WERTV7	CURR	13	2	Tax amount in local currency with sign
47	FWSTE	☐	J_1AFWSTE	WERTV7	CURR	13	2	Tax amount in document currency with sign
48	WT_ACCBS	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
49	WT_ACCWT	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
50	WT_QBSHH	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
51	WT_QBSHB	☐	WT_WT1	WERTV8	CURR	15	2	Withholding tax amount in document currency
52	WT_QSSHH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
53	WT_QSSHB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
54	WT_WDMBTR	☐	WT_AWT	WERTV8	CURR	15	2	Withholding tax amount (in local currency) already withheld
55	WT_WWRBTR	☐	WT_AWT1	WERTV8	CURR	15	2	Withholding tax amount already withheld in document currency
56	WT_ALWT	☐	WT_ALWT	XFELD	CHAR	1	0	Indicator: Withholding tax already withheld?
57	OFTP	☐	J_1AOFTP_D	J_1AOFTP	CHAR	2	0	Official document type	*
58	QSCOD	☐	QSCOD	CHAR4	CHAR	4	0	Official Withholding Tax Code
59	RATE	☐	F130PROZ	DEC3_2	DEC	5	2	Percentage Rate
60	MACOEF	☐	J_1AGIMAC	J_1AGIMAC	DEC	6	5	Gross Income Tax coefficient
61	COPYNO	☐	J_1ACOPYN	NUM2	NUMC	2	0	Number of copies
62	ISNR	☐	J_1AISNR	J_1AISNR	CHAR	4	0	Issuing Branch number
63	ISNR2	☐	J_1AISNR	J_1AISNR	CHAR	4	0	Issuing Branch number
64	OFFNUM	☐	J_1AOFFNUM	J_1AOFFNUM	CHAR	8	0	Official document number for Argentina
65	OFFNUM2	☐	J_1AOFFNUM	J_1AOFFNUM	CHAR	8	0	Official document number for Argentina
66	PRDATE	☐	J_1APRDATE	DATUM	DATS	8	0	Printing/Presentation date
67	PRTCHR	☐	J_1APCHAR	J_1APCHAR	CHAR	1	0	Character to be printed on the document	*
68	PRTCHR2	☐	J_1APCHAR	J_1APCHAR	CHAR	1	0	Character to be printed on the document	*
69	LEGAL	☐	J_1ALEGAL	TEXT40	CHAR	40	0	Legalization
70	SIGN	☐	J_1ASIGN	TEXT40	CHAR	40	0	Signature
71	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
72	PDATA	☐	J_1APDATA	CHAR1	CHAR	1	0	Print data on SAPscript layoutset
73	FORTN	☐	J_1AFORTN	NUM1	NUMC	1	0	Fortnight (1 or 2)
74	TEXT1	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
75	TEXT2	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
76	TEXT3	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
77	TEXT4	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
78	TEXT5	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
79	TEXT6	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
80	CTNUMBER	☐	CTNUMBER	CHAR10	CHAR	10	0	Withholding Tax Certificate Number
81	J_1AFORMAT	☐	TYP_FORMAT	TYP_FORMAT	CHAR	1	0	Certificate Format

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIWTFORM_01	BUKRS	T001	BUKRS		1	CN
2	FIWTFORM_01	WAERS	TCURC	WAERS		1	CN
3	FIWTFORM_01	WAERS2	TCURC	WAERS		1	CN
4	FIWTFORM_01	WAERS3	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in