Skip to Content

SAP CPI pulling all job information history from Compound employee

Aug 22, 2017 at 11:04 AM


avatar image
Former Member

While trying to fetch data from compound employee job_information, I'm facing an issue. As job_information is effective dated entity it returns all records (New Hire/Data Change) for an employee. When I tried to map the xml on a xsd and then convert it to a csv, the 2nd job_information record of 1st employee is appending on the 2nd employee row of the csv (please see screenshot).

How I can pull only the latest effective dated record and not all records for an user from compound employee ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gayathri Narayana
Aug 22, 2017 at 09:19 PM

Hi Matt,

Did you try with the filter step?.In addition you can use the request-reply step to enhance the data of user with additional records.



10 |10000 characters needed characters left characters exceeded