SAP Knowledge Base Article - Public

2085343 - Worksheet Design - Reportable Fields - Compensation Management

Symptom

  • Running Ad hoc report and data is not showing for some fields, even though we can see the fields have data in the compensation plan.

  • Why does a field in compensation template not show up in adhoc reports so that I can report on it?

  • How many custom fields can be defined as reportable in a Compensation Form Template?

Environment

SuccessFactors Compensation Management

Resolution

In order for a field to be reportable, it must be set to be reportable in Column Designer prior to launching compensation forms.

Admin Center >  Compensation Home > Plans (Select Plan) > Plan Setup > Design Worksheet: > select the Column

      reportable field.png

Note: If you do not see the "Reportable" checkbox it is likely the field is a Standard field and will already be included in reports. You will see the "reportable" checkbox for Custom fields that you have added.

How many custom fields can be defined as reportable in a Compensation Form Template?

There is a limit to the number of custom fields you can mark as reportable:

  • Up to 100 numeric fields

  • Up to 40 text fields

  • Up to 5 date fields

Note: Fields marked as Calculate Total (NeedCalcTotal =”true”) are included in the above numeric limit of 100.

      2.png

Keywords

 reportable, reportable column, design worksheet , KBA , sf compensation worksheet design , LOD-SF-CMP-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , How To

Product

SAP SuccessFactors HCM Core all versions