topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Wed, 22 Oct 2008 03:26:26 GMT

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

Re: select query

Former Member — Wed, 22 Oct 2008 03:28:23 GMT

Is your matnr issue solved or still pending ?

Re: select query

Former Member — Wed, 22 Oct 2008 03:31:55 GMT

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.

Re: select query

Former Member — Wed, 22 Oct 2008 03:35:19 GMT

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

Re: select query

Former Member — Wed, 22 Oct 2008 04:28:41 GMT

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.