SAP Knowledge Base Article - Public

3646194 - How to add Business Calc Amount 1 and Business Calc Amount 2 column to statement template

Symptom

  • Business Calc Amount 1&2 fields cannot be selected in the statement template.
  • Only the Business Calc Amount field is selectable in the statement template through editor.

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

Environment

SAP SuccessFactors Compensation

Reproducing the Issue

  1. Access the statement template management page.
  2. Attempt to select Business Calc Amount 1&2 fields, observe that these fields are not selectable through editor.
  3. Only Business Calc Amount field is selectable through editor.

Resolution

  1. Download the statement template as an XSL file.
  2. Add the following variables under the variable section for Business Calc Amount 1&2:
    <xsl:variable name="goalResultsPayoutAmountGrandTotal1" select="./comp-plan-entry/comp-varpay/vp-grand-result-payout-amt1" />
    <xsl:variable name="goalResultsPayoutAmountGrandTotal2" select="./comp-plan-entry/comp-varpay/vp-grand-result-payout-amt2" />


  3. Use these variables wherever needed in the template with the following syntax:
    <xsl:value-of select="format-number($goalResultsPayoutAmountGrandTotal1, $userLocaleSpecificMoneyFormat, $userLocaleSpecificDecimalFormatter)" />
    <xsl:value-of select="format-number($goalResultsPayoutAmountGrandTotal2, $userLocaleSpecificMoneyFormat, $userLocaleSpecificDecimalFormatter)" /> 
  4. Upload statement XSL file to system.

Keywords

business calc amount, statement template, field selection issue, xsl template modification, variable section, goalResultsPayoutAmountGrandTotal1, goalResultsPayoutAmountGrandTotal2, column selectable, select through editor, column cannot selected, missing column, missing field, total compensation template , KBA , LOD-SF-CMP-PS , Personal Statements , How To

Product

SAP SuccessFactors Compensation all versions