SAP ABAP Table J_1ICO_VENDDET (Columbia: Monthly data for freelancers/vendors)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-WT (Package) Withholding Tax reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1ICO_VENDDET	Table Relationship Diagram
Short Description	Columbia: Monthly data for freelancers/vendors

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	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
4	SMONTH	☑	SMONTH		NUMC	2	0	Month
5	SYEAR	☑	SYEAR	NUMC4	NUMC	4	0	YEAR
6	WITHT	☐	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	*
7	WT_WITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
8	TOT_AMTACRCMP	☐	TOT_AMTACRCMP	WERT7	CURR	13	2	Total Amount Service for Vendor
9	TOT_AMT	☐	TOT_AMT	WERT7	CURR	13	2	Amount of service for the company
10	VOL_CONTRIBUTION	☐	VOL_CONTRIBUTION	WERT7	CURR	13	2	Volunteer Contribution
11	TOTAL_POST_AMNT	☐	TOTAL_POST_AMNT	WERT7	CURR	13	2	Tax base Amount posted till now
12	VOLN_CON_NXT_INV	☐	VOL_CONTRIBUTION	WERT7	CURR	13	2	Volunteer Contribution
13	TOTAL_TAX_AMNT	☐	TOTAL_TAX_AMNT	WERT7	CURR	13	2	Total Tax Amount posted till now
14	TOTAL_VOL_CONTRI	☐	TOTAL_VOL_CONTRI	WERT7	CURR	13	2	Total Volunteer Contribution
15	IDWTCO_ARPVALUE	☐	IDWTCO_ARPVALUE	WERT7	CURR	13	2	ARP Contribution
16	IDWTCO_ARPRATE	☐	IDWTCO_ARPRATE	PRZ34	DEC	7	4	ARP Contribution rate
17	FIWTCO_AMTSCI	☐	FIWTCO_AMTSCI	WERT7	CURR	13	2	Scientific/Technological paid amount
18	FIWTCO_PENSION	☐	FIWTCO_PENSION	PRZ34	DEC	7	4	Pension rate
19	FIWTCO_PREVINT	☐	FIWTCO_PREVINT	WERT7	CURR	13	2	Previous year interest
20	FIWTCO_APREVINT	☐	FIWTCO_PREVINT	WERT7	CURR	13	2	Previous year interest
21	FIWTCO_PREVPAY	☐	FIWTCO_PREVPAY	WERT7	CURR	13	2	Previous year payment
22	FIWTCO_APREVPAY	☐	FIWTCO_PREVPAY	WERT7	CURR	13	2	Previous year payment
23	FIWTCO_DEDDEPEND	☐	FIWTCO_DEDDEPEND	XFELD	CHAR	1	0	Dependent deduction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1ICO_VENDDET	BUKRS	T001	BUKRS	KEY
2	J_1ICO_VENDDET	LIFNR	LFA1	LIFNR	KEY
3	J_1ICO_VENDDET	MANDT	T000	MANDT

History

Last changed by/on	SAP	20140121
SAP Release Created in