on 09-14-2013 10:07 AM
Hi Guru's
I have a requirement to filter out the data in a bex query.I need to filter out the data whose sales orders created on greater than the user entered
Date.
The user entered date is a varaiable created on 0Netdue date.I should not report on the data for the sales orders created on after the date entered by the user.
How can I implement in the bex?
Thanks in advance.
Srini.
Hi,
Give some technical name and meaningful description---Processing by Replacement path
Reference characteristic---(That date on which variable is being created in your case sales order created date)
Replacement path tab---Replace variable with (give the technical name of that variable which you created on net due date)----Replace with key---Save the variable and give ranges---less than or equal to.
Hope this helps.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi SM,
R.Clk on sale order date--Restrict--Show variables--Click on create new variable
Give ur description---select th variable type as Replacement path
Reference characteristic - sales order created date "with greater than or equal to"
Regards
Shyamala.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.