select statement

[Former Member]

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'.

[Former Member]

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.