Skip to Content
Author's profile photo Irfan Ullah

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.