topic Re: select in Application Development and Automation Discussions

select

Former Member — Tue, 22 Apr 2008 05:29:47 GMT

SELECT matnr meins FROM mara INTO CORRESPONDING FIELDS OF TABLE gt_mara.

is this statement correct where gt_mara has two fields matnr and meins

DATA:BEGIN OF wa_trans.

INCLUDE STRUCTURE gt_trans.

DATA: END OF wa_trans.

wat does thios do

Re: select

Former Member — Tue, 22 Apr 2008 05:33:22 GMT

Hi,

Do like this

Types: Begin of ty_mara,

matnr type mara-matnr,

meins type mara-meins,

end of ty_mara.

Data: gt_mara type table of ty_mara, " This is Internal table gt_mara declaration.

wa_mara type ty_mara. "This is Work Area declaration

SELECT matnr meins FROM mara INTO TABLE gt_mara.

Regards,

Satish

Re: select

Former Member — Tue, 22 Apr 2008 05:36:59 GMT

IF GT_MARA has these two fields only no need to write corresponding fields of table as a optimization point of view

else the statement is correct


SELECT matnr meins FROM mara INTO TABLE gt_mara.


DATA:BEGIN OF wa_trans.
INCLUDE STRUCTURE gt_trans.
DATA: END OF wa_trans.

This statement defines a line type having a same structure as

GT_trans..

as u have named it WA_trans

it is working as a work area only it is also right....

HTH

pls reward points

regards

rajan

Re: select

Former Member — Tue, 22 Apr 2008 05:37:37 GMT

Hi,

Try to do like this

Data : Begin of imara occurs 0, "internal table declartions

matnr like mara-matnr,

meins like mara-meins,

end of imara.

Data: gt_mara type table of imara, "Internal table gt_mara declaration.

wa_mara type imara. "Work Area declaration

SELECT matnr meins FROM mara INTO TABLE gt_mara.

Reward me Points,

Pari

Re: select

prasanth_kasturi — Tue, 22 Apr 2008 05:41:14 GMT

hi,

if the order of fields in gt_mara is meins and matnr its necessary to use corresponding edition. otherwise its not

you can use

SELECT matnr meins FROM mara into TABLE gt_mara.

and the next one defines a work area of structure gt_trans.

reward if helpful

prasanth