Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to make key date of query as transcation date in cube

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


|jan 1|--- 15$

100-----|-ic


|oct 1|--- 32$

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


|jan 1|--- 15$

100-----|-ic


|oct 1|--- 32$

if key date is jan 1st it displays as,

customer|customer_grp----|date-|--|sale

100--


|-sa
|jan 1|
--- 15$

100--


|-sa
|oct 1|
--- 32$

let me know whether it is possible to achive this type of report

-thanks in advance

- points will be awarded for inputs

Former Member
Not what you were looking for? View more on this topic or Ask a question