SAP Knowledge Base Article - Public

2084711 - Error: File empty or format invalid When Uploading Lookup Table - Compensation


You have created a Lookup table only by giving name and description and you receive the error “File empty or format invalid”

**Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental**


SAP SuccessFactors Compensation and Variable Pay

Reproducing the Issue

  1. Admin Center > Actions for All Plans
  2. All Plans > Compensation and Variable Pay Lookup Tables
  3. Select a table > Choose file > Import


You have created a Lookup table only by giving name and description


Once created Number of Input and Number of Output will be 1 by default.


Now, if you are uploading .csv file with more than two columns for e.g. three columns


You will receive the error “File empty or format invalid”


You will receive the same error message, if you are trying to edit existing Lookup table by importing a new file with different number of columns compared to one already imported.


  • Always give the Number of Inputs (Keys) and Number of Outputs (Values) while creating a lookup table. Please make sure that (Number of Inputs + Number of Outputs) =No of columns in your csv file.
  • Example: You have total three columns (MV_Title,GRADE and Value) in your csv file and based on MV_Title and Grade the Value will be displayed on the form. Here you have two Keys i.e. MV_Title, GRADE and one Value i.e. Value (based on the keys value will be displayed on form).So you can create a look up table with Number of Input=2 and Number of Output=1
  • You might have exceeded the total character limit of 256 characters (including spaces). Try to reimport the file with 256 characters or less.

Note: You can upload maximum five input fields and five output fields in a Lookup table.


error, number, file, inputs, outputs, compensation, form, message, comp, cmp , KBA , sf compensation manage data , LOD-SF-CMP , Compensation Management , How To


SAP SuccessFactors Compensation all versions