Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating a custom grid in SNP94

I am looking into creating a custom SNP94 data view.

I would like to pull up a selection for multiple materials and then drill-down to the material level.

Right now, each key figure is displayed for each material and also a total for each material so it looks like this, for example:

Month 1 Month 2

KEY Figure 1 Total

Material 1

Material 2

KEY Figure 2 Total

Material 1

Material 2

KEY Figure 3 Total

Material 1

Material 2

Is there anyway to change this view to be like below: Either through settings in the Planning Book config or custom development.

Month 1 Month 2

Material 1 Key Figure 1

Key Figure 2

Key Figure 3

Material 2 Key Figure 1

Key Figure 2

Key Figure 3

Total Key Figure 1

Key Figure 2

Key Figure 3

Thank you so much for your support and knowledge in helping answer my questions.

Former Member
Former Member replied

Forgot to mention after you've ReOpened the Selection on defining the Pivot Sorting .. then on the Planning Book Header Selection ... Select "Details (All)" for the Product Characteristic to see Details by Product by Keyfigures and this will also show the Total for Total Product.

Hope this helps. I retested in SCM 5.0 here and it works for me exactly as you want in Standard Functionality.

Additionally the Option of Filtering only the KeyFigures you want is an fantastic functionality to help the Planners see Only what you want to see. You can have Totals of only specific Months shown on the Right. (Inside Planning Book select from Main Menu -> Settings -> Row Totals -> Selected Columns".

These things I have found with experience, Planners love to see exactly what they want to see including say Totals of the First Quarter (total of 3 months).

Anway ... I hope this helps and please do award if it did.

Regards,

Ambrish Mathur

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question