1. SAP Tutorial
  2. FI Module

J_1ICO_VENDDET SAP table for – Columbia: Monthly data for freelancers/vendors

Here we would like to draw your attention to J_1ICO_VENDDET table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1ICO_VENDDET is a SAP standard transp table used for storing Columbia: Monthly data for freelancers/vendors related data in SAP. It comes under the package ID-FI-WT.

SAP J_1ICO_VENDDET table

Table J_1ICO_VENDDET technical data

TableJ_1ICO_VENDDET
Data storingColumbia: Monthly data for freelancers/vendors
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-WT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_1ICO_VENDDET Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_1ICO_VENDDET table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • LIFNR : Account Number of Vendor or Creditor
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SMONTH : Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • SYEAR : YEAR
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • WITHT : Indicator for withholding tax type
    Its data type is CHAR (Character String) with field length 2
  • WT_WITHCD : Withholding tax code
    Its data type is CHAR (Character String) with field length 2
  • TOT_AMTACRCMP : Total Amount Service for Vendor
    Its data type is CURR (Currency Field) with field length 13
  • TOT_AMT : Amount of service for the company
    Its data type is CURR (Currency Field) with field length 13
  • VOL_CONTRIBUTION : Volunteer Contribution
    Its data type is CURR (Currency Field) with field length 13
  • TOTAL_POST_AMNT : Tax base Amount posted till now
    Its data type is CURR (Currency Field) with field length 13
  • VOLN_CON_NXT_INV : Volunteer Contribution
    Its data type is CURR (Currency Field) with field length 13
  • TOTAL_TAX_AMNT : Total Tax Amount posted till now
    Its data type is CURR (Currency Field) with field length 13
  • TOTAL_VOL_CONTRI : Total Volunteer Contribution
    Its data type is CURR (Currency Field) with field length 13
  • IDWTCO_ARPVALUE : ARP Contribution
    Its data type is CURR (Currency Field) with field length 13
  • IDWTCO_ARPRATE : ARP Contribution rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FIWTCO_AMTSCI : Scientific/Technological paid amount
    Its data type is CURR (Currency Field) with field length 13
  • FIWTCO_PENSION : Pension rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FIWTCO_PREVINT : Previous year interest
    Its data type is CURR (Currency Field) with field length 13
  • FIWTCO_APREVINT : Previous year interest
    Its data type is CURR (Currency Field) with field length 13
  • FIWTCO_PREVPAY : Previous year payment
    Its data type is CURR (Currency Field) with field length 13
  • FIWTCO_APREVPAY : Previous year payment
    Its data type is CURR (Currency Field) with field length 13
  • FIWTCO_DEDDEPEND : Dependent deduction
    Its data type is CHAR (Character String) with field length 1

    • J_1ICO_VENDDET related tables

    • IDWT_COND_CHK : Condition check table for WT generic tool
    • IDWTNAVIG : Navigation Table for the Withholding Tax Reporting Tool
    • IDWT_ADD_VARIANT : Additional variant contents for WT generic tool
    • J_1IE_RCT : Table for Storing contract details(Ireland)
    • T059ID01T : Texts in Withholding Tax Output Group
    • CIS_VF_EXT : Extension Table for CIS Sub contractors
    • J_1_T059WTK : Constant Table for WithHolding Tax
    • IDWT_CIS_HEADER : Header fields for CIS Transmission
    • T059ID01 : Withholding Tax Output Group Description
    • FIWT_TAX_AMOUNT : Table to maintain withholding tax amounts
    • FIWT_PARTNR_EXM : Table for Vendor specific threshold amounts
    • J_1_T059WTKT : Text table for J_1_T059WTK
    • J_11042S_US : Authority for Exemption/Reason for Exemption (US)
    • IDWTNAVIGT : Text table for IDWTNAVIG
    • J_1ICO_VENDDET : Columbia: Monthly data for freelancers/vendors

    J_1ICO_VENDDET related transaction codes under SAP package ID-FI-WT

    • IE_RCT_UPDATE : Transaction to update RCT Response
    • CISV : CIS Vendor Verification Process
    • CIS_VENDOR : Vendor Master Data Update
    • IE_RCT_SUBMIT : Transaction to execute RCT program
    • CISVU : Update Vendor master
    • WTNR : w/tax certificate number range
    • WTOG : define output group
    • FIWTRCT : Vendor specific threshold amounts
    • J1ICOVEND : Monthly freelancer data
    • S_P00_07000134 : Generic Withholding Tax Reporting

    Related References

    Related Tutorials

    J_1AWITH SAP table for – Withholding transaction data

    J_1AWITH table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding transaction data....

    IDWT_EMPDATA_VE SAP table for – To store the employee data for Venezuela payroll

    IDWT_EMPDATA_VE table in SAP FI (Localization in FI) module. This table is used for storing data of To store the...

    RFUMSV00_HIST SAP table for – Maintain data for previous VAT return run

    RFUMSV00_HIST table in SAP FI (Localization in FI) module. This table is used for storing data of Maintain data for...

    DFKKITVATM SAP table for – VAT monthly report for Italy: hystory table

    DFKKITVATM table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    FIWT_TAX_AMOUNT SAP table for – Table to maintain withholding tax amounts

    FIWT_TAX_AMOUNT table in SAP FI (Localization in FI) module. This table is used for storing data of Table to maintain...

    FIWT_PARTNR_EXM SAP table for – Table for Vendor specific threshold amounts

    FIWT_PARTNR_EXM table in SAP FI (Localization in FI) module. This table is used for storing data of Table for Vendor...

    J_3R_FATAX SAP table for – Transport Tax Data

    J_3R_FATAX table in SAP FI (Localization in FI) module. This table is used for storing data of Transport Tax Data....

    «
    »