topic Re: Misc in Application Development and Automation Discussions

Misc

Former Member — Wed, 15 Aug 2007 17:57:50 GMT

Hi Guys,

I have a requirement where I need to go to mara table and collect matnr where mara-meins = 'CS' and mara-bstme= 'UN'

Can you help me to write the syntax for the above condition.

Thanks

Rajeev Gupta

Re: Misc

RichHeilman — Wed, 15 Aug 2007 18:00:19 GMT

This may take a while.



data: imara type table of mara with header line.


select * into table imara from mara
             where meins = 'CS'
               and bstme = 'UN'.
loop at imara.
  write:/ imara-matnr.
endloop.

Regards,

Rich Heilman

Re: Misc

Former Member — Wed, 15 Aug 2007 18:07:31 GMT

Hi Rajeev,

Report Z1234567.

Tables: MARA.

*Internal table for mara

data: begin of i_mara OCCURS 0,

matnr like mara-matnr,

end of i_mara.

*Start of Selection Event

Start-of-Selection.

select matnr into table i_mara from mara

where meins = 'CS'

and bstme = 'UN'.

Loop at i_mara.

write:/ i_mara-matnr.

Endloop.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

Re: Misc

Former Member — Wed, 15 Aug 2007 18:36:52 GMT

Hi Rajeev,

TYPES: BEGIN OF TY_MARA,

MATNR TYPE MARA-MATNR,

END OF TY_MARA.

DATA IT_MARA TYPE STANDARD TABLE OF TY_MARA WITH HEADER LINE.

SELECT MATNR

FROM MARA

INTO TABLE IT_MARA

WHERE MEINS = 'CS' AND BSTME = 'UN'.

IF IT_MARA[] IS NOT INITIAL.

WRITE:/ IT_MARA-MATNR.

ENDIF.

Thanks,

Vinay