I've got a custom made SAP XML driver which has been polished to work quite well but one thing is giving me headache and all ideas are welcome.
I have one E1PLOGI XML element per SAP personality and under that I have a certain infotype which represents a work contract. There are numerous other infotypes representing different data and all that associates these infotypes to the contract infotypes are dates.
I accept different kinds of infotype XML elements for parsing if the element in question falls within the contract dates with following rules:
- if contract is in the past we get the latest entry that intersects the contract period
- if contract is in the present time we get the entry that is valid now
- if contract is in the future we get the first entry that intersects the contract period
However we have a problem if we have both present and future data included as we only have the present data in the contract object. In order to update to the future data we'd need to run the XML through the driver in that future date so that it would pick up the data from XML file but that will not happen unless someone in HR changes something.
So I am thinking that maybe I will just mark the contract future date in one attribute and make job to take care of that. Or I could somehow save all the future data in some multivalue attribute(s). How would you do this?
Running all data regularly is very intensive and would not like to take that option.