po

[Former Member]

HI,

select objectclas

objectid

tabname

fname

value_new

value_old

from cdpos

into table t_cdpos

where objectclas = 'EINKBELEG'

and objectid = 3100000295

and tabname = 'ekpo'

and ( fname = 'brtwr'

or fname = 'key'

or fname = 'loekz' ).

wht's wrong in this?

I wnt to get old and new vlaues.

how to get those for that particular PO.

pls help its urgent.

regards,

kb

[Former Member]

Hi,

i have used capital letter's. Then also i am not getting values into t_cdpos.

regards,

kb

[Former Member]

select objectclas
objectid
tabname
fname
value_new
value_old
from cdpos
into table t_cdpos
where objectclas = 'EINKBELEG'
and objectid = 3100000295
and tabname = 'EKPO'  "Capital
and ( fname = 'BRWTR'  "Capital
or fname = 'KEY' "Capital
or fname = 'LOEKZ' ). "Capital

[Former Member]

Hi,

I am not getting any values into t_cdpos.

Pls help.

Regards,

kb

[naimkhans_babi]

well

Yaa its fine you need to pass the data in Capital only but as well you need to check.. wither that change object really contains any data.. or not.. for that you need to see RSSCD100 program.. pass all the values here.. you can find values if it is changed over there....and... you can check with the BANF as well may be sometime BANF contains the value as per the scenarios i dont know what you have.. but check with the BANF object instead of EINKBELENGE

[naimkhans_babi]

Dear KB...

This is what i have written.. you can see the queries.. here...

select objectid changenr tabkey value_new from cdpos into table

it_cdpos1 for all entries in i_ekpo where

*objectclas = 'BANF' or

objectclas = 'EINKBELEG' and

objectid = i_ekpo-i_objectid and

tabname = 'EBAN' and

tabkey = i_ekpo-i_tabkey and

fname = 'FRGZU'.

used RSSCD100 program to check... change object information.

reward points if used full

Regards

Naeem

[Former Member]

Hi kb,

write values in capital letters.

these are always case sensitive.

Whenever u comapre a value write that in capital letters in codes ( ' ' )

select objectclas

objectid

tabname

fname

value_new

value_old

from cdpos

into table t_cdpos

where objectclas = 'EINKBELEG'

and objectid = '3100000295'

and tabname = 'EKPO'

and ( fname = 'BRTWR'

or fname = 'KEY'

or fname = 'LOEKZ ).

Regards,

Hemant

[Former Member]

Hi,

i have used capital letter's. Then also i am not getting values into t_cdpos.

regards,

kb

[Former Member]

select objectclas
objectid
tabname
fname
value_new
value_old
from cdpos
into table t_cdpos
where objectclas = 'EINKBELEG'
and objectid = '3100000295'  " Object ID should be in Single Quote <======
and tabname = 'EKPO'  "Capital
and ( fname = 'BRWTR'  "Capital
or fname = 'KEY' "Capital
or fname = 'LOEKZ' ). "Capital
 

[JoffyJohn]

Try with this

SELECT objectclas

objectid

tabname

fname

value_new

value_old

FROM cdpos

INTO TABLE t_cdpos

WHERE objectclas = 'EINKBELEG'

AND objectid = '3100000295'

AND tabname = 'EKPO'

AND ( fname = 'BRTWR'

OR fname = 'KEY'

OR fname = 'LOEKZ' ).

[Former Member]

thanks