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

PDV and SAP Query - Missing Date Params

Posted on Nov 01, 2005 at 02:39 PM 25 Views

Hello,

I am working on getting an SAP Query onto our MSS portal using the PDV SAPQuery template. I want the query to report data as of 1/1/06 but cannot seem to get it to work. I set up a variant in the system to set the dates but the iview seems to overwrite the date settings at runtime.

The function module that is called by this iview seems to be looking for the parameters Begin_Date and End_Date but the iview does not have any such parameters. Are these supposed to be delivered with the template? Is there a way to add them? Has anyone else sucessfully implemented a time sensitive query in the PDV?

Thank you,

Josh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 09:48 AM
    0

    Hi Josh,

    I ran into the same problem.

    I cannot select any dates. When I run the query without variant, I get results valid only on the system date. If I try to use a query variant with a selected period, I get the message that no dates can be selected.

    Have you or anybody solved the problem?

    Beata

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 18, 2005 at 12:29 PM

      Beata,

      We ended up copying the function module and hardcoding the date since we were looking to run it with a specific date. Long term we will look at adding custom parameters to the iview if SAP doesn't address the issue in a suppport pack.

      Regards,

      Josh

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.