Require function module for start and end bucket of planning book

[Former Member]

Hello All,

I need to fetch the start and end bucket date of a planning book. Is there any function module which can directly give first and last bucket date of a planning book ?

Thanks & Regards,

Vivek

[Former Member · Accepted solution]

/SAPAPO/MSDP_PB_GET_DVWHDR gives you the time bucket profiles for start and end. You have to figure out how to read the time bucket profiles then..

[Former Member · Accepted solution]

Hi ,

Another option is to create a simple query on the table "/SAPAPO/PBDVWHDR '

Regards

Datta

[Former Member · Accepted solution]

Hello dear Sanjeev / Datta,

Thanks for your prompt response.

The problem resolved. The solution is as follows.

Step1) CALL FUNCTION '/SAPAPO/MSDP_PB_READ_DVIEW'

Input : Plng book and dataview

output: cs_pbdvwhdr = ls_header (in changing parameter)

Step2) CALL FUNCTION '/SAPAPO/SDP_TB_CREATE_COLS'

Input: bucket Profile of past and future, which we will get from step1.

And from date as space in a variable of type datum (As the parameter is mandatory)

Output: et_cols_ext (Importing table) which will give start and end date.

Hope, This solution will help others also.

Thanks & Regards,

Vivek