select statement

Former Member — Wed, 22 Oct 2008 09:11:55 GMT

Hi all,

can anyone tell me how to write the code for the following

In CDPOS table search for all the records for which changes are there in table MARC for the following fields,

MINBE

EISBE

MABST

with respect ot changes in material no.with this code we can check for only one field,how to check for multiple fields

select objectclas objectid changenr tabname fnamefrom cdpos into table itab where objectclas = 'material'

and tabname = 'marc'

and fname = 'minbe'.

Re: select statement

Former Member — Wed, 22 Oct 2008 09:52:05 GMT

Hi Siva,

Use this query.

select * from cdpos into CORRESPONDING FIELDS OF TABLE

itab where objectclas = 'MATERIAL'

and tabname = 'MARC'

and fname IN ('MINBE','EISBE','MABST').

Regards,

Amit.