Skip to Content

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

Duplicate Customer Reference No

I am trying to stop entering Duplicates for Customer Reference No during Sales Order Entry by a formatted search.

SQL Query

Select case when NumAtCard in (Select NumAtCard from ORDR where NumAtCard in ('test11'))

then '' else NumAtCard end from ORDR where CardCode = 'AQU001'

Select case when NumAtCard in (Select NumAtCard from ORDR where NumAtCard = '$[ordr.NumAtCard]')

then ' ' else ''$[ordr.NumAtCard]'' end from ORDR

The above query is not working in formated search, I must be missing some thing, please advise?

Regards,

Mohan

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