topic Re: Error in Call Method 'create_dynamic_table'. in Application Development and Automation Discussions

Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 09:58:48 GMT

Hi Experts,

i am working on Dynamic ALV.I have created a Dynamic Fieldcatalog,which is storing the correct field values as per requirement.

When I debbug the code: I get the following error when I am calling method 'create_dynamic_table'.

"Unable to interpret "MATERIALS(000010)". Possible 10 MATERIALS(000010)"

DATA: g_table TYPE REF TO data.

CALL METHOD cl_alv_table_create=>create_dynamic_table
    EXPORTING
      it_fieldcatalog           = i_fieldcat
    IMPORTING
      ep_table                  = g_table.
*    EXCEPTIONS
*      generate_subpool_dir_full = 1
*      OTHERS                    = 2.

Please advice how do I approach this error.Is some change required in my piece of code?

Thanks.

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 10:02:59 GMT

It seems that something is wrong with you fieldcatalog. Can you share it with us?

Regards

Marcin

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 10:09:00 GMT

HI Marcin Pciak,

Thanks for the prompt reply.Please advice what could be the possible error.I am checking as well.

IF i_fieldcat[] IS INITIAL.
    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'WERKS'.
    w_fieldcat-seltext   = text-004.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'MATNR'.
    w_fieldcat-seltext   = text-005.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'MAKTX'.
    w_fieldcat-seltext   = text-006.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'MEINS'.
    w_fieldcat-seltext   = text-007.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'POPER'.
    w_fieldcat-seltext   = text-008.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'BDATJ'.
    w_fieldcat-seltext   = text-009.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

    SORT i_tckh3 BY el_hv.
    LOOP AT i_tckh3 INTO w_tckh3.
      SORT i_tckh1 BY elemt.
      LOOP AT i_tckh1 INTO w_tckh1 WHERE elemt = w_tckh3-elemt.
        lcount = lcount + 1.
        CONCATENATE w_tckh1-txele ' ' INTO w_fieldcat-seltext.
        CONCATENATE w_tckh1-txele ' ' INTO w_fieldcat-coltext.
        CONCATENATE w_tckh1-txele ' ' INTO w_fieldcat-fieldname.
*        CONDENSE w_fieldcat-fieldname NO-GAPS.
        w_fieldcat-col_pos = lcount.
        APPEND w_fieldcat TO i_fieldcat.
        CLEAR  w_fieldcat.
        CLEAR: w_tckh1.
      ENDLOOP.
      CLEAR:w_tckh3.
    ENDLOOP.

    lcount = lcount + 1.
    w_fieldcat-fieldname   = 'TOTAL'.
    w_fieldcat-seltext   = text-010.
    w_fieldcat-col_pos     = lcount.
    APPEND w_fieldcat TO i_fieldcat.
    CLEAR  w_fieldcat.

  ENDIF.

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 10:15:25 GMT

This looks suspiscious


    SORT i_tckh3 BY el_hv.
    LOOP AT i_tckh3 INTO w_tckh3.
      SORT i_tckh1 BY elemt.
      LOOP AT i_tckh1 INTO w_tckh1 WHERE elemt = w_tckh3-elemt.
        lcount = lcount + 1.
        CONCATENATE w_tckh1-txele ' ' INTO w_fieldcat-seltext.
        CONCATENATE w_tckh1-txele ' ' INTO w_fieldcat-coltext.
        CONCATENATE w_tckh1-txele ' ' INTO w_fieldcat-fieldname.
*        CONDENSE w_fieldcat-fieldname NO-GAPS.
        w_fieldcat-col_pos = lcount.
        APPEND w_fieldcat TO i_fieldcat.
        CLEAR  w_fieldcat.
        CLEAR: w_tckh1.
      ENDLOOP.
      CLEAR:w_tckh3.
    ENDLOOP.

Don't know excatly what you appending here to field catalog. One thing which I can catch


"try
WRITE w_tchkh1-txele TO ... LEFT-JUSTIFIED.
"instead of 
CONCATENATE....

Anyhow I suggest to comment this part and rerun the program to ensure that this one is not causing the error. If not then investigate further.

Regards

Marcin

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 10:22:38 GMT

Hi Marcin,

I changed the code as per your suggestion,still the same error

please advice.I have cross checked a number of posts on SDN,but all follow the same sequence,so I think i have not missed out on any point.

Please suggest.

Thanks.

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 10:29:16 GMT

This works fine for me



DATA: i_fieldcat TYPE lvc_t_fcat,
      w_fieldcat TYPE lvc_s_fcat.

DATA: lcount TYPE i,
      g_table TYPE REF TO data.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'WERKS'.
w_fieldcat-seltext   = text-004.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'MATNR'.
w_fieldcat-seltext   = text-005.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'MAKTX'.
w_fieldcat-seltext   = text-006.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'MEINS'.
w_fieldcat-seltext   = text-007.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'POPER'.
w_fieldcat-seltext   = text-008.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'BDATJ'.
w_fieldcat-seltext   = text-009.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.

lcount = lcount + 1.
w_fieldcat-fieldname   = 'TOTAL'.
w_fieldcat-seltext   = text-010.
w_fieldcat-col_pos     = lcount.
APPEND w_fieldcat TO i_fieldcat.
CLEAR  w_fieldcat.


CALL METHOD cl_alv_table_create=>create_dynamic_table
  EXPORTING
    it_fieldcatalog           = i_fieldcat
  IMPORTING
    ep_table                  = g_table
  EXCEPTIONS
    generate_subpool_dir_full = 1
    OTHERS                    = 2.

Check it once again, if possible in some new program

Regards

Marcin

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 10:48:44 GMT

Still same error

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 11:18:31 GMT

Check these OSS notes, maybe there is something which applies to your case.

[Note 454535 - ALV-TableCreate:generating length >80 char. for program line|https://websmp130.sap-ag.de/sap(bD1wbCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=454535]

[Note 654306 - ALV grid: Field catalog entry intlen|https://websmp130.sap-ag.de/sap(bD1wbCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=654306]

[Note 721628 - ALV: Dynamic table generation for decimal fields|https://websmp130.sap-ag.de/sap(bD1wbCZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=721628]

Regards

Marcin

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 11:30:52 GMT

When i commented the following code the error has gone:

*    SORT i_tckh3 BY el_hv.
*    LOOP AT i_tckh3 INTO w_tckh3.
*      SORT i_tckh1 BY elemt.
*      LOOP AT i_tckh1 INTO w_tckh1 WHERE elemt = w_tckh3-elemt.
*        lcount = lcount + 1.
*        WRITE w_tckh1-txele TO w_fieldcat-seltext LEFT-JUSTIFIED.
*        WRITE w_tckh1-txele TO w_fieldcat-coltext LEFT-JUSTIFIED.
*        WRITE w_tckh1-txele TO w_fieldcat-fieldname LEFT-JUSTIFIED.
*        w_fieldcat-col_pos = lcount.
*        APPEND w_fieldcat TO i_fieldcat.
*        CLEAR  w_fieldcat.
*        CLEAR: w_tckh1.
*      ENDLOOP.
*      CLEAR:w_tckh3.
*    ENDLOOP.

any suggestions...

But the main purpose of this Fieldcatalog is for Dynamic fields.

Edited by: p317980 on Mar 18, 2010 12:31 PM

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 11:35:14 GMT

What you excatly store in these tables? Dynamic field names? If so please ensure that you are providing field names in CAPITALS and that you don't have duplicate entries after these two loops.

In debugger check also the content of the fieldcatalog.

Edited by: Marcin Pciak on Mar 18, 2010 12:35 PM

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 11:36:40 GMT

Hi Marcin,

When I check this code in debug mode:G_TABLE is blank.

* Create dynamic internal table and assign to FS
  CALL METHOD cl_alv_table_create=>create_dynamic_table
    EXPORTING
      it_fieldcatalog = i_fieldcat
    IMPORTING
      ep_table        = g_table
    EXCEPTIONS
      generate_subpool_dir_full = 1
      OTHERS                    = 2.


 ASSIGN g_table->* TO <i_table>.
* Create dynamic work area and assign to FS
  CREATE DATA w_data LIKE LINE OF <i_table>.
  ASSIGN w_data->* TO <i_value>.

please advice.

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 11:41:44 GMT

Do you mean, there is no reference stored in G_TABLE? Or you mean that table <i_table> is empty?

G_TABLE musn't be blank if you are able to perform


 ASSIGN g_table->* TO <i_table>.

It is the purpose of dynamic table creation to have empty table created but its structure is dynamic, meaning that based on fields provided in field catalog it will be generated.

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 11:46:16 GMT

Hi Marcin,

I changed the FIELDNAME to UPPER CASE AS BELOW:

LOOP AT i_tckh3 INTO w_tckh3.
      LOOP AT i_tckh1 INTO w_tckh1 WHERE elemt = w_tckh3-elemt.
        lcount = lcount + 1.
        WRITE w_tckh1-txele TO w_fieldcat-seltext LEFT-JUSTIFIED.
        WRITE w_tckh1-txele TO w_fieldcat-coltext LEFT-JUSTIFIED.
        WRITE w_tckh1-txele TO w_fieldcat-fieldname LEFT-JUSTIFIED.
        TRANSLATE w_fieldcat-fieldname TO UPPER CASE.
        w_fieldcat-col_pos = lcount.
        APPEND w_fieldcat TO i_fieldcat.
        CLEAR  w_fieldcat.
        CLEAR: w_tckh1.
      ENDLOOP.
      CLEAR:w_tckh3.
    ENDLOOP.

the fieldcatalog stores the headings as per number of records in the loop.The data is coming correct in i_fieldcat.

The error still persists.

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 12:02:58 GMT

Any Suggestions ????

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 12:08:38 GMT

Hi Marcin,

I viewed G_TABLE in debug mode:The following displays the results in debug mode.

G_TABLE->*       Standard Table[0x7(140)]

When I comment the loop in the fieldcatalog,then the error does not appear,But we have to define an Dynamic internal table,so we need to populate it through this procedure.

I have specified only the static fields in the internal table of the final ALV.

Do you suggest some other option of doing the same??

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Thu, 18 Mar 2010 12:14:39 GMT

Are these dynamic fields available in the DDIC?

I can see that you didn't type your dynamic fields in any way. Try giving reference to DDIC fields


w_fieldcatalog-ref_field = "name of field to take the type from
w_fieldcatalog-ref_table = "name of table this field is placed in

You may try also providing data type directly by means of fields DATATYPE , INTTYPE , INTLEN .

It is really hard to tell what may cause the problem without seeing the content of these two misterious tables you have for dyncamic fields. Try adding just one field from these tables by looping only once, observe what is placed in the fieldcatalog and whether this is correct.

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Thu, 18 Mar 2010 16:35:35 GMT

Hi Marcin,

Thanks for all the prompt replies,I will try these changes first thing tomorrow.Will keep you posted on this.Am hoping that the issue should get resolved...

Thanks once again!!!!

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Fri, 19 Mar 2010 04:57:34 GMT

Hi Marcin,

I have added the Ref_Field & Ref_Table in the fieldcatalog.Now the error message has changed to :

"MATERIALS" is not expected 10 MATERIALS"

please suggest what needs to be done.I am chekcing the code,the fields are getting updated in fieldcatalog.

Thanks.

Re: Error in Call Method 'create_dynamic_table'.

MarcinPciak — Fri, 19 Mar 2010 08:05:19 GMT

Can you please paste here example values you have in the tables i_tckh3 and i_tckh1. I think this is crucial here.

You can print the ouput of this tables with WRITE statement and then just copy/paste it here, so I we can see couple rows of example data.

Re: Error in Call Method 'create_dynamic_table'.

Former Member — Fri, 19 Mar 2010 08:22:25 GMT

Hi Marcin,

Thanks for all the help,finally solved the issue.I made a small error while coding the Fieldcatalog:

now the changed code looks like the following code:

LOOP AT i_tckh3 INTO w_tckh3.
      LOOP AT i_tckh1 INTO w_tckh1 WHERE elemt = w_tckh3-elemt.
        lcount = lcount + 1.
        WRITE w_tckh1-txele TO w_fieldcat-seltext   LEFT-JUSTIFIED.
        CONCATENATE 'KST' w_tckh3-el_hv INTO w_fieldcat-fieldname.
        TRANSLATE w_fieldcat-fieldname              TO UPPER CASE.
        w_fieldcat-col_pos   =  lcount.
        w_fieldcat-ref_field = 'KST001'.
        w_fieldcat-ref_table = 'KEPH'.
        w_fieldcat-datatype  = 'CURR'.
        APPEND w_fieldcat TO i_fieldcat.
        CLEAR  w_fieldcat.
        CLEAR: w_tckh1.
      ENDLOOP.
      CLEAR:w_tckh3.
    ENDLOOP.

Emphasis on the COncatenate statement in the loop.Earlier I was passing the TXELE field to fieldname,which was wrong.

Thanks a Ton!!!!

I have a small dount in the next step:While assigning the values to the final internal table:

LOOP AT i_final INTO w_final.

    ASSIGN COMPONENT 'WERKS' OF STRUCTURE <i_value> TO <fs1>.
    <fs1> = w_final-werks.

    ASSIGN COMPONENT 'MATNR' OF STRUCTURE <i_value> to <fs1>.
    <fs1> = w_final-matnr.

     LOOP AT i_keph INTO w_keph WHERE kalnr = w_final-kalnr.
      ASSIGN COMPONENT  'KST001' OF STRUCTURE <i_value> TO <fs1>.
      <fs1> = <FS1> + w_keph-kst001.
    ENDLOOP.

   
    APPEND <i_value> TO <i_table>.
    CLEAR: <i_value>.
  ENDLOOP.

Now the LOOP AT I_KEPH: has all the values of the cost fields.I need to assign the appropriate value of KSTXXX to the corresponding Dynamic fieldcatalog:What should the procedure be.I am NOT able to check what values are there in dynamic calatog.

Hope this point is not too confusing.