Does anyone have reporting content on Missing Customer Hierarchies (Retailer)?

Answered

DSP User

• February 05, 2018 16:35

Missing Customer Hierarchies (Retailer) - We've been asked to prepare reports to identify KUNNRs with missing levels within a customer hierarchy (in this case related to Retailer). Goal is to identify all KUNNRS meeting pre-defined criteria that do not have all 7 levels assigned. I'm in search of any reporting content that may already be written. I'll be searching through dgReports related to dspMonitor, but wanted to extend the search to the broader community. Thanks Glenn

1

• Best answer

  

  DSP Expert

  • February 05, 2018 16:53

  KVandergriend: This is a fairly easy report to write in SQL. Simply create 7 views that include the parent/child relationship, each feeding off the previous view created. The first view needs to be the top level. Then compare the KUNNRs in the last view to the ones that need 7 levels.

  0

Please sign in to leave a comment.