cancel
Showing results for 
Search instead for 
Did you mean: 

Need logic for Last year data

Former Member
0 Kudos

Hi Experts,

I am having the billing doc date and Ex-factory value, based on billing date need to show the Ex-factory value from 1-Apr-12 to 31-Mar-13.

Please provide the logic for the requirement.

Thanks & Regards

Ravi Shankar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you are working with a relational database, best practice is to have a calendar table that reflects both calendar and fiscal year. Once you have advised which you are using, one of us will provide a more detailed solution.

Former Member
0 Kudos

Hi,

We are using SAP BW data-source for the reports.

former_member184594
Active Contributor
0 Kudos

Hello Ravi,

If you are working with Bex, then you need to set this logic in Bex Query designer. You need to create a variable as "Customer Exits" which means you need to know how to write ABAP in the backend. If you know it, it is not a big deal. If you don't then you should consult you BW people.

Check the documents below:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d09d4588-3832-2c10-e185-f778d9dbe...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90f8b363-882d-2c10-ea91-9f08ce4c6...

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2013/04/08/creating-customer-exit-va...

Hope this helps.

Answers (1)

Answers (1)

arijit_das
Active Contributor
0 Kudos

Best practice is to create a restricted key figure at BEx level.

If you are working with relational database, try to do the calculation in universe layer.