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
- 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') - 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 HCM Suite all versions