topic Accessing Dynamic Database Table Names (Stored in a variable) in Application Development and Automation Discussions

Accessing Dynamic Database Table Names (Stored in a variable)

Former Member — Mon, 09 Jul 2018 09:35:50 GMT

Dear Experts,

I am currenty having a basic problem on which i hope you can help me with.

Suppose i have a code running and in runtime a name of a database table will be saved into the variable lv_tablename. Something like this:

lv_tablename = MARA.

I would like to work with this Variable in the following way. For example, suppose i would like to build a custom type, which contains all fields of mara with one additional custom field at the end.

'Something like this':

TYPES:
  BEGIN OF ty_custom.
    Include type mara as ty_custom.
Types:
    lastfield type c,
  END OF ty_custom.

Instead of the table name 'MARA' i want to use the content of the variable lv_tablename. Something like this:

TYPES:
  BEGIN OF ty_custom.
    Include type (lv_tablename) as ty_custom.
Types:
    lastfield type c,
  END OF ty_custom.

Or Use the Variable for an inner Join :

Select MARA~MATNR MARC~MATNR MARC~WERKS
    INTO CORRESPONDING FIELDS OF TABLE lt_table
    FROM ((lv_tablename) AS MARA
    INNER JOIN MARC AS MARC
       on MARA~MATNR = MARC~MATNR).

But as probably many of you already know, it doesn't work. Is there any easy way to do this? Maybe by putting the complete syntax in a variable? Any help would be appreciated!

Re: Accessing Dynamic Database Table Names (Stored in a variable)

matt — Mon, 09 Jul 2018 09:38:36 GMT

Welcome to the site!

Please in future, if you're posting code, using the "code" button in the editor and make sure your code is formatted nicely. Use right-click "paste as text" if pasting code copied from an editor. This time, I've done it for you.

Matt Billingham

SAP Community Moderator

Re: Accessing Dynamic Database Table Names (Stored in a variable)

matt — Mon, 09 Jul 2018 09:43:18 GMT

You can't use

Include type (lv_tablename) as ty_custom.

If you want dynamic data structures, you must use the RTTS classes. (If you don't know what they are, then please search this site - there's many examples).

For the inner join - please search before posting. Often you'll find the answer without posting a question. Try: https://archive.sap.com/discussions/thread/1898930

Re: Accessing Dynamic Database Table Names (Stored in a variable)

retired_member — Mon, 09 Jul 2018 09:53:03 GMT

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abendynamic_sql_abexa.htm