SAP Knowledge Base Article - Public

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

Symptom

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

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 HCM

  • Integration Center

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).



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, Integration Center, Mandatory check, value missing, ISC , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions