Skip to Content
1
Jun 04, 2020 at 05:21 PM

SAP CPI:How can we fetch past effective date records from Compound Employee

2438 Views

Hi ,

We have one requirement that need to fetch the data based on below conditions.

Case1 : in Job information portlet suppose if the manager or title will update with Past effective date with last modified>last run date Ex: Record updated Jun 4,2020 but effective from may 1,2020.

Case2 : In job information portlet any record will modified on past date but effective from current date.

Record updated on may 20,2020 but will be effective from Jun 6,2020.

please kindly suggest me a query to solve the above conditions.

Regards,

Abdul.