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

problem with getting customer exit variable values in BEX.

Scenario: I have a report with 32 keyfigures and the title of each should be a particular month. Typically it is 15 months before and 15 months after the current month. If hardcoded, I have to manually change the months every month as the current month changes.

Hence I have gone for a customer exit varialble.

Approach: In my EXIT_SAPLRRS0_001 I have written the code and in E_T_RANGE I am getting all the required values in the E_T_RANGE-LOW column. I do not require intervals in this particular case.

Problem: I tried all possible approaches of getting these values in the BEX report but they don't work. I am referring to the file "HowToDeriveVariableValue.pdf". In the file I do not understand how things work according to the screenshots shown by them on page 5 and 6. They show a new structure in the column area where they put a "new selection" for the text variable. But the text variable already has a selection "Key figure name"...so it can have either the ocalmonth variable (customer exit variable under 0calmonth) or the key figure. I tried n number of ways to put them together but either my customer exit value gets pulled out or the key figure value gets pulled out but not both.

Please shed some light on how I can proceed from here.

Thanks and regards,

Mihir

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2006 at 12:49 PM

    Hi Mihir,

    Could you clarify whether you need :

    1. 31 different columns where each cloumn will hv data for one of the 31 months.

    2. one column having data for 31 months.

    If it is option 1 then

    1. drag and drop the key figure into columns.

    2. then double click on the key figure in the column sections and drag and drop the variable 0cmonth(current month) under the calender year / month charac.

    3. Go the header section and click on the variable option and select the text variable for it i.e 0t_month(not very sure pls check).

    Copy the same column and specify an offset ( -1 or +1) only for variable 0cmonth.

    this should work.

    Worst case, create your own Z variable but I don't think you will require a customer exit varaiable.

    Cheers,

    Raghu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Eddo and Raghu,

      Thanks for your replies and sorry for getting back a little late...Was working on something else.

      Raghu, I tried using your suggestion but it does not allow me to drag and drop the variable 0cmonth or even the complete time characteristic 0calmonth in the key figure window after double clicking on the key figure.

      <u>

      I will clearly state the situation:</u>

      a) I indeed need 31 different columns where each cloumn will hv data for one of the 31 months.

      <b>b)</b> However, I am just picking up data from a table in R/3 where the data for every month is presented as 31 key figures. Moreover that particular R/3 table has no date/month field. Hence we also delete and do full loads regularly.

      So basically, I cannot use offset and I also don't ever need to filter between different months out of the 31 months. They are just KEY FIGURES.

      Now the situation is:

      At present, we have hard-coded the names of months (curr+15 and curr-15) as a description of key figures.

      Since the current month changes we have to change the hard-coded DESCRIPTIONS every month.

      I just need to do these descriptions DYNAMIC according to the changing calender month i.e. in my customer exit, I am taking the current date and filling the table E_T_RANGE with values 15 months before and after the current date.

      So my E_T_RANGE has values 200606, 200605, 200604....etc.

      Now if I can get each of this value in a variable assigned to each of my key figure, I can substitute this value by its text (text of 0calmonth) to get June 2006 instead of 200606.

      Now my problem is:

      <b>I have all required values in E_T_RANGE-LOW field.

      How do I separate each value and put in a variable for it to arrive in BEX?

      The HOW-to Guide shows it just for 1 variable but what about multiple vatiables?</b>

      Looking forward to your replies.

      Thanks and regds,

      Mihir

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2006 at 09:25 AM

    Hi,

    Have you create a structure to put a month restriction according to you user Exit ?

    If yes, you can put the Text Variable for the structure.

    Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Eddo,

      Thanks for your reply. Can you please elaborate a bit on how to go about it?

      In my "columns" window, I created a structure and inside that I have a text variable (e.g. &ZCURP&). Then I write clicked on the structure > New selection -> and then I put 0calmonth and the variable under it.

      Below the structure, I have the KEY FIGURES (again in the column window) and to the 1st key figure e.g. ZPR01 I assign the above text variable &ZCURP& as the description so that I get the month name above the key figure. But when I execute this I can see the month name in the report in front of Calendar Year/Month but it says no applicable data found i.e. it is not able to retrieve data because of the structure present in the column window. If I remove that I can get data.

      I also wish to know how to get the multiple values present in E_T_Range-LOW column into respective key figure descriptions i.e. each value assigned to a particular key figure.

      Thanks and regds,

      Mihir

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2006 at 10:10 AM

    Hi,

    I think you don't have to put any restriction / text variable on your Key Figure. Coz you have done it on Structure level.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I removed the text variable from the key figure but then it takes the default key figure description that is present in the system. Even if I remove that it keeps coming.

      Further, inspite of doing this, when my structure (containing the user exit variable) as well as key figure structure are in the column window, it does not pull any data.

      regds

      Mihir

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2006 at 10:38 AM

    Mihir,

    My understanding of your requirement :

    Report containing value for different months based on the current month. I feel that you have complicated the requirement by using a exit variable.

    I think you should use the standard available variable - current month and then use offset to derive the other months. Use the standard text variable for displaying the relevant month in the column header.

    cheers,

    Raghu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Raghu,

      Thanks for your reply. I had tried using the standard text variables &0T_CMONT& (Text variable month) as well as &0T_CMNTH& (Text variable replaced by 0calmonth) but they don't pull any values and only the variable name is displayed in the report. Hence I went for the customer exit variable approach.

      The time characteristic 0calmonth was however, included recently in the cube.

      Mihir

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2006 at 01:40 AM

    Mihir,

    I'm not quite sure about your situation w/o looking on you query.

    I think your query only restricting the data for a single month, but the idea of your query it should be restricting 31 month ( interval from curr - 15 to curr + 15)

    May be you can review following step and map to your case :

    1.Create a User Entry Variable (or current month ?).

    2.Create Customer Exit Variables (30?) to get the all month you need base on User Entry Variable (above) to be used on your report.

    3.On your query create Restricted KF based on your variables(31?).

    4.Now you can try to put also the text variables on your RKF.

    Good luck.

    Add a comment
    10|10000 characters needed characters exceeded

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.