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

Bex Query - Display Product Key + long text

Dear All,

In the BW report, when on 0product characteristic we choose to display as key and text. the text display is the short text.

Do you how we can display key + long text instead of key + short text ?

thanks,

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2005 at 10:00 AM

    Hi,

    I think you need to upgrade to BW 3.5 for this. You can choose which text to display in 3.5.

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2005 at 01:30 AM

    I could not understand your problem fully well...

    Do you intend to always display the long text with key for characteristic (0Product) in BEx? In that case could you choose the appropriate value for BEx description in Business Explorer tab of the infoobject maintenance!

    Cheers...Elango

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2005 at 10:09 AM

    Ok siggi,

    So you confirm that the short text is selected by default when we want to display key + text. With the version BW 3.5, we can select short text, medium text or long text.

    I work on the BW 3.0B.

    Thanks for your answer.

    Greg

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      A workaround until 3.5 is to create another InfoObject, e.g. ZPRODUCT_NM, as a reference object to 0PRODUCT.

      Then add it as a display attribute to 0PRODUCT.

      Change the master data load to add a mapping in the transfer rule to map 0PRODUCT from the DataSource to the new attr, ZPRODUCT_NM as well as 0PRODUCT.

      Then add the new attr to your query, change the 0PRODUCT characteristics to display as just Key and set the ZPRODUCT_NM attr to display as long or medium text as needed.

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.