SQL Queries mostly used in SAP B1

Displaying pending sales orders, which have not been shipped completely to the customer? The requirement is to add a filter by notes column from the OCRD table. The solution is:  SELECT T1.DocNum as …