Skip to Content
author's profile photo Former Member
Former Member

Date range in query keydate

Hi,

Is the keydate in query accepts the date range, from the query properties keydate accepts one date. I also tried from variable customer exit it is giving an error shown below.

EError for variable in customer enhancement <variable name>

EVariables contain invalid values.

I>> Row: 82 Inc: LRRMSU13 Prog: SAPLRRMS

ASystem error in program CL_RSR_OLAP_VAR and form INIT-02- (see long text)

The requirement is to display multiple records from master data (the time dependent master data in the given data range) based on the keydate range provided.

Please respond how to resolve this.

Thanks

Sreedh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2008 at 08:49 PM

    It is not possible to use Date-Range in query key date.

    You can use Infoset to reprot on MASTER DATA.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 05:39 AM

    Hi Sreedh,

    A little more explanation is required from you.

    How is the date specified in your master data...how do you want it to be filtered as per the selection inout range ??

    Regards

    Shalabh Jain

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 06:28 PM

    Hi Shalabh,

    Here is the output i'm looking for

    Time dependent Master data

    Emp1 date from date to Attr1 Attr2

    ABCD 01/01/2008 02/29/2008 Name1 Name2

    ABCD 03/01/2008 05/31/2008 Name3 Name4

    In query when the key date is >= 01/01/2008, the trsn data will show as

    Emp1 Attr1 Attr2 Keyfig

    ABCD Name1 Name2

    ABCD Name3 Name4 30

    The keydate for the query is not accepting the range, is there anyway to achieve this. Don't want to use the Infoset.

    Thanks

    Sreedh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The keydate that you specify in the Query properties is used only when your query has navigational attributes to be displayed. During query execution, it joins the characteristic data records from the infoprovider with the corresponding master data table records that are valid on the key date to get the navigational attributes.

      To uniquely select only one valid record from master data table, the look up should be based only as of a particular key date and not date range.

      If you want to pick some data records in particular date range, <= or >= a particular date, you should not term it as key date and get confused. You should term it as a valid date/date range or selection date/date range

      Hope it was helpful!

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 08:38 PM

    Thanks uday. I will keep this post open for sometime to see any one have workaround to resolve this issue.

    Thanks

    Sreedh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sreedh,

      Why dont you work around with a user input variable ? It can be a selection option variable on the date that you wish to filter upon and then can filter out the records as per your requriement.

      Regards

      Shalabh

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.