HELP - QUERY FOR APPROVAL TEMPLATE Sales Order

[supjkt]

hi there,

neeed help please.

I want to make approval template for Sales Order, only for sales order with specific customer code (in range) and certain doc series , which will need approval.

already tried, but seems all sales order will require approval.

please help. thank you

[narayanis]

Hi,

Select Distinct 'True' From ORDR Where $[ORDR."CardCode"] In ('100071') And $[ORDR."Series"] In ('119')

You can provide appropriate business partner and series codes in the bracket. I tested this on SAP B1 Hana and found executing.