Automate

 View Only

  • 1.  Current or Effective Pricing Condition

    Posted 12-17-2021 18:57

    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
    ------------------------------


  • 2.  RE: Current or Effective Pricing Condition

    Posted 12-20-2021 05:12
    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
    ------------------------------

    Original Message


  • 3.  RE: Current or Effective Pricing Condition

    Employee
    Posted 12-20-2021 08:58
    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
    ------------------------------

    Original Message