topic abap in Application Development and Automation Discussions

abap

Former Member — Tue, 24 Oct 2006 10:09:43 GMT

i have selected labst from mard based on matnr and charg from mchb based on for all entries in it_mard.and looping both internal tabels is it correct

Re: abap

Former Member — Tue, 24 Oct 2006 10:12:36 GMT

Yes it is correct...if you refer to my code in your earlier post you can replace the code in second select to get the data from MARD..the rest can remain the same to give you the percentage.

Please note to reward points for all helpful answers...

Thanks and Regards

Anurag

Re: abap

venkata_ramisetti — Tue, 24 Oct 2006 10:16:52 GMT

Hi,

YOu can write lik e below also,

SELECT MARD_{MATNR MARD}LABST MCHB~CHARG

INTO TABLE IT_MARD_MCHB

FROM MARD INNER JOIN MCHB

ON MARD_{MATNR = MCHB}MATNR AND

MARD_{WERKS = MCHB}WERKS AND

MARD_{LGORT = MCHB}LGORT.

Thanks,

Ramakrishna

Re: abap

Former Member — Tue, 24 Oct 2006 10:22:36 GMT

Hi Rakhee,

Is your Code something similar to this?

select matnr

werks

lgort

labst

from mard

into table it_mard

where matnr in s_matnr.

if not it_mard[] is initial.

select matnr

werks

lgort

charg

from MCHB

into table it_mchb

for all entries in it_mard

where matnr = it_mard-matnr

and werks = it_mard-werks

and lgort = it_mard-lgort.

endif.

loop at it_mchb.

move-corrsponding it_mchb to it_final.

read table it_mard with key matnr = it_mchb-matnr

werks = it_mchb-werks

lgort = it_mchb-lgort.

if sy-subrc = 0.

move-corresponding it_mard to it_final.

append it_final.

clear it_final.

endif.

endloop.

Regards,

ravi