09-27-2006 6:23 PM
HELLO EVERYONE,
I AM USING 2 TABLES <b>MARA</b> AND <b>MCHB</b>.WITH <b>MARA-MATNR</b> V HAV TO RETRIEVE <b>MCHB-MATNR</b> AND <b>WERKS</b>.THE <b>WERKS</b> BEING RETRIEVED FROM <b>MHCB</b> HAS TO B NONZERO.THE <b>WERKS</b> FLD WITH ZERO MUST NOT BE RETRIEVED AGAINST THE <b>MATNR</b>.CAN ANYONE KINDLY HELP ME.
THANKING YOU IN ANTICIPATION.
REGARDS,
SIRISHA.
09-27-2006 6:27 PM
hI,
SELECT * FROM MCHB
INTO TABLE MCHB
FOR ALL ENTRIES IN T_MARA
WHERE MATNR = T_MARA-MATNR
AND WERKS <> '0000'.
Thanks,
Naren
09-27-2006 6:27 PM
hI,
SELECT * FROM MCHB
INTO TABLE MCHB
FOR ALL ENTRIES IN T_MARA
WHERE MATNR = T_MARA-MATNR
AND WERKS <> '0000'.
Thanks,
Naren
09-27-2006 6:28 PM
Check the below code:
data: begin of i_data occurs 0,
matnr like mara-matnr,
WERKS type WERKS_D,
LGORT type LGORT_D,
CHARG type CHARG_D,
end of i_data.
select amatnr bwerks blgort bcharg into table i_data
from mara as a inner join mchb as b
on amatnr = bmatnr
where b~werks <> ''.
if sy-subrc = 0.
endif.
09-27-2006 6:29 PM
HI,
write the select as below.
Declare IT_MATNR, it_werks as internal table
<b>Select MATNR into table IT_MATNR from MARA.
Select werks into table it_werks from MCHB
for all entries in IT_matnr
where MATNR = IT_MATNR-MATNR and
WERKS <> '0000'.</b>
Regards
Sudheer
09-27-2006 6:30 PM
hi,
select maramatnr mchbwerks
into table itab
from mara
join mchb
on maramatnr=mchbmatnr
<b>where mchb~werks NE 0.</b>
rgds
anver
pls mark points if hlped
09-27-2006 6:47 PM
hey everyone,
thank u for the response.i really appreciate it.yhank u ona n all
regards,
Sirisha .