alv

Former Member — Mon, 13 Aug 2007 04:56:32 GMT

Hi,

If I want to extract data from more than 5 tables.Hou can I do .

For ex:

DATA : BEGIN OF T_HEADER1 OCCURS 1,

GBORT TYPE P0002-GBORT,

ANSSA TYPE P0006-ANSSA,

NAME2 TYPE P0006-NAME2,

STRAS TYPE P0006-STRAS,

ORT01 TYPE P0006-ORT01,

ORT02 TYPE P0006-ORT02,

PSTLZ TYPE P0006-PSTLZ,

FNMHG TYPE P0539-FNMHG,

LNMHG TYPE P0539-LNMHG,

REGNO TYPE P0539-REGNO,

DAT01 TYPE P0041-DAT01,

PERNR TYPE P0000-PERNR,

END OF T_HEADER1.

For this,wud u plse tell hou can write the SELECT statement.

Re: alv

Former Member — Mon, 13 Aug 2007 07:06:29 GMT

Hi,

Try to find out the common fields between these tables and u can use join.

u can write individual select queries using <b>for all entries</b>.

regards,

pritha.