Use of RTTS To Solve GENERATE_SUBPOOL_DIR_FULL Exception For Dynamic Table Generation

[former_member223182]

Summary

We as a developers working in SAP Webdynpro FPM and Object oriented ALV have encountered an exception GENERATE_SUBPOOL_DIR_FULL while trying to use the API CL_ALV_TABLE_CREATE to generate dynamic tables which are required in our specific requirements. There is a limitation wherein the API will allow to generate dynamic internal tables for 36 times only after which it throws an exception GENERATE_SUBPOOL_DIR_FULL. The scenario which I encountered was in developing SAP FPM cockpit wherein we had create umpteen number of dynamic internal tables depeding upon selection criteria selected by end user in the cockpit. Hence in my case the end user used to get dump screen after trying to search multiple criteria. I struggled a lot and then later used the RTTS code to resolve the issue which I am sharing in my below document. Please note that I am not giving insight on RTTS as there are lots of documents in SCN which could be referred the best one is https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=42965 published by Marcelos Ramos. For more detail please refer to the same.

 

Scenario

As briefly described in the Summary the main scenario where I encountered this issue was SAP FPM web dynpro component for search cockpit which had multiple search screens associated with it.

These multiple screens were used to fetch data from various CDS Hana views and then dynamic internal tables used to be generated depending upon the fields coming from CDS views which used to be binded to the result screen in the cockpit. As already specified I was initially using CL_SALV_TABLE_CREATE=>CREATE_DYNAMIC_TABLE which takes in as importing parameter as Field catalog data type(used for ALV grid class as well) and passes the dynamic parameter of Type reference to Data as output. But in our cockpit we have multiple save searches which resulted in umpteen calls to the API thus resulting in an exception GENERATE_SUBPOOL_DIR_FULL.

Hence to resolve the issue introduced the below code snippet which I have explained with comments preceding with " please refer to them for further explaination:-

***Data Declaration

FIELD-SYMBOLS : <lt_mbs_grp_sel> TYPE STANDARD TABLE,

                <l_dyn_table>    TYPE STANDARD TABLE,

                <ls_table_2>     TYPE any,

                <ls_val>         TYPE any,

                <ls_val_i>       TYPE any.

DATA: l_element  TYPE REF TO cl_abap_elemdescr,               

      l_intlen  TYPE i,l_dec type i,            

      lt_Fcat TYPE lvc_t_fcat,

      lt_comp    TYPE cl_abap_structdescr=>component_table,

      ls_comp    LIKE LINE OF lt_comp,

      l_new_type TYPE REF TO cl_abap_structdescr,

      l_new_tab  TYPE REF TO cl_abap_tabledescr,

      l_data     TYPE REF TO data.

***prepare the Runtime Type identification structure to be used to generate table

LOOP AT lt_fcat INTO DATA(ls_fcat).

*   Field name

ls_comp-name = ls_fcat-fieldname.

* Field Type

l_intlen  = ls_fcat-intlen.   

l_dec = ls_fcat-decimals.

ls_comp-type = cl_abap_elemdescr=>get_by_kind(p_type_kind   = ls_fcat-int

                                              typep_length   = l_intlen

                                              p_decimals = l_dec ).

**   Filling the component table

APPEND ls_comp TO lt_comp.

CLEAR: ls_comp.

ENDLOOP.

* 3. Create a New Type

l_new_type = cl_abap_structdescr=>create( lt_comp ).

* 4. New dynamic internal Table type

l_new_tab = cl_abap_tabledescr=>create(p_line_type  = l_new_type

                                       p_table_kind = cl_abap_tabledescr=>tablekind_std

                                       p_unique     = abap_false ).

*5. data to handle the new table type

CREATE DATA l_data TYPE HANDLE l_new_tab.

** 6. New internal table in the fieldsymbols

ASSIGN l_data->* TO <l_dyn_table>.

CREATE DATA lt_table LIKE LINE OF <l_dyn_table>.

ASSIGN lt_table->* TO <ls_table_2>.

The final dynamic table is <ls_table2> to be retrieved and used further in the application/program. Hope so It will save time and effort for fellow developers who might face this issue.