Skip to Content

SAP Cloud platform integration CPI\HCI Future dated data is appearing with fitter period delta

Below query we are using

SELECT person, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, compensation_information, paycompensation_recurring, deduction_recurring, global_assignment_information, job_information, paycompensation_non_recurring, payment_information, national_id_card, personal_information, phone_information FROM CompoundEmployee WHERE company = '"+ CompanyCo +"' and compensation_pay_group = '"+ PayGroupID +"' and to_datetime('2018-11-06T01:30:00Z') and fromDate = to_date('2018-11-01','yyyy-MM-dd') and toDate = to_date('2018-11-15','yyyy-MM-dd')</urn:queryString>ORDER BY start_date DESC


Employment information is appearing for future dated employee which getting hired on 19th November it should not appear and please provide suggestion any filter condition

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Nov 07, 2018 at 09:18 AM

    Hello Venkata,

    I dont see last_modified_on in your query.

    Could you please check below KBA which might help you.

    2649816

    Add a comment
    10|10000 characters needed characters exceeded

    • hi sriprasad,

      thanks for quick answer

      Below mentioned query deatils

      SELECT person, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, compensation_information, paycompensation_recurring, deduction_recurring, global_assignment_information, job_information, paycompensation_non_recurring, payment_information, national_id_card, personal_information, phone_information FROM CompoundEmployee WHERE company = '"+ CompanyCo +"' and compensation_pay_group = '"+ PayGroupID +"' and last_modified_on > to_datetime('2018-11-06T01:30:00Z') and fromDate = to_date('2018-11-01','yyyy-MM-dd') and toDate = to_date('2018-11-15','yyyy-MM-dd') ORDER BY start_date DESC

  • Posted on Nov 07, 2018 at 02:20 PM

    One quick note is Employment is not effective dated segment. Job and Comp which are under Employment are effective dated.

    -Bhargav

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 07, 2018 at 11:52 AM

    SELECT person, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, compensation_information, paycompensation_recurring, deduction_recurring, global_assignment_information, job_information, paycompensation_non_recurring, payment_information, national_id_card, personal_information, phone_information FROM CompoundEmployee WHERE company = '"+ CompanyCo +"' and compensation_pay_group = '"+ PayGroupID +"' and last_modified_on > to_datetime('2018-11-06T01:30:00Z') and fromDate = to_date('2018-11-01','yyyy-MM-dd') and toDate = to_date('2018-11-15','yyyy-MM-dd') ORDER BY start_date DESC

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 19 at 12:55 PM

    any updates here
    why can we not filter future dates records in query?

    Add a comment
    10|10000 characters needed characters exceeded

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.