Formatted search

[Former Member]

Hi all.

I created an User defined row at marketing documents level.

Requirement.

As soon as i select the item at row level - the price which maintained at item master level should be picked & should be shown at User defined row.

It's like Unit price. ( I need to configure the same logic - which is applied to unit price). Can we get the solution based on foramatted search with query.

If we can do with foramtted search & query - plz give the solution of how to do?

It's urgent.

Thanks & Regards.

Ganesh Varma. G

[former_member186095 · Accepted solution]

Hi,

this following query FMS will display the item price of item that selected in the item column of marketing document. The price is related to the price list that selected for BP in the BP master data.

SELECT t0.price FROM [dbo].[ITM1]  
T0 INNER JOIN OPLN T1 ON T0.PriceList = T1.ListNum 
INNER JOIN OCRD T2 ON T1.ListNum = T2.ListNum 
and t2.listnum = t0.pricelist WHERE t2.cardcode = $[$4.1.0] 
and t0.itemcode = $[$38.1.0]

Assigned the above query FMS to the UDF you have created. It will work similar with SAP B1 unit price assigning in the marketing document for the selected item. The FMS is really helpful if you manage manual price input in the marketing document. I use the FMS when sales admin want to know the actual price.

Rgds,

[Former Member · Accepted solution]

Hi.

Thanks for u'r reply.

Can u be more elobrate on which u mentioned. what are all the tables & fields has to be selected at query genertor.

where we have to mention that query.

can u specify stepwise. - it will help me a lot.

Thanks & Regards

Ganesh Varma. G

[former_member186095 · Accepted solution]

Hi,

just open the query generator --> click execute button --> the query editor screen will display. Copy the query FMS I gave and paste to the editor. But before that, activating the query editor by clicking pencil-like icon. In this case, you do not need to define the table, etc.

Save the query into query manager. After save the query, you could use it.

If you want to see it more detail, I can send you webex movie file to see how it works, how to create query for FMS use and define the FMS in the UDF.

Let me know your e-mail. I could not send asap since it is been nite here. I've got to go home.

Rgds,

[Former Member · Accepted solution]

Thanks for u'r answer (it's working)

what's u'r good name.

can u explain the logic of that FMS query.. Becoz we need it in different cases.

we need to pull the data from customer master (User Defined Fields to Marketing docts row level as soon as the customer selected at header level)

It will be very helpful - if u explain the logic.

Plz mail the web x file & logic behind the query to the below id

varmab2b (atherate) g(/)mai(/)l dot (com)

tryto understand & reply the above

Thanks & Regards

Ganesh Varma. G

[Former Member · Accepted solution]

It would be helpful if you could send the web-ex to me as well

My id is mohanakrishnan (atherrate) live (dot) com

Regards,

Mohan

[former_member186095 · Accepted solution]

Hi,

To know fore detail about FMS, there is a pdf file explaining about it in the documentation resource center in SAp partner portal. you could download it but if you want I send just let me know your e-mail

Rgds,

[Former Member · Accepted solution]

e-mail

varmab2b/gmail/com

[former_member186095 · Accepted solution]

GAnesh,

I'll send in this afternoon. I am still busy to help client in the monthly closing. My e-mail is anthoni76@yahoo.com. send your empty e-mail to me. Just to make sure

Rgds,

[Former Member · Accepted solution]

hi Jimmy

I saw on the thread you are talking about Pdf file for formatted search.I look for it and couldn't find it . I am trying to understand How to get the code like $[38.1.0]

Can you please tell me how to get the code from

Thnak you

[former_member186095 · Accepted solution]

Hi Bishal,

Create a separate message.

Rgds,