SAP Knowledge Base Article - Public

3376515 - PicklistValueV2 results for mdfSystemEffectiveEndDate and mdfSystemEffectiveStartDate are always the same

Symptom

The response from Odata call for PicklistValueV2 return the same value for mdfSystemEffectiveStartDate and mdfSystemEffectiveEndDate regardless of the different versions

Environment

SAP SuccessFactors HXM Suite

SAP Metadata Framework

Reproducing the Issue

  1. Make the Odata call below for two versions of Picklist with different PickListV2_effectiveStartDate
    https://apisalesdemo2.successfactors.eu/odata/v2/PickListValueV2(PickListV2_effectiveStartDate=datetime'2023-09-07T00:00:00',PickListV2_id='PLTCourse',externalCode='C1')
    https://apisalesdemo2.successfactors.eu/odata/v2/PickListValueV2(PickListV2_effectiveStartDate=datetime'2023-09-01T00:00:00',PickListV2_id='PLTCourse',externalCode='C1')
  2. notice both result give the same mdfSystemEffectiveStartDate and mdfSystemEffectiveEndDate
    <d:mdfSystemEffectiveEndDate m:type="Edm.DateTime">9999-12-31T00:00:00</d:mdfSystemEffectiveEndDate>
    <d:mdfSystemEffectiveStartDate m:type="Edm.DateTime">1900-01-01T00:00:00</d:mdfSystemEffectiveStartDate>

Cause

PicklistValue is FROM_PARENT effective dated object

Resolution

Since PicklistValue is FROM_PARENT effective dated object, that means that mdfSystemEffectiveStartDate and mdfSystemEffectiveEndDate will always have the same default value

Keywords

PicklistValueV2, mdfSystemEffectiveStartDate, mdfSystemEffectiveEndDate , FROM_PARENT, effective dated , KBA , LOD-SF-MDF-PKL , Picklists , Problem

Product

SAP SuccessFactors HXM Suite all versions