Skip to Content

Future dated termination filtered in Query

Dear community users,

I have faced the CompoundEmployee API limitation that (according to SAP delta documentation) I see no way how to use a filter inside the query to extract the termination only effective on today. I tried to use Period delta (fromDate .... to date) or Effective end date params but still all records are passed.

I would kindly ask you for help me and assure that it is or is not possible.

Following use case:

I need to send terminations effective from past to today (client does not accept future terminations) in delta mode (so only changes are send).

If I will use filters inside iflow but not in query - all filtered delta changes will be lost after one run.

Interface is scheduled once/day.

query:

SELECT person, employment_information, job_information, national_id_card, personal_information FROM CompoundEmployee WHERE last_modified_on > to_datetime('${property.maxDateFromLastRun1}') AND company_territory_code = 'TUR' AND fromDate = to_date('${property.currentDate}','YYYY-MM-DD') AND toDate = to_date('${property.currentDate}','YYYY-MM-DD')

test case:

- 2 records - termination date = yesterday

- 2 records - termination date = today

- 2 records - termination date = tomorrow

expected output:

-send only those terminations effective today

current output:

- all 6 records are propagated

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.