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

Description on the column

Hi BI Gurus,

I have written a report in the Bex and I have included the infoobject 0BILL_BLOCK and on the properties of this, I have turned on Standard: Key and text on Display As option. It's ok in terms of displaying the key and text. It's displaying Key under 'Billing block' header and description for the key without header. It's as follows at the moment:

Billing block No column heading(blank)

08 Credit memo

The quesstion is how do I get the heading description? The users want as follows:

Billing block Description

08 Credit memo

Please let me know about it.

Thanks for your help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2008 at 03:06 PM

    You can write an excel macro to do so.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2008 at 03:11 PM

    Hi Basnet,

    In the query, right click on "Billing block No column heading(blank)" select properties and then change the descripotion to "Billing block Description".

    This should do it.

    Regards

    Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2008 at 03:16 PM

    Hi,

    Would you be able to give me some hints as to how I can write a macro? I can write ABAP code and extract it from source system. I thought there must be easy way than this.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      you want to display the Column header for the the key and alo the text??

      That has to be done using a macro and can only work if you are using a workbook.

      Something like the below. This you have to include in SAPBEXONREFRESH (BI 7.0) or SAPBEXREFRESH (BW 3.x).

      Sub Macro1()

      Range("A17").Select

      Selection.Copy

      Range("B17").Select

      ActiveSheet.Paste

      End Sub

      There are many links which will help you achieve this. Search on SAPBEXONREFRESH / SAPBEXREFRESH.

      Hope this helps.

      Regards

      Kumar

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.