How to fetch Particular UDF dropdown data into excel SAP Business one, SBO

[nikunjmehta2290]

Hello all,

How to fetch Particular UDF drop down data into excel SAP Business one, SBO? For example one UDF which contains lots of details into drop down.

Regards,

Nikunj

[hdolenec · Accepted solution]

If UDF validation is valid values, code and description of all values are stored in UFD1 table. Here is how to get description of valid values field "U_Line" on Sales Quotation.

SELECT T0."DocNum", T1."Descr" AS "Line"
FROM OQUT T0
LEFT JOIN UFD1 T1 on T1."TableID"='OQUT' and T1."FieldID"=0 and T1."FldValue"=T0."U_Line"