Couple of queries,
1. I find text join works fine in Analytical view(SPS5 version), but I remember reading in some SAP documentation that text join are relevant to only to attribute views.
2. Also text join should always be 1:1 , but we map only one column of Main table with that of Text Table( MARA - MAKT), but define SPRAS as language field, hence this SPRAS would act as another key to get only one unique relevant text ?
Thanks in advance!