topic Re: Using Table name in Read statement dynamically in Application Development and Automation Discussions

Using Table name in Read statement dynamically

Former Member — Wed, 06 Jul 2011 10:52:14 GMT

Hi Experts,

I have the following requirement.

Based on a country code say "A" , "B", "C" and based on this i have to read different internal tables lt_tabA, lt_tabB and lt_tabC.

The table key can be given dynamically, but how can i use the internal table name dynamically without using if statements.

Please help.

Thanks!

Best Regards,

Gayathri

Re: Using Table name in Read statement dynamically

GayathriRR — Wed, 06 Jul 2011 10:53:45 GMT

I basically have to use READ statement

Re: Using Table name in Read statement dynamically

Former Member — Wed, 06 Jul 2011 10:54:39 GMT

Hi,

if you have just 3 internal tables, what is teh issue in using if/case statements?

Re: Using Table name in Read statement dynamically

GayathriRR — Wed, 06 Jul 2011 10:58:36 GMT

There is no issue. It is just that a similar piece of code has to repeated and i want the code to be better.

Re: Using Table name in Read statement dynamically

Former Member — Wed, 06 Jul 2011 10:59:00 GMT

hi,

thsi should solve your problem:

[;

Re: Using Table name in Read statement dynamically

Former Member — Wed, 06 Jul 2011 12:21:43 GMT

Hello,

it is possible with a little dynamic programming. Here is how:


FIELD-SYBMOLS:
  <lv_tab>  TYPE STANDARD TABLE.

DATA:
  lt_tab1   TYPE TABLE OF....
  lt_tab2   TYPE TABLE OF...

ASSIGN lt_tab1 TO <lv_tab>.

READ TABLE <lv_tab> " read from the first table
  ...

ASSIGN lt_tab2 TO <lv_tab>.

READ TABLE <lv_tab> " read from the second table
  ...

Re: Using Table name in Read statement dynamically

Former Member — Wed, 06 Jul 2011 12:37:04 GMT

Hi,

you can use the concept of field symbols .

ASSIGN COMPONENT lv_data OF STRUCTURE <dyn_wa> TO <fs1>.

<fs1> = p_wa_out-comp_code.

some thing like this.

Re: Using Table name in Read statement dynamically

Clemenss — Wed, 06 Jul 2011 16:17:11 GMT

Hi Gayathri,

something like

DATA:
    lt_t100 TYPE TABLE OF t100,
    lt_t000 TYPE TABLE OF t000.
  FIELD-SYMBOLS:
    <table> TYPE table,
    <rec>   TYPE ANY,
    <field> TYPE ANY.
  SELECT:
    * INTO CORRESPONDING FIELDS OF TABLE lt_t100 FROM t100 UP TO 10 ROWS,
    * INTO CORRESPONDING FIELDS OF TABLE lt_t000 FROM t000 UP TO 10 ROWS.

  CASE abap_true.
    WHEN space.
      ASSIGN  lt_t100 TO <table>.
    WHEN OTHERS.
      ASSIGN  lt_t000 TO <table>.
  ENDCASE.
  READ TABLE <table> with key ('MANDT') = sy-mandt ASSIGNING <rec>.

Regards,

Clemens

Re: Using Table name in Read statement dynamically

GayathriRR — Thu, 07 Jul 2011 03:29:49 GMT

thanks for the link to the thread..It has solve my problem