10-22-2008 4:26 AM
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
10-22-2008 4:28 AM
10-22-2008 4:35 AM
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
10-22-2008 4:31 AM
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.
10-22-2008 5:28 AM
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.