SAP Knowledge Base Article - Public

3087968 - More Field Options-> "Value is Mandatory" behavior in Integration Center

Symptom

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

You wish to extract only those records for which specific field value is not blank or null.

You can achieve this using More Field Options-> "Value is Mandatory" behavior in Integration Center

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Cause

Expected Behavior

Resolution

  • When the "Value Is Mandatory" checkbox is enabled for a specific field, Integration Center will validate data for this specific field.
  • As you see below, for all records which have no data, "Mandatory value missing" message will appear in preview. However, when the output is being generated by executing the integration, records will be skipped completely. In the example below, you will see only one record in the output for Person ID External rkent1.
  • Note: Monitoring of the missing records in the output (for the fields which are marked mandatory but has missing values) can be done by Execution Manager Dashboard (XM)




    Please note

    When you use "Value is Mandatory" to mark a field as mandatory, if the field is null then the entire record will be omitted.
    For this reason, we do not recommend using this option in Event Based Integration (ISC) scenarios as they generally process a single record which would then be skipped/excluded, resulting in an empty output (file).

Keywords

Integration Centre, Mandatory check, value missing, ISC , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Suite all versions