topic Re: data selection into same itab in Application Development and Automation Discussions

data selection into same itab

Former Member — Tue, 25 Mar 2008 06:13:38 GMT

hi,

itab having txz01 and bukrs field , bukrs having data.

can i do like this to fetch data for txz01 for all bukrs having in same itab.

is this correct to fetch data?

select txz01 from ekpo into corresponding fields of table gt_item for all entries in gt_item where bukrs = gt_item-bukrs.

Former Member — Tue, 25 Mar 2008 06:20:21 GMT

itab having txz01 and bukrs field , bukrs having data.

can i do like this to fetch data for txz01 for all bukrs having in same itab.

is this correct to fetch data?

Data itab1 like itab occurs 0 .

itab1 = itab .

append itab1 .

select txz01 from ekpo into corresponding fields of table itab1 for all entries in gt_item where bukrs = gt_item-bukrs.

loop at itab .

read table itab1 where bukrs = itab-bukrs.

itab-txz01 = itab1-txz01 .

Modify itab .

endloop.

Reward points if it is usefull ...

Girish

Former Member — Tue, 25 Mar 2008 06:26:23 GMT

Hi.

you can. Just check it out the following code.

tables : mara.

DATA : BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

MAKTX LIKE MAKT-MAKTX,

END OF ITAB.

select-options : matnr for mara-matnr.

select * from mara into corresponding fields of table itab where matnr in matnr.

select * from makt into corresponding fields of table itab

for all entries in itab where matnr = itab-matnr.

Reward if the above is useful.

Regards,

Sankar.

Former Member — Tue, 25 Mar 2008 06:34:46 GMT

Hi Santoshini,

Your question is that for the data bukrs exits in internal table you want to fetch txz01 into same internal table??

first fetch the data into another internal table and then modify the first internal table in this way you can do it.

<b>reward if useful</b>

Regards,

sunil kairam.