select query

[Former Member]

Hi all

i want select query for this.

in cdpos table search for all the records for which changes are there in table MARC(fieldname TABNAME) for the following fields wrt to change in material no

MINBE

EISBE

MABST

I require for all the 3 fields

[Former Member]

Is your matnr issue solved or still pending ?

[Former Member]

Exactly Balu!! Even I wanted to know that.

Sivaram:

Close one issue first and then go to the other one.

If the issue is solved, close the question.

Edited by: Vishwa Sri Hari on Oct 22, 2008 9:05 AM

[Former Member]

Hi,

data: it_cdpos like table of cdpos ,

it_mara like table of mara .

select * from cdpos into it_cdpos .

select * from mara into it_mara.

loop at it_cdpos .

if it_cdpos-fieldname <> it_mara-fieldname.

select field1 field2 field3 from cdpos into it_cdpos1

.

endif.

endloop.

[Former Member]

yes the matnr issue has been resolved.

There is actually no need to use any FM,

I declared another variable like CDHDR-OBJECTID

and passed the matnr to this variable.

It has been done and the no is now being dispalyed as 18 digit.

can you please give me the solution for the select query.