Skip to Content
author's profile photo Former Member
Former Member

Text Join in Analytical view

Hi Guys,

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!


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Mar 20, 2013 at 04:25 PM

    Hi Vittali,

    Logically it makes sense to mark the join as "Text" when it comes to Attribute view as you get the text description for the attributes in there. But you can also make a join in Data foundation for the analytic view as TEXT join to use one of the column as Text description of the join column.

    Basically TEXT join will assume that you are using Multi-lingual text property and hence treats is in that way, also enforces you to mark LANGUAGE column. The language column is not the KEY as such but acts as a FILTER (like where clause) for the value set in by the default language setting.

    Please also note that you can also use LEFT OUTER JOIN for the TEXT description in cases where the text is not language dependent. In such cases where you do not have a language column, you cannot use TEXT join.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Krishna,

      In hanalive, i want to make a new calculation view .

      this is using an hanalive view CapReqDetailedSchedGRemainingDurnQuery.

      In this original view, i have a join text on work center text and i can see it in my language (french).

      When i make a join with this view in a new view, i leave this connection to the text.

      Can you explain how this text join are propagated to the father views ?

      thanks for your help


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.