1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to IDWT_EMPDATA_VE 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). IDWT_EMPDATA_VE is a SAP standard transp table used for storing To store the employee data for Venezuela payroll related data in SAP. It comes under the package ID-FI-SA.

SAP IDWT_EMPDATA_VE table

Table IDWT_EMPDATA_VE technical data

TableIDWT_EMPDATA_VE
Data storingTo store the employee data for Venezuela payroll
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-SA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP IDWT_EMPDATA_VE 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 IDWT_EMPDATA_VE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERNR : Personnel Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RIFNUMBER : Tax Number 1
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • PAY_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SUM_1 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_1 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_2 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_2 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_3 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_3 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_4 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_4 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_5 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_5 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_6 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_6 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_7 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_7 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_8 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_8 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_9 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_9 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_10 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_10 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_11 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_11 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUM_12 : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • RATE_12 : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4

    • IDWT_EMPDATA_VE related tables

    • J_VE_INCWT : Maintain Withholding Tax Payment Details
    • IDMX_VAT_ACC : Maintaining G/L Accounts for Different Concepts
    • IDWT_EMPDATA_VE : To store the employee data for Venezuela payroll
    • IDMX_VAT : Mexico : Identifiable and Non-Identifiable VAT conditions

    IDWT_EMPDATA_VE related transaction codes under SAP package ID-FI-SA

    • S_AC0_52000779 : Deferred Tax Certificates (Mexico)
    • RFVATRTNMX : VAT Return (Mexico)
    • S_AC0_52000103 : Purchase Ledger (Venezuela)
    • S_AC0_52000104 : Sales Ledger (Venezuela)

    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....

    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...

    VIXCFRBUDGET SAP table for – Budget Seasonality Data

    VIXCFRBUDGET table in SAP FI (Localization in FI) module. This table is used for storing data of Budget Seasonality Data....

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

    J_1ICO_VENDDET table in SAP FI (Localization in FI) module. This table is used for storing data of Columbia: Monthly data...

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

    TCJ_WTAX_ITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Withholding...

    GLE_MCA_MI_RATES SAP table for – Manual input exchanges rates

    GLE_MCA_MI_RATES table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Manual...

    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....

    «
    »