Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Approval Procedure

Hi Experts,

I need query for approval procedure to block sale order if a UDF field in BP master is null.

Thanks and regards,

Bharathiraja

Former Member
replied

Hi Bharathiraja,

Please try below query.

I made small change in MG S's query and its working fine in my system.

SELECT distinct 'TRUE'

FROM OCRD T0

INNER JOIN ORDR T1 ON T0.CardCode = T1.CardCode

WHERE T0.CardCode= $[$4.0.0] and Len(isnull(T0.U_CL,''))=0

Thanks

Unnikrishnan

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question