topic Re: db Table as a parameter in Application Development and Automation Discussions

db Table as a parameter

Former Member — Thu, 10 Jan 2008 20:58:41 GMT

Hi SDN,

I have two tables with identical structure. How can I write a FORM/ENDFORM such that I pass the name of the table as a variable. Please note I am not talking about internal tables but actual db tables like MARA, etc.

Please give an example.

I want to accomplish the following:

TABLES A, B, C, D

FORM GETRECS

SELECT X, Y, Z

FROM ?

ENDFORM

How can use a variable to replace ? after FROM?

Thanks.

Saf.

Re: db Table as a parameter

Former Member — Thu, 10 Jan 2008 21:11:04 GMT

Are you looking for something like this:

REPORT ztest LINE-SIZE 80 MESSAGE-ID 00.

TABLES: bsik, bsak.

PERFORM getrecs USING 'BSIK'.
PERFORM getrecs USING 'BSAK'.

DATA: itab TYPE TABLE OF bsik.

*&---------------------------------------------------------------------*
*&      Form  getrecs
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
FORM getrecs  USING    table.

  SELECT * FROM (table)
    APPENDING TABLE itab.

ENDFORM.                    " getrecs

Rob

Re: db Table as a parameter

Former Member — Thu, 10 Jan 2008 21:21:56 GMT

Thanks Rob. Points assigned.

Re: db Table as a parameter

Former Member — Thu, 10 Jan 2008 21:26:44 GMT

Glad it worked out for you.

Rob