Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 06:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ambrish, I just tested this out and it is exactly what I am looking for but I have two questions.

      1) I switched the columns and rows so that the time buckets went down the grid instead of accross and now I cant seem to get the user setting "Drill-down" setting to work.

      2) Is there any way to display the row totals by default or do I have to go into the transaction and to that menu path every time?

  • avatar image
    Former Member
    Oct 21, 2008 at 04:14 AM

    Hi Stacy St. Peter ,

    I think your problem will solve by using PIVOT SETTING.

    Do one think, when you drill down to detailed level. Right click on the Data View name which is located at just below the upload data & Desgin. Click on Pivote setting. Drag Material & drop above the Key figure. & press Contnue. You will find the the one materials having all the key figures infront of them.

    This seeting you can put n to default also. Press "Maintain User Setting" Go to second last tab Pivot setting. Do Pivot setting over there.

    Hope this will help you....

    Regards

    Sujay

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 09:34 PM

    I am not able to get your requirement completely but if you wants to change your planning table layout than you can do it by BADI:(SE18/SE19)

    /SAPAPO/SDP_SELECTOR

    Method :ALV_LIST_LAYOUT_SET

    Manish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 06:04 AM

    Stacy,

    If I've understood your requirement correctly ...

    What you need to do is Standard Functionality in SCM-APO.

    Which version of APO are you using ? This is available as Standard from as early as SCM 4.0. I've done exactly what you need with Standard APO Planning Book functionality.

    Please Explore the Buttons in Transaction /sapapo/SDP94 after you've Opened up your Selection in your Planning Book.

    Select "Header ON" in your Planning Book and then ... click on "Header Settings" to define your Drilldown.

    The Click on "User Settings" on Top Toolbar in Planning Book and Click and define 2 things "Pivot Sorting" and "Navigation Path (Drilldown)". In your Pivot Sorting you define the "Product" first, maybe if you want "location" next and Finally define the "Keyfigure" as Last. Save your Settings.

    Then REOPEN the SELECTION.

    You can also use the Magnifying Glass to Filter KeyFigures only that you want to see by selecting "Multiple KFs".

    Hope this helps. If it does, please award.

    Regards,

    Ambrish Mathur

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 02:48 PM

    Just a few more questions.

    Add comment
    10|10000 characters needed characters exceeded