topic Re: Two Tables in a single structure in Application Development and Automation Discussions

Two Tables in a single structure

Former Member — Fri, 18 Jan 2008 08:29:56 GMT

Hi,

How can i declare a structure that include all the fields of two table?? Please note that there some common fields in the two tables such as MANDT.

TYPES: BEGIN OF MY_STRUCT.

INCLUDE STRUCTURE TABLEA.

INCLUDE STRUCTURE TABLEB.

END OF MY_STRUCT.

Regards,

Kit

Re: Two Tables in a single structure

Former Member — Fri, 18 Jan 2008 08:47:07 GMT

Hi Kit,

you may declare like this:


TYPES: BEGIN OF my_struct.
        INCLUDE STRUCTURE tablea AS a RENAMING WITH SUFFIX a1.
        INCLUDE STRUCTURE tableb AS b RENAMING WITH SUFFIX b1.
TYPES: END OF my_struct.

I hope this helps. Best regards,

Alvaro

Re: Two Tables in a single structure

Former Member — Fri, 18 Jan 2008 08:52:02 GMT

Hi Alvaro,

Thx for your reply.

Do i need to use the alias a and b to access the structure variable??

Regards,

Kit

Re: Two Tables in a single structure

Former Member — Fri, 18 Jan 2008 08:59:36 GMT

Hi Kit,

if you declare (say) a variable with reference to this type:


DATA: l_mystruc TYPE my_struct.

...then you can access the individual fields by appending the suffix to the name of the field.

For example, if both tables have field MANDT, you may access L_MYSTRUC-MANDTA1 for the first table and L_MYSTRUC-MANDTB1 for the second table.

You may also access the whole structure of each table, by typing L_MYSTRUC-A or L_MYSTRUC-B.

I hope this helps. Best regards,

Alvaro