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
Fld Value: Descr:
1 STEEL 2 WIRE 3 PLASTIC
Thanks in advance.