ONLY NONZERO VALUES

[Former Member]

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.

[Former Member]

hI,

SELECT * FROM MCHB

INTO TABLE MCHB

FOR ALL ENTRIES IN T_MARA

WHERE MATNR = T_MARA-MATNR

AND WERKS <> '0000'.

Thanks,

Naren

[Former Member]

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 a_{matnr b}werks b_{lgort b}charg into table i_data

from mara as a inner join mchb as b

on a_{matnr = b}matnr

where b~werks <> ''.

if sy-subrc = 0.

endif.

[Former Member]

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

[anversha_s]

hi,

select mara_{matnr mchb}werks

into table itab

from mara

join mchb

on mara_matnr=mchbmatnr

<b>where mchb~werks NE 0.</b>

rgds

anver

pls mark points if hlped

[Former Member]

hey everyone,

thank u for the response.i really appreciate it.yhank u ona n all

regards,

Sirisha .