Using of UDFs Valid Entries in Query with Description
This Document Describes the detail of using a UDFs Description of Valid entries instead of showing code.
In SAP Business One there is Two Tables in which we have all customized fields CUFD and UFD1.
CUFD and UFD1 contains all header or row level User Defined Fields.
We can link it in our query.
The following example shows the link between UDFs.
I make a UDF which shows the regional serried name as Company-City-00, there is almost 7 Regions I make the following query without link of UDF1 and CUFD, but in result it shows code instead of Description after making link with these two tables it shows description rather then code which ease my report and query.
SELECT distinct T0.[DocNum],concat(T2.Descr,’-‘, T0.[U_DocNum]) as ‘Sales Order No.’, T0.[CardCode], T0.[CardName],
t0.[Doccur],T0.[DocTotal],sum(T4.[Quantity]) as ‘Total Quantity’,T0.[DocDate], T1.[SlpName]
FROM ORDR T0 INNER JOIN OSLP T1 ON T0.[SlpCode] = T1.[SlpCode] inner join RDR1 T4 on T0.[DocNum]=T4.[DocEntry], UFD1 T2, CUFD T3
where T2.TableID = ‘ORDR’ and T2.FieldID = 54 and T3.TableID = ‘ORDR’ and T3.FieldID = 54 and T0.[U_Series]= T2.FldValue and T0.[docstatus]=’O’
Group By T0.[DocNum],t0.[Doccur],T2.Descr,T0.[U_DocNum], T0.[CardCode], T0.[CardName], T0.[DocStatus],T0.[DocTotal], T1.[SlpName] ,T0.[DocDate]
ORDER BY T0.[DocNum]
I hope this Document will help others.
Irfan Ullah Irfee