Question:
Dear all,
I want to have tree columns in my query.
1. Month values
2. trimestre to date values
3. year to date values
I want to get values for all the columns only entering the month and the year as variables.
e.g., if I enter as month May and as year 2002, I want to have one column with May values (month), another with April and May (Trim to date) and another With values from Jan to May (year to date).
Note: I am not in May 2002 but in Dec 2002, so I have data for all the months (this to make the difference, for instance, between TRIM and TRIM to Date)
How can I create this two variables?
Thanks in advance
Regards
Eduardo
Answer:
There is a white paper titled "How to derive a variable from another variable" or something like that. this will give you the step-by-step instructions on how to create a customer exit and how to get a YTD total. From their you will need to know some ABAP to figure how to get the other variables, but it is not that difficult.
Thanks,
jlaruss
Answer:
Create a structure for your characteristics
Create the following selections:
1. containing the current period (restricted by a variable)
2. containing a range for period (<some logic> -> current period)
3. containing a range for period (1 -> current period)
Put a filter on fiscal year (restricted by variable)
cheers,
El Belgio
Answer:
Thanks for both replies
jlaruss can you be so kind to let me know, in a more detailed way, how can I get this paper.
thanks