please suggest which table store the filed bucket resource consumption(Variable) in PDS

[Former Member]

Hi All,

please suggest which table store the bucket resource consumption(Variable) in PDS,please find the attachment

regards

vijaya

[Former Member · Accepted solution]

Vijaya,

Try /SAPAPO/REQCAP.

Best Regards,

DB49

[Former Member · Accepted solution]

Hi

thanks

Please Suggest how this Report  calculate/take values" /SAPAPO/CDPS_REPT - Production Planning -> Reporting -> Order and Resource Reporting"

Mainly please explain how this fields/keyfigues calculates or takes data 1)Available Capacity 2)Free Capacity 3) Resource Load in %  in the Order and Resource Report

Regards

Vijaya

[Former Member · Accepted solution]

Vijaya,

???? Unfortunately, when SAP programmers created that program, they did not send me the design specs first.  They can be quite annoying in that way.

I took a quick look at this report.  Some of the data is stored in LiveCache, and some is stored in tables.  Like most SCM reports.

If this subject really interests you, have one of your senior ABAPers analyze the code to determine the exact methods used by SAP to produce the output.

Best Regards,

DB49

[tiago_furlanetto]

Hi Vijaya,

The PDS data is stored in a database cluster structure which is quite difficult to navigate outside the debugger.

The easiest way to see the PDS data exactly as stored in the system via debugging is:

1) Set a breakpoint at Method GET_CLUSTER_PPE FROM, from Class /SAPAPO/CL_PDS_DB_CLUSTER_PPE, statement below:

IMPORT  hirachy   TO ls_ppds_data->hirarchy

               hir_type  TO ls_ppds_data->hirarchy_type

               FROM DATABASE /sapapo/cullindx(pv)

               ID iv_cluster_id.

2) Execute transaction /SAPAPO/CURTO_SIMU and display the details for a PDS. When the breakpoint is reached, you will be at callstack below:

26  METHOD GET_CLUSTER_PPE /SAPAPO/CL_PDS_DB_CLUSTER_PPE=CP

25  METHOD /SAPAPO/IF_PDS_DB~GET_CLUSTER /SAPAPO/CL_PDS_DB_PPDS========CP

24  METHOD GET_CLUSTER /SAPAPO/CL_CURTO_DB===========CP

23  METHOD CONSTRUCTOR /SAPAPO/CL_PDS_DATA_PPE=======CP

22  METHOD CONSTRUCTOR /SAPAPO/CL_PDS_BUFFER_PPDS====CP

21  METHOD GET_SINGLE_PDS /SAPAPO/CL_PDS_BUFFER_OBJ=====CP

3) Press F6 to execute the IMPORT statement. At this point, the PDS data was imported from the database into structure ls_ppds_data->hirarchy and can be navigated.

4) The Capacity Requirements, specifically, can be seen by navigating the structure until you reach point below:

LS_PPDS_DATA->HIRARCHY-ADD_APPLICTN_DATA[1]-MODES[1]-BODY-CAP_REQS

--> You can see, for example, what are the fixed and variable time-continous and bucket capacity consumptions.

Regards,
Tiago