Missing descriptions in Text

[maffio]

Hello Expert.

I have created a Text table, using a Data Flow importing a standard Text CDS. No logic at all has been added: the Data Flow reads the Text CDS and with a 1:1 mapping, save data into a Text Table (Texts are language dependant). Nevertheless, when I check data, the descriptions do not appear: Datasphere is not able to retrieve them (I am expecting to see the descriptions in the connection language). Investigating a lot, I found the reason of this issue: the language code, which is a one digit code coming from the CDS (as: E, I...) is not converted in the two digit code required by Datasphere (as: EN, IT..). I am pretty sure of this, since, if I do this conversion through a custom formula, then everything works perfectly and I can see the descriptions, filtered on the connection language. According to your official documentations, if I am not wrong, this conversion should be done automatically by Datasphere (as BW, for example, does).

Is there something wrong in what I am doing? Do I really need a custom formula to do this conversion, in all the Text tables (tens and tens) that I need to bring from S4 into Datasphere? I cannot believe this.

Can you help me?

Thanks

Andrea

[Martin_Kuma]

Yes 🙂

You have to go for two characters. Else the language settings from your profile will not work. 

You can bypass this however. You do not create Text Views (you can assoc only one without a warning and one never knows which DSP update turns the warning into an error). You join the text field directly into you master data view, set the semantic to text and assign as text in attributes. Then you will not have lang-dependent text however. 

[maffio]

Hello Martin. Thanks for your reply. I understand what you are saying, but what I am trying to do seems to be aligned with Sap best practices. If you check the official documentation provided by Sap, you will see that the conversion should be done automatically by Datasphere, and do not require any custom solution (which I already have) (BW7.5, or BW4, as you probably know, does it). Regards. Andrea