Question

Demand Planner SQL exclude certain values

  • 17 February 2023
  • 0 replies
  • 23 views

Badge

Hi All,

I need to exclude a specific “market_code” in my demand planning server setup. It is currently pulling in intercompany movements to warehouses and is multiplying the sales history. I need to understand what SQL statement I can use to exclude and ‘markey_code’ “inter” sales. 

 

I have tried to figure this out, and everytime I run the data it fails. Current SQL is below and we need to add something to exclude these sales

SQL: Select contract, part_no, issue_date, issue_qty from IFSAPP.comb_ext_inv_part_issue_pub


0 replies

Be the first to reply!

Reply