on 08-20-2013 8:10 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Hope this helps.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.