Skip to Content

Formatted Search

Feb 07, 2017 at 01:47 PM


avatar image
Former Member

How can i show my unit price in base price automaticlly by FMS?

When i use this code in my base price by FMS,it is static not dnyamic.I want when i enter item-code,then base price will be unit price(1st of list price) automaticlly

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" = [%0]

10 |10000 characters needed characters left characters exceeded

Did you post this in the right tag? There is no OITM table in our system. No idea what FMS is in this context, this is the tag for the SAP ERP SD configuration questions.

* Please Login or Register to Answer, Follow or Comment.

0 Answers