topic Re: ONLY NONZERO VALUES in Application Development and Automation Discussions

ONLY NONZERO VALUES

Former Member — Wed, 27 Sep 2006 17:23:53 GMT

HELLO EVERYONE,

I AM USING 2 TABLES MARA AND MCHB.WITH MARA-MATNR V HAV TO RETRIEVE MCHB-MATNR AND WERKS.THE WERKS BEING RETRIEVED FROM MHCB HAS TO B NONZERO.THE WERKS FLD WITH ZERO MUST NOT BE RETRIEVED AGAINST THE MATNR.CAN ANYONE KINDLY HELP ME.

THANKING YOU IN ANTICIPATION.

REGARDS,

SIRISHA.

Re: ONLY NONZERO VALUES

Former Member — Wed, 27 Sep 2006 17:27:49 GMT

hI,

SELECT * FROM MCHB

INTO TABLE MCHB

FOR ALL ENTRIES IN T_MARA

WHERE MATNR = T_MARA-MATNR

AND WERKS <> '0000'.

Thanks,

Naren

Re: ONLY NONZERO VALUES

Former Member — Wed, 27 Sep 2006 17:28:29 GMT

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.

Re: ONLY NONZERO VALUES

Former Member — Wed, 27 Sep 2006 17:29:17 GMT

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

Re: ONLY NONZERO VALUES

anversha_s — Wed, 27 Sep 2006 17:30:33 GMT

hi,

select mara_{matnr mchb}werks

into table itab

from mara

join mchb

on mara_matnr=mchbmatnr

where mchb~werks NE 0.

rgds

anver

pls mark points if hlped

Re: ONLY NONZERO VALUES

Former Member — Wed, 27 Sep 2006 17:47:37 GMT

hey everyone,

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

regards,

Sirisha .