Supply Chain Management Blogs by SAP
Expand your SAP SCM knowledge and stay informed about supply chain management technology and solutions with blog posts by SAP. Follow and stay connected.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member187488
Active Contributor
0 Kudos

A customer asked a question about BAPI_PPMSRVAPS_GETLIST. The issue is they input some PPM names in input table PLAN_SELECTION, but only returns part of the PPMs. No error in the return table.

PPMs are selected in below coding at around line 140 in FORM SELECT_WITH_RANGES (Program /SAPAPO/SAPLOO_PPM).

       select x~ext_plannr x~logqs x~plannr x~planid

             p~pl_usage

             m~valfr m~valto

             into corresponding fields of table et_planid

             from /sapapo/planmap as x

                  join /sapapo/plan as p   on p~planid eq x~planid

                  join /sapapo/trprod as m on m~planid eq x~planid

             where x~ext_plannr in it_plan_sel and

                   x~logqs      eq iv_logqs and

                   p~pl_usage   like iv_planusage and

                   m~valfr      le iv_valto and

                   m~valto      ge iv_valfr.

So the PPMs are selected from table /sapapo/planmap, /sapapo/plan and /sapapo/trprod.
It first gets planid from table /sapapo/planmap, then read corresponding data from the other two tables.
In this specific issue, those PPMs that are not returned by the BAPI are not saved in table /sapapo/trprod.

The reason why PPMs are not saved in table /sapapo/trprod is that these PPMs are not assigned to any model.
After performing model assignment in /sapapo/scc03, the BAPI worked correctly.

Then customer found that if they input many PPMs in input table PLAN_SELECTION, they'll get no result though the PPMs are assigned to model correctly.
In the return table, error "E APO_BAPI 072 XXX entries in selection tables exceed Maximum Number (100)" happens. The long text of error APO_BAPI 072 indicates that BAPI is not designed to be executed with huge amount of data. Is there any way to overcome this restriction? I noticed below coding:

In FM BAPI_PPMSRVAPS_GETLIST, line 243

*   -> change restriction for number of entries to be read
    read table extension_in with key structure = 'MAX_RANGE_ENTRIES'
      into ls_extension_in.
    if sy-subrc is initial.
      TRY .
        lv_max_range_entries = ls_extension_in-valuepart1.
      CATCH cx_sy_conversion_no_number.
        clear lv_max_range_entries.
      CATCH cx_sy_conversion_overflow.
        lv_max_range_entries = 2147483647.
      ENDTRY.
      if lv_max_range_entries < 0.
        clear lv_max_range_entries.
      endif.
    endif.

Then in FORM GET_SELECTED_OBJECTS, line 8280

* -> restrict number of entries to be read
  IF NOT iv_max_range_entries IS INITIAL.
    lv_max_range_entries = iv_max_range_entries.
  ELSE.
    lv_max_range_entries = gc_apo_bapi_max_range_entries.

  ENDIF.

We can see that "gc_apo_bapi_max_range_entries = 100" is hard coded, but it could be overwritten by "iv_max_range_entries", which comes from input parameter in BAPI's input table EXTENSION_IN. By adding and entry:

- STRUCTURE                      MAX_RANGE_ENTRIES

- VALUEPART1                     (a number more than number of entries in input table PLAN_SELECTION)

into input table EXTENSION_IN, the BAPI returns all PPM's information successfully.