Here is a puzzle I've spent hours not solving:
I am using a bapi (bapi_absence_getlist) that returns the user's registered absence days and absence codes (subtypes) from SAP. Now the thing is that I don't want to show the absence codes but rather the accompanying text ('holiday' not '0210').
By writing a simple sql query I am able to display these texts and codes in a separate table. What I now need your help to do is to 'merge' these two tables into one where one column is shown from the BAPI (absence date), and the other from the query (absence type text). Both data sets have the code as joining key.
(I could of course expand the functionality of the BAPI to also return the text, but I still want your tips on how to merge two datasets like this). I have joined datasets earlier with success, but only when the datasets have held exactly the same columns/fields.
Henning