SAP Knowledge Base Article - Public

2745963 - Calculated Field to Remove Selected Date from IC output file

Symptom

In this document we will walkthrough how to set up a calculated field in Integration Center to remove a date of your choosing.

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

Environment

  • Integration Center
  • SuccessFactor HCM Suite

Resolution

In this example we will set up a calculated field to remove the date 31/12/9999 from the endDateTime field in Job Information.

    1. Click the Add button and select Add Calculated Field.
    2. Define Field Value = to the date you want removed. (In this example 31/12/9999)
    3. Set an If/Then/Else clause.
    4. In the If statement: Field Value  Is equal to Specified Date Field. (In this Example endDate)
    5. The Then statement can be left as it is.
    6. The Else statement: Field Value= Specified Date Field. (In this Example endDate).
    7. Your Calculation trace should look like the example below

**Note: Please add the date field to the integration to ensure that you set the correct date format for the field. Simply add the field, copy the date, then remove the field and create your calculated field.

CalculationTrace1.PNG

 Please find Screenshots of each step attached.

Keywords

  • Calculted Field
  • Calculation
  • Remove Date
  • Null Date
  • Blank Date
  • Calculated Date
, KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Core all versions

Attachments

CalculationTrace1.PNG
Add_Calculated Field.PNG
Field_Value_ StartingStatement.PNG
IfStatement.PNG
ThenStatement.PNG
ElseStatement.PNG
ResultInPreview.PNG