Automate

I am attempting to create a Customer query that produces the effective material item price for a given time period.  I'm using condition tables KONP and A305 to determine the pricing.  Problem is these tables include records for multiple validation "to-from" periods.   However, I'm only interested in the current period or a selected period of time.  How do I filter out all the records in a query except for the selected period (date) included in the query selection?  

Any suggestions?  Thanks in advance . . . 

------------------------------
Dave Leon | KIS Technologies Inc. | (713) 201-0041
------------------------------

hi Dave,
I think you can use the parameter "Today" in criteria of the query: I created a similar query (with A304 iso A305) some time ago in which I filter results based on that parameter:

and criterion for validity start date:

hope that helps,
regards, jan

------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875
------------------------------

Hi Dave
Jan had the right idea.  There are two dates, from and to validity, and use can use the "today" variable to check the current prices, meaning the day you run the query.  (Note in my screen shot I'm using A304, but the same applies to A305)

click on the date icon next to the input field and choose Today.   Note I made that input criteria fixed, meaning it will always only pull the current price, but that's optional.

Also if you download the price update template, it includes an example query:  https://community.winshuttle.com/sap-module-templates/viewdocument/update-pricing-condition-records?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------