I am facing an issues in displaying the transaction data with time dependent master data.
I want to set the key date of the query to go against the transaction date and diplay the respective master data.
I read in other posts,
that i cant use the user exit variable, because the exit is executed only once before the query run.
The fllowing is the report i want to achive,
customer|customer_grp
-|date-|
--|sale
100----
-|-sa
100----
-|-ic
in the above scenario, customer_grp for cusotmer 100 is sa from jan - mar and
customer_grp for cusotmer 100 is ic from apr - dec
I have customer_grp as time dependent attribute of customer. when i execute the report with key date as ,nov 1st
it displays as,
customer|customer_grp
-|date-|
--|sale
100----
-|-ic
100----
-|-ic
if key date is jan 1st it displays as,
customer|customer_grp----
|date-|
--|sale
100--
100--
let me know whether it is possible to achive this type of report
-thanks in advance
- points will be awarded for inputs