Hi @Yoca Toca and @Yaniv Feldman,
We are currently experiencing a similar issue. Let me explain you our environment and situation.
On the first times, we were extracting directly (just connecting and making a '*' selection) the fields long descriptions from SAP BW. But after some patches implemented on the SAP BW database, that extraction changed and now, we obtain fields with both long and short descriptions.
The reason for the patches implementation was that we were using 2 versions of the SAP Connector ( 5.40 and 5.70) for different extractions and we wanted so standarize its use. But, it has not been completely successful, because one connector works much faster than the other one, depending on which cube we are extracting from.
Furthermore, the SAP BW team reported that no changes have been made upon the SAP BW cubes that we are extracting from.
So, what we need to understand which is the logic behind that field description selection, so we can react properly to this issue.
It would be grateful if someone could give us some insights and share his/her experience for this serious issue.
Thank you all and keep in touch!