I have enhanced a datasource 0EMPLOYEE_ATTR with one field from PA0007 table. When I test the enhanced datasource, via RSA3, I see that the field is correctly populated (EVERYTIME). But when I load the data into BW first few times no data came into that field (remaining data is correct). Then a completely random behavior started. The data is getting populated into the field sometimes and sometimes the field does not get populated at all. There is no specific reason or action or count that would define a pattern.
Has anyone come across this issue? Points shall be rewarded.
PLEASE NOTE: The code in the function exit is completely correct as the RSA3 on the source sytem always shows the data extraction correctly. The problem only happens when the data is loaded into the BW system (with or without PSA). The behaviour is completely random.