BEx - Displaying Only Records with the smallest Billing Date!?!?

[Former Member]

Hi All,

I have a simple question that probably has a simple answer.

I want to display Billing in a BEx report but only the first Billing for every customer, meaning - Minimum 'Billing Date'.

I'm Sure it is Possible, but not sure how...

Pomise to grant full points for the answer.

Thanks, YB.

[Former Member · Accepted solution]

Hi

Whats there in your cube?

Do you need data as you want to show in reports or you have to keep all data in cube?

Its better to design cubes w.r.t reports than to try to build reports out of cubes.

Let me know so tht I may be of some help to you

Gaurav

[Former Member · Accepted solution]

Gaurav,

Thanks for your response. I don't want to change the data structure in the cube. I am trying to find the solution in the report level.

The cube holds Billing Items (2LIS_11_VAITM). Every record is an invoice. I want to show the frist invoice ever reported for each and every customer.

[Former Member · Accepted solution]

Hi

You can write a user exit and populate this with date corrresponding to min billing as you want, so this would fetch data from cube as you want.

But performance may be problem!!

Let me know if you need more help..

Guarav

• Assign points if it helps

[Former Member · Accepted solution]

Hey Gaurav,

I Think that is a good idea. Do you have a sample code for something similar.

I'm having a hard time imagining how to write such a code.

Thanks YB.

[Former Member · Accepted solution]

Hi

You have to make a user exit variable and write a code with pseudo logic as mentioned below:

1) Get data from cube into internal table..

2) Sort table ascending and read data corresponding to min billing..

Search on SDN or SAP help for user exit coding and exit variable.

Hope this helps....

Thanks..

Gaurav

• Assign points if it helps

[Former Member]

Hi Yaniv,

If you apply date infoobject as variable,you can get the data depending upon the entry of the date what you entered in the variable..is there anything else you need to display in the report ?

[Former Member]

Raja Hi.

I dont want the user to have to choose a date.

The output of the report does not depend on the user's input at all.

[former_member213594]

Hi,

Please create a condition on "Billing date" and choose Bottom N and show the first entry.

This will bring the record that has Minimum billing date.

Hope this helps.

Thanks

Martin

[Former Member]

Hi Martin,

Thanks for the answer, but the Billing day is a characteristic the condition applies only on KF.

The Check box there is only to evaluate the condition.