topic regarding internal tables in Application Development and Automation Discussions

regarding internal tables

Former Member — Tue, 19 Jun 2007 03:52:56 GMT

Hi i want to show out put as matnr menge(quantity) and costing lotsize(losgr).

i have menge and matnr in mseg table and losgr in marc table...how i can display these three in my final internal table...

Re: regarding internal tables

Former Member — Tue, 19 Jun 2007 04:01:58 GMT

hi..

first create an internal table with the final structure and writing the select query with inner join you can be able to display all those fields in ur internal table.

thanks

Ashu

Re: regarding internal tables

Former Member — Tue, 19 Jun 2007 04:04:03 GMT

Hai,

Use Inner Join u ll get the answer.

SELECT A_{MENGE A}MATNR B~LOSGR INTO CORRESPONDING FIELDS OF TABLE itab

FROM MSEG AS A INNER JOIN MARC AS B

ON A_{<common field in MSEG & MARC> = b}<common field in MSEG & MARC>

Regards,

Padmam.

Re: regarding internal tables

Former Member — Tue, 19 Jun 2007 04:07:19 GMT

Write a Query like this..

select matnr werks lgort lotsize from marc inti table it_marc where <Give All Cond.>

select mblnr zeite matnr menge from mseg inti table it_mseg for all entries in it_marc where matnr = it_marc-matnr and <give all cond>..

Check for duplicate here because matnr is not a key in mseg table. debug it and see it will be correct..

Reward All Helpfull Answers...........

Re: regarding internal tables

Former Member — Tue, 19 Jun 2007 04:08:14 GMT

use for all entries... suppose you have got the value from mseg table in imseg.

now

declare imarc int table with matnr and losgr.

select matnr losgr into table imarc from marc for all entries in imseg where matnr = imseg-matnr.

now ..

declare ifinal for all the data you need.

loop at imseg.

move-corresponding imseg to ifinal.

read table imarc with key matnr = imseg-matnr.

ifinal-losgr = imarc-losgr.

append ifinal.

clear ifinal.

endloop.

regards

shiba dutta