DM/SP: SQL for Notes BI report that shows Hierarchy, Item, Org, Time, Customer — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DM/SP: SQL for Notes BI report that shows Hierarchy, Item, Org, Time, Customer

edited Jun 16, 2025 8:53PM in Supply Chain Planning and Collaboration 1 comment

Summary:

DM/SP: SQL for Notes BI report that shows Hierarchy, Item, Org, Time, Customer

Content (please ensure you mask any confidential information):

DM/SP: SQL to Notes BI report that shows Hierarchy, Item, Org, Time, Customer

I found this table "ZMM_NOTES". It doesn't specify the location/hierarchy level that the notes were added to. (Item, Org, Time, Customer ect).

QUESTIONS:

  • What are the other tables that I can linked it to to get the location/hierarchy level that the note was inserted in the table. (Item,Org,Time,Customer, ect)
    • ZMM_NOTES
    • MSC_ASSOCIATION_CONTEXT
  • Why are the following tables empty?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!