topic Re: Create data ststement problem in Application Development and Automation Discussions

Create data ststement problem

Former Member — Thu, 10 Jul 2008 14:22:24 GMT

Hello friends,

I am working on 2 systems in 4.7 and 4.6.

I have to create a dynamic internal table based on the table name passed on the selection screen.

I am able to do this in 4.7 with the below statement.


DATA:  i_table_update TYPE REF TO data.

PARAMETERS: p_table TYPE tabname OBLIGATORY.

  CREATE DATA i_table_update TYPE STANDARD TABLE OF (p_table).

the above statement has a syntax error in 4.6

the error is

Unable to interpret "TABLE". Possible causes of error: Incorrect spelling or comma error.

Any suggestions.

Re: Create data ststement problem

RichHeilman — Thu, 10 Jul 2008 14:27:14 GMT

That's right, the TYPE TABLE syntax is not available in 46c.

Regards,

Rich Heilman

Re: Create data ststement problem

Former Member — Thu, 10 Jul 2008 14:29:17 GMT

Thanks Rich,

Whats the alternative for this.

The problem we are doing some database changes for the material group and we have to this for many tables based on the table name passed on the selection screen.

Thanks and pls let me know if you have any example of this.

Ster.

Re: Create data ststement problem

Former Member — Thu, 10 Jul 2008 14:32:23 GMT

Hi,

Refer to this program:

http://www.sap-img.com/ab030.htm

Write a small subroutine, to create a dynamic table.

Regards,

Subramanian

Re: Create data ststement problem

former_member194669 — Thu, 10 Jul 2008 14:34:28 GMT

Try this way


  call function 'LVC_FIELDCATALOG_MERGE'
    exporting
      i_structure_name = p_table  " Table Name 
    changing
      ct_fieldcat      = i_fcat
    exceptions
      others           = 1.

  call method cl_alv_table_create=>create_dynamic_table
    exporting
      it_fieldcatalog = i_fcat
    importing
      ep_table        = i_content.
  if sy-subrc = 0.
    assign i_content->* to <ptab>.
  else.
    write: 'Error creating internal table'.
  endif.

a®

Re: Create data ststement problem

RichHeilman — Thu, 10 Jul 2008 14:38:47 GMT

aRs has the right idea here. Here is a complete example program.

Regards,

Rich Heilman

Re: Create data ststement problem

Former Member — Thu, 10 Jul 2008 14:50:02 GMT

Thanks ALL,

ARS I will trying ur approach and would get back if I have any questions.

Thanks,

Ster.

Re: Create data ststement problem

Former Member — Thu, 10 Jul 2008 15:12:05 GMT

Thanks All for the suggestions.

Ster