UDF display

[Former Member]

Hi Experts,

I am new to SAP B1, have one issue.

I have created one UDF in Item Master Data.

I want to display this UDF in all marketing documents in Row level.

Please guide me to configure this.

thanks in advance.

Sb1

[Former Member]

Hi ,

Gordon is right way .... i m now understand this question...

but for this one udf will be add in marketing document?

Thanks,

JRAJPUT

Edited by: J2663312 on Jul 9, 2010 3:14 PM

[Former Member]

Thanks..Resolved

Closed.

[Former Member]

Hi SB1fan,

Both Gordon and Joseph are correct (use Gordons query above Sachins as Sachin is specifying the Sales Order table therefore that query will only work on Sales Orders, Gordons will work for ALL documents).

You will need to add a UDF to the Marketing Document Lines. The UDF has to be the same type and length as the UDF you've added to the Item Master data.

Save the query Gordon has given you (change the YourUDF bit to the name of your UDF on the Item Master Data). Please note this query is referencing data directly on the form so you will get an error if you run the query from Query Generator, it will only work as a formatted search.

Then go to your UDF on the documents lines, press Alt, Shift & F2. Apply the formatted search, link it to your saved query, tick Auto Refresh and select the Item Code field.

Now when you select an item, it will go and get the value of the field from the Item Master Data automatically.

If you want this for all documents you will now need to apply the formatted search to each document form (you can use the one saved query).

Regards,

Adrian

[former_member1269712]

Hi,

Open same in marketing document in row level and set FMS in same field set query e.g for sales order - SELECT U_itmasterudfname FROM OITM T0 where T0.ItemCode =$[rdr1.itemcode]

Thanks

SD

[Former Member]

Hi,

You have to create row leve udf for marketing and use fms to capture the value on udf of item master.

Thanks,

Joseph

[Former Member]

Hi Boss,

Chosse Master Data>Items->Items--->and Add your UDF

This will show in all your Marketing Documents.

From FORM SETTING u can put field visible and active

may This help .

NOTE:- Choose DATA TYPE as per your Configuration bcz this is one time option u can not change.

and only you are the person who login on system when u add UDF

Thanks,

JRAJPUT

Edited by: J2663312 on Jul 9, 2010 11:39 AM

[Former Member]

You may create an FMS query such as this:

SELECT T0.U_YourUDF FROM dbo.OITM T0

WHERE T0.ItemCode = $[$38.1.0\]

However, you have to assign this FMS to each individual marketing document.

Thanks,

Gordon