Problems with Product Planning Table

[Former Member]

Hi, experts!

I cann`n start Product Planning Table (tran. /SAPAPO/PPT1).

Process is started, however it proceeds very long. It is not possible to find any visible reasons in trace.

The problem has appeared after installation Support Package

SAPKY70008, before such problem didn't exist with Support Package

SAPKY70002.

Following notes have been established:

Note 1543834 - Requirements view enabled in Product planning table

Note 1560563-/SAPAPO/PPT1: Error in data selection for requirements view

But it hasn't helped.

What notes need to be established still?

Whether installation of Support Package

SAPKY70009 and Support Package SAPKY70010 will solve this problem?

[tiago_furlanetto]

Hi Timofey.

I've have an issue once with View /SAPAPO/V_PRCRES. While opening the PPT, the system took many minutes to execute a select statement in this view. In the end, the issue was that the database parameters were incorrectly set (DB was Oracle 10.2.0.4.0). Could you please make a trace from SE30 and check whether it is ABAP or DB that is consuming most of the processing time and in case of ABAP, mention which Programs/Subroutines/Function Modules the system spends time the most on?

[Former Member]

Hi, Tiago!

I have made as you have told to me.

This is trace

Transaction /SAPAPO/PPT1 = Product Planning Table Time 08:30:40

Program /SAPAPO/PPT1 Date 04.04.11

User BABAILOV_TS

Execution time in microseconds:

ABAP 3.089.292 = 55,3%

Database 1.966.024 = 35,2%

System 533.394 = 9,5%

0% 50% 100% 5.588.710 = 100,0%

What it is possible to make still to solve this problem?

Similar problem at start optimizer DPS01 with the table/SAPAPO/TRPROD