Skip to Content
0
Former Member
Oct 02, 2014 at 06:54 PM

Description from UDF on OITM Query Assistance

108 Views


Hello Experts,

I am new in creating queries and need the ability to put the Product Type UDF description on a query on SAP B1.

This is my code below.

SELECT T0.[ItemCode], T0.[ItemName], T0.[U_PPP_ProdType] FROM OITM T0

I have the UFD1 table id, fieldID, IndexID, FldValue and Descr Information but how do I structure it to pull information on my query?

Field ID: OITM

IndexID: 20

Fld Value: Descr:

1 STEEL 2 WIRE 3 PLASTIC

Thanks in advance.