Online transfer of demand from DP to SNP

[gurucharanscm]

Hi Experts,

Is it somehow possible to release the demand from DP to SNP online inside the interactive planning? It is understood that

• the data should not be locked during the release... so the functionality should also check if the data is in the display mode before the release starts.
• the drill-down should be at product-location level.

We are thinking if this is possible by calling a transaction via the DP macro. And if this happens, what we can do is to call the transaction /sapapo/rtsoutput_fcst and then load the product-location in the selection screen of this transaction with what is actually drilled-down in the DP planning book and then execute the transaction.

It is understood that this is easy to speak... but would like to know if anyone has some hints on the technical side...

Thanks.

[Former Member · Accepted solution]

Yes, it is definitely possible.

I've seen exactly same use case in an old client of mine. I remember though we had some issue/requirements around agregation, so the possibility of the user to change demand in an aggregated level and then release it. The function would the check for all product location combination and run transaction for each. Don't know if you need that.

Here are main sections of the code (stuff not client dependent):

*"  IMPORTING

*"     REFERENCE(PLOB_VALUES) TYPE  /SAPAPO/DM_PLOB_VALUES

*"     REFERENCE(PLOB_VALUES2) TYPE  /SAPAPO/DM_PLOB_VALUES

*"     REFERENCE(SDP_BOOK) TYPE  /SAPAPO/FUNSTRING

*"     REFERENCE(SDP_VIEW) TYPE  /SAPAPO/FUNSTRING

*"  TABLES

*"      COLS_INDEX STRUCTURE  /SAPAPO/PGCOLS

*"      LINE_INDEX STRUCTURE  /SAPAPO/MCP6_LI

*"      GRID_LINES STRUCTURE  /SAPAPO/MCP6_LI OPTIONAL

*"      GRID_COLS STRUCTURE  /SAPAPO/PGCOLS OPTIONAL

*"      GRID_CELLS STRUCTURE  /SAPAPO/PLV_CELL OPTIONAL

*"      GRID_FIXED_LINES STRUCTURE  /SAPAPO/MCP6_LI_FIX OPTIONAL

*"      GRID_FIXED_COLS STRUCTURE  /SAPAPO/MCP6_COL_FIX OPTIONAL

*"      GRID_FIXED_TAB STRUCTURE  /SAPAPO/MCP6_VOFM OPTIONAL

*"      VALUE_TAB STRUCTURE  /SAPAPO/VALUE_TAB

*"  CHANGING

*"     REFERENCE(F_CALC_ERROR) TYPE  C

*"     REFERENCE(F_ARGUMENT) TYPE  /SAPAPO/MXVAL

*"     REFERENCE(F_TAB) TYPE  /SAPAPO/MSDP_VALUE_TAB OPTIONAL

To get the material/location being processed:

REFRESH i_temp[].

  MOVE plob_values-selection TO i_temp .

  LOOP AT i_temp INTO wa_temp .

    IF wa_temp-iobjnm EQ c_zapo_prod.

      r_sel-sign = wa_temp-sign.

      r_sel-option = wa_temp-option.

      r_sel-low-iobjnm     = c_zapo_prod.

      r_sel-low-sign = c_i.

      r_sel-low-option = wa_temp-option.

      r_sel-low-low    = wa_temp-low.

      APPEND r_sel.

      CLEAR r_sel.

    ELSEIF  wa_temp-iobjnm EQ c_zapo_loc.

      r_sel-sign = wa_temp-sign.

      r_sel-option = wa_temp-option.

      r_sel-low-iobjnm     = c_zapo_loc.

      r_sel-low-sign = c_i.

      r_sel-low-option = wa_temp-option.

      r_sel-low-low    = wa_temp-low.

      APPEND r_sel.

      CLEAR r_sel.

    ENDIF.

  ENDLOOP.

to execute the report:

  SUBMIT /sapapo/rtscopy USING SELECTION-SCREEN c_1000

      WITH SELECTION-TABLE i_rsparams

      WITH r_dat  IN r_dat

      WITH p_kfmap IN r_kfmap

      WITH p_chamap IN r_charmap

    WITH p_group IN r_group

      WITH p_sel IN r_sel

      WITH copy  EQ c_x

      WITH p_log EQ c_x

      EXPORTING LIST TO MEMORY

*        TO SAP-SPOOL

*        VIA JOB name NUMBER number

                    AND RETURN.

Hope this helps!

[Former Member]

Hello,

I think it should be possible to call transactions using macro though tough for sure.

You can refer to following thread

http://scn.sap.com/thread/1623306

Regards,

Anurag