Change of Time Bucket Profile within Planning Book - Not working

[satish_waghmare3]

Hello All,

This is regarding an issue which is preventing change of Time Bucket profile in DP(& also SNP) Planning books.  We are in SAP SCM 7.0 EHP3. I understand as per Standard APO, it is possible to change "Time Bucket Profile" when "Period Structure" button is clicked in planning book(refer below screenshot). However it is not working in our APO system. Ideally it is expected to have this functionality working by default. We want to fix this issue as users want to change time bucket profile within pbook (Example -  Month to Week or Week to Month)

I know when this button is clicked, system can carry out an authorization check for the “C_APO_FUN” authorization object and the “S_TIMEB or C_TIMEB” function, Parameter Name T_TBID. Since I have SAP_ALL authorization,  I do not think this is related to authorization. I have verified above objects with security expert and confirmed that there is no security/authorization related issue. We also tried the system trace option, but it did not help.

As per my understanding, there is no special configuration which we do to activate or deactivate this functionality of changing time bucket profile.

Appreciate any help/input in this regard.

Thank you

Satish Waghmare

[former_member187488 · Accepted solution]

Hi,

It's hard to make any guess at this time. I suggest you to set a break point at function module /SAPAPO/SDP_TB_F4_FOR_PAREA, and then start the process (pushing the period structure button).
Inside this FM, all available TB profiles will be read into internal table LT_SDPTB[] after FM

'/SAPAPO/SDP_TB_READ' is called.
Then it will check these TB profiles one by one.
You can check whether the TB profiles are read correctly first, and then check whether they're filtered out afterwards.
If this FM is OK, you can go out of the FM and then debug further.

Best Regards,
Ada

[satish_waghmare3 · Accepted solution]

Thank you Ada.

We have debugged the function module given by you.

We have implemented User Exit EXIT_/SAPAPO/SAPLMCPR_015 which is called inside the FM /SAPAPO/MCP_PERMISSION_CHECK2.

This exit is used to have an authorization check.

A small code change is required to achieve the desired functionality.

Thank you

Satish Waghmare

[rupesh_brahmankar3]

Hello Satish,

Please check Enhancement APODM015 FM EXIT_/SAPAPO/SAPLMCPR_015 is activated.

Also check your user ID has the user-specific parameter /SAPAPO/SDP_DATLO (Local Date for Start Period) set to 'X'.

Best Regards,

R.Brahmankar

[satish_waghmare3]

Any inputs please...Please let me know if above details are not clear enough.

Thanks in advance

Satish Waghmare

[Former Member]

Satish,

What messages do you get when you attempt to change the TB profile?

Best Regards,

DB49

[satish_waghmare3]

Hello DB49

Thanks for looking into my question.

I do not get the list of time buckets profiles in the drop down after I click "Period Structure" button. It gives me option to select ONLY these two options -  1. "Use Storage Bucket Profile" and  2. "Restore Standard Settings". Please refer below screenshot.

This is kind of strange, ideally I should get list of time bucket profiles associated with the planning book to select from drop down.  This is not working with any of the planning book in DP and SNP.

Let me know if you need any additional information.

Thank you

Satish Waghmare

[Former Member]

Satish,

FYI SAP_ALL will not always give you carte blanche access, particularly for certain custom authorizations that were locally developed.  I will, however, assume that your security team has already eliminated authorization as a problem, as you have stated.

I will assume that this is not a new Planning book or Planning area.  Please confirm.  If this is a brand new planning book, then there are several possibilities, depending on the steps that were taken when the PB/PA were originally created or imported.

I will further assume that you have verified that there are actually some usable time bucket profiles from which to choose.  Please confirm.

First, we gather some info.  Select 'Restore Standard Settings' menu item;.  Tell me if anything in your display changes.

Then, please display the Storage bucket profile assigned to the Planning Area (/SAPAPO/TR32).  Also please find the Time bucket profile(s) assigned to the Data view of the planning book you are using (/SAPAPO/SDP8B); and display it as well. (/SAPAPO/TR30) Verify that there are actually some periods created.

Best Regards,

DB49

[satish_waghmare3]

Hello DB49

Here are details -

1. Yes, based on trace and other mechanisms, Security related issue is overruled in this case.

2. This is not a new planning book or planning area. In fact issue is seen in all planning books/dataviews exist. Also I tried creating brand new planning book, but issue still exist with it.

3. Planning Book has both Weekly and Monthly Dataview in it. It has total of 4 usable time bucket profiles assigned to dataviews exist in that planning book. However none of them are displayed in the drop down.

4. When "Restore Standard Setting" is selected,  It does not change anything.  However if I select "Use Storage Bucket Profile", it shows technical periods/storage buckets in planning book/dataview. Then if I select "Restore Standard Setting" again, it will show planning book with original Time Bucket profile assigned to dataview

5. Please refer below screenshot which shows 1. Storage Bucket Profile 2. Setting for two dataviews from the (one) Planning Book 3. Time Bucket Profile Settings.

6. Period list looks fine for all of time bucket profiles.

Please let me know if you need more information.

Appreciate your help on this matter.

Thank you

Satish Waghmare

[Former Member]

Satish,

One last question:  I assume you are getting these symptoms in your Prod system. Do you also get these same symptoms in your Dev system?

Expert Ada has given you some good ideas to begin to isolate the problem, but before launching into  debug sessions, you might first want to try the simplest fixes.  They won't hurt anything, and once in a while they may actually help.  I usually execute these before I deep dive into any DP/SNP problem:

1.  Check/repair consistency of the DP Planning Area Time Series - Tcode /SAPAPO/TSCONS

2.  Check/repair consistency of the SNP PA Time series - Tcode /SAPAPO/TSLCREORGSNP

3.  Check consistency of the Selection IDs - Report /SAPAPO/MCPSH_GEN_SELTAB_CHECK

4.  Check consistency of the Planning Books - Report /SAPAPO/ADMIN_MVIEW_CONS_CHECK

5.  Reinitialize ALL Macros for the affected books - Tcode /SAPAPO/ADVM

Less likely (but again, can't hurt)

6,  Check/repair consistency of the PLOBS for the DP PAs - Tcode /SAPAPO/STRUCONS

.

Assuming these standard checks/repairs don't help, and assuming you get the same results in an unlocked system (dev) as you get in a locked system (prod), you can, as suggested earlier, start to debug.  However, in my opinion, this is standard functionality, and it should work.  I personally would be more inclined to raise a message with SAP than spend time in debugging.

Best Regards,

DB49