Skip to Content
0

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

Feb 06, 2017 at 02:02 PM

217

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Nagarajan K Feb 07, 2017 at 01:27 AM
1

Hi,

Are you looking for formatted search?

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded

yes,i am looking for FMS

0
Dick Smith Feb 07, 2017 at 06:37 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 07, 2017 at 02:10 PM
1

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]

Show 6 Share
10 |10000 characters needed characters left characters exceeded

but when i am writing this code in my query,it would be error.My database is Hana.Is this depend on Hana?

0

Yes, please change it as per HANA

0

i cant do it.Please,can you tell me how i write in Hana?

0

Run query and save it in query generator. And then open sales order and run saved query.

0

But this query is not working.When i execute this query,this error will show me - 1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 182 '' (SWEI) (at pos 182)

And i cant change this code as HANA .Please,any suggestion

0

i find it.Thank you very much

0
DIEGO LOTHER Feb 06, 2017 at 09:50 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 08, 2017 at 08:20 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 08, 2017 at 08:48 AM
0

What was the reason?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Nagarajan K Feb 08, 2017 at 09:01 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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?

0
Nagarajan K Feb 08, 2017 at 09:11 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded