Skip to Content
avatar image
Former Member

i want it to enter base price to sales order as soon as i enter item code

SELECT T1."Price" FROM OITM T0 INNER JOIN ITM1 T1 ON T0."ItemCode" = T1."ItemCode" INNER JOIN OPLN T2 ON T1."PriceList" = T2."ListNum" WHERE T2."ListNum" = 1 AND T0."ItemCode" = ??

I am trying to get base price automatically by help of query in sales order. i want it to enter base price to sales order as soon as i enter item code. when to place of question mark i put item code it gives result. but i want it to be dynamical. Could you help me plz?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Feb 07, 2017 at 01:27 AM

    Hi,

    Are you looking for formatted search?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 06:37 AM

    This is standard functionality ...Just setup prices according to business requirements using

    1.Price list

    2.Perido and volume discounts

    3.Discount groups

    4.Special prices for BP

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 02:10 PM

    Hi,

    Try this,

    SELECT T1."Price" FROM OITM T0 INNER JOIN ITM1 T1 ON T0."ItemCode" = T1."ItemCode" INNER JOIN OPLN T2 ON T1."PriceList" = T2."ListNum" WHERE T2."ListNum" = 1 AND T0."ItemCode" =$[$38.1.0]

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06, 2017 at 09:50 PM

    Hi Emin,

    Why do you not set the price list 1 as a default list for your Business Partner? With this, SAP will automatically fill the prices in the marketing documents.

    You can define a default list for your BP in the Business Partners Master Data screen, on the payment terms tab.

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 08:20 AM

    Did you run query and save it under query manager? Same query is working in SQL and there is no difference for HANA expect table name with quotation marks; i don't have HANA DB to check and advise.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 08:48 AM

    What was the reason?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      When i execute this query,this code will be error again.But i saved this query,and then i saved it to UDF.Then this code is working.But when i execute this code,it will show error again

  • Feb 08, 2017 at 09:01 AM

    OK. Please close this thread by assigning correct answer. Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am new in this program.Maybe i cant explain correctly.

      Can i ask anything? I use Price Report and i have 2 column in Sales Order(Discount 1 and Discount2).But i want that when i use price report,for example 28%+1%,Discount 1 will get 28,and Discount 2 will get 1.Can you tell me how i write this query? I must use substring method?

  • Feb 08, 2017 at 09:11 AM

    Yes sure, but please create new discussion for this new requirement. Also try to explain with original document screen.

    Add comment
    10|10000 characters needed characters exceeded